4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2022
Temporada Siguiente »
Publicidad 600x120.gif
MLS - Liga USA 2022
2021/2022

MLS - Liga USA 2022

MLS - Liga USA 2022

La temporada finalizó el Sábado, 05 Noviembre 2022.
Resultados
« Jornada Anterior
Final
 
05 Nov 22
21:00 Finalizado 		Los Angeles FC Los Angeles FC (3) 3-3 (0) Philadelphia Union Philadelphia Union más información Jugadas destacadas 241
28' Kellyn Acosta 1-0
1-1 59' D. Gazdag
83' J. Murillo 2-1
2-2 85' Jack Elliott
116' M. Crépeau
2-3 124' Jack Elliott
128' G. Bale 3-3
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.


  USO DE MEMORIA  
4,990,856 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.2009
Total Execution Time  0.2029
  CADENA URL  
/usa2022
  GET DATOS  
$_GET['/usa2022']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (8)  
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 11:40:24' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0124  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 11:40:24' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0129  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 11:40:24' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0131  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 11:40:24' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0141  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 `calendars2022` 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` = 69988 AND c.`round` = 4 ORDER BY c.type ASC,((c.team1*c.team1)+(c.team2*c.team2)) ASC,shedule ASC LIMIT 200
0.0145  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 events2022 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars2022 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 69988 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 (684636) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0127  SELECT data1, data2 FROM services_tags WHERE categoryId=69
0.0148  SELECT group_code, extraName from `leagues` WHERE categoryId=69 AND year=2022