4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Bergantiños FC - CD Lugo B
Jornada 6
FINALIZADO
20
50
127 Pts. Elo
4º

128 Pts. Elo
12º

0-0
Domingo, 15 Octubre 2023, 17:30

Bergantiños FC

4-4-2
Alineación Inicial
Suplentes

CD Lugo B

4-4-2
Alineación Inicial
Suplentes
Bergantiños FC
CD Lugo B
T. Amarilla
T. Amarilla
Sale del partido
Sale del partido
Entra en el partido
Entra en el partido
T. Amarilla
T. Amarilla
Sale del partido
Entra en el partido
Entra en el partido
Sale del partido
Sale del partido
Entra en el partido
Sale del partido
Sale del partido
Entra en el partido
Sale del partido
Entra en el partido
Sale del partido
Entra en el partido
Entra en el partido
T. Amarilla
T. Amarilla
T. Amarilla

Eventos del partido

Tarjetas

minuto 26'T. Amarilla A. Mediero
minuto 36'T. Amarilla Usama Arhoun
T. Amarilla
Manu
minuto 55'
minuto 58'T. Amarilla Pablo Fernández
T. Amarilla
Israel
minuto 88'
minuto 89'T. Amarilla M. Álvarez
minuto 90'T. Amarilla Alberto Freire

Cambios

minuto 46'Sale del partido D. Roson
minuto 46'Sale del partido D. Noya
minuto 46'Entra en el partido P. Martínez
minuto 46'Entra en el partido Roberto Colucci
Sale del partido
Jorge Cano
minuto 60'
Entra en el partido
Longo
minuto 60'
minuto 62'Entra en el partido A. Lizancos
minuto 62'Sale del partido J. Lansade
minuto 68'Sale del partido A. Mediero
minuto 68'Entra en el partido J. Maceira
Sale del partido
Marcos Remeseiro
minuto 78'
Sale del partido
A. Ramos
minuto 78'
Entra en el partido
Dani Pedrosa
minuto 78'
Sale del partido
Manu
minuto 78'
Entra en el partido
F. Kanoute
minuto 78'
minuto 78'Sale del partido Hugo García
minuto 78'Entra en el partido Alejandro Arranz
Entra en el partido
D. Álvarez
minuto 78'
0 Comentarios

No hay comentarios



  USO DE MEMORIA  
6,885,696 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0016
Controller Execution Time ( Match / Index )  0.3053
Total Execution Time  0.3069
  CADENA URL  
/partido/Bergantinos/Polvorin-Sd/2024
  GET DATOS  
$_GET['/partido/Bergantinos/Polvorin-Sd/2024']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0040  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 72260
0.0018  SELECT data1 FROM stats2024 t WHERE league_id = 72260 AND teamId = 6586120 and type = 33
0.0018  SELECT data1 FROM stats2024 t WHERE league_id = 72260 AND teamId = 6586127 and type = 33
0.0022  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '449121' 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 = 449121 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0024  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 449121 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0026  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 = 72260 AND t.round = 31 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='449121' AND `active` = 1 AND year = 2024
0.0083  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='72260' AND relp.team_id=6586120 WHERE relp.in_squad=1 and mp.`match_id` = '449121' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0053  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='72260' AND relp.team_id=6586127 WHERE relp.in_squad=1 and mp.`match_id` = '449121' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=449121 AND extraId = 72260 AND type_rel = 4
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2470 AND type_rel = 3
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 449121 AND league_id = 72260 AND year = 2024