2.855.770 resultados, 9.127.069 comentarios, 804.045 imágenes, 79.786 vídeos, 85.880 noticias
MLS - Liga USA
2021/2022

MLS - Liga USA

Publicidad 600x120.gif
  • Atlanta United
  • Charlotte FC
  • Chicago Fire
  • Cincinnati
  • Columbus Crew
  • DC United
  • Inter Miami
  • CF Montréal
  • New England Revolution
  • New York City
  • Orlando City
  • Philadelphia Union
  • New York RB
  • Toronto FC
  • Austin FC
  • Colorado Rapids
  • FC Dallas
  • Houston Dynamo
  • Sporting Kansas City
  • Los Angeles FC
  • LA Galaxy
  • Minnesota United
  • Nashville SC
  • Portland Timbers
  • Real Salt Lake
  • Seattle Sounders
  • San Jose Earthquakes
  • Vancouver Whitecaps

MLS - Liga USA

La competición comienza el Sábado, 26 Febrero 2022, FALTAN 34 DÍAS.
 
26 Feb 22
Sin comenzar
Philadelphia Union Philadelphia Union
19:00
Minnesota United Minnesota United más información ...
 
26 Feb 22
Sin comenzar
Columbus Crew Columbus Crew
21:30
Vancouver Whitecaps Vancouver Whitecaps más información ...
 
26 Feb 22
Sin comenzar
Los Angeles FC Los Angeles FC
21:30
Colorado Rapids Colorado Rapids más información ...
 
26 Feb 22
Sin comenzar
FC Dallas FC Dallas
23:30
Toronto FC Toronto FC más información ...
 
27 Feb 22
Sin comenzar
DC United DC United
00:00
Charlotte FC Charlotte FC más información ...
 
27 Feb 22
Sin comenzar
Austin FC Austin FC
00:00
Cincinnati Cincinnati más información ...
 
27 Feb 22
Sin comenzar
Inter Miami Inter Miami
00:00
Chicago Fire Chicago Fire más información ...
 
27 Feb 22
Sin comenzar
San Jose Earthquakes San Jose Earthquakes
00:00
New York RB New York RB más información ...
 
27 Feb 22
Sin comenzar
Portland Timbers Portland Timbers
01:30
New England Revolution New England Revolution más información ...
 
27 Feb 22
Sin comenzar
Orlando City Orlando City
19:00
CF Montréal CF Montréal más información ...
Conferencia Este Puntos J. G. E. P. F. C.
1 Atlanta United Atlanta United 0 0 0 0 0 0 0
2 Charlotte FC Charlotte FC 0 0 0 0 0 0 0
3 Chicago Fire Chicago Fire 0 0 0 0 0 0 0
4 Cincinnati Cincinnati 0 0 0 0 0 0 0
5 Columbus Crew Columbus Crew 0 0 0 0 0 0 0
6 DC United DC United 0 0 0 0 0 0 0
7 Inter Miami Inter Miami 0 0 0 0 0 0 0
8 CF Montréal CF Montréal 0 0 0 0 0 0 0
9 New England Revolution England 0 0 0 0 0 0 0
10 New York City New York City 0 0 0 0 0 0 0
11 Orlando City Orlando City 0 0 0 0 0 0 0
12 Philadelphia Union Philadelphia 0 0 0 0 0 0 0
13 New York RB New York RB 0 0 0 0 0 0 0
14 Toronto FC Toronto FC 0 0 0 0 0 0 0
Conferencia Oeste Puntos J. G. E. P. F. C.
1 Austin FC Austin FC 0 0 0 0 0 0 0
2 Colorado Rapids Colorado Rapids 0 0 0 0 0 0 0
3 FC Dallas FC Dallas 0 0 0 0 0 0 0
4 Houston Dynamo Houston Dynamo 0 0 0 0 0 0 0
5 Sporting Kansas City Sporting Kansas 0 0 0 0 0 0 0
6 Los Angeles FC Los Angeles FC 0 0 0 0 0 0 0
7 LA Galaxy LA Galaxy 0 0 0 0 0 0 0
8 Minnesota United Minnesota United 0 0 0 0 0 0 0
9 Nashville SC Nashville SC 0 0 0 0 0 0 0
10 Portland Timbers Portland Timbers 0 0 0 0 0 0 0
11 Real Salt Lake Real Salt Lake 0 0 0 0 0 0 0
12 Seattle Sounders Seattle Sounders 0 0 0 0 0 0 0
13 San Jose Earthquakes Jose Earthquakes 0 0 0 0 0 0 0
14 Vancouver Whitecaps Vancouver 0 0 0 0 0 0 0
Series Finales : Atlanta United, Austin FC
Playoffs : Charlotte FC, Chicago Fire, Cincinnati, Columbus Crew, DC United, Inter Miami, Colorado Rapids, FC Dallas, Houston Dynamo, Sporting Kansas, Los Angeles FC, LA Galaxy

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 cookies: Utilizamos "cookies" propias y de terceros para mejorar nuestros servicios, elaborar información estadística, analizar sus hábitos de navegación e inferir grupos de interés. Esto nos permite personalizar el contenido que ofrecemos y mostrarle publicidad relacionada con sus preferencias. Adicionalmente, compartimos los análisis de navegación y los grupos de interés inferidos con terceros. Si continúa navegando acepta su uso. Más información y cambio de configuración. Aceptar

  USO DE MEMORIA  
11,881,632 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.0805
Total Execution Time  0.0826
  CADENA URL  
/usa
  GET DATOS  
$_GET['/usa']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2022-01-22 23:56:37' 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 > '2022-01-22 23:56:37' 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 > '2022-01-22 23:56:37' 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 > '2022-01-22 23:56:37' 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 `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` = 66172 AND c.`round` = 1 ORDER BY shedule ASC LIMIT 200
0.0020  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 = 66172 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 (308013,308014,308015,308016,308017,308018,308019,308020,308021,308022) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0018  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 `tables2022` 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 = 66172 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
0.0057  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2022` 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 = 66172 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
0.0027  SELECT c.id, 2022 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 `calendars2022` 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 tables2022 AS t1 ON t1.team = c.team1 AND t1.round = l.current_round LEFT JOIN tables2022 AS t2 ON t2.team = c.team2 AND t2.round = l.current_round WHERE c.`shedule` > '2022-01-23 00:00:00' AND c.`shedule` < '2022-01-27 23:59:59' AND l.id = 66172 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0018  SELECT data1, data2 FROM services_tags WHERE categoryId=69
0.0027  SELECT group_code, extraName from `leagues` WHERE categoryId=69 AND year=2022