4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Queens Park Rangers - Ipswich Town
Jornada 3
FINALIZADO
40
10
806 Pts. Elo
38%
17º

1372 Pts. Elo
61%
1º

0-1
Sábado, 19 Agosto 2023, 16:00
0 - 1
 75' C. Chaplin

Queens Park Rangers

3-4-3
Alineación Inicial
Suplentes

Ipswich Town

4-5-1
Alineación Inicial
Suplentes

Eventos del partido

Goles

minuto 75'Gol de C. Chaplin

Tarjetas

T. Amarilla
P. Smyth
minuto 19'
minuto 21'T. Amarilla Massimo Luongo
T. Amarilla
I. Chair
minuto 51'
T. Amarilla
S. Field
minuto 55'
T. Amarilla
J. Colback
minuto 98'

Ocasiones

Tiro al palo
S. Armstrong
minuto 12'

Cambios

minuto 37'Sale del partido J. Donacien
minuto 37'Entra en el partido Harry Clarke
Entra en el partido
J. Colback
minuto 46'
Sale del partido
Chris Willock
minuto 46'
Sale del partido
S. Armstrong
minuto 65'
Entra en el partido
R. Kolli
minuto 65'
Sale del partido
S. Field
minuto 67'
Entra en el partido
E. Dixon-Bonner
minuto 67'
minuto 82'Sale del partido Wes Burns
minuto 82'Entra en el partido O. Hutchinson
minuto 82'Sale del partido N. Broadhead
minuto 82'Entra en el partido K. Jackson
minuto 92'Entra en el partido M. Harness
minuto 92'Sale del partido George Hirst
minuto 92'Entra en el partido F. Ladapo
minuto 92'Sale del partido C. Chaplin
Entra en el partido
S. Duke-Mckenna
minuto 93'
Sale del partido
Andre Dozzell
minuto 93'

Otros

minuto 36'Lesionado J. Donacien
Lesionado
S. Armstrong
minuto 64'
Lesionado
S. Field
minuto 66'

Estadísticas del partido

Queens Park Rangers Queens Park Ipswich Town Ipswich Town
38%
Posesión del balón
 61%
0
Goles
 1
4
Tiros a puerta
 3
5
Tiros fuera
 10
10
Total tiros
 16
2
Paradas del portero
 4
5
Saques de esquina
 4
2
Fueras de juego
 3
0
Tarjetas Rojas
 0
1
Tiros al palo
 0
2
Lesiones
 1
3
Sustituciones
 3
15
Faltas
 10
0 Comentarios

No hay comentarios



  USO DE MEMORIA  
6,935,704 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.3690
Total Execution Time  0.3700
  CADENA URL  
/partido/Queens-Park-Rangers-Fc/Ipswich-Town-Fc/2024
  GET DATOS  
$_GET['/partido/Queens-Park-Rangers-Fc/Ipswich-Town-Fc/2024']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0017  SELECT data1 FROM stats2024 t WHERE league_id = 72033 AND teamId = 6582241 and type = 33
0.0018  SELECT data1 FROM stats2024 t WHERE league_id = 72033 AND teamId = 6582233 and type = 33
0.0019  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '27642' 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 = 27642 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 27642 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0020  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.0042  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 `tables2024` 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 = 72033 AND t.round = 45 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0018  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='27642' AND `active` = 1 AND year = 2024
0.0115  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=6582241 WHERE relp.in_squad=1 and mp.`match_id` = '27642' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0099  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=6582233 WHERE relp.in_squad=1 and mp.`match_id` = '27642' 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=27642 AND extraId = 72033 AND type_rel = 4
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=25 AND type_rel = 3
0.0081  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.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 (1312774,1312207,1312289,1312261,1312186) ORDER BY n.cover_points DESC, update_date DESC
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 27642 AND league_id = 72033 AND year = 2024