4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Coxyde - White Star Woluwé
FINALIZADO
00
11
318 Pts. Elo
14º

572 Pts. Elo
15º

2-2
Domingo, 19 Febrero 2017, 15:00
O. Diakho 20'
1 - 0
J. Somay 32'
2 - 0
2 - 1
74' Kevin Koffi
2 - 2
88' Kevin Koffi

Eventos del partido

Goles

O. DiakhoGol de
O. Diakho
minuto 20'
J. SomayGol de
J. Somay
minuto 32'
minuto 74'Kevin KoffiGol de penalti Kevin Koffi
minuto 88'Kevin KoffiGol de Kevin Koffi

Tarjetas

minuto 68'A. Kabous2a Amarilla y Roja A. Kabous

Cambios

minuto 39'M. ZaananEntra en el partido M. Zaanan
minuto 39'L. MoensSale del partido L. Moens
D. VerhaerenEntra en el partido
D. Verhaeren
minuto 39'
K. NtikaSale del partido
K. Ntika
minuto 39'
Y. MohammedSale del partido
Y. Mohammed
minuto 43'
F. GarciaEntra en el partido
F. Garcia
minuto 43'
minuto 46'S. CorsicoSale del partido S. Corsico
minuto 46'D. KalonjiEntra en el partido D. Kalonji
minuto 60'M. TchitéSale del partido M. Tchité
minuto 60'E. DivrikliEntra en el partido E. Divrikli

Alineaciones

Coxyde

Coxyde

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



  USO DE MEMORIA  
5,818,472 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Match / Index )  0.1754
Total Execution Time  0.1766
  CADENA URL  
/partido/Coxyde/White-Star-Woluwe/2017
  GET DATOS  
$_GET['/partido/Coxyde/White-Star-Woluwe/2017']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0017  SELECT data1 FROM stats2017 t WHERE league_id = 33772 AND teamId = 715534 and type = 33
0.0018  SELECT data1 FROM stats2017 t WHERE league_id = 33772 AND teamId = 715532 and type = 33
0.0019  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '79115' 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 = 79115 AND year = 2017 AND channel = 'Footters' LIMIT 1
0.0017  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 79115 AND year = 2017 AND channel = 'Footters' LIMIT 1
0.0019  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='79115' AND `active` = 1 AND year = 2017
0.0041  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='33772' AND relp.team_id=715534 WHERE relp.in_squad=1 and mp.`match_id` = '79115' AND mp.year='2017' ORDER BY mp.`team` ASC, p.`role` ASC
0.0047  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='33772' AND relp.team_id=715532 WHERE relp.in_squad=1 and mp.`match_id` = '79115' AND mp.year='2017' ORDER BY mp.`team` ASC, p.`role` ASC
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=79115 AND extraId = 33772 AND type_rel = 4
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1894 AND type_rel = 3
0.0019  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1894 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0021  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (1293576,1264941,900137,769348,500257) ORDER BY n.cover_points DESC, update_date DESC
0.0019  SELECT * FROM futbol.calendars_lineups WHERE id = 79115 AND league_id = 33772 AND year = 2017