4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Norwich City - Stoke City
Jornada 6
FINALIZADO
20
20
1437 Pts. Elo
44%
4º

1252 Pts. Elo
55%
19º

1-0
Sábado, 16 Septiembre 2023, 16:00
Jack Stacey 44'
1 - 0

Eventos del partido

Goles

Jack StaceyGol de
Jack Stacey
minuto 44'

Tarjetas

minuto 20'Mehdi LérisT. Amarilla Mehdi Léris
minuto 31'B. PearsonT. Amarilla B. Pearson
D. GiannoulisT. Amarilla
D. Giannoulis
minuto 43'
C. FassnachtT. Amarilla
C. Fassnacht
minuto 81'

Cambios

P. PlachetaEntra en el partido
P. Placheta
minuto 60'
Ui-Jo HwangEntra en el partido
Ui-Jo Hwang
minuto 60'
D. GiannoulisSale del partido
D. Giannoulis
minuto 60'
Adam IdahSale del partido
Adam Idah
minuto 60'
minuto 61'Wesley MoraesSale del partido Wesley Moraes
minuto 61'Sead HaksabanovicEntra en el partido Sead Haksabanovic
minuto 61'D. JohnsonEntra en el partido D. Johnson
minuto 61'Joon-Ho BaeSale del partido Joon-Ho Bae
Onel HernándezEntra en el partido
Onel Hernández
minuto 71'
Jonathan RoweSale del partido
Jonathan Rowe
minuto 71'
minuto 74'Mehdi LérisSale del partido Mehdi Léris
minuto 74'J. TchamadeuEntra en el partido J. Tchamadeu
Tony SpringettEntra en el partido
Tony Springett
minuto 82'
Liam GibbsEntra en el partido
Liam Gibbs
minuto 82'
C. FassnachtSale del partido
C. Fassnacht
minuto 82'
Ashley BarnesSale del partido
Ashley Barnes
minuto 82'
minuto 88'Wouter BurgerSale del partido Wouter Burger
minuto 88'D. GayleEntra en el partido D. Gayle

Alineaciones

Norwich City

Norwich City

4-5-1
Alineación Inicial
Suplentes
Stoke City

Stoke City

4-5-1
Alineación Inicial
Suplentes

Estadísticas del partido

Norwich City Norwich City Stoke City Stoke City
44%
Posesión del balón
 55%
1
Goles
 0
5
Tiros a puerta
 2
5
Tiros fuera
 6
13
Total tiros
 13
2
Paradas del portero
 4
5
Saques de esquina
 3
2
Fueras de juego
 1
0
Tarjetas Rojas
 0
3
Sustituciones
 3
7
Faltas
 14


  USO DE MEMORIA  
6,857,184 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Match / Index )  0.5513
Total Execution Time  0.5524
  CADENA URL  
/partido/Norwich-City-Fc/Stoke-City/2012?section=legal
  GET DATOS  
$_GET['/partido/Norwich-City-Fc/Stoke-City/2012']  
$_GET['section']   legal
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0145  SELECT data1 FROM stats2024 t WHERE league_id = 72033 AND teamId = 6582238 and type = 33
0.0144  SELECT data1 FROM stats2024 t WHERE league_id = 72033 AND teamId = 6582245 and type = 33
0.0148  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '27677' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 27677 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0147  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 27677 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0148  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='27677' AND `active` = 1 AND year = 2024
0.0217  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='72033' AND relp.team_id=6582238 WHERE relp.in_squad=1 and mp.`match_id` = '27677' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0237  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='72033' AND relp.team_id=6582245 WHERE relp.in_squad=1 and mp.`match_id` = '27677' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0147  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=27677 AND extraId = 72033 AND type_rel = 4
0.0150  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=25 AND type_rel = 3
0.0428  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 25 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0151  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 (1315250,1315058,1314507,1313848,1313382) ORDER BY n.cover_points DESC, update_date DESC
0.0145  SELECT * FROM futbol.calendars_lineups WHERE id = 27677 AND league_id = 72033 AND year = 2024