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
MLS - Liga USA
2023/2024

MLS - Liga USA

  • Inter Miami
  • Cincinnati
  • New York RB
  • Toronto FC
  • DC United
  • Columbus Crew
  • New York City
  • Atlanta United
  • Philadelphia Union
  • Charlotte FC
  • CF Montréal
  • Chicago Fire
  • Orlando City
  • Nashville SC
  • New England Revolution
  • Real Salt Lake
  • Minnesota United
  • LA Galaxy
  • Vancouver Whitecaps
  • Los Angeles FC
  • Colorado Rapids
  • Austin FC
  • Houston Dynamo
  • St. Louis City
  • Sporting Kansas City
  • Portland Timbers
  • Seattle Sounders
  • FC Dallas
  • San Jose Earthquakes
Resultados
« Jornada Anterior
Jornada 11
Jornada Siguiente »
05 May 24
01:30 Descanso 		Atlanta United Atlanta United 0-0 Minnesota United Minnesota United más información 34
05 May 24
01:30 Descanso 		Charlotte FC Charlotte FC 0-0 Portland Timbers Portland Timbers más información 24
05 May 24
01:30 Descanso 		DC United DC United 2-1 Philadelphia Union Philadelphia Union más información Jugadas destacadas 31
9' C. Dájome 1-0
33' J. Murrell 2-0
2-1 42' A. Bedoya
05 May 24
01:30 Descanso 		Inter Miami Inter Miami 0-1 New York RB New York RB más información Jugadas destacadas 276
0-1 30' D. Vanzeir
05 May 24
01:30 En juego, 45' 		Orlando City Orlando City 0-1 Cincinnati Cincinnati más información Jugadas destacadas 52
0-1 1' L. Acosta
23' R. Schlegel
05 May 24
01:30 Descanso 		San Jose Earthquakes San Jose Earthquakes 1-0 Los Angeles FC Los Angeles FC más información Jugadas destacadas 43
5' Rodrigues 1-0
05 May 24
01:30 En juego, 45' 		Toronto FC Toronto FC 1-0 FC Dallas FC Dallas más información Jugadas destacadas 30
48' F. Bernardeschi 1-0
48' F. Bernardeschi
05 May 24
02:30 Sin comenzar 		Chicago Fire Chicago Fire 4' New England Revolution New England Revolution más información 8
05 May 24
02:30 Sin comenzar 		Houston Dynamo Houston Dynamo 4' St. Louis City St. Louis City más información 8
05 May 24
02:30 Sin comenzar 		Nashville SC Nashville SC 4' CF Montréal CF Montréal más información 7
05 May 24
Sin comenzar 		Real Salt Lake Real Salt Lake
03:30
 		Sporting Kansas City Sporting Kansas City más información 8
05 May 24
Sin comenzar 		Vancouver Whitecaps Vancouver Whitecaps
04:30
 		Austin FC Austin FC más información 7
05 May 24
Sin comenzar 		New York City New York City
22:00
 		Colorado Rapids Colorado Rapids más información ...
06 May 24
Sin comenzar 		Seattle Sounders Seattle Sounders
00:45
 		LA Galaxy LA Galaxy más información 1
Clasificación
« Jornada Anterior
Jornada 11
Jornada Siguiente »
Conferencia Este Puntos J. G. E. P. F. C. Forma
1 Inter Miami Inter Miami 21 12 6 3 3 26 17
  • EMPATE
  • Inter Miami 2
  • Colorado Rapids 2
  • VICTORIA
  • Sporting Kansas Ci. 2
  • Inter Miami 3
  • VICTORIA
  • Inter Miami 3
  • Nashville SC 1
  • VICTORIA
  • New England Revolu. 1
  • Inter Miami 4
  • DERROTA
  • Inter Miami 0
  • New York RB 1
2 Cincinnati Cincinnati 21 11 6 3 2 13 9
  • DERROTA
  • Cincinnati 1
  • New York RB 2
  • DERROTA
  • CF Montréal 2
  • Cincinnati 1
  • VICTORIA
  • Atlanta United 1
  • Cincinnati 2
  • VICTORIA
  • Cincinnati 2
  • Colorado Rapids 1
  • VICTORIA
  • Orlando City 0
  • Cincinnati 1
3 New York RB New York RB 20 11 5 5 1 15 10
  • VICTORIA
  • Cincinnati 1
  • New York RB 2
  • EMPATE
  • New York RB 0
  • Chicago Fire 0
  • EMPATE
  • Los Angeles FC 2
  • New York RB 2
  • EMPATE
  • New York RB 1
  • Vancouver Whitecap. 1
  • VICTORIA
  • Inter Miami 0
  • New York RB 1
4 Toronto FC Toronto FC 19 11 6 1 4 12 13
  • DERROTA
  • Vancouver Whitecap. 4
  • Toronto FC 0
  • DERROTA
  • Charlotte FC 3
  • Toronto FC 2
  • VICTORIA
  • Toronto FC 1
  • New England Revolu. 0
  • VICTORIA
  • Orlando City 1
  • Toronto FC 2
  • VICTORIA
  • Toronto FC 1
  • FC Dallas 0
5 DC United DC United 16 11 4 4 3 16 16
  • EMPATE
  • Columbus Crew 1
  • DC United 1
  • DERROTA
  • DC United 2
  • Orlando City 3
  • DERROTA
  • New York City 2
  • DC United 0
  • VICTORIA
  • DC United 2
  • Seattle Sounders 1
  • VICTORIA
  • DC United 2
  • Philadelphia Union 1
6 Columbus Crew Columbus Crew 15 10 3 6 1 12 9
  • EMPATE
  • Nashville SC 2
  • Columbus Crew 2
  • EMPATE
  • Columbus Crew 1
  • DC United 1
  • EMPATE
  • Real Salt Lake 0
  • Columbus Crew 0
  • EMPATE
  • Columbus Crew 2
  • Portland Timbers 2
  • EMPATE
  • Columbus Crew 0
  • CF Montréal 0
7 New York City New York City 14 10 4 2 4 11 10
  • EMPATE
  • Inter Miami 1
  • New York City 1
  • EMPATE
  • New York City 1
  • Atlanta United 1
  • VICTORIA
  • New York City 2
  • New England Revolu. 0
  • VICTORIA
  • New York City 2
  • DC United 0
  • VICTORIA
  • New York City 2
  • Charlotte FC 1
8 Atlanta United Atlanta United 13 10 3 4 3 13 9
  • EMPATE
  • New York City 1
  • Atlanta United 1
  • EMPATE
  • Atlanta United 2
  • Philadelphia Union 2
  • DERROTA
  • Atlanta United 1
  • Cincinnati 2
  • EMPATE
  • Chicago Fire 0
  • Atlanta United 0
  • EMPATE
  • Atlanta United 0
  • Minnesota United 0
9 Philadelphia Union Philadelphia 13 10 3 4 3 18 16
  • VICTORIA
  • Nashville SC 1
  • Philadelphia Union 2
  • EMPATE
  • Atlanta United 2
  • Philadelphia Union 2
  • DERROTA
  • Philadelphia Union 1
  • Real Salt Lake 2
  • DERROTA
  • Philadelphia Union 2
  • Seattle Sounders 3
  • DERROTA
  • DC United 2
  • Philadelphia Union 1
10 Charlotte FC Charlotte FC 12 11 3 3 5 10 13
  • DERROTA
  • New England Revolu. 1
  • Charlotte FC 0
  • VICTORIA
  • Charlotte FC 3
  • Toronto FC 2
  • DERROTA
  • Charlotte FC 0
  • Minnesota United 3
  • DERROTA
  • New York City 2
  • Charlotte FC 1
  • EMPATE
  • Charlotte FC 0
  • Portland Timbers 0
11 CF Montréal CF Montréal 12 9 3 3 3 12 16
  • DERROTA
  • DC United 1
  • CF Montréal 0
  • DERROTA
  • Seattle Sounders 5
  • CF Montréal 0
  • VICTORIA
  • CF Montréal 2
  • Cincinnati 1
  • EMPATE
  • CF Montréal 2
  • Orlando City 2
  • EMPATE
  • Columbus Crew 0
  • CF Montréal 0
12 Chicago Fire Chicago Fire 10 10 2 4 4 11 18
  • DERROTA
  • Atlanta United 3
  • Chicago Fire 0
  • VICTORIA
  • Chicago Fire 2
  • Houston Dynamo 1
  • EMPATE
  • New York RB 0
  • Chicago Fire 0
  • DERROTA
  • Chicago Fire 0
  • Real Salt Lake 4
  • EMPATE
  • Chicago Fire 0
  • Atlanta United 0
13 Orlando City Orlando City 9 10 2 3 5 11 18
  • EMPATE
  • Orlando City 1
  • New York RB 1
  • VICTORIA
  • DC United 2
  • Orlando City 3
  • EMPATE
  • CF Montréal 2
  • Orlando City 2
  • DERROTA
  • Orlando City 1
  • Toronto FC 2
  • DERROTA
  • Orlando City 0
  • Cincinnati 1
14 Nashville SC Nashville SC 8 9 1 5 3 10 17
  • DERROTA
  • Los Angeles FC 5
  • Nashville SC 0
  • EMPATE
  • Nashville SC 2
  • Columbus Crew 2
  • DERROTA
  • Nashville SC 1
  • Philadelphia Union 2
  • DERROTA
  • Inter Miami 3
  • Nashville SC 1
  • EMPATE
  • Nashville SC 1
  • San Jose Earthquak. 1
15 New England Revolution England 4 9 1 1 7 6 18
  • EMPATE
  • New England Revolu. 1
  • Chicago Fire 1
  • VICTORIA
  • New England Revolu. 1
  • Charlotte FC 0
  • DERROTA
  • New York City 2
  • New England Revolu. 0
  • DERROTA
  • Toronto FC 1
  • New England Revolu. 0
  • DERROTA
  • New England Revolu. 1
  • Inter Miami 4
Conferencia Oeste Puntos J. G. E. P. F. C. Forma
1 Real Salt Lake Real Salt Lake 18 10 5 3 2 17 9
  • VICTORIA
  • Real Salt Lake 3
  • St. Louis City 1
  • EMPATE
  • Minnesota United 1
  • Real Salt Lake 1
  • EMPATE
  • Real Salt Lake 0
  • Columbus Crew 0
  • VICTORIA
  • Chicago Fire 0
  • Real Salt Lake 4
  • VICTORIA
  • Philadelphia Union 1
  • Real Salt Lake 2
2 Minnesota United Minnesota United 18 10 5 3 2 15 10
  • EMPATE
  • Minnesota United 1
  • Real Salt Lake 1
  • DERROTA
  • Minnesota United 1
  • Houston Dynamo 2
  • VICTORIA
  • Charlotte FC 0
  • Minnesota United 3
  • VICTORIA
  • Minnesota United 2
  • Sporting Kansas Ci. 1
  • EMPATE
  • Atlanta United 0
  • Minnesota United 0
3 LA Galaxy LA Galaxy 18 10 5 3 2 21 17
  • VICTORIA
  • LA Galaxy 1
  • Seattle Sounders 0
  • DERROTA
  • Los Angeles FC 2
  • LA Galaxy 1
  • VICTORIA
  • Vancouver Whitecap. 1
  • LA Galaxy 3
  • VICTORIA
  • LA Galaxy 4
  • San Jose Earthquak. 3
  • DERROTA
  • Austin FC 2
  • LA Galaxy 0
4 Vancouver Whitecaps Vancouver 17 9 5 2 2 18 10
  • VICTORIA
  • Vancouver Whitecap. 3
  • Portland Timbers 2
  • VICTORIA
  • Vancouver Whitecap. 4
  • Toronto FC 0
  • DERROTA
  • Vancouver Whitecap. 1
  • LA Galaxy 3
  • VICTORIA
  • Seattle Sounders 0
  • Vancouver Whitecap. 2
  • EMPATE
  • New York RB 1
  • Vancouver Whitecap. 1
5 Los Angeles FC Los Angeles FC 15 11 4 3 4 18 17
  • VICTORIA
  • Los Angeles FC 2
  • LA Galaxy 1
  • EMPATE
  • Portland Timbers 2
  • Los Angeles FC 2
  • EMPATE
  • Los Angeles FC 2
  • New York RB 2
  • VICTORIA
  • Los Angeles FC 3
  • Portland Timbers 2
  • DERROTA
  • San Jose Earthquak. 1
  • Los Angeles FC 0
6 Colorado Rapids Colorado Rapids 15 10 4 3 3 16 15
  • VICTORIA
  • Colorado Rapids 3
  • Los Angeles FC 2
  • EMPATE
  • Inter Miami 2
  • Colorado Rapids 2
  • VICTORIA
  • San Jose Earthquak. 0
  • Colorado Rapids 3
  • VICTORIA
  • Colorado Rapids 2
  • FC Dallas 1
  • DERROTA
  • Cincinnati 2
  • Colorado Rapids 1
7 Austin FC Austin FC 15 10 4 3 3 14 13
  • VICTORIA
  • Austin FC 2
  • FC Dallas 1
  • VICTORIA
  • Austin FC 4
  • San Jose Earthquak. 3
  • DERROTA
  • St. Louis City 1
  • Austin FC 0
  • VICTORIA
  • Houston Dynamo 0
  • Austin FC 1
  • VICTORIA
  • Austin FC 2
  • LA Galaxy 0
8 Houston Dynamo Houston Dynamo 13 9 4 1 4 9 10
  • VICTORIA
  • Houston Dynamo 2
  • San Jose Earthquak. 1
  • DERROTA
  • Chicago Fire 2
  • Houston Dynamo 1
  • VICTORIA
  • Minnesota United 1
  • Houston Dynamo 2
  • DERROTA
  • Houston Dynamo 0
  • Austin FC 1
  • DERROTA
  • FC Dallas 2
  • Houston Dynamo 0
9 St. Louis City St. Louis City 12 9 2 6 1 15 14
  • EMPATE
  • St. Louis City 2
  • DC United 2
  • DERROTA
  • Real Salt Lake 3
  • St. Louis City 1
  • EMPATE
  • St. Louis City 0
  • FC Dallas 0
  • VICTORIA
  • St. Louis City 1
  • Austin FC 0
  • EMPATE
  • Sporting Kansas Ci. 3
  • St. Louis City 3
10 Sporting Kansas City Sporting Kansas 11 10 2 5 3 18 18
  • VICTORIA
  • Toronto FC 1
  • Sporting Kansas Ci. 3
  • EMPATE
  • Sporting Kansas Ci. 3
  • Portland Timbers 3
  • DERROTA
  • Sporting Kansas Ci. 2
  • Inter Miami 3
  • EMPATE
  • Sporting Kansas Ci. 3
  • St. Louis City 3
  • DERROTA
  • Minnesota United 2
  • Sporting Kansas Ci. 1
11 Portland Timbers Portland Timbers 11 11 2 5 4 20 21
  • EMPATE
  • Sporting Kansas Ci. 3
  • Portland Timbers 3
  • EMPATE
  • Portland Timbers 2
  • Los Angeles FC 2
  • EMPATE
  • Columbus Crew 2
  • Portland Timbers 2
  • DERROTA
  • Los Angeles FC 3
  • Portland Timbers 2
  • EMPATE
  • Charlotte FC 0
  • Portland Timbers 0
12 Seattle Sounders Seattle Sounders 9 10 2 3 5 13 13
  • VICTORIA
  • Seattle Sounders 5
  • CF Montréal 0
  • EMPATE
  • FC Dallas 0
  • Seattle Sounders 0
  • DERROTA
  • Seattle Sounders 0
  • Vancouver Whitecap. 2
  • DERROTA
  • DC United 2
  • Seattle Sounders 1
  • VICTORIA
  • Philadelphia Union 2
  • Seattle Sounders 3
13 FC Dallas FC Dallas 8 10 2 2 6 9 13
  • EMPATE
  • St. Louis City 0
  • FC Dallas 0
  • EMPATE
  • FC Dallas 0
  • Seattle Sounders 0
  • DERROTA
  • Colorado Rapids 2
  • FC Dallas 1
  • VICTORIA
  • FC Dallas 2
  • Houston Dynamo 0
  • DERROTA
  • Toronto FC 1
  • FC Dallas 0
14 San Jose Earthquakes Jose Earthquakes 7 11 2 1 8 15 25
  • DERROTA
  • Austin FC 4
  • San Jose Earthquak. 3
  • DERROTA
  • San Jose Earthquak. 0
  • Colorado Rapids 3
  • DERROTA
  • LA Galaxy 4
  • San Jose Earthquak. 3
  • EMPATE
  • Nashville SC 1
  • San Jose Earthquak. 1
  • VICTORIA
  • San Jose Earthquak. 1
  • Los Angeles FC 0
Series Finales : Inter Miami, Cincinnati, New York RB, Toronto FC, DC United, Columbus Crew, New York City, Real Salt Lake, Minnesota United, LA Galaxy, Vancouver, Los Angeles FC, Colorado Rapids, Austin FC
Playoffs : Atlanta United, Philadelphia, Houston Dynamo, St. Louis City
JUGADORES DESTACADOS

INFORMACIÓN

La Major League Soccer (MLS) es la máxima división del fútbol en los Estados Unidos y Canadá. El torneo es organizado por la Federación de Fútbol de los Estados Unidos (U.S. Soccer), que es miembro de la FIFA.

MLS - Liga USA

05 May 24 01:30
DRV PNK Stadium
05 May 24 01:30
Mercedes-Benz Stadium
05 May 24 01:30
Exploria Stadium
05 May 24 01:30
Audi Field
05 May 24 01:30
BMO Field

  USO DE MEMORIA  
7,152,016 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.0961
Total Execution Time  0.0980
  CADENA URL  
/usa/grupo0/jornada2?section=legal
  GET DATOS  
