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

Cruce de partidos Liga Profesional Argentina - Todos los partidos de la temporada

IdaVuelta
 Boca Juniors Estudiantes La Plata Independiente Racing Club River Plate San Lorenzo Vélez Sarsfield Newell's Old Boys Rosario Central CA Huracán Argentinos Juniors Gimnasia La Plata Lanús Banfield Unión Santa Fe Colón Tigre Quilmes Belgrano Godoy Cruz Arsenal de Sarandí Defensa y Justicia Sarmiento Temperley Atletico Rafaela San Martín San Juan Olimpo Nueva Chicago Aldosivi Crucero del Norte
Boca Juniors Boca Juniors
Estudiantes La Plata Estudiantes La Plata
Independiente Independiente
Racing Club Racing Club
River Plate River Plate
San Lorenzo San Lorenzo
Vélez Sarsfield Vélez Sarsfield
Newell's Old Boys Newell's Old Boys
Rosario Central Rosario Central
CA Huracán CA Huracán
Argentinos Juniors Argentinos Juniors
Gimnasia La Plata Gimnasia La Plata
Lanús Lanús
Banfield Banfield
Unión Santa Fe Unión Santa Fe
Colón Colón
Tigre Tigre
Quilmes Quilmes
Belgrano Belgrano
Godoy Cruz Godoy Cruz
Arsenal de Sarandí Arsenal de Sarandí
Defensa y Justicia Defensa y Justicia
Sarmiento Sarmiento
Temperley Temperley
Atletico Rafaela Atletico Rafaela
San Martín San Juan San Martín San Juan
Olimpo Olimpo
Nueva Chicago Nueva Chicago
Aldosivi Aldosivi
Crucero del Norte Crucero del Norte

  USO DE MEMORIA  
8,180,888 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.4037
Total Execution Time  0.4057
  CADENA URL  
/primera_division_argentina2015/grupo1/cruces
  GET DATOS  
$_GET['/primera_division_argentina2015/grupo1/cruces']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0125  SELECT type FROM routes WHERE alias = 'primera_division_argentina2015'
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=675 AND type_rel = 3
0.0127  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 = 8714 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0260  SELECT c.id, c.team1, c.team2, c.datateam1, c.datateam2, c.extra, c.shedule, c.r1, c.r2, c.status FROM calendars2015 AS c WHERE c.league_id='8714' ORDER BY c.id ASC
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 20:54:03' 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-04-28 20:54:03' 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-28 20:54:03' 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-28 20:54:03' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0302  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 events2015 e ON e.player_id = p.id AND e.league_id = 8714 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 8714 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.0452  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 events2015 e ON e.player_id = p.id AND e.league_id = 8714 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 8714 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0153  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 events2015 e ON e.player_id = p.id AND e.league_id = 8714 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 8714 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0262  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2015` 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 = 8714 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC