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

Cruce de partidos MLS - Liga USA - Todos los partidos de la temporada

IdaVuelta
 Seattle Sounders LA Galaxy Sporting Kansas City DC United New York RB Columbus Crew New England Revolution FC Dallas Vancouver Whitecaps CF Montréal Chicago Fire Portland Timbers Colorado Rapids Houston Dynamo Real Salt Lake San Jose Earthquakes Toronto FC Philadelphia Union Chivas USA
Seattle Sounders Seattle Sounders
LA Galaxy LA Galaxy
Sporting Kansas City Sporting Kansas City
DC United DC United
New York RB New York RB
Columbus Crew Columbus Crew
New England Revolution New England Revolution
FC Dallas FC Dallas
Vancouver Whitecaps Vancouver Whitecaps
CF Montréal CF Montréal
Chicago Fire Chicago Fire
Portland Timbers Portland Timbers
Colorado Rapids Colorado Rapids
Houston Dynamo Houston Dynamo
Real Salt Lake Real Salt Lake
San Jose Earthquakes San Jose Earthquakes
Toronto FC Toronto FC
Philadelphia Union Philadelphia Union
Chivas USA Chivas USA

  USO DE MEMORIA  
6,342,864 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0027
Controller Execution Time ( Home / Category )  0.2836
Total Execution Time  0.2863
  CADENA URL  
/usa2012/grupo1/cruces
  GET DATOS  
$_GET['/usa2012/grupo1/cruces']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (8)  
0.0217  SELECT c.id, c.team1, c.team2, c.datateam1, c.datateam2, c.extra, c.shedule, c.r1, c.r2, c.status FROM calendars2012 AS c WHERE c.league_id='1561' ORDER BY c.id ASC
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 13:17:32' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0124  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 13:17:32' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0109  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 13:17:32' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0112  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 13:17:32' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0548  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 events2012 e ON e.player_id = p.id AND e.league_id = 1561 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 1561 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.0295  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 events2012 e ON e.player_id = p.id AND e.league_id = 1561 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 1561 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0116  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 events2012 e ON e.player_id = p.id AND e.league_id = 1561 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 1561 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10