4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2008
Temporada Siguiente »
Publicidad 600x120.gif
Copa de la Liga 2008
2007/2008

Copa de la Liga 2008

Resultados
« Jornada Anterior
Final
 
 
29 Mar 08
20:00 Finalizado 		PSG PSG 2-1 Lens Lens más información Jugadas destacadas ...
19' Pauleta 1-0
1-1 51' Eric Carrière
90' B. Mendy 2-1
JUGADORES DESTACADOS
RK Nombre Goles Posición Equipo
1 Pauleta pt Pauleta 6 DEL PSG PSG
2 Riviere fr Riviere 5 MED Niort Niort
3 T. Maoulida fr T. Maoulida 3 DEL Lens Lens
4 Y. Gervinho ci Y. Gervinho 3 DEL Le Mans Le Mans
5 Olivier Bogaczyk fr Olivier Bogaczyk 3 MED Sète Sète
6 B. Mendy fr B. Mendy 2 DEF PSG PSG
7 Eric Carrière fr Eric Carrière 2 MED Lens Lens
8 D. Matsui jp D. Matsui 2 MED Le Mans Le Mans
9 Tulio De Melo br Tulio De Melo 2 DEL Le Mans Le Mans
10 A. Diané ci A. Diané 2 DEL PSG PSG
11 E. Grandin fr E. Grandin 2 MED Caen Caen
12 J. Job cm J. Job 2 DEL CS Sedan CS Sedan
13 D. Oliech ke D. Oliech 2 DEL Auxerre Auxerre
14 V. Montaño co V. Montaño 2 DEL Montpellier Montpellier
15 Nikola Nikezić me Nikola Nikezić 2 DEL Le Havre Le Havre
16 D. N'gog fr D. N'gog 2 DEL PSG PSG
17 Nenê br Nenê 2 MED Monaco Monaco
18 B. Pedretti fr B. Pedretti 2 MED Auxerre Auxerre
19 C. Diers fr C. Diers 2 MED Clermont Clermont
20 T. Vauvy fr T. Vauvy 2 DEL Stade Lavallois Stade Lavallois

INFORMACIÓN

La Copa de la Liga (en francés y oficialmente: Coupe de la Ligue) es un torneo futbolístico por eliminación directa que se disputa anualmente entre clubes de Francia. A diferencia de la Copa de Francia, sólo toman parte los clubes profesionales del país y, también a diferencia de ese torneo (organizado por la Federación Francesa de Fútbol), la Coupe de Ligue está organizada por la LFP.

  USO DE MEMORIA  
4,784,640 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0030
Controller Execution Time ( Home / Category )  0.6399
Total Execution Time  0.6430
  CADENA URL  
/copa_de_la_liga2008
  GET DATOS  
$_GET['/copa_de_la_liga2008']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0106  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=324 AND type_rel = 3
0.0109  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 324 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0108  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 (982991,960725,952938,868602,868239) ORDER BY n.cover_points DESC, update_date DESC
0.0107  SELECT c.id, c.name, c.alias, l.id AS league_id, l.year, l.group_code, l.total_group, c.id AS categoryId, c.stepParent FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND c.active_year=l.year WHERE c.id=16 ORDER BY l.group_code ASC
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 11:06:28' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 11:06:28' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0107  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 11:06:28' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0107  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 11:06:28' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0120  SELECT c.isVideo, c.id,c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2,c.betId,c.betId_wh,c.betId_bwin,c.betId_marca,c.betId_888, c.betId_sportium, c.betId_marathon, c.finished, c.penaltis1, c.penaltis2, c.prorroga, c.status, c.minute, dt1.stadium as stadium_name FROM `calendars2008` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 20540 AND c.`round` = 7 ORDER BY c.type ASC,((c.team1*c.team1)+(c.team2*c.team2)) ASC,shedule ASC LIMIT 200
0.0121  SELECT ev.match_id,dp.alias,ev.minute,ev.action,ev.player_id,e.name,e.classf,dp.nick,rel.squadNumber,rel.player_id as playerId,rel.team_id,rel.teamId FROM events2008 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars2008 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 20540 AND (ev.team1id=rel.team_id OR ev.team2id=rel.team_id) INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE ev.match_id IN (94276) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0110  SELECT data1, data2 FROM services_tags WHERE categoryId=324
0.0116  SELECT group_code, extraName from `leagues` WHERE categoryId=324 AND year=2008