4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
CD Colunga - Caudal Deportivo
Jornada 12
FINALIZADO
41
40
69 Pts. Elo
8º

127 Pts. Elo
9º

1-0
Domingo, 26 Noviembre 2023, 15:45
Dani Corgo 71'
1 - 0
CD Colunga

CD Colunga

4-4-2
Alineación Inicial
Suplentes
Caudal Deportivo

Caudal Deportivo

4-4-2
Alineación Inicial
Suplentes

Eventos del partido

Goles

Dani CorgoGol de
Dani Corgo
minuto 71'

Tarjetas

DavidT. Amarilla
David
minuto 2'
minuto 16'DavidT. Amarilla David
MarcosT. Amarilla
Marcos
minuto 27'
minuto 31'I. SánchezT. Amarilla I. Sánchez
minuto 46'XurdeT. Amarilla Xurde
AwusiT. Amarilla
Awusi
minuto 49'
minuto 66'Pablo RodriguezT. Amarilla Pablo Rodriguez
Awusi2a Amarilla y Roja
Awusi
minuto 90'

Cambios

Keko RozaSale del partido
Keko Roza
minuto 35'
SantiagoEntra en el partido
Santiago
minuto 35'
minuto 54'Eloy OrdóñezSale del partido Eloy Ordóñez
minuto 54'ToqueroEntra en el partido Toquero
minuto 69'DavidSale del partido David
minuto 69'MarioSale del partido Mario
minuto 69'G. HuelgaEntra en el partido G. Huelga
minuto 69'Pablo CastielloEntra en el partido Pablo Castiello
DavidSale del partido
David
minuto 88'
P. CueliEntra en el partido
P. Cueli
minuto 88'
0 Comentarios

No hay comentarios



  USO DE MEMORIA  
6,684,280 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.4233
Total Execution Time  0.4242
  CADENA URL  
/partido/Cd-Colunga-Senior/Caudal-Deportivo/2024
  GET DATOS  
$_GET['/partido/Cd-Colunga-Senior/Caudal-Deportivo/2024']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0125  SELECT data1 FROM stats2024 t WHERE league_id = 72261 AND teamId = 6586138 and type = 33
0.0124  SELECT data1 FROM stats2024 t WHERE league_id = 72261 AND teamId = 6586137 and type = 33
0.0127  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '425001' 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 = 425001 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0125  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 425001 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0125  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='425001' AND `active` = 1 AND year = 2024
0.0140  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='72261' AND relp.team_id=6586138 WHERE relp.in_squad=1 and mp.`match_id` = '425001' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0136  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='72261' AND relp.team_id=6586137 WHERE relp.in_squad=1 and mp.`match_id` = '425001' 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=425001 AND extraId = 72261 AND type_rel = 4
0.0124  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2470 AND type_rel = 3
0.0125  SELECT * FROM futbol.calendars_lineups WHERE id = 425001 AND league_id = 72261 AND year = 2024