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
 Charlotte Eagles North Carolina Fusion U23 Reading United Ocean City Nor'easters Long Island Rough Riders Western Mass Pioneers Seacoast United Phantoms SC United Bantams West Chester United Connecticut Westchester Flames Northern Virginia Royals Lehigh Valley Utd. Sonic Lionsbridge Boston Bolts Black Rock Cedar Stars Rush North Carolina II Boston City Christos Manhattan Tobacco Road New Jersey Copa West Virginia United Virginia Beach United Wake Charlotte Independence II Hudson Valley Vermont Green Lone Star II Morris Elite RC New Jersey Albany Rush FC Motown II Pathfinder Patuxent Ironbound Virginia Marauders Charlottesville Blues Staten Island Athletic
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
Seacoast United Phantoms Seacoast United Phantoms
SC United Bantams SC United Bantams
West Chester United West Chester United
Connecticut Connecticut
Westchester Flames Westchester Flames
Northern Virginia Royals Northern Virginia Royals
Lehigh Valley Utd. Sonic Lehigh Valley Utd. Sonic
Lionsbridge Lionsbridge
Boston Bolts Boston Bolts
Black Rock Black Rock
Cedar Stars Rush Cedar Stars Rush
North Carolina II North Carolina II
Boston City Boston City
Christos Christos
Manhattan Manhattan
Tobacco Road Tobacco Road
New Jersey Copa New Jersey Copa
West Virginia United West Virginia United
Virginia Beach United Virginia Beach United
Wake Wake
Charlotte Independence II Charlotte Independence II
Hudson Valley Hudson Valley
Vermont Green Vermont Green
Lone Star II Lone Star II
Morris Elite Morris Elite
RC New Jersey RC New Jersey
Albany Rush Albany Rush
FC Motown II FC Motown II
Pathfinder Pathfinder
Patuxent Patuxent
Ironbound Ironbound
Virginia Marauders Virginia Marauders
Charlottesville Blues Charlottesville Blues
Staten Island Athletic Staten Island Athletic

  USO DE MEMORIA  
7,674,776 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0028
Controller Execution Time ( Home / Category )  0.1046
Total Execution Time  0.1074
  CADENA URL  
/pdl2024/grupo1/cruces
  GET DATOS  
$_GET['/pdl2024/grupo1/cruces']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0018  SELECT type FROM routes WHERE alias = 'pdl2024'
0.0039  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'pdl' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0021  SELECT id,name,alias,stepParent FROM categories WHERE parentId=671 ORDER BY order_id ASC
0.0023  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 = 75488 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024  SELECT c.id, c.team1, c.team2, c.datateam1, c.datateam2, c.extra, c.shedule, c.r1, c.r2, c.status FROM calendars2024 AS c WHERE c.league_id='75488' 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-27 17:46:31' 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=2 AND last_update > '2024-04-27 17:46:31' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 17:46:31' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 17:46:31' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0026  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'pdl' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
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 events2024 e ON e.player_id = p.id AND e.league_id = 75488 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 75488 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.0021  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 events2024 e ON e.player_id = p.id AND e.league_id = 75488 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 75488 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0021  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 events2024 e ON e.player_id = p.id AND e.league_id = 75488 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 75488 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0053  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2024` 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 = 75488 AND t.round = 1 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC