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 SVG Göttingen Göttingen 18 63 14 43
2 TSC Vahdet TSC Vahdet 18 50 21 40
3 Vorsfelde Vorsfelde 19 51 25 35
4 SSV Kästorf Kästorf 15 39 16 35
5 SV Lengede SV Lengede 18 45 28 30
6 BSC Acosta BSC Acosta 19 34 39 26
7 Göttingen 05 Göttingen 18 35 36 25
8 Sportfreunde Salzgitter Sportfreunde 18 39 39 21
9 MTV Isenbüttel Isenbüttel 16 28 38 20
10 Eintracht Braunschweig II Eintracht 17 28 41 19
11 SV Reislingen/Neuhaus Reislingen/N 19 27 49 19
12 TSV Landolfshausen Landolfshaus 16 22 41 18
13 KSV Vahdet KSV Vahdet 16 27 42 17
14 Petershütte Petershütte 16 24 52 16
15 TSV Germania Lamme Germania 16 32 47 15
16 SC Hainberg SC Hainberg 15 21 37 14
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 SV Hemelingen Hemelingen 30 113 31 81
2 Union Bremen Union Bremen 30 109 40 68
3 VfL Bremen VfL Bremen 30 97 47 64
4 TuS Komet Arsten Komet Arsten 30 108 56 63
5 TuRa Bremen TuRa Bremen 30 84 43 54
6 Woltmershausen Woltmershaus 30 89 53 53
7 Melchiorshausen Melchiorshau 30 53 49 48
8 FC Huchting FC Huchting 30 82 55 47
9 Vahr-Blockdiek Vahr-Blockdi 30 56 69 39
10 OT Bremen OT Bremen 30 60 71 37
11 SV Lemwerder Lemwerder 30 65 68 35
12 DJK Blumenthal Blumenthal 30 57 95 27
13 SV Grohn SV Grohn 30 52 97 26
14 SG Findorff SG Findorff 30 54 81 23
15 TV Bremen-Walle Bremen-Walle 30 37 82 21
16 TSV Lesum-Burgdamm Lesum-Burgda 30 24 203 3
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 SC Borgfeld SC Borgfeld 30 115 38 75
2 SFL Bremerhaven Bremerhaven 30 130 39 73
3 TuRa Bremen TuRa Bremen 30 81 54 55
4 SV Lemwerder Lemwerder 30 75 48 54
5 Union Bremen Union Bremen 30 81 58 50
6 TuS Komet Arsten Komet Arsten 30 93 59 49
7 SV Hemelingen Hemelingen 30 91 62 49
8 Vahr-Blockdiek Vahr-Blockdi 30 67 65 44
9 Woltmershausen Woltmershaus 30 79 67 40
10 TV Bremen-Walle Bremen-Walle 30 57 81 38
11 SV Grohn SV Grohn 30 68 91 34
12 OT Bremen OT Bremen 30 72 99 34
13 Melchiorshausen Melchiorshau 30 46 90 32
14 TSV Lesum-Burgdamm Lesum-Burgda 30 48 104 30
15 DJK Blumenthal Blumenthal 30 43 90 23
16 TSV Farge TSV Farge 30 44 145 13
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Hastedt Hastedt 30 115 31 71
2 Vatan Sport Vatan Sport 30 74 34 70
3 SFL Bremerhaven Bremerhaven 30 77 37 68
4 SC Borgfeld SC Borgfeld 30 99 44 63
5 SV Lemwerder Lemwerder 30 73 67 47
6 TuS Komet Arsten Komet Arsten 30 76 73 44
7 DJK Blumenthal Blumenthal 30 58 65 44
8 TSV Lesum-Burgdamm Lesum-Burgda 30 65 82 42
9 SV Hemelingen Hemelingen 30 68 67 38
10 Union Bremen Union Bremen 30 56 70 35
11 Vahr-Blockdiek Vahr-Blockdi 30 66 87 33
12 Woltmershausen Woltmershaus 30 52 64 32
13 OT Bremen OT Bremen 30 55 71 32
14 Türkspor Bremen Türkspor 30 48 68 32
15 TuSpo Surheide TuSpo 30 57 80 30
16 Burg Burg 30 30 129 4
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Oberneuland Oberneuland 30 112 37 78
2 Melchiorshausen Melchiorshau 30 81 39 65
3 SFL Bremerhaven Bremerhaven 30 104 30 63
4 SV Hemelingen Hemelingen 30 68 38 62
5 Vahr-Blockdiek Vahr-Blockdi 30 83 45 61
6 OT Bremen OT Bremen 30 99 52 55
7 SC Borgfeld SC Borgfeld 30 105 49 54
8 TuSpo Surheide TuSpo 30 71 73 43
9 Wulsdorf Wulsdorf 30 52 75 39
10 SV Lemwerder Lemwerder 30 55 56 35
11 Woltmershausen Woltmershaus 30 48 68 29
12 DJK Blumenthal Blumenthal 30 51 87 28
13 Türkspor Bremen Türkspor 30 45 94 28
14 Burg Burg 30 59 113 25
15 ATSV Sebaldsbrück Bremen ATSV 30 27 100 16
16 FC Sparta Bremerhaven Sparta 30 25 129 5

  USO DE MEMORIA  
5,407,224 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3618
Total Execution Time  0.3637
  CADENA URL  
/landesliga2020/grupo8/historico
  GET DATOS  
$_GET['/landesliga2020/grupo8/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0124  SELECT type FROM routes WHERE alias = 'landesliga2020'
0.0253  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 = 8 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=8 DESC LIMIT 1
0.0127  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 2090 GROUP BY l.categoryId
0.0127  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=2090 GROUP BY l.year ORDER BY l.year DESC
0.0126  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 = 51139 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0128  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 2090 AND group_code = 8 and tables = 1 AND year <= 2020 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0130  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 = 51139 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.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 = 48739 AND t.round = 30 ORDER BY team.conference 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 `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 = 46649 AND t.round = 30 ORDER BY team.conference 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 `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 = 46819 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 46837 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-07 18:05:22' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-07 18:05:22' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-07 18:05:22' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-07 18:05:22' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0131  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.0128  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 = 51139 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51139 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.0126  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 = 51139 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51139 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0126  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 = 51139 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51139 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0137  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 = 51139 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