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 Rotenburger SV Rotenburger 18 50 26 41
2 MTV Treubund Lüneburg Treubund 18 46 18 38
3 TuS Harsefeld Harsefeld 18 33 18 33
4 Ahlerstedt Ahlerstedt 17 44 29 31
5 Drochtersen/Assel II Drochtersen/ 18 42 35 30
6 Güldenstern Stade Güldenstern 19 40 42 27
7 VfL Lüneburg Lüneburg 16 28 24 26
8 FC Verden 04 Verden 19 32 30 26
9 Ottersberg Ottersberg 18 39 41 24
10 Blau Weiss Bornreihe Blau Weiss. 19 37 42 23
11 VfL Westercelle Westercelle 19 36 36 21
12 Hedendorf/Neukloster Hedendorf/Ne 19 38 53 21
13 TSV Gellersen Gellersen 17 27 33 20
14 Eintracht Lüneburg Eintracht 18 28 44 20
15 Teutonia Uelzen Teutonia 18 28 36 16
16 SV Emmendorf Emmendorf 17 20 61 6
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 MTV Eintracht Celle Eintracht 30 106 35 70
2 TuS Harsefeld Harsefeld 30 64 38 60
3 Ahlerstedt Ahlerstedt 30 73 36 56
4 MTV Treubund Lüneburg Treubund 30 60 36 53
5 Rotenburger SV Rotenburger 30 50 33 53
6 Eintracht Lüneburg Eintracht 30 67 61 50
7 Teutonia Uelzen Teutonia 30 56 55 45
8 Güldenstern Stade Güldenstern 30 63 59 44
9 Blau Weiss Bornreihe Blau Weiss. 30 52 49 43
10 SV Emmendorf Emmendorf 30 49 56 41
11 FC Verden 04 Verden 30 52 53 40
12 TSV Gellersen Gellersen 30 53 53 39
13 Drochtersen/Assel II Drochtersen/ 30 45 62 39
14 TSV Winsen/Luhe Winsen/Luhe 30 44 80 25
15 TV Meckelfeld Meckelfeld 30 23 74 21
16 TuSG Ritterhude TuSG 30 33 110 8
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Hagen/Uthlede Hagen/Uthled 30 91 39 72
2 MTV Treubund Lüneburg Treubund 30 76 25 66
3 Blau Weiss Bornreihe Blau Weiss. 30 60 42 50
4 SV Emmendorf Emmendorf 30 54 55 49
5 Rotenburger SV Rotenburger 30 36 30 48
6 Eintracht Lüneburg Eintracht 30 45 42 44
7 TuS Harsefeld Harsefeld 30 43 44 43
8 TuSG Ritterhude TuSG 30 45 69 41
9 Ahlerstedt Ahlerstedt 30 55 52 39
10 TV Meckelfeld Meckelfeld 30 45 45 37
11 Drochtersen/Assel II Drochtersen/ 30 47 53 37
12 Teutonia Uelzen Teutonia 30 67 67 35
13 Ottersberg Ottersberg 30 40 56 33
14 TSV Etelsen TSV Etelsen 30 65 83 32
15 VfL Westercelle Westercelle 30 40 64 32
16 Cuxhaven Cuxhaven 30 40 83 15
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 MTV Eintracht Celle Eintracht 30 77 34 65
2 TuS Harsefeld Harsefeld 30 54 31 60
3 Hagen/Uthlede Hagen/Uthled 30 75 38 58
4 MTV Treubund Lüneburg Treubund 30 63 36 57
5 TSV Etelsen TSV Etelsen 30 60 43 48
6 Cuxhaven Cuxhaven 30 57 50 47
7 Teutonia Uelzen Teutonia 30 69 55 45
8 Drochtersen/Assel II Drochtersen/ 30 46 59 42
9 Eintracht Lüneburg Eintracht 30 53 44 41
10 TV Meckelfeld Meckelfeld 30 52 57 39
11 Ottersberg Ottersberg 30 40 49 39
12 Rotenburger SV Rotenburger 30 49 44 38
13 FC Verden 04 Verden 30 53 78 36
14 TuS Bodenteich Bodenteich 30 27 45 32
15 SV Pennigbüttel Pennigbütte 30 31 86 15
16 SG Stinstedt Stinstedt 30 39 96 13
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Blau Weiss Bornreihe Blau Weiss. 32 105 48 71
2 Hagen/Uthlede Hagen/Uthled 32 83 41 66
3 MTV Eintracht Celle Eintracht 32 64 37 61
4 Rotenburger SV Rotenburger 32 55 46 58
5 Cuxhaven Cuxhaven 32 63 50 52
6 Ottersberg Ottersberg 32 50 60 47
7 TuS Harsefeld Harsefeld 32 59 46 46
8 Eintracht Lüneburg Eintracht 32 52 48 46
9 MTV Treubund Lüneburg Treubund 32 53 47 45
10 TSV Etelsen TSV Etelsen 32 62 43 43
11 FC Verden 04 Verden 32 75 58 43
12 Drochtersen/Assel II Drochtersen/ 32 62 60 43
13 TV Jahn Schneverdingen Jahn 32 74 61 42
14 Ahlerstedt Ahlerstedt 32 43 60 37
15 TuS Celle TuS Celle 32 43 91 30
16 TuS Zeven TuS Zeven 32 42 91 20
17 MTV Dannenberg Dannenberg 32 24 122 12

  USO DE MEMORIA  
5,405,072 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0822
Total Execution Time  0.0842
  CADENA URL  
/landesliga2020/grupo17/historico
  GET DATOS  
$_GET['/landesliga2020/grupo17/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0018  SELECT type FROM routes WHERE alias = 'landesliga2020'
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'landesliga' AND (l.group_code = 17 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=17 DESC LIMIT 1
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=2090 ORDER BY order_id ASC
0.0019  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 = 50527 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 2090 AND group_code = 17 and tables = 1 AND year <= 2020 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0028  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 = 50527 AND t.round = 19 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 48750 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 46658 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 46828 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032  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 = 46846 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 15:17:30' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 15:17:30' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 15:17:30' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0021  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 15:17:30' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'landesliga' 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.0020  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 = 50527 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50527 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.0020  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 = 50527 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50527 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0019  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 = 50527 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50527 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0029  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 = 50527 AND t.round = 19 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC