4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Kongsvinger II
TEMPORADA 2023/2024
CUARTA NORUEGA GRUPO 6
Equipo PJ GF GC Puntos
1 Skjervøy Skjervøy 4 12 3 12
2 Hønefoss Hønefoss 3 14 0 9
3 Fløya Fløya 4 14 3 9
4 Elverum Elverum 4 5 6 9
5 HamKam II HamKam II 4 11 8 7
6 Harstad Harstad 3 5 3 6
7 Kongsvinger II Kongsvinger 4 8 10 6
8 Sprint-Jeløy Sprint-Jelø 4 2 6 6
9 Mjølner Mjølner 4 5 8 4
10 Fyllingsdalen Fyllingsdale 4 3 10 4
11 Innstrandens Innstrandens 4 5 6 3
12 Bodø / Glimt II Bodø Glimt 4 3 9 3
13 Fredrikstad II Fredrikstad 4 0 4 1
14 IL Ulfstind IL Ulfstind 4 3 14 0
TEMPORADA 2021/2022
CUARTA NORUEGA GRUPO 2
Equipo PJ GF GC Puntos
1 Aalesunds FK II Aalesunds 26 60 17 61
2 Förde Förde 26 68 32 55
3 Elverum Elverum 26 64 34 55
4 Florø Florø 26 53 27 49
5 Molde FK II Molde FK II 26 76 49 47
6 Spjelkavik Spjelkavik 26 45 43 40
7 Hønefoss Hønefoss 26 56 46 37
8 Brumunddal Brumunddal 26 51 48 30
9 Volda Volda 26 44 53 29
10 Hødd II Hødd II 26 48 66 28
11 Raufoss II Raufoss II 26 38 70 28
12 Kongsvinger II Kongsvinger 26 47 67 25
13 Lillehammer Lillehammer 26 27 55 19
14 Toten Toten 26 26 96 10
TEMPORADA 2020/2021
CUARTA NORUEGA GRUPO 1
Equipo PJ GF GC Puntos
1 Gjøvik-Lyn Gjøvik-Lyn 13 49 9 39
2 Gjelleråsen Gjelleråsen 13 37 18 26
3 Elverum Elverum 13 27 18 25
4 Lillestrom II Lillestrom 13 31 23 24
5 Kongsvinger II Kongsvinger 13 32 24 22
6 Brumunddal Brumunddal 13 33 19 21
7 Lorenskog IF Lorenskog 13 18 17 18
8 Grorud II Grorud II 13 21 22 16
9 Raufoss II Raufoss II 13 19 30 14
10 Toten Toten 13 21 42 14
11 Funnefoss / Vormsund Funnefoss 13 18 30 11
12 Nybergsund IL-Trysil Nybergsund 13 11 23 11
13 Ullensaker/Kisa II Ullensaker/K 13 11 32 8
14 Rommen SK Rommen SK 13 12 33 6
TEMPORADA 2019/2020
CUARTA NORUEGA GRUPO 1
Equipo PJ GF GC Puntos
1 Brumunddal Brumunddal 0 0 0 0
2 Elverum Elverum 0 0 0 0
3 Funnefoss / Vormsund Funnefoss 0 0 0 0
4 Gjelleråsen Gjelleråsen 0 0 0 0
5 Gjøvik-Lyn Gjøvik-Lyn 0 0 0 0
6 Grorud II Grorud II 0 0 0 0
7 Kongsvinger II Kongsvinger 0 0 0 0
8 Lillestrom II Lillestrom 0 0 0 0
9 Lorenskog IF Lorenskog 0 0 0 0
10 Nybergsund IL-Trysil Nybergsund 0 0 0 0
11 Raufoss II Raufoss II 0 0 0 0
12 Rommen SK Rommen SK 0 0 0 0
13 Toten Toten 0 0 0 0
14 Ullensaker/Kisa II Ullensaker/K 0 0 0 0
TEMPORADA 2018/2019
CUARTA NORUEGA GRUPO 5
Equipo PJ GF GC Puntos
1 Rosenborg II Rosenborg 26 74 29 60
2 Strindheim Strindheim 26 59 46 46
3 Gjøvik-Lyn Gjøvik-Lyn 26 63 50 45
4 Kolstad Kolstad 26 55 43 43
5 Nybergsund IL-Trysil Nybergsund 26 49 36 42
6 Ranheim II Ranheim II 26 65 52 41
7 Brumunddal Brumunddal 26 51 40 38
8 Tiller IL Tiller IL 26 36 38 37
9 Melhus Melhus 26 43 52 35
10 Raufoss II Raufoss II 26 42 69 32
11 Kongsvinger II Kongsvinger 26 54 56 30
12 Orkla Orkla 26 48 55 30
13 Verdal Verdal 26 32 52 26
14 Steinkjer Steinkjer 26 20 73 11
TEMPORADA 2015/2016
CUARTA NORUEGA GRUPO 3
Equipo PJ GF GC Puntos
1 Skedsmo Skedsmo 26 73 28 63
2 Flisa Flisa 26 67 31 56
3 Funnefoss / Vormsund Funnefoss 26 81 23 55
4 Lillestrom II Lillestrom 26 90 35 55
5 Valdres FK Valdres FK 26 64 33 51
6 Hauerseter Hauerseter 26 48 45 44
7 Aurskog-Høland Aurskog-Høl 26 53 47 42
8 Årdal Årdal 26 56 46 38
9 Gran IL Gran IL 26 43 49 33
10 Kongsvinger II Kongsvinger 26 40 61 27
11 Ullensaker/Kisa II Ullensaker/K 26 29 74 23
12 Jevnaker Jevnaker 26 26 62 14
13 Hallingdal FK Hallingdal 26 28 93 13
14 Sander IL Sander IL 26 27 98 8
TEMPORADA 2014/2015
CUARTA NORUEGA GRUPO 2
Equipo PJ GF GC Puntos
1 Asker Asker 26 151 19 74
2 Funnefoss / Vormsund Funnefoss 26 88 32 59
3 Skedsmo Skedsmo 26 84 37 53
4 Hauerseter Hauerseter 26 67 55 49
5 Skjetten Skjetten 26 69 45 44
6 Strømmen II Strømmen 26 84 65 43
7 Lokomotiv Oslo Lokomotiv 26 50 58 38
8 Ottestad Ottestad 26 56 78 37
9 Kongsvinger II Kongsvinger 26 51 74 35
10 HamKam II HamKam II 26 60 72 31
11 Ullensaker/Kisa II Ullensaker/K 26 60 83 28
12 Rælingen FK Rælingen 26 35 88 19
13 Gjerdrum Gjerdrum 26 37 88 17
14 Grue Grue 26 15 113 5
TEMPORADA 2012/2013
CUARTA NORUEGA GRUPO 2
Equipo PJ GF GC Puntos
1 Stabæk II Stabæk II 26 80 28 62
2 Flisa Flisa 26 59 36 49
3 Hasle-Løren Hasle-Løren 26 53 37 48
4 Funnefoss / Vormsund Funnefoss 26 71 55 41
5 Lyn II Lyn II 26 78 53 40
6 Hauerseter Hauerseter 26 66 55 38
7 Fjellhamar FK Fjellhamar 26 45 49 35
8 Korsvoll IL Korsvoll IL 26 43 48 35
9 Grorud II Grorud II 26 47 44 34
10 Sander IL Sander IL 26 42 47 32
11 Lørenskog II Lørenskog 26 48 47 31
12 Gjerdrum Gjerdrum 26 39 64 31
13 Kongsvinger II Kongsvinger 26 33 74 21
14 Holmlia Holmlia 26 25 92 13
TEMPORADA 2011/2012
CUARTA NORUEGA GRUPO 4
Equipo PJ GF GC Puntos
1 Eidsvold TF Eidsvold TF 24 80 25 60
2 IL Stjørdals-Blink Stjørdals-B 24 89 20 56
3 Ottestad Ottestad 24 69 44 49
4 Tiller IL Tiller IL 24 76 44 47
5 Flisa Flisa 24 54 39 38
6 Sander IL Sander IL 24 52 46 32
7 Hauerseter Hauerseter 24 50 76 29
8 HamKam II HamKam II 24 46 53 28
9 Alvdal Alvdal 24 39 54 22
10 Kongsvinger II Kongsvinger 24 46 69 21
11 Funnefoss / Vormsund Funnefoss 24 29 63 21
12 Brumunddal II Brumunddal 24 33 79 21
13 Moelven Moelven 24 30 81 15
14 Nybergsund IL-Trysil Nybergsund 0 0 0 0

  USO DE MEMORIA  
5,649,544 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0017
Controller Execution Time ( Home / Category )  0.5637
Total Execution Time  0.5655
  CADENA URL  
/historico/Kongsvinger-2
  GET DATOS  
$_GET['/historico/Kongsvinger-2']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0134  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Kongsvinger-2' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0126  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=119338 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=119338 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=119338 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0261  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 74995
0.0129  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=119338 AND type_rel = 2
0.0128  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1937 AND type_rel = 3
0.0135  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1937 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0138  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (694715,651476,517291) ORDER BY n.cover_points DESC, update_date DESC
0.0141  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '119338' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0138  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '119338' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0136  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 74995 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0142  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=119338 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0132  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (74995,71432) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 74995 AND teamId = 119338
0.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 119338
0.0129  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2024` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 74995 AND t.round = 4 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0127  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '119338' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '119338' and rp.type = 4
0.0136  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '119338' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0146  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 74995 WHERE rp.league_id = 74995 AND rp.teamId = 119338 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0138  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 74995 WHERE rp.league_id = 74995 AND rp.teamId = 119338 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0146  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 74995 WHERE rp.league_id = 74995 AND rp.teamId = 119338 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0140  SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 119338 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0146  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2024` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 74995 AND t.round = 4 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0137  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2022` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 66285 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2021` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 63569 AND t.round = 13 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2020` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 53745 AND t.round = 13 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2019` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 48612 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2016` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 48758 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2015` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 48810 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2013` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 48840 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2012` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 48854 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 74995 ORDER BY nameShow LIMIT 100