4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Notts County - Stoke City
Jornada 38
FINALIZADO
00
00
765 Pts. Elo

1143 Pts. Elo

1-5
Sábado, 08 Julio 2023, 16:00
0 - 1
 16' Tom Sparrow
0 - 2
 19' Tyrese Campbell
0 - 3
 37' Tyrese Campbell
0 - 4
 44' Tyrese Campbell
Macca 44'
1 - 4
1 - 5
 60' Wright-Phillips
Notts County

Notts County

4-4-2
Alineación Inicial
Suplentes
Stoke City

Stoke City

4-4-2
Alineación Inicial
Suplentes
Notts County
Stoke City
Gol
Gol
Gol
Gol
Gol
Entra en el partido
Sale del partido
Sale del partido
Entra en el partido
Sale del partido
Entra en el partido
Entra en el partido
Sale del partido
Entra en el partido
Sale del partido
Entra en el partido
Entra en el partido
Sale del partido
Sale del partido
Sale del partido
Entra en el partido
Sale del partido
Entra en el partido
Entra en el partido
Sale del partido
Sale del partido
Entra en el partido
Gol

Eventos del partido

Goles

minuto 16'Tom SparrowGol de Tom Sparrow
minuto 19'Tyrese CampbellGol de Tyrese Campbell
minuto 37'Tyrese CampbellGol de Tyrese Campbell
minuto 44'Tyrese CampbellGol de Tyrese Campbell
MaccaGol de
Macca
minuto 44'
minuto 60'Wright-PhillipsGol de Wright-Phillips

Cambios

minuto 46'Blondy NoukeuEntra en el partido Blondy Noukeu
minuto 46'Emre TezgelSale del partido Emre Tezgel
minuto 46'Jacob BrownSale del partido Jacob Brown
minuto 46'Dara McguinnessEntra en el partido Dara Mcguinness
minuto 46'Tom SparrowSale del partido Tom Sparrow
minuto 46'Wright-PhillipsEntra en el partido Wright-Phillips
minuto 46'William SmithEntra en el partido William Smith
minuto 46'J. LaurentSale del partido J. Laurent
minuto 46'Jack GriffithsEntra en el partido Jack Griffiths
minuto 46'Lewis BakerSale del partido Lewis Baker
minuto 46'Ben KershawEntra en el partido Ben Kershaw
minuto 46'Liam MccarronEntra en el partido Liam Mccarron
minuto 46'Ben WilmotSale del partido Ben Wilmot
minuto 46'J. TymonSale del partido J. Tymon
minuto 46'Connor TaylorSale del partido Connor Taylor
minuto 46'David OkagbueEntra en el partido David Okagbue
minuto 46'Lewis MacariSale del partido Lewis Macari
minuto 46'T. EdwardsEntra en el partido T. Edwards
minuto 46'Luke BadleyEntra en el partido Luke Badley
minuto 46'J. BonhamSale del partido J. Bonham
minuto 46'Tyrese CampbellSale del partido Tyrese Campbell
minuto 46'Kahrel ReddinEntra en el partido Kahrel Reddin
0 Comentarios

No hay comentarios



  USO DE MEMORIA  
6,760,600 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.2591
Total Execution Time  0.2601
  CADENA URL  
/partido/Notts-County/Stoke-City/2024
  GET DATOS  
$_GET['/partido/Notts-County/Stoke-City/2024']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0110   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 = 'Notts-County' AND dt2.basealias = 'Stoke-City'
0.0036  SELECT c.*, 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, dt1.id 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 datastadiums AS s ON s.id = c.stadium WHERE c.extra != 1 AND dt1.basealias = 'Notts-County' AND dt2.basealias = 'Stoke-City'
0.0018  SELECT data1 FROM stats2024 t WHERE league_id = 71432 AND teamId = 6578685 and type = 33
0.0018  SELECT data1 FROM stats2024 t WHERE league_id = 71432 AND teamId = 6577560 and type = 33
0.0023  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '1229' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 1229 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 1229 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0018  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='1229' AND `active` = 1 AND year = 2024
0.0098  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='71432' AND relp.team_id=6578685 WHERE relp.in_squad=1 and mp.`match_id` = '1229' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0079  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='71432' AND relp.team_id=6577560 WHERE relp.in_squad=1 and mp.`match_id` = '1229' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1229 AND extraId = 71432 AND type_rel = 4
0.0018  SELECT position FROM tables2024 WHERE team=6578685 AND league_id=71432 AND round=38
0.0018  SELECT position FROM tables2024 WHERE team=6577560 AND league_id=71432 AND round=38
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 1229 AND league_id = 71432 AND year = 2024