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

Cruce de partidos USL Championship - USA - Todos los partidos de la temporada

IdaVuelta
 Charleston Battery Richmond Kickers Rochester New York Pittsburgh Riverhounds Orange County SC Sacramento Republic Phoenix Rising Louisville City Charlotte Independence Colorado Springs Switchback FC Tulsa LA Galaxy II Penn FC New York RB II OKC Energy Wilmington Hammerheads Real Monarchs Austin Aztex Saint Louis Toronto II Portland Timbers II Vancouver Whitecaps II Seattle Sounders II FC Montreal
Charleston Battery Charleston Battery
Richmond Kickers Richmond Kickers
Rochester New York Rochester New York
Pittsburgh Riverhounds Pittsburgh Riverhounds
Orange County SC Orange County SC
Sacramento Republic Sacramento Republic
Phoenix Rising Phoenix Rising
Louisville City Louisville City
Charlotte Independence Charlotte Independence
Colorado Springs Switchback Colorado Springs Switchback
FC Tulsa FC Tulsa
LA Galaxy II LA Galaxy II
Penn FC Penn FC
New York RB II New York RB II
OKC Energy OKC Energy
Wilmington Hammerheads Wilmington Hammerheads
Real Monarchs Real Monarchs
Austin Aztex Austin Aztex
Saint Louis Saint Louis
Toronto II Toronto II
Portland Timbers II Portland Timbers II
Vancouver Whitecaps II Vancouver Whitecaps II
Seattle Sounders II Seattle Sounders II
FC Montreal FC Montreal

  USO DE MEMORIA  
6,753,568 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3405
Total Execution Time  0.3424
  CADENA URL  
/usl_pro_usa2015/grupo1/cruces
  GET DATOS  
$_GET['/usl_pro_usa2015/grupo1/cruces']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0125  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1666 ORDER BY order_id ASC
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 = 9545 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0258  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='9545' ORDER BY c.id ASC
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-30 18:26:23' 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-30 18:26:23' 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 18:26:23' 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 18:26:23' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0288  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 = 9545 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 9545 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.0334  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 = 9545 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 9545 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0149  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 = 9545 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 9545 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0388  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 = 9545 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC