4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Bristol City - Huddersfield Town
Jornada 43
FINALIZADO
10
60
1338 Pts. Elo
61%
12º

1039 Pts. Elo
38%
22º

1-1
Sábado, 13 Abril 2024, 16:00
0 - 1
 81' Josh Koroma
N. Wells 100'
1 - 1

Eventos del partido

Goles

minuto 81'Josh KoromaGol de Josh Koroma
N. WellsGol de penalti
N. Wells
minuto 100'

Tarjetas

minuto 7'B. SpencerT. Amarilla B. Spencer
minuto 12'Alex MatosT. Amarilla Alex Matos
minuto 42'M. HelikT. Amarilla M. Helik
H. RobertsT. Amarilla
H. Roberts
minuto 63'
minuto 71'Matthew PearsonT. Amarilla Matthew Pearson
minuto 99'J. RudoniT. Amarilla J. Rudoni
minuto 100'L. NichollsT. Amarilla L. Nicholls

Cambios

T. ConwaySale del partido
T. Conway
minuto 66'
N. WellsEntra en el partido
N. Wells
minuto 66'
Joe WilliamsSale del partido
Joe Williams
minuto 71'
A. MehmetiEntra en el partido
A. Mehmeti
minuto 71'
minuto 80'Rhys HealeyEntra en el partido Rhys Healey
minuto 80'Alex MatosSale del partido Alex Matos
minuto 86'Josh KoromaSale del partido Josh Koroma
minuto 86'J. HeadleyEntra en el partido J. Headley
minuto 95'Sorba ThomasSale del partido Sorba Thomas
minuto 95'O. TurtonEntra en el partido O. Turton

Otros

minuto 85'Josh KoromaLesionado Josh Koroma

Alineaciones

Bristol City

Bristol City

3-4-3
Alineación Inicial
Suplentes
Huddersfield Town

Huddersfield Town

4-5-1
Alineación Inicial
Suplentes

Estadísticas del partido

Bristol City Bristol City Huddersfield Town Huddersfield
61%
Posesión del balón
 38%
1
Goles
 1
3
Tiros a puerta
 4
3
Tiros fuera
 6
9
Total tiros
 13
3
Paradas del portero
 2
12
Saques de esquina
 4
2
Fueras de juego
 0
0
Tarjetas Rojas
 0
0
Lesiones
 1
2
Sustituciones
 3
7
Faltas
 18


  USO DE MEMORIA  
6,912,544 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0017
Controller Execution Time ( Match / Index )  0.3062
Total Execution Time  0.3080
  CADENA URL  
/partido/Bristol-City-Fc/Huddersfield-Town-Fc/2005?section=legal
  GET DATOS  
$_GET['/partido/Bristol-City-Fc/Huddersfield-Town-Fc/2005']  
$_GET['section']   legal
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0041  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 72033
0.0018  SELECT data1 FROM stats2024 t WHERE league_id = 72033 AND teamId = 6582227 and type = 33
0.0017  SELECT data1 FROM stats2024 t WHERE league_id = 72033 AND teamId = 6582231 and type = 33
0.0020  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '28116' 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 = 28116 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0019  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 28116 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0021  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 72033 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0018  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='28116' AND `active` = 1 AND year = 2024
0.0083  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=6582227 WHERE relp.in_squad=1 and mp.`match_id` = '28116' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0082  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=6582231 WHERE relp.in_squad=1 and mp.`match_id` = '28116' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=28116 AND extraId = 72033 AND type_rel = 4
0.0018  SELECT avg_rating FROM elo_teams WHERE id=1337
0.0017  SELECT * FROM futbol.calendars_lineups WHERE id = 28116 AND league_id = 72033 AND year = 2024