4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
16 jugadores
Olympique Lyonnais Olympique
R. Vercoutre R. Vercoutre 43 años 185cm 78kg POR
G. Coupet G. Coupet 51 años 181cm 80kg POR
Cris Cris 46 años 183cm 77kg DEF
L. Diatta L. Diatta 48 años 183cm 76kg DEF
C. Caçapa C. Caçapa 47 años 184cm 77kg DEF
Jérémy Berthod Jérémy Berthod 40 años 180cm 75kg DEF
S. Monsoreau S. Monsoreau 43 años 186cm 80kg DEF
F. Malouda F. Malouda 43 años 181cm 73kg MED
H. Ben Arfa H. Ben Arfa 37 años 178cm 65kg MED
B. Pedretti B. Pedretti 43 años 178cm 71kg MED
M. Diarra M. Diarra 42 años 182cm 80kg MED
J. Clement J. Clement 39 años 174cm 61kg MED
P. Frau P. Frau 44 años 175cm 73kg DEL
J. Carew J. Carew 44 años 195cm 89kg DEL
Nilmar Nilmar 39 años 180cm 73kg DEL
S. Govou S. Govou 44 años 175cm 70kg DEL
16 jugadores
Auxerre Auxerre
Baptiste Chabert Baptiste Chabert 41 años 184cm 78kg POR
Fabien Cool Fabien Cool 51 años 186cm POR
B. Sagna B. Sagna 41 años 176cm 72kg DEF
J. Mignot J. Mignot 43 años 183cm 75kg DEF
B. Martin B. Martin 38 años 185cm 73kg DEF
Johan Radet Johan Radet 47 años DEF
R. Bolf R. Bolf 50 años 187cm 86kg DEF
Jean-Sébastien Jaurès Jean-Sébastien Jaurès 46 años 176cm 76kg DEF
L. Mathis L. Mathis 42 años 174cm 70kg MED
P. Violeau P. Violeau 53 años MED
B. Cheyrou B. Cheyrou 43 años 182cm 78kg MED
T. Kahlenberg T. Kahlenberg 41 años 183cm 72kg MED
R. Poyet R. Poyet 43 años 184cm 76kg DEL
K. Lejeune K. Lejeune 39 años 181cm 76kg DEL
L. Pieroni L. Pieroni 43 años 180cm 85kg DEL
K. Akalé K. Akalé 43 años DEL

Equipos de esta liga

2

  USO DE MEMORIA  
4,360,400 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.3803
Total Execution Time  0.3823
  CADENA URL  
/supercopa_francia2006/grupo0/jugadores
  GET DATOS  
$_GET['/supercopa_francia2006/grupo0/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (21)  
0.0128  SELECT type FROM routes WHERE alias = 'supercopa_francia2006'
0.0263  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'supercopa_francia' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2006 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0130  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=297 AND type_rel = 3
0.0139  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 297 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0134  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 (1091309,1296174,1296082,1294842,1273667) ORDER BY n.cover_points DESC, update_date DESC
0.0133  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 297 GROUP BY l.categoryId
0.0135  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=297 GROUP BY l.year ORDER BY l.year DESC
0.0135  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 20553 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0136  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 20553 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0154  SELECT dp.nick,dp.alias,dp.role,p.id,p.teamId,dp.height,dp.weight,p.team_id,p.player_id,p.squadNumber,dp.CountryCode,dp.age FROM rel_players p INNER JOIN dataplayers dp ON dp.id = p.player_id INNER JOIN datateams dt ON dt.id = p.teamId WHERE p.league_id = 20553 AND dt.id IN (1866,399) ORDER BY dt.relations DESC,dp.role ASC
0.0130  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-05 03:37:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-05 03:37:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-05 03:37:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0127  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-05 03:37:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0134  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 297 AND l.year = 2006
0.0129  SELECT e.action, count(e.action) as total, e.player_id FROM events2006 e WHERE e.league_id IN (20553) AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0131  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (20553) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (512,3250,21368) ORDER BY rp.in_squad = 1 DESC
0.0136  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 297 AND l.year = 2006
0.0127  SELECT e.action, count(e.action) as total, e.player_id FROM events2006 e WHERE e.league_id IN (20553) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0133  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 297 AND l.year = 2006
0.0130  SELECT e.action, count(e.action) as total, e.player_id FROM events2006 e WHERE e.league_id IN (20553) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10