4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2024
 
US Open Cup 2024
2023/2024

u.s. open cup, lamar hunt u.s. open cup, national challenge cup, copa usa, copa de los estados unidos, us cup, us open cup

US Open Cup 2024

Ver jornada
Jornada 1
19 Mar 24 ChattanoogaChattanooga 0 - 1 Miami UnitedMiami 24
20 Mar 24 Brave SCBrave SC 0 - 2 Savannah CloversSavannah 9
20 Mar 24 Forward MadisonForward 2 - 0 DuluthDuluth 18
20 Mar 24 Vermont GreenVermont 4 - 3 LexingtonLexington 19
20 Mar 24 TormentaTormenta 1 - 0 America CFL SpursAmerica 1
20 Mar 24 West Chester UnitedWest 0 - 2 Maryland BobcatsMaryland 14
20 Mar 24 Tulsa AthleticsTulsa 1 - 4 Northern ColoradoNorthern 12
20 Mar 24 Austin FC IIAustin 2 - 2 Foro SCForo SC 4
20 Mar 24 Portland Timbers IIPortland 1 - 2 El FarolitoFarolito 68
20 Mar 24 Richmond KickersRichmond 1 - 0 ChristosChristos 17
21 Mar 24 Asheville CityAsheville 0 - 2 One KnoxvilleKnoxville 14
21 Mar 24 Chicago Fire IIChicago 6 - 0 Chicago CityChicago 4
21 Mar 24 AS FrenziAS Frenzi 2 - 3 Club De LyonClub Lyon 3
21 Mar 24 SC United BantamsUnited 0 - 1 Greenville TriumphGreenville 19
21 Mar 24 Apotheos FCApotheos Apl Georgia Lions SCGeorgia 1
21 Mar 24 New York RB IIYork 5 - 1 Hudson ValleyHudson 20
21 Mar 24 Chicago House ACChicago 0 - 3 Minnesota United IIMinnesota 1
21 Mar 24 FC FolsomFC Folsom 1 - 2 Fuego FCFuego FC 11
21 Mar 24 BallardBallard 0 - 1 Spokane VelocitySpokane 29
21 Mar 24 CapoCapo 2 - 2 Des Moines MenaceMoines 7
21 Mar 24 Irvine ZetaIrvine Zeta 1 - 0 MesoAmerica FCMesoAmerica 1
21 Mar 24 LA ForceLA Force 2 - 1 RedlandsRedlands 39
22 Mar 24 Steel CitySteel City 0 - 1 Michigan StarsMichigan 12
22 Mar 24 Carolina CoreCarolina 3 - 2 Northern VirginiaNorthern 23
22 Mar 24 Chattanooga Red WolvesChattanooga 4 - 2 BrocktonBrockton 4
22 Mar 24 Crown LegacyCrown 0 - 1 SC United HeatUnited Heat 6
22 Mar 24 MotownMotown 0 - 3 New York City IIYork City 1
22 Mar 24 Vereinigung ErzgebirgeVereinigung 0 - 2 Charlotte IndependenceCharlotte 1
22 Mar 24 Western Mass PioneersWestern 0 - 4 Union OmahaUnion Omaha 2
22 Mar 24 Lubbock Matadors SCLubbock 2 - 1 Arizona MonsoonArizona 3
22 Mar 24 Colorado Rapids IIColorado 3 - 0 AztecaAzteca 5
22 Mar 24 LA Galaxy IIGalaxy 2 - 1 Irvine Zeta IIIrvine Zeta 9
Ver jornada
Jornada 2
03 Abr 24 Fuego FCFuego FC 1 - 2 El FarolitoFarolito 42
03 Abr 24 Charlotte IndependenceCharlotte 0 - 0 SC United HeatUnited Heat 15
03 Abr 24 Lubbock Matadors SCLubbock 2 - 0 Foro SCForo SC 3
03 Abr 24 Minnesota United IIMinnesota 0 - 2 Michigan StarsMichigan 2
04 Abr 24 Miami UnitedMiami 2 - 0 Club De LyonClub Lyon 4
03 Abr 24 New York City IIYork City 4 - 2 New York RB IIYork 6
03 Abr 24 Richmond KickersRichmond 5 - 2 Maryland BobcatsMaryland 5
04 Abr 24 Apotheos FCApotheos 0 - 1 Chattanooga Red WolvesChattanooga 6
04 Abr 24 Chicago Fire IIChicago 2 - 0 Forward MadisonForward 7
04 Abr 24 Colorado Rapids IIColorado 2 - 3 Northern ColoradoNorthern 3
04 Abr 24 One KnoxvilleKnoxville 2 - 3 Greenville TriumphGreenville 3
04 Abr 24 TormentaTormenta 4 - 0 Savannah CloversSavannah 2
04 Abr 24 Spokane VelocitySpokane 1 - 0 LA ForceLA Force 19
04 Abr 24 Union OmahaUnion Omaha 3 - 1 Des Moines MenaceMoines 5
04 Abr 24 LA Galaxy IIGalaxy 0 - 3 Irvine ZetaIrvine Zeta 11
04 Abr 24 Vermont GreenVermont 1 - 2 Carolina CoreCarolina 1
Ver jornada
Jornada 3
17 Abr 24 Charlotte IndependenceCharlotte 4 - 4 Rhode Island FCRhode 26
17 Abr 24 Detroit CityDetroit 1 - 0 Michigan StarsMichigan 93
17 Abr 24 Louisville CityLouisville 3 - 1 Greenville TriumphGreenville 9
17 Abr 24 New Mexico UnitedMexico 3 - 1 Lubbock Matadors SCLubbock 8
17 Abr 24 Oakland RootsOakland 2 - 1 El FarolitoFarolito 57
18 Abr 24 Birmingham LegionBirmingham 4 - 2 Chattanooga Red WolvesChattanooga 4
18 Abr 24 Chicago Fire IIChicago 0 - 1 Indy ElevenIndy Eleven 9
18 Abr 24 FC TulsaFC Tulsa 2 - 1 Northern ColoradoNorthern 1
18 Abr 24 Hartford AthleticHartford 2 - 3 New York City IIYork City 9
18 Abr 24 Las Vegas LightsVegas 2 - 1 Spokane VelocitySpokane 41
18 Abr 24 Memphis 901Memphis 2 - 0 Miami UnitedMiami 4
18 Abr 24 Miami FCMiami FC 2 - 4 TormentaTormenta 10
18 Abr 24 Monterey BayMonterey 2 - 1 Irvine ZetaIrvine Zeta 6
18 Abr 24 North CarolinaNorth 1 - 0 Carolina CoreCarolina 5
18 Abr 24 Richmond KickersRichmond 0 - 0 Loudoun UnitedLoudoun 5
18 Abr 24 Union OmahaUnion Omaha 0 - 0 El Paso LocomotivePaso 10
Ver jornada
Jornada 4
08 May 24 Pittsburgh RiverhoundsPittsburgh
01:00
 		FC TulsaFC Tulsa 1
08 May 24 Atlanta UnitedAtlanta
01:30
 		Charlotte IndependenceCharlotte 1
08 May 24 Houston DynamoHouston
02:00
 		Detroit CityDetroit 1
08 May 24 FC DallasFC Dallas
02:30
 		Memphis 901Memphis 1
08 May 24 Orange County SCOrange
04:00
 		Loudoun UnitedLoudoun 1
08 May 24 San Jose EarthquakesJose
04:00
 		Oakland RootsOakland 1
08 May 24 Sacramento RepublicSacramento
04:30
 		Monterey BayMonterey 1
09 May 24 Charleston BatteryCharleston
01:00
 		TormentaTormenta ...
09 May 24 North CarolinaNorth
01:00
 		Phoenix RisingPhoenix ...
09 May 24 Indy ElevenIndy Eleven
01:00
 		San AntonioAntonio ...
09 May 24 Tampa Bay RowdiesTampa
01:30
 		Birmingham LegionBirmingham ...
09 May 24 New York City IIYork City
01:30
 		Colorado Springs SwitchbackColorado ...
09 May 24 Union OmahaUnion Omaha
02:00
 		Sporting Kansas CitySporting ...
09 May 24 New Mexico UnitedMexico
03:00
 		Real Salt LakeReal Salt. ...
09 May 24 Las Vegas LightsVegas
04:30
 		Los Angeles FCAngeles ...
09 May 24 Seattle SoundersSeattle
04:30
 		Louisville CityLouisville 1

  USO DE MEMORIA  
4,807,608 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3591
Total Execution Time  0.3610
  CADENA URL  
/copa_open_usa2024/grupo0/calendario
  GET DATOS  
$_GET['/copa_open_usa2024/grupo0/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=610 AND type_rel = 3
0.0132  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 610 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0136  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (1281610,1281603,1281359,1281329,1281121) ORDER BY n.cover_points DESC, update_date DESC
0.0126  SELECT id,name,alias,stepParent FROM categories WHERE parentId=610 ORDER BY order_id ASC
0.0142  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 = 75531 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0135  SELECT c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2, dt1.stadium as stadium_name FROM calendars2024 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 75531 ORDER BY round ASC
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-06 14:21:02' 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-05-06 14:21:02' 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-05-06 14:21:02' 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-05-06 14:21:02' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0129  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 610 AND l.year = 2024
0.0131  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (75531) 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, e.player_id ASC LIMIT 10
0.0132  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (75531) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (214298,3396745,274992,295529,770410,1029643,3253248,72158,101409,120816) ORDER BY rp.in_squad = 1 DESC
0.0127  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 610 AND l.year = 2024
0.0132  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (75531) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0133  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (75531) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (3263734,3539366,133669,209256,264468,277376,309489,371552,379869,382575) ORDER BY rp.in_squad = 1 DESC
0.0127  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 610 AND l.year = 2024
0.0130  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (75531) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0133  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (75531) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (277376,363403,687595,753641,825655,830380,877282,923025,926263,934764) ORDER BY rp.in_squad = 1 DESC