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

Cruce de partidos USL League Two - Todos los partidos de la temporada

IdaVuelta
 Des Moines Menace Flint City Bucks Ventura County Fusion Charlotte Eagles North Carolina Fusion U23 Reading United Ocean City Nor'easters Long Island Rough Riders Western Mass Pioneers Tucson CFC Atletico Mississippi Brilla Thunder Bay Chill Seacoast United Phantoms Dayton Dutch Lions Portland Phoenix The Villages Tormenta Fresno Fuego SC United Bantams Seattle Sounders Sub 23 Wilmington Hammerheads St. Louis Lions Jersey Express Seahorses West Virginia Chaos Connecticut Westchester Flames Victoria Highlanders Academy Bradenton BYU Cougars Calgary Foothills Golden State Force New York RB III Chicago FC United Lehigh Valley Utd. Sonic Twin City Toucans Manitoba Miami City San Francisco City FA Euro K-W United Lane United Springfield Synergy Boston Bolts Colorado Rapids II Texas United TSS Rovers Cincinnati Dutch Lions Derby City Rovers
Des Moines Menace Des Moines Menace
Flint City Bucks Flint City Bucks
Ventura County Fusion Ventura County Fusion
Charlotte Eagles Charlotte Eagles
North Carolina Fusion U23 North Carolina Fusion U23
Reading United Reading United
Ocean City Nor'easters Ocean City Nor'easters
Long Island Rough Riders Long Island Rough Riders
Western Mass Pioneers Western Mass Pioneers
Tucson Tucson
CFC Atletico CFC Atletico
Mississippi Brilla Mississippi Brilla
Thunder Bay Chill Thunder Bay Chill
Seacoast United Phantoms Seacoast United Phantoms
Dayton Dutch Lions Dayton Dutch Lions
Portland Phoenix Portland Phoenix
The Villages The Villages
Tormenta Tormenta
Fresno Fuego Fresno Fuego
SC United Bantams SC United Bantams
Seattle Sounders Sub 23 Seattle Sounders Sub 23
Wilmington Hammerheads Wilmington Hammerheads
St. Louis Lions St. Louis Lions
Jersey Express Jersey Express
Seahorses Seahorses
West Virginia Chaos West Virginia Chaos
Connecticut Connecticut
Westchester Flames Westchester Flames
Victoria Highlanders Victoria Highlanders
Academy Bradenton Academy Bradenton
BYU Cougars BYU Cougars
Calgary Foothills Calgary Foothills
Golden State Force Golden State Force
New York RB III New York RB III
Chicago FC United Chicago FC United
Lehigh Valley Utd. Sonic Lehigh Valley Utd. Sonic
Twin City Toucans Twin City Toucans
Manitoba Manitoba
Miami City Miami City
San Francisco City San Francisco City
FA Euro FA Euro
K-W United K-W United
Lane United Lane United
Springfield Synergy Springfield Synergy
Boston Bolts Boston Bolts
Colorado Rapids II Colorado Rapids II
Texas United Texas United
TSS Rovers TSS Rovers
Cincinnati Dutch Lions Cincinnati Dutch Lions
Derby City Rovers Derby City Rovers

  USO DE MEMORIA  
9,319,880 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.3517
Total Execution Time  0.3537
  CADENA URL  
/pdl2017/grupo1/cruces
  GET DATOS  
$_GET['/pdl2017/grupo1/cruces']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (10)  
0.0154  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 = 37996 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0334  SELECT c.id, c.team1, c.team2, c.datateam1, c.datateam2, c.extra, c.shedule, c.r1, c.r2, c.status FROM calendars2017 AS c WHERE c.league_id='37996' ORDER BY c.id ASC
0.0148  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-09 06:49:30' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0149  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-09 06:49:31' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0149  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-09 06:49:31' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0147  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-09 06:49:31' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0155  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 = 37996 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 37996 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.0151  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 = 37996 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 37996 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0156  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 = 37996 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 37996 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0364  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 = 37996 AND t.round = 51 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC