4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
AFC Edinburgh University - Berwick Rangers
Jornada 6
FINALIZADO
11
00
13 Pts. Elo
17º

199 Pts. Elo
5º

1-3
Martes, 22 Agosto 2023, 20:45
J. Aitken 1'
1 - 0
1 - 1
 55' L. Buchanan
1 - 2
 58' L. Buchanan
1 - 3
 68' L. Buchanan

Eventos del partido

Goles

J. AitkenGol de
J. Aitken
minuto 1'
minuto 55'L. BuchananGol de penalti L. Buchanan
minuto 58'L. BuchananGol de L. Buchanan
minuto 68'L. BuchananGol de L. Buchanan

Tarjetas

R. MurrayT. Amarilla
R. Murray
minuto
L. MurrayTarjeta Roja a
L. Murray
minuto 54'

Cambios

Cameron ReidEntra en el partido
Cameron Reid
minuto 46'
B. BarlowSale del partido
B. Barlow
minuto 46'
minuto 68'L. BuchananSale del partido L. Buchanan
minuto 68'L. BakerEntra en el partido L. Baker
minuto 75'S. KhyyamEntra en el partido S. Khyyam
minuto 75'K. BakerEntra en el partido K. Baker
minuto 75'J. MccormackSale del partido J. Mccormack
minuto 75'A. HarrisSale del partido A. Harris

Otros

D. MaskreyAsistencia
D. Maskrey
minuto 1'
minuto 58'M. TravisAsistencia M. Travis

Alineaciones

AFC Edinburgh University

AFC Edinburgh University

4-4-2
Alineación Inicial
Suplentes
Berwick Rangers

Berwick Rangers

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
6,710,912 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.5187
Total Execution Time  0.5197
  CADENA URL  
/partido/Edinburgh-University/Berwick-Rangers/2024?section=legal
  GET DATOS  
$_GET['/partido/Edinburgh-University/Berwick-Rangers/2024']  
$_GET['section']   legal
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0125  SELECT data1 FROM stats2024 t WHERE league_id = 72464 AND teamId = 6588738 and type = 33
0.0124  SELECT data1 FROM stats2024 t WHERE league_id = 72464 AND teamId = 6588733 and type = 33
0.0130  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '413215' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 413215 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0125  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 413215 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0127  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 `tables2024` where league_id = 72464 and round = 35 group by league_id, round
0.0126  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='413215' AND `active` = 1 AND year = 2024
0.0151  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='72464' AND relp.team_id=6588738 WHERE relp.in_squad=1 and mp.`match_id` = '413215' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0145  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='72464' AND relp.team_id=6588733 WHERE relp.in_squad=1 and mp.`match_id` = '413215' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=413215 AND extraId = 72464 AND type_rel = 4
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1590 AND type_rel = 3
0.0125  SELECT * FROM futbol.calendars_lineups WHERE id = 413215 AND league_id = 72464 AND year = 2024