4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Pomorie - CSKA Sofia II
FINALIZADO
00
00
786 Pts. Elo
10º

538 Pts. Elo

2-1
Domingo, 16 Octubre 2016, 15:00
  • Asistencia: 600 espectadores
M. Tawiah 28'
1 - 0
Ahmed Ahmedov 45'
2 - 0
2 - 1
52' M. Angelov

Eventos del partido

Goles

M. TawiahGol de
M. Tawiah
minuto 28'
Ahmed AhmedovGol de
Ahmed Ahmedov
minuto 45'
minuto 52'M. AngelovGol de M. Angelov

Cambios

D. StoyanovEntra en el partido
D. Stoyanov
minuto 58'
minuto 58'G. TartovSale del partido G. Tartov
M. TanevSale del partido
M. Tanev
minuto 58'
minuto 58'T. YordanovEntra en el partido T. Yordanov
B. RasimSale del partido
B. Rasim
minuto 76'
K. GeorgievEntra en el partido
K. Georgiev
minuto 76'
S. GanevEntra en el partido
S. Ganev
minuto 83'
I. SherdenovSale del partido
I. Sherdenov
minuto 83'
minuto 84'Lazar MarinSale del partido Lazar Marin
minuto 84'R. ZhivkovEntra en el partido R. Zhivkov

Alineaciones




  USO DE MEMORIA  
5,815,264 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.1720
Total Execution Time  0.1730
  CADENA URL  
/partido/Pomorie/Cska-Sofia-Ii/2017
  GET DATOS  
$_GET['/partido/Pomorie/Cska-Sofia-Ii/2017']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (10)  
0.0018  SELECT data1 FROM stats2017 t WHERE league_id = 34065 AND teamId = 721223 and type = 33
0.0017  SELECT data1 FROM stats2017 t WHERE league_id = 34065 AND teamId = 721217 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 = '254466' 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 = 254466 AND year = 2017 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 254466 AND year = 2017 AND channel = 'Footters' LIMIT 1
0.0018  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='254466' AND `active` = 1 AND year = 2017
0.0050  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='34065' AND relp.team_id=721223 WHERE relp.in_squad=1 and mp.`match_id` = '254466' AND mp.year='2017' ORDER BY mp.`team` ASC, p.`role` ASC
0.0104  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='34065' AND relp.team_id=721217 WHERE relp.in_squad=1 and mp.`match_id` = '254466' 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=254466 AND extraId = 34065 AND type_rel = 4
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 254466 AND league_id = 34065 AND year = 2017