¿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
Blackpool - Stoke City
Jornada 33
FINALIZADO
40
10
876 Pts. Elo
30%
23º

991 Pts. Elo
69%
16º

1-0
Sábado, 18 Febrero 2023, 16:00
Ian Poveda 7'
1 - 0

Eventos del partido

Goles

Ian PovedaGol de
Ian Poveda
minuto 7'

Tarjetas

K. DougallT. Amarilla
K. Dougall
minuto 24'
Ian PovedaT. Amarilla
Ian Poveda
minuto 27'
D. ThompsonT. Amarilla
D. Thompson
minuto 81'
J. HusbandT. Amarilla
J. Husband
minuto 85'
minuto 93'Ben WilmotT. Amarilla Ben Wilmot

Cambios

L. FioriniSale del partido
L. Fiorini
minuto 46'
Cj HamiltonEntra en el partido
Cj Hamilton
minuto 46'
Jordan GabrielEntra en el partido
Jordan Gabriel
minuto 63'
A. LyonsSale del partido
A. Lyons
minuto 63'
Morgan RogersSale del partido
Morgan Rogers
minuto 64'
L. GarbuttEntra en el partido
L. Garbutt
minuto 64'
Ian PovedaSale del partido
Ian Poveda
minuto 64'
D. ThompsonEntra en el partido
D. Thompson
minuto 64'
minuto 70'Lewis BakerEntra en el partido Lewis Baker
minuto 70'K. HoeverEntra en el partido K. Hoever
minuto 70'D. GayleSale del partido D. Gayle
minuto 70'Dujon SterlingSale del partido Dujon Sterling
minuto 92'Nathan LoweEntra en el partido Nathan Lowe
minuto 92'J. ThompsonSale del partido J. Thompson

Otros

L. FioriniAsistencia
L. Fiorini
minuto 7'

Alineaciones

Blackpool

Blackpool

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

Stoke City

4-5-1
Alineación Inicial
Suplentes

Estadísticas del partido

Blackpool Blackpool Stoke City Stoke City
30%
Posesión del balón
 69%
1
Goles
 0
1
Tiros a puerta
 6
2
Tiros fuera
 9
3
Total tiros
 15
6
Paradas del portero
 0
3
Saques de esquina
 5
4
Tarjetas Amarillas
 1
0
Tarjetas Rojas
 0
1
Asistencias
 0
3
Sustituciones
 3
13
Faltas
 9


  USO DE MEMORIA  
8,673,896 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0015
Controller Execution Time ( Match / Index )  1.0766
Total Execution Time  1.0781
  CADENA URL  
/partido/Blackpool-Fc/Stoke-City/1965?section=legal
  GET DATOS  
$_GET['/partido/Blackpool-Fc/Stoke-City/1965']  
$_GET['section']   legal
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0030   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 = 'Blackpool-Fc' AND dt2.basealias = 'Stoke-City'
0.0031   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 = 'Blackpool-Fc' AND dt2.basealias = 'Stoke-City'
0.0029   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 = 'Blackpool-Fc' AND dt2.basealias = 'Stoke-City'
0.0017  SELECT data1 FROM stats2023 t WHERE league_id = 67799 AND teamId = 6517140 and type = 33
0.0017  SELECT data1 FROM stats2023 t WHERE league_id = 67799 AND teamId = 6517153 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 = '46025' and rp.type = 2023 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 = 46025 AND year = 2023 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 46025 AND year = 2023 AND channel = 'Footters' LIMIT 1
0.0019  SELECT AVG(points) as avg_points, AVG(gf) as avg_gf, AVG(ga) as avg_gc, SUM(win_h) as win_home, SUM(win_a) as win_away, SUM(draw_h) as draw_home, SUM(draw_a) as draw_away from `tables2023` where league_id = 67799 and round = 46 group by league_id, round
0.0021  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='46025' AND `active` = 1 AND year = 2023
0.0125  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='67799' AND relp.team_id=6517140 WHERE relp.in_squad=1 and mp.`match_id` = '46025' AND mp.year='2023' ORDER BY mp.`team` ASC, p.`role` ASC
0.0089  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='67799' AND relp.team_id=6517153 WHERE relp.in_squad=1 and mp.`match_id` = '46025' AND mp.year='2023' ORDER BY mp.`team` ASC, p.`role` ASC
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=46025 AND extraId = 67799 AND type_rel = 4
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=25 AND type_rel = 3
0.0073  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 (1348773,1346543,1346803,1346649,1346438) ORDER BY n.cover_points DESC, update_date DESC
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 46025 AND league_id = 67799 AND year = 2023