4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
SC Covilha - SC Freamunde
Jornada 21
FINALIZADO
20
30
1075 Pts. Elo
11º

1005 Pts. Elo
20º

1-1
Sábado, 07 Enero 2017, 16:00
Pintassilgo 45'
1 - 0
1 - 1
 81' Jorge Daniel Vilela

Eventos del partido

Goles

PintassilgoGol de
Pintassilgo
minuto 45'
minuto 81'Jorge Daniel VilelaGol de Jorge Daniel Vilela

Tarjetas

minuto 38'Mohcine HassanT. Amarilla Mohcine Hassan
B. DiarraT. Amarilla
B. Diarra
minuto 57'
Joel VitalT. Amarilla
Joel Vital
minuto 63'
minuto 85'Jorge Daniel VilelaT. Amarilla Jorge Daniel Vilela
minuto 90'HuguinhoT. Amarilla Huguinho

Cambios

minuto 46'HuguinhoEntra en el partido Huguinho
minuto 46'Rui RainhoSale del partido Rui Rainho
minuto 57'I. PérezSale del partido I. Pérez
minuto 57'S. HipperdingerEntra en el partido S. Hipperdinger
Cristian PondeEntra en el partido
Cristian Ponde
minuto 63'
PintassilgoSale del partido
Pintassilgo
minuto 63'
minuto 73'Mohcine HassanSale del partido Mohcine Hassan
minuto 73'K. YeroEntra en el partido K. Yero
P. AgyemangEntra en el partido
P. Agyemang
minuto 76'
Filipe ChabySale del partido
Filipe Chaby
minuto 76'
B. DiarraSale del partido
B. Diarra
minuto 84'
Luís PintoEntra en el partido
Luís Pinto
minuto 84'

Otros

Harramiz SoaresAsistencia
Harramiz Soares
minuto 45'

Alineaciones

SC Covilha

SC Covilha

4-4-2
Alineación Inicial
Suplentes
SC Freamunde

SC Freamunde

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
5,982,840 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.2095
Total Execution Time  0.2104
  CADENA URL  
/partido/Sporting-Covilha/Sc-Freamunde/2017
  GET DATOS  
$_GET['/partido/Sporting-Covilha/Sc-Freamunde/2017']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (10)  
0.0018  SELECT data1 FROM stats2017 t WHERE league_id = 31022 AND teamId = 707635 and type = 33
0.0018  SELECT data1 FROM stats2017 t WHERE league_id = 31022 AND teamId = 707634 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 = '100953' and rp.type = 2017 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 = 100953 AND year = 2017 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 100953 AND year = 2017 AND channel = 'Footters' LIMIT 1
0.0020  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='100953' AND `active` = 1 AND year = 2017
0.0089  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='31022' AND relp.team_id=707635 WHERE relp.in_squad=1 and mp.`match_id` = '100953' AND mp.year='2017' ORDER BY mp.`team` ASC, p.`role` ASC
0.0090  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='31022' AND relp.team_id=707634 WHERE relp.in_squad=1 and mp.`match_id` = '100953' AND mp.year='2017' ORDER BY mp.`team` ASC, p.`role` ASC
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=100953 AND extraId = 31022 AND type_rel = 4
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 100953 AND league_id = 31022 AND year = 2017