$_GET['/usa/grupo0/jornada2']  
$_GET['section']   legal
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'usa' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-05 00:34:22' 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=2 AND last_update > '2024-05-05 00:34:22' 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-05-05 00:34:22' 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=3 AND last_update > '2024-05-05 00:34:22' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024  SELECT c.isVideo, c.id,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,c.betId,c.betId_wh,c.betId_bwin,c.betId_marca,c.betId_888, c.betId_sportium, c.betId_marathon, c.finished, c.penaltis1, c.penaltis2, c.prorroga, c.status, c.minute, dt1.stadium as stadium_name FROM `calendars2024` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 74856 AND c.`round` = 11 ORDER BY shedule ASC LIMIT 200
0.0026  SELECT ev.match_id,dp.alias,ev.minute,ev.action,ev.player_id,e.name,e.classf,dp.nick,rel.squadNumber,rel.player_id as playerId,rel.team_id,rel.teamId FROM events2024 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars2024 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 74856 AND (ev.team1id=rel.team_id OR ev.team2id=rel.team_id) INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE ev.match_id IN (648536,648537,648539,648541,648544,648546,648548,648538,648540,648542,648545,648535,648543,648547) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0026  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(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 = 74856 AND t.round = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0058  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 = 74856 AND t.round = 11 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  SELECT c.id, 2024 AS year, IF(l.tables = 1 AND t1.points>0,((t1.points / (l.current_round * 3)) + (t2.points / (l.current_round * 3)))/2 * ct.coefficient,0.7 * ct.coefficient) as fcoef FROM `calendars2024` AS c INNER JOIN `leagues` AS l ON c.`league_id` = l.`id` INNER JOIN `categories` AS ct ON ct.`id` = l.`categoryId` LEFT JOIN tables2024 AS t1 ON t1.team = c.team1 AND t1.round = l.current_round LEFT JOIN tables2024 AS t2 ON t2.team = c.team2 AND t2.round = l.current_round WHERE c.`shedule` > '2024-05-05 00:00:00' AND c.`shedule` < '2024-05-09 23:59:59' AND l.id = 74856 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0036  SELECT c.*, c.stadium as real_stadium, l.year, cat.id AS categoryId, cat.name, s.name as stadium, s.seats, s.yearBuilt, s.size, dt1.id AS dt1id, dt2.id AS dt2id, dt1.nameShow AS nameShow1, dt2.nameShow AS nameShow2, dt1.basealias AS basealias1, dt2.basealias AS basealias2, c.comments AS totalcomments FROM calendars2024 c INNER JOIN leagues l ON l.id = c.league_id INNER JOIN categories cat ON cat.id = l.categoryId INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt2 ON dt2.id = t2.teamId LEFT JOIN rel_stadiums rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = rs.stadium_id WHERE c.id = 648541
0.0036  SELECT c.*, c.stadium as real_stadium, l.year, cat.id AS categoryId, cat.name, s.name as stadium, s.seats, s.yearBuilt, s.size, dt1.id AS dt1id, dt2.id AS dt2id, dt1.nameShow AS nameShow1, dt2.nameShow AS nameShow2, dt1.basealias AS basealias1, dt2.basealias AS basealias2, c.comments AS totalcomments FROM calendars2024 c INNER JOIN leagues l ON l.id = c.league_id INNER JOIN categories cat ON cat.id = l.categoryId INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt2 ON dt2.id = t2.teamId LEFT JOIN rel_stadiums rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = rs.stadium_id WHERE c.id = 648536
0.0040  SELECT c.*, c.stadium as real_stadium, l.year, cat.id AS categoryId, cat.name, s.name as stadium, s.seats, s.yearBuilt, s.size, dt1.id AS dt1id, dt2.id AS dt2id, dt1.nameShow AS nameShow1, dt2.nameShow AS nameShow2, dt1.basealias AS basealias1, dt2.basealias AS basealias2, c.comments AS totalcomments FROM calendars2024 c INNER JOIN leagues l ON l.id = c.league_id INNER JOIN categories cat ON cat.id = l.categoryId INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt2 ON dt2.id = t2.teamId LEFT JOIN rel_stadiums rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = rs.stadium_id WHERE c.id = 648544
0.0040  SELECT c.*, c.stadium as real_stadium, l.year, cat.id AS categoryId, cat.name, s.name as stadium, s.seats, s.yearBuilt, s.size, dt1.id AS dt1id, dt2.id AS dt2id, dt1.nameShow AS nameShow1, dt2.nameShow AS nameShow2, dt1.basealias AS basealias1, dt2.basealias AS basealias2, c.comments AS totalcomments FROM calendars2024 c INNER JOIN leagues l ON l.id = c.league_id INNER JOIN categories cat ON cat.id = l.categoryId INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt2 ON dt2.id = t2.teamId LEFT JOIN rel_stadiums rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = rs.stadium_id WHERE c.id = 648539
0.0041  SELECT c.*, c.stadium as real_stadium, l.year, cat.id AS categoryId, cat.name, s.name as stadium, s.seats, s.yearBuilt, s.size, dt1.id AS dt1id, dt2.id AS dt2id, dt1.nameShow AS nameShow1, dt2.nameShow AS nameShow2, dt1.basealias AS basealias1, dt2.basealias AS basealias2, c.comments AS totalcomments FROM calendars2024 c INNER JOIN leagues l ON l.id = c.league_id INNER JOIN categories cat ON cat.id = l.categoryId INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt2 ON dt2.id = t2.teamId LEFT JOIN rel_stadiums rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = rs.stadium_id WHERE c.id = 648548
0.0018  SELECT data1, data2 FROM services_tags WHERE categoryId=69
0.0029  SELECT group_code, extraName from `leagues` WHERE categoryId=69 AND year=2024