4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
SD Compostela - Choco
Jornada 17
FINALIZADO
10
30
416 Pts. Elo
1º

303 Pts. Elo
6º

2-0
Domingo, 22 Diciembre 2019, 17:00
Primo 30'
1 - 0
David Soto 88'
2 - 0

Eventos del partido

Goles

PrimoGol de
Primo
minuto 30'
David SotoGol de
David Soto
minuto 88'

Tarjetas

minuto 23'CaloiT. Amarilla Caloi
minuto 38'AitorT. Amarilla Aitor
David SotoT. Amarilla
David Soto
minuto 54'
minuto 57'Sergio SantosT. Amarilla Sergio Santos

Cambios

Gabri PalmásSale del partido
Gabri Palmás
minuto 61'
Miki VillarEntra en el partido
Miki Villar
minuto 61'
minuto 70'Oscar ComísEntra en el partido Oscar Comís
minuto 70'AdriSale del partido Adri
minuto 70'TomásSale del partido Tomás
minuto 70'Eduardo OteroEntra en el partido Eduardo Otero
minuto 74'Martín CrespoEntra en el partido Martín Crespo
minuto 74'M. GarcíaSale del partido M. García
S. RodríguezEntra en el partido
S. Rodríguez
minuto 75'
Hugo SanmartínSale del partido
Hugo Sanmartín
minuto 75'
Brais AbelendaSale del partido
Brais Abelenda
minuto 86'
Rodrigo AlonsoEntra en el partido
Rodrigo Alonso
minuto 86'

Alineaciones

SD Compostela

SD Compostela

4-4-2
Alineación Inicial
Suplentes
Choco

Choco

4-4-2
Alineación Inicial
Suplentes

Estadísticas del partido

A PHP Error was encountered

Severity: Warning

Message: Invalid argument supplied for foreach()

Filename: comment/main_view.php

Line Number: 2065

SD Compostela Compostela Choco Choco
0 Comentarios

No hay comentarios


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

  USO DE MEMORIA  
6,526,728 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.3198
Total Execution Time  0.3208
  CADENA URL  
/partido/Sd-Compostela/Choco/2020
  GET DATOS  
$_GET['/partido/Sd-Compostela/Choco/2020']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (10)  
0.0018  SELECT data1 FROM stats2020 t WHERE league_id = 50269 AND teamId = 6289297 and type = 33
0.0018  SELECT data1 FROM stats2020 t WHERE league_id = 50269 AND teamId = 6289296 and type = 33
0.0021  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '117914' and rp.type = 2020 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 117914 AND year = 2020 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 117914 AND year = 2020 AND channel = 'Footters' LIMIT 1
0.0018  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='117914' AND `active` = 1 AND year = 2020
0.0028  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='50269' AND relp.team_id=6289297 WHERE relp.in_squad=1 and mp.`match_id` = '117914' AND mp.year='2020' ORDER BY mp.`team` ASC, p.`role` ASC
0.0024  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='50269' AND relp.team_id=6289296 WHERE relp.in_squad=1 and mp.`match_id` = '117914' AND mp.year='2020' ORDER BY mp.`team` ASC, p.`role` ASC
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=117914 AND extraId = 50269 AND type_rel = 4
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 117914 AND league_id = 50269 AND year = 2020