4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

Cruce de partidos Tercera Austria - Todos los partidos de la temporada

IdaVuelta
 Blau-Weiß Linz TSV Hartberg Spittal Voitsberg Union St. Florian Wels Sturm Graz II Bleiburg Gratkorn Union Perg Köflach WAC Sankt Andrä SC Schwanenstadt LASK Linz II FC Kärnten II Arnfels
Blau-Weiß Linz Blau-Weiß Linz
TSV Hartberg TSV Hartberg
Spittal Spittal
Voitsberg Voitsberg
Union St. Florian Union St. Florian
Wels Wels
Sturm Graz II Sturm Graz II
Bleiburg Bleiburg
Gratkorn Gratkorn
Union Perg Union Perg
Köflach Köflach
WAC Sankt Andrä WAC Sankt Andrä
SC Schwanenstadt SC Schwanenstadt
LASK Linz II LASK Linz II
FC Kärnten II FC Kärnten II
Arnfels Arnfels

  USO DE MEMORIA  
6,087,192 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.0906
Total Execution Time  0.0927
  CADENA URL  
/regionalliga2004/grupo1/cruces
  GET DATOS  
$_GET['/regionalliga2004/grupo1/cruces']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (10)  
0.0026  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 = 27570 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0058  SELECT c.id, c.team1, c.team2, c.datateam1, c.datateam2, c.extra, c.shedule, c.r1, c.r2, c.status FROM calendars2004 AS c WHERE c.league_id='27570' ORDER BY c.id ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 04:13:17' 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=2 AND last_update > '2024-04-28 04:13:17' 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-28 04:13:17' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 04:13:17' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0025  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 events2004 e ON e.player_id = p.id AND e.league_id = 27570 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 27570 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 events2004 e ON e.player_id = p.id AND e.league_id = 27570 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 27570 AND (e.action = 4 or e.action = 5) 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 events2004 e ON e.player_id = p.id AND e.league_id = 27570 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 27570 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0062  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2004` 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 = 27570 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC