4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 TSV Schwaben Augsburg Schwaben 32 58 20 68
2 Türkspor Augsburg Türkspor 32 68 43 61
3 FV Illertissen II Illertissen 32 74 44 57
4 SV Egg SV Egg 32 58 43 56
5 SC Ichenhausen Ichenhausen 32 44 31 56
6 TSV Nördlingen Nördlingen 32 57 50 49
7 SC Olching SC Olching 32 51 44 48
8 TSV Aindling Aindling 32 54 48 47
9 FC Memmingen II Memmingen 32 49 46 44
10 SV Mering SV Mering 32 51 54 42
11 SpV Kaufbeuren Kaufbeuren 32 40 45 39
12 FC Stätzling Stätzling 32 50 58 39
13 Raisting Raisting 32 44 52 38
14 TSV Gilching-Argelsried Gilching-Arg 32 48 61 38
15 SC Oberweikertshofen Oberweikerts 32 32 52 26
16 FC Ehekirchen Ehekirchen 32 35 77 20
17 Kissinger SC Kissinger 32 24 69 16
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 FC Gundelfingen Gundelfingen 32 65 29 63
2 SV Mering SV Mering 32 67 46 59
3 TSV Nördlingen Nördlingen 32 70 45 56
4 SC Oberweikertshofen Oberweikerts 32 48 40 51
5 SV Egg SV Egg 32 58 36 50
6 FC Memmingen II Memmingen 32 45 36 50
7 FV Illertissen II Illertissen 32 49 45 49
8 TSV Aindling Aindling 32 43 36 46
9 Raisting Raisting 32 50 40 45
10 SC Ichenhausen Ichenhausen 32 51 45 44
11 Türkspor Augsburg Türkspor 32 58 65 44
12 SpV Kaufbeuren Kaufbeuren 32 36 45 38
13 Kissinger SC Kissinger 32 39 55 35
14 TSV Meitingen Meitingen 32 47 69 35
15 Fürstenfeldbruck Fürstenfeld 32 44 63 33
16 TuS Feuchtwangen Feuchtwangen 32 42 66 30
17 SF Dinkelsbühl Dinkelsbühl 32 35 86 23

  USO DE MEMORIA  
5,212,224 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3550
Total Execution Time  0.3569
  CADENA URL  
/landesliga2017/grupo1/historico
  GET DATOS  
$_GET['/landesliga2017/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0144  SELECT type FROM routes WHERE alias = 'landesliga2017'
0.0291  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 = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2017 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0146  SELECT id,name,alias,stepParent FROM categories WHERE parentId=2090 ORDER BY order_id ASC
0.0149  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 2090 AND group_code = 1 and tables = 1 AND year <= 2017 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0150  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 = 46830 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-10 05:12:40' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-10 05:12:40' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-10 05:12:40' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-10 05:12:40' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0151  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 = 2017 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0276  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 events2017 e ON e.player_id = p.id AND e.league_id = 46812 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 46812 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.0275  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 events2017 e ON e.player_id = p.id AND e.league_id = 46812 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 46812 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0162  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 events2017 e ON e.player_id = p.id AND e.league_id = 46812 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 46812 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0156  SELECT *,(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 = 46812 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC