4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
SD Compostela - Real Avilés Industrial
Jornada 33
DESCANSO
20
00
268 Pts. Elo
7º

328 Pts. Elo
11º

2-1
Domingo, 28 Abril 2024, 12:00
Pep Caballé 14'
1 - 0
David Grande 17'
2 - 0
2 - 1
 28' Davo Fernández

SD Compostela

5-4-1
Alineación Inicial
Suplentes

Real Avilés Industrial

4-5-1
Alineación Inicial
Suplentes

Eventos del partido

Goles

Gol de
Pep Caballé
minuto 14'
Gol de
David Grande
minuto 17'
minuto 28'Gol de Davo Fernández

Tarjetas

T. Amarilla
Kike Vidal
minuto 2'
T. Amarilla
S. Rodríguez
minuto 47'
0 Comentarios

No hay comentarios


Partido televisado en...
Canal Medio Idioma País
TVG2 TV Castellano

  USO DE MEMORIA  
6,536,552 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.1636
Total Execution Time  0.1645
  CADENA URL  
/partido/Sd-Compostela/Real-Aviles-Ind/2024
  GET DATOS  
$_GET['/partido/Sd-Compostela/Real-Aviles-Ind/2024']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0018  SELECT data1 FROM stats2024 t WHERE league_id = 72362 AND teamId = 6587608 and type = 33
0.0018  SELECT data1 FROM stats2024 t WHERE league_id = 72362 AND teamId = 6587605 and type = 33
0.0020  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '196901' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0017  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 196901 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 196901 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0018  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='196901' AND `active` = 1 AND year = 2024
0.0105  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='72362' AND relp.team_id=6587608 WHERE relp.in_squad=1 and mp.`match_id` = '196901' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0081  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='72362' AND relp.team_id=6587605 WHERE relp.in_squad=1 and mp.`match_id` = '196901' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=196901 AND extraId = 72362 AND type_rel = 4
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2469 AND type_rel = 3
0.0019  SELECT * FROM futbol.calendars_lineups WHERE id = 196901 AND league_id = 72362 AND year = 2024