4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Le Mans - Valenciennes
Jornada 14
FINALIZADO
10
10
2167 Pts. Elo
9º

1666 Pts. Elo
20º

1-0
Sábado, 15 Noviembre 2008, 17:00
M. Coutadeur 21'
1 - 0

Le Mans

5-3-2
Alineación Inicial
Suplentes

Valenciennes

5-4-1
Alineación Inicial
Suplentes
Le Mans
Valenciennes
Gol
Entra en el partido
Sale del partido
T. Amarilla
Entra en el partido
Sale del partido
Entra en el partido
Sale del partido
Sale del partido
Entra en el partido
T. Amarilla
Entra en el partido
Sale del partido
Entra en el partido
Sale del partido

Eventos del partido

Goles

Gol de
M. Coutadeur
minuto 21'

Tarjetas

minuto 62'T. Amarilla R. Schmitz
T. Amarilla
M. Dossevi
minuto 87'

Cambios

minuto 55'Entra en el partido Y. Bezzaz
minuto 55'Sale del partido J. Abardonado
minuto 68'Entra en el partido D. Ducourtioux
minuto 68'Sale del partido J. Audel
minuto 68'Entra en el partido Filip Sebo
minuto 68'Sale del partido Y. Bezzaz
Sale del partido
R. Lamah
minuto 85'
Entra en el partido
M. Dossevi
minuto 85'
Entra en el partido
M. Estigarribia
minuto 90'
Sale del partido
A. Le Tallec
minuto 90'
Entra en el partido
T. Helstad
minuto 90'
Sale del partido
Y. Gervinho
minuto 90'
0 Comentarios

No hay comentarios



  USO DE MEMORIA  
6,017,208 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.1397
Total Execution Time  0.1407
  CADENA URL  
/partido/Mans-Uc-72/Valenciennes-Afc/2009
  GET DATOS  
$_GET['/partido/Mans-Uc-72/Valenciennes-Afc/2009']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0039  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 151
0.0020  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '68054' and rp.type = 2009 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 = 68054 AND year = 2009 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 68054 AND year = 2009 AND channel = 'Footters' LIMIT 1
0.0018  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='68054' AND `active` = 1 AND year = 2009
0.0056  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='151' AND relp.team_id=6758 WHERE relp.in_squad=1 and mp.`match_id` = '68054' AND mp.year='2009' ORDER BY mp.`team` ASC, p.`role` ASC
0.0046  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='151' AND relp.team_id=6752 WHERE relp.in_squad=1 and mp.`match_id` = '68054' AND mp.year='2009' ORDER BY mp.`team` ASC, p.`role` ASC
0.0023  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=68054 AND extraId = 151 AND type_rel = 4
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=16 AND type_rel = 3
0.0408  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 16 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 (1312894,1312768,1312690,1312688,1312580) ORDER BY n.cover_points DESC, update_date DESC
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 68054 AND league_id = 151 AND year = 2009