4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Årdal Årdal 0 0 0 0
2 Bjarg Bjarg 0 0 0 0
3 Brann II Brann II 0 0 0 0
4 Fana Fana 0 0 0 0
5 Lyn 1896 FK Lyn 1896 FK 0 0 0 0
6 Fjora Fjora 0 0 0 0
7 Frigg Frigg 0 0 0 0
8 Fyllingsdalen Fyllingsdale 0 0 0 0
9 IF Ready IF Ready 0 0 0 0
10 Lysekloster Lysekloster 0 0 0 0
11 Os Turn Os Turn 0 0 0 0
12 Sandviken Sandviken 0 0 0 0
13 Sogndal II Sogndal II 0 0 0 0
14 Stord Stord 0 0 0 0
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Vard Vard 26 103 22 63
2 Lysekloster Lysekloster 26 85 30 54
3 Djerv 1919 Djerv 1919 26 72 38 51
4 Fyllingsdalen Fyllingsdale 26 68 41 50
5 Fana Fana 26 76 40 48
6 Stord Stord 26 70 48 40
7 Strømsgodset II Strømsgodse 26 55 49 39
8 Sogndal II Sogndal II 26 54 52 35
9 Brann II Brann II 26 49 49 33
10 Fjora Fjora 26 54 78 33
11 Os Turn Os Turn 26 58 46 31
12 Vestfossen Vestfossen 26 43 70 24
13 Bergen Nord Bergen Nord 26 30 71 20
14 Valdres FK Valdres FK 26 10 193 3
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Sotra SK Sotra SK 26 80 32 56
2 Fyllingsdalen Fyllingsdale 26 63 31 54
3 Lysekloster Lysekloster 26 75 30 52
4 Viking FK II Viking 26 77 44 46
5 Brodd Brodd 26 66 47 43
6 Brann II Brann II 26 72 50 42
7 Fana Fana 26 49 44 40
8 Vardeneset Vardeneset 26 52 64 37
9 Sogndal II Sogndal II 26 53 68 34
10 Stord Stord 26 51 62 30
11 Tertnes Tertnes 26 39 68 30
12 Øystese Øystese 26 39 75 24
13 Förde Förde 26 32 68 20
14 Varegg Varegg 26 18 83 12
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Brattvåg Brattvåg 26 78 27 56
2 Lysekloster Lysekloster 26 55 32 56
3 SK Herd SK Herd 26 57 48 42
4 Fyllingsdalen Fyllingsdale 26 61 50 41
5 Sotra SK Sotra SK 26 52 43 41
6 Varegg Varegg 26 51 54 40
7 Spjelkavik Spjelkavik 26 45 44 35
8 Förde Förde 26 47 49 34
9 Brann II Brann II 26 48 47 30
10 Stord Stord 26 48 58 30
11 Os Turn Os Turn 26 45 55 30
12 Haugesund II Haugesund 26 37 60 27
13 Fjora Fjora 26 41 73 26
14 Aalesunds FK II Aalesunds 26 35 60 17
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Vestfossen Vestfossen 26 92 45 52
2 Odd III Odd III 26 73 56 52
3 Strømsgodset III Strømsgodse 26 75 46 51
4 IF Ready IF Ready 26 64 39 51
5 Holmen Holmen 26 51 44 50
6 Halsen Halsen 26 71 46 49
7 Mjøndalen IF II Mjøndalen 26 85 43 47
8 Åssiden IF Åssiden IF 26 66 49 44
9 Eik Tønsberg Tønsberg 26 77 66 38
10 Bærum II Bærum II 26 51 72 29
11 Kongsberg Kongsberg 26 49 74 27
12 Asker II Asker II 26 43 103 19
13 Svelvik Svelvik 26 33 84 16
14 Drammen Drammen 26 21 84 6
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 FK Tønsberg Tønsberg 26 109 19 75
2 Lommedalen Lommedalen 26 91 52 57
3 Sandefjord II Sandefjord 26 85 51 49
4 Mjøndalen IF II Mjøndalen 26 78 68 46
5 Vestfossen Vestfossen 26 53 54 45
6 Strømsgodset III Strømsgodse 26 73 53 38
7 Åssiden IF Åssiden IF 26 60 58 35
8 Bærum II Bærum II 26 61 69 35
9 Larvik Turn Larvik Turn 26 54 71 32
10 Eik Tønsberg Tønsberg 26 60 68 31
11 Skarphedin Skarphedin 26 54 67 30
12 Modum Modum 26 41 54 30
13 Fagerborg Fagerborg 26 41 75 19
14 Birkebeineren Birkebeinere 26 26 127 7
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Drammen Drammen 24 66 44 50
2 Jevnaker Jevnaker 24 70 44 45
3 Lommedalen Lommedalen 24 63 44 43
4 Odd III Odd III 24 50 49 38
5 Modum Modum 24 56 45 33
6 Åssiden IF Åssiden IF 24 58 61 33
7 Bærum II Bærum II 24 52 69 32
8 Vestfossen Vestfossen 24 48 66 32
9 Lokomotiv Oslo Lokomotiv 24 44 47 31
10 Mjøndalen IF II Mjøndalen 24 53 57 30
11 Skarphedin Skarphedin 24 45 50 29
12 Hønefoss II Hønefoss 24 34 60 23
13 Asker II Asker II 24 60 63 20
14 Kjapp Kjapp 0 0 0 0
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Holmen Holmen 26 82 32 63
2 Ullern Ullern 26 95 42 62
3 Modum Modum 26 85 32 60
4 Jevnaker Jevnaker 26 101 38 58
5 Lommedalen Lommedalen 26 72 47 48
6 Mjøndalen IF II Mjøndalen 26 85 60 39
7 Bærum II Bærum II 26 72 81 37
8 Gjøvik-Lyn Gjøvik-Lyn 26 54 86 34
9 Hønefoss II Hønefoss 26 55 58 33
10 Asker II Asker II 26 60 72 33
11 Raufoss II Raufoss II 26 42 69 18
12 Nordre Land Nordre Land 26 33 67 18
13 Stoppen Stoppen 26 43 132 13
14 Drammens BK Drammens BK 26 37 100 11
Ver
TEMPORADA 2011/2012
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,687,880 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.4152
Total Execution Time  0.4172
  CADENA URL  
/cuarta_noruega2020/grupo4/historico
  GET DATOS  
$_GET['/cuarta_noruega2020/grupo4/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0131  SELECT type FROM routes WHERE alias = 'cuarta_noruega2020'
0.0262  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'cuarta_noruega' AND (l.group_code = 4 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=4 DESC LIMIT 1
0.0126  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1937 ORDER BY order_id ASC
0.0130  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 53748 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0131  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 1937 AND group_code = 4 and tables = 1 AND year <= 2020 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0134  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 = 53748 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.0141  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 = 48611 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143  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 `tables2018` 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 = 42435 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0141  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 `tables2017` 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 = 38249 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143  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 = 48759 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 `tables2014` 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 = 48830 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143  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 = 48842 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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.0130  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-01 08:46:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-01 08:46:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-01 08:46:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-01 08:46:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0141  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'cuarta_noruega' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0139  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2020 e ON e.player_id = p.id AND e.league_id = 53748 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 53748 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0139  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2020 e ON e.player_id = p.id AND e.league_id = 53748 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 53748 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0139  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2020 e ON e.player_id = p.id AND e.league_id = 53748 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 53748 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0179  SELECT *,(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 = 53748 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