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 Lohbrügge Lohbrügge 22 96 26 61
2 ASV Hamburg ASV Hamburg 22 70 38 42
3 SV Altengamme Altengamme 21 51 32 41
4 SC V/W Billstedt Billstedt 21 40 34 37
5 Condor Hamburg Condor 22 53 53 36
6 Rahlstedter SC Rahlstedter 22 46 48 34
7 Voran Ohe Voran Ohe 20 48 43 33
8 Kosova Kosova 22 48 42 28
9 Oststeinbeker SV Oststeinbeke 22 38 43 26
10 SV Bergstedt Bergstedt 21 40 47 26
11 Türkiye Türkiye 19 33 44 23
12 TuS Berne TuS Berne 21 36 81 22
13 Dersimspor Hamburg Dersimspor 19 33 47 21
14 Düneberger SV Düneberger 22 31 58 21
15 SV Nettelnburg/Allermöhe Nettelnburg/ 22 36 44 20
16 FTSV Altenwerder FTSV 22 36 55 14
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Hamm United FC Hamm United 30 93 36 67
2 Bramfelder SV Bramfelder 29 104 37 66
3 Lohbrügge Lohbrügge 30 78 31 65
4 SV Nettelnburg/Allermöhe Nettelnburg/ 30 78 53 55
5 Voran Ohe Voran Ohe 30 69 50 53
6 SV Altengamme Altengamme 30 98 55 51
7 BSV Buxtehude Buxtehude 30 72 58 46
8 Kosova Kosova 30 84 75 45
9 Vorwärts-Wacker 04 Vorwärts-Wa 30 75 50 42
10 Dersimspor Hamburg Dersimspor 30 46 84 38
11 SV Bergstedt Bergstedt 30 65 85 34
12 Düneberger SV Düneberger 30 56 70 31
13 Rahlstedter SC Rahlstedter 30 48 71 29
14 TuS Berne TuS Berne 30 66 100 29
15 Inter Hamburg Inter 30 55 141 18
16 FC Elazig Spor Elazig Spor 29 36 127 14
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Meiendorfer SV Meiendorfer 30 83 21 72
2 Bramfelder SV Bramfelder 30 77 55 59
3 Dersimspor Hamburg Dersimspor 30 65 47 55
4 SV Altengamme Altengamme 30 86 57 53
5 Voran Ohe Voran Ohe 30 59 48 50
6 SV Nettelnburg/Allermöhe Nettelnburg/ 30 74 67 49
7 BSV Buxtehude Buxtehude 30 78 64 47
8 Lohbrügge Lohbrügge 30 79 65 46
9 SV Bergstedt Bergstedt 30 52 55 44
10 Rahlstedter SC Rahlstedter 30 62 57 41
11 TuS Berne TuS Berne 30 65 68 41
12 Kosova Kosova 30 46 76 33
13 FC Elazig Spor Elazig Spor 30 43 70 29
14 Juventude do Minho Juventude 30 46 86 27
15 Bergedorf 85 Bergedorf 30 39 79 23
16 Condor Hamburg II Condor 30 51 90 18
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 TSV Sasel TSV Sasel 30 90 34 63
2 Vorwärts-Wacker 04 Vorwärts-Wa 30 71 39 62
3 Bramfelder SV Bramfelder 30 81 38 59
4 Dersimspor Hamburg Dersimspor 30 71 48 59
5 Meiendorfer SV Meiendorfer 30 73 52 53
6 Voran Ohe Voran Ohe 30 63 50 49
7 SV Nettelnburg/Allermöhe Nettelnburg/ 30 59 56 46
8 Paloma Hamburg Paloma 30 60 46 43
9 Condor Hamburg II Condor 30 60 65 39
10 Bergedorf 85 Bergedorf 30 56 80 37
11 FC Elazig Spor Elazig Spor 30 43 55 32
12 Lohbrügge Lohbrügge 30 51 62 31
13 SV Altengamme Altengamme 30 33 55 31
14 Hamm United FC Hamm United 30 39 55 26
15 Barsbütteler SV Barsbüttele 30 30 55 23
16 SC Schwarzenbek Schwarzenbek 30 26 116 13
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 SC Poppenbüttel Poppenbütte 27 102 36 65
2 Kosova Kosova 27 57 29 57
3 Hamm United FC Hamm United 28 55 29 57
4 Dersimspor Hamburg Dersimspor 28 61 32 56
5 Lohbrügge Lohbrügge 28 75 58 43
6 FC Elazig Spor Elazig Spor 28 47 68 40
7 SV Altengamme Altengamme 27 60 40 39
8 Bramfelder SV Bramfelder 28 47 45 39
9 Bergedorf 85 Bergedorf 27 54 62 39
10 SC Schwarzenbek Schwarzenbek 28 45 52 37
11 Voran Ohe Voran Ohe 28 48 64 33
12 Vorwärts-Wacker 04 Vorwärts-Wa 28 53 59 30
13 Barsbütteler SV Barsbüttele 28 38 55 30
14 SC Vier- und Marschlande Vier- 28 42 73 20
15 Croatia Hamburg Croatia 28 20 102 6

  USO DE MEMORIA  
5,383,472 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0032
Controller Execution Time ( Home / Category )  0.2883
Total Execution Time  0.2916
  CADENA URL  
/landesliga2020/grupo10/historico
  GET DATOS  
$_GET['/landesliga2020/grupo10/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0125  SELECT id,name,alias,stepParent FROM categories WHERE parentId=2090 ORDER BY order_id ASC
0.0128  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 2090 AND group_code = 10 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 = 50262 AND t.round = 22 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 `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 = 48741 AND t.round = 30 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 `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 = 46651 AND t.round = 30 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 `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 = 46821 AND t.round = 30 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 = 46839 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-04-30 22:40:12' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-30 22:40:12' 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-04-30 22:40:12' 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-04-30 22:40:12' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0127  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 = 50262 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50262 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 = 50262 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50262 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 = 50262 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50262 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 = 50262 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC