4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2024
 
Publicidad 600x120.gif
Leagues Cup 2024
2023/2024

Leagues Cup 2024

  • Cincinnati
  • New York City
  • Querétaro
  • Atl. San Luis
  • CF Montréal
  • Orlando City
  • Inter Miami
  • Puebla
  • Tigres UANL
  • Charlotte FC
  • Cruz Azul
  • Philadelphia Union
  • Mazatlán
  • Nashville SC
  • New England Revolution
  • New York RB
  • Pachuca
  • Toronto FC
  • Atlanta United
  • DC United
  • Santos Laguna
Resultados
 
Jornada 1
Jornada Siguiente »
 
27 Jul 24
Sin comenzar 		Atlanta United Atlanta United
02:00
 		DC United DC United más información ...
 
27 Jul 24
Sin comenzar 		Orlando City Orlando City
02:00
 		CF Montréal CF Montréal más información ...
 
28 Jul 24
Sin comenzar 		New England Revolution New England Revolution
02:00
 		Mazatlán Mazatlán más información ...
 
28 Jul 24
Sin comenzar 		New York RB New York RB
02:00
 		Toronto FC Toronto FC más información ...
 
28 Jul 24
Sin comenzar 		Philadelphia Union Philadelphia Union
02:00
 		Charlotte FC Charlotte FC más información ...
 
28 Jul 24
Sin comenzar 		Puebla Puebla
02:00
 		Inter Miami Inter Miami más información 1
 
29 Jul 24
Sin comenzar 		New York City New York City
02:00
 		Querétaro Querétaro más información ...
Clasificación
 
Jornada 1
Jornada Siguiente »
Este 1 Puntos J. G. E. P. F. C.
1 Cincinnati Cincinnati 0 0 0 0 0 0 0
2 New York City New York City 0 0 0 0 0 0 0
3 Querétaro Querétaro 0 0 0 0 0 0 0
Este 2 Puntos J. G. E. P. F. C.
1 Atl. San Luis Atl. San Luis 0 0 0 0 0 0 0
2 CF Montréal CF Montréal 0 0 0 0 0 0 0
3 Orlando City Orlando City 0 0 0 0 0 0 0
Este 3 Puntos J. G. E. P. F. C.
1 Inter Miami Inter Miami 0 0 0 0 0 0 0
2 Puebla Puebla 0 0 0 0 0 0 0
3 Tigres UANL Tigres UANL 0 0 0 0 0 0 0
Este 4 Puntos J. G. E. P. F. C.
1 Charlotte FC Charlotte FC 0 0 0 0 0 0 0
2 Cruz Azul Cruz Azul 0 0 0 0 0 0 0
3 Philadelphia Union Philadelphia 0 0 0 0 0 0 0
Este 5 Puntos J. G. E. P. F. C.
1 Mazatlán Mazatlán 0 0 0 0 0 0 0
2 Nashville SC Nashville SC 0 0 0 0 0 0 0
3 New England Revolution England 0 0 0 0 0 0 0
Este 6 Puntos J. G. E. P. F. C.
1 New York RB New York RB 0 0 0 0 0 0 0
2 Pachuca Pachuca 0 0 0 0 0 0 0
3 Toronto FC Toronto FC 0 0 0 0 0 0 0
Este 7 Puntos J. G. E. P. F. C.
1 Atlanta United Atlanta United 0 0 0 0 0 0 0
2 DC United DC United 0 0 0 0 0 0 0
3 Santos Laguna Santos Laguna 0 0 0 0 0 0 0
Series Finales : Cincinnati, New York City, Atl. San Luis, CF Montréal, Inter Miami, Puebla, Charlotte FC, Cruz Azul, Mazatlán, Nashville SC, New York RB, Pachuca, Atlanta United, DC United


  USO DE MEMORIA  
5,166,920 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0024
Controller Execution Time ( Home / Category )  0.0735
Total Execution Time  0.0759
  CADENA URL  
/leagues_cup2024/grupo1
  GET DATOS  
$_GET['/leagues_cup2024/grupo1']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0018  SELECT type FROM routes WHERE alias = 'leagues_cup2024'
0.0039  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'leagues_cup' 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.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2149 AND type_rel = 3
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 2149 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0021  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 (1306498,1285933,1274482,1274443,1274446) ORDER BY n.cover_points DESC, update_date DESC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 16:46:20' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 16:46:20' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 16:46:20' 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 16:46:20' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT data1, data2 FROM services_tags WHERE categoryId=2149
0.0020  SELECT group_code, extraName from `leagues` WHERE categoryId=2149 AND year=2024