4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
New England Revolution - Orlando City
Jornada 256
FINALIZADO
20
00
1977 Pts. Elo

2018 Pts. Elo

1-3
Domingo, 11 Febrero 2024, 01:30
M. Polster 2'
1 - 0
1 - 1
 20' F. Torres
1 - 2
 50' F. Torres
1 - 3
 62' W. Cartagena
New England Revolution

New England Revolution

4-4-2
Alineación Inicial
Suplentes
Orlando City

Orlando City

4-4-2
Alineación Inicial
Suplentes

Eventos del partido

Goles

M. PolsterGol de
M. Polster
minuto 2'
minuto 20'F. TorresGol de F. Torres
minuto 50'F. TorresGol de F. Torres
minuto 62'W. CartagenaGol de W. Cartagena

Tarjetas

Carles GilT. Amarilla
Carles Gil
minuto 42'
Nacho GilT. Amarilla
Nacho Gil
minuto 73'

Cambios

G. VrioniSale del partido
G. Vrioni
minuto 36'
B. WoodEntra en el partido
B. Wood
minuto 36'
minuto 46'Rafael SantosEntra en el partido Rafael Santos
minuto 46'Michael HallidaySale del partido Michael Halliday
minuto 58'M. OjedaSale del partido M. Ojeda
minuto 58'C. AraujoEntra en el partido C. Araujo
Henrich RavasSale del partido
Henrich Ravas
minuto 60'
minuto 60'J. LynnEntra en el partido J. Lynn
minuto 60'Iván AnguloSale del partido Iván Angulo
E. Edwards Jr.Entra en el partido
E. Edwards Jr.
minuto 60'
minuto 72'Felipe MartinsEntra en el partido Felipe Martins
minuto 72'W. CartagenaSale del partido W. Cartagena
P. MillerEntra en el partido
P. Miller
minuto 73'
Josh BolmaSale del partido
Josh Bolma
minuto 73'
minuto 85'Yutaro TsukadaEntra en el partido Yutaro Tsukada
minuto 85'F. TorresSale del partido F. Torres
minuto 85'S. MohammedEntra en el partido S. Mohammed
minuto 85'N. LodeiroSale del partido N. Lodeiro

Estadísticas del partido

New England Revolution England Orlando City Orlando City
1
Goles
 3
2
Tarjetas Amarillas
 0
0
Tarjetas Rojas
 0
3
Sustituciones
 3
0 Comentarios

No hay comentarios



  USO DE MEMORIA  
6,595,920 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.3141
Total Execution Time  0.3151
  CADENA URL  
/partido_71432/New-England-Revolution/Orlando-City-Us/2024
  GET DATOS  
$_GET['/partido_71432/New-England-Revolution/Orlando-City-Us/2024']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0018  SELECT data1 FROM stats2024 t WHERE league_id = 71432 AND teamId = 6626609 and type = 33
0.0017  SELECT data1 FROM stats2024 t WHERE league_id = 71432 AND teamId = 6627464 and type = 33
0.0022  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '676496' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 676496 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 676496 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0018  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='676496' AND `active` = 1 AND year = 2024
0.0032  SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='71432' AND relp.team_id=6626609 WHERE relp.in_squad=1 and mp.`match_id` = '676496' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0030  SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='71432' AND relp.team_id=6627464 WHERE relp.in_squad=1 and mp.`match_id` = '676496' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=676496 AND extraId = 71432 AND type_rel = 4
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=153 AND type_rel = 3
0.0099  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 153 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 (1312034,1307741,1307681,1307639,1307019) ORDER BY n.cover_points DESC, update_date DESC
0.0018  SELECT position FROM tables2024 WHERE team=6626609 AND league_id=71432 AND round=256
0.0018  SELECT position FROM tables2024 WHERE team=6627464 AND league_id=71432 AND round=256
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 676496 AND league_id = 71432 AND year = 2024