4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Havant & Waterlooville - St. Albans City
Jornada 37
FINALIZADO
20
10
293 Pts. Elo
6º

237 Pts. Elo
9º

1-2
Miércoles, 08 Marzo 2023, 20:45
0 - 1
 40' S. Jeffers
P. Rooney 47'
1 - 1
1 - 2
 69' G. Mcconnell

Eventos del partido

Goles

minuto 40'S. JeffersGol de S. Jeffers
P. RooneyGol de
P. Rooney
minuto 47'
minuto 69'G. McconnellGol de G. Mcconnell

Tarjetas

J. NewtonT. Amarilla
J. Newton
minuto 50'
P. RooneyT. Amarilla
P. Rooney
minuto 52'
minuto 88'D. StanleyT. Amarilla D. Stanley

Cambios

Samuel MagriEntra en el partido
Samuel Magri
minuto 46'
J. OastlerSale del partido
J. Oastler
minuto 46'
T. Miller-RodneyEntra en el partido
T. Miller-Rodney
minuto 58'
P. RooneySale del partido
P. Rooney
minuto 58'
minuto 59'R. Di TrolioSale del partido R. Di Trolio
minuto 59'M. ClarkEntra en el partido M. Clark
J. JebbSale del partido
J. Jebb
minuto 72'
E. BurnettEntra en el partido
E. Burnett
minuto 72'
minuto 77'M. SundireEntra en el partido M. Sundire
minuto 77'M. WeissSale del partido M. Weiss
minuto 77'K. WiltshireEntra en el partido K. Wiltshire
minuto 77'C. CooperSale del partido C. Cooper

Alineaciones

Havant & Waterlooville

Havant & Waterlooville

4-4-2
Alineación Inicial
Suplentes
St. Albans City

St. Albans City

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
6,781,984 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.3477
Total Execution Time  0.3487
  CADENA URL  
/partido/Havant-Water-Hellip/St-Albans-City/2023
  GET DATOS  
$_GET['/partido/Havant-Water-Hellip/St-Albans-City/2023']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0018  SELECT data1 FROM stats2023 t WHERE league_id = 68219 AND teamId = 6523936 and type = 33
0.0018  SELECT data1 FROM stats2023 t WHERE league_id = 68219 AND teamId = 6523941 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 = '119059' and rp.type = 2023 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 = 119059 AND year = 2023 AND channel = 'Footters' LIMIT 1
0.0019  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 119059 AND year = 2023 AND channel = 'Footters' LIMIT 1
0.0022  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='119059' AND `active` = 1 AND year = 2023
0.0344  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='68219' AND relp.team_id=6523936 WHERE relp.in_squad=1 and mp.`match_id` = '119059' AND mp.year='2023' ORDER BY mp.`team` ASC, p.`role` ASC
0.0143  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='68219' AND relp.team_id=6523941 WHERE relp.in_squad=1 and mp.`match_id` = '119059' AND mp.year='2023' ORDER BY mp.`team` ASC, p.`role` ASC
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=119059 AND extraId = 68219 AND type_rel = 4
0.0020  SELECT rating1, rating2 FROM calendars_elo WHERE id=119059 AND league_id=68219 AND year=2023
0.0020  SELECT * FROM futbol.calendars_lineups WHERE id = 119059 AND league_id = 68219 AND year = 2023