¿Eres mayor de edad?

SI NO

Confirma si tienes 18 años

Faldón apuestas
4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Derby County - West Ham
1/16 Final
FINALIZADO
10
10
806 Pts. Elo
47%

2006 Pts. Elo
53%

0-2
Lunes, 30 Enero 2023, 20:45
  • Asistencia: 25 espectadores
0 - 1
 10' Jarrod Bowen
0 - 2
 50' M. Antonio

Eventos del partido

Goles

minuto 10'Jarrod BowenGol de Jarrod Bowen
minuto 50'M. AntonioGol de M. Antonio

Tarjetas

K. SmithT. Amarilla
K. Smith
minuto 22'
minuto 70'Tomáš SoučekT. Amarilla Tomáš Souček

Cambios

Liam ThompsonEntra en el partido
Liam Thompson
minuto 61'
Max BirdSale del partido
Max Bird
minuto 61'
Tom BarkhuizenSale del partido
Tom Barkhuizen
minuto 62'
E. CashinEntra en el partido
E. Cashin
minuto 62'
Tony SpringettEntra en el partido
Tony Springett
minuto 62'
N. Mendez-LaingSale del partido
N. Mendez-Laing
minuto 62'
C. DaviesSale del partido
C. Davies
minuto 63'
Lewis DobbinEntra en el partido
Lewis Dobbin
minuto 63'
minuto 64'M. AntonioSale del partido M. Antonio
minuto 64'S. BenrahmaEntra en el partido S. Benrahma
Jake RooneyEntra en el partido
Jake Rooney
minuto 71'
Conor HourihaneSale del partido
Conor Hourihane
minuto 71'
minuto 78'EmersonSale del partido Emerson
minuto 78'A. CresswellEntra en el partido A. Cresswell
minuto 78'Divin MubamaEntra en el partido Divin Mubama
minuto 78'Jarrod BowenSale del partido Jarrod Bowen
minuto 87'M. LanziniEntra en el partido M. Lanzini
minuto 87'Pablo FornalsSale del partido Pablo Fornals

Otros

minuto 10'Tomáš SoučekAsistencia Tomáš Souček
Max BirdLesionado
Max Bird
minuto 60'

Alineaciones

Derby County

Derby County

4-5-1
Alineación Inicial
Suplentes
West Ham

West Ham

3-6-1
Alineación Inicial
Suplentes

Estadísticas del partido

Derby County Derby County West Ham West Ham
47%
Posesión del balón
 53%
0
Goles
 2
1
Tiros a puerta
 5
10
Tiros fuera
 3
11
Total tiros
 8
3
Paradas del portero
 1
2
Saques de esquina
 2
3
Fueras de juego
 3
1
Tarjetas Amarillas
 1
0
Tarjetas Rojas
 0
0
Asistencias
 1
1
Lesiones
 0
3
Sustituciones
 3
5
Faltas
 9


  USO DE MEMORIA  
6,965,672 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.2883
Total Execution Time  0.2893
  CADENA URL  
/partido/Derby-County-Fc/West-Ham-United/1928?section=legal
  GET DATOS  
$_GET['/partido/Derby-County-Fc/West-Ham-United/1928']  
$_GET['section']   legal
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0159   SELECT c.*, c.stadium as real_stadium, 2025 AS year, dt1.id AS dteam1_id, dt1.nameShow as team1_name, dt1.basealias AS team1_basealias, dt1.fullName as team1_fullName, dt1.color1 AS team1_color1, dt1.seats, dt1.size, dt1.yearBuilt, dt2.id AS dteam2_id, dt2.nameShow as team2_name, dt2.basealias AS team2_basealias, dt2.fullName as team2_fullName, dt2.color1 AS team2_color1, t1.name as team1_Oname, t2.name as team2_Oname, s.id as stadium_id, rs.teamId as stadium_team_id, s.name AS stadium_name, s.size AS stadium_size, s.seats AS stadium_seats, s.yearBuilt AS stadium_yearBuilt, dt1.managerNow AS manager1, dt2.managerNow AS manager2 FROM calendars2025 AS c INNER JOIN teams AS t1 ON c.team1 = t1.id INNER JOIN datateams AS dt1 ON t1.teamId = dt1.id INNER JOIN teams AS t2 ON c.team2 = t2.id INNER JOIN datateams AS dt2 ON t2.teamId = dt2.id LEFT JOIN futbol.rel_stadiums as rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = c.stadium WHERE c.extra != 1 AND dt1.basealias = 'Derby-County-Fc' AND dt2.basealias = 'West-Ham-United'
0.0129   SELECT c.*, c.stadium as real_stadium, 2026 AS year, dt1.id AS dteam1_id, dt1.nameShow as team1_name, dt1.basealias AS team1_basealias, dt1.fullName as team1_fullName, dt1.color1 AS team1_color1, dt1.seats, dt1.size, dt1.yearBuilt, dt2.id AS dteam2_id, dt2.nameShow as team2_name, dt2.basealias AS team2_basealias, dt2.fullName as team2_fullName, dt2.color1 AS team2_color1, t1.name as team1_Oname, t2.name as team2_Oname, s.id as stadium_id, rs.teamId as stadium_team_id, s.name AS stadium_name, s.size AS stadium_size, s.seats AS stadium_seats, s.yearBuilt AS stadium_yearBuilt, dt1.managerNow AS manager1, dt2.managerNow AS manager2 FROM calendars2026 AS c INNER JOIN teams AS t1 ON c.team1 = t1.id INNER JOIN datateams AS dt1 ON t1.teamId = dt1.id INNER JOIN teams AS t2 ON c.team2 = t2.id INNER JOIN datateams AS dt2 ON t2.teamId = dt2.id LEFT JOIN futbol.rel_stadiums as rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = c.stadium WHERE c.extra != 1 AND dt1.basealias = 'Derby-County-Fc' AND dt2.basealias = 'West-Ham-United'
0.0162   SELECT c.*, c.stadium as real_stadium, 2024 AS year, dt1.id AS dteam1_id, dt1.nameShow as team1_name, dt1.basealias AS team1_basealias, dt1.fullName as team1_fullName, dt1.color1 AS team1_color1, dt1.seats, dt1.size, dt1.yearBuilt, dt2.id AS dteam2_id, dt2.nameShow as team2_name, dt2.basealias AS team2_basealias, dt2.fullName as team2_fullName, dt2.color1 AS team2_color1, t1.name as team1_Oname, t2.name as team2_Oname, s.id as stadium_id, rs.teamId as stadium_team_id, s.name AS stadium_name, s.size AS stadium_size, s.seats AS stadium_seats, s.yearBuilt AS stadium_yearBuilt, dt1.managerNow AS manager1, dt2.managerNow AS manager2 FROM calendars2024 AS c INNER JOIN teams AS t1 ON c.team1 = t1.id INNER JOIN datateams AS dt1 ON t1.teamId = dt1.id INNER JOIN teams AS t2 ON c.team2 = t2.id INNER JOIN datateams AS dt2 ON t2.teamId = dt2.id LEFT JOIN futbol.rel_stadiums as rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = c.stadium WHERE c.extra != 1 AND dt1.basealias = 'Derby-County-Fc' AND dt2.basealias = 'West-Ham-United'
0.0107  SELECT data1 FROM stats2023 t WHERE league_id = 68334 AND teamId = 6555066 and type = 33
0.0105  SELECT data1 FROM stats2023 t WHERE league_id = 68334 AND teamId = 6562008 and type = 33
0.0108  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '621411' and rp.type = 2023 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0105  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 621411 AND year = 2023 AND channel = 'Footters' LIMIT 1
0.0105  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 621411 AND year = 2023 AND channel = 'Footters' LIMIT 1
0.0105  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='621411' AND `active` = 1 AND year = 2023
0.0124  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='68334' AND relp.team_id=6555066 WHERE relp.in_squad=1 and mp.`match_id` = '621411' AND mp.year='2023' ORDER BY mp.`team` ASC, p.`role` ASC
0.0117  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='68334' AND relp.team_id=6562008 WHERE relp.in_squad=1 and mp.`match_id` = '621411' AND mp.year='2023' ORDER BY mp.`team` ASC, p.`role` ASC
0.0106  SELECT position FROM tables2023 WHERE team=6555066 AND league_id=68334 AND round=10
0.0107  SELECT position FROM tables2023 WHERE team=6562008 AND league_id=68334 AND round=10
0.0107  SELECT * FROM futbol.calendars_lineups WHERE id = 621411 AND league_id = 68334 AND year = 2023