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
G. Coupet G. Coupet 51 años 181cm 80kg POR
N. Puydebois N. Puydebois 43 años POR
J. Bréchet J. Bréchet 44 años 187cm 77kg DEF
C. Caçapa C. Caçapa 47 años 184cm 77kg DEF
P. Muller P. Muller 47 años 180cm 64kg DEF
J. Chanelet J. Chanelet 55 años DEF
Florent Laville Florent Laville 50 años 188cm 88kg DEF
P. Violeau P. Violeau 53 años MED
Eric Carrière Eric Carrière 50 años 173cm 64kg MED
V. Dhorasoo V. Dhorasoo 50 años 168cm 58kg MED
M. Diarra M. Diarra 42 años 182cm 80kg MED
Juninho Juninho 49 años 179cm 74kg MED
S. Govou S. Govou 44 años 175cm 70kg DEL
Tony Vairelles Tony Vairelles 51 años DEL
P. Luyindula P. Luyindula 44 años 178cm 74kg DEL
Sonny Anderson Sonny Anderson 53 años 181cm 72kg DEL
16 jugadores
Lorient Lorient
Stéphane Le Garrec Stéphane Le Garrec 55 años POR
Fabien Garnier Fabien Garnier 42 años POR
M. Boutruche M. Boutruche 47 años DEF
Christophe Ferron Christophe Ferron 53 años DEF
Yohan Bouzin Yohan Bouzin 49 años DEF
Loïc Druon Loïc Druon 52 años DEF
Pape Diop Pape Diop 49 años DEF
Antony Gauvin Antony Gauvin 50 años DEF
Tchiressoua Guel Tchiressoua Guel 48 años MED
Pascal Bedrossian Pascal Bedrossian 49 años MED
Richard Martini Richard Martini 45 años MED
Sylvain Ripoll Sylvain Ripoll 52 años MED
Samassi Abou Samassi Abou 51 años 185cm 80kg DEL
P. Loko P. Loko 54 años DEL
Nicolas Esceth-Nzi Nicolas Esceth-Nzi 46 años DEL
Élie Kroupi Élie Kroupi 44 años DEL

Equipos de esta liga

3

  USO DE MEMORIA  
4,362,504 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0589
Total Execution Time  0.0609
  CADENA URL  
/supercopa_francia2003/grupo0/jugadores
  GET DATOS  
$_GET['/supercopa_francia2003/grupo0/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0017  SELECT type FROM routes WHERE alias = 'supercopa_francia2003'
0.0040  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 = 2003 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0019  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 = 25443 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0018  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 25443 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0032  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 = 25443 AND dt.id IN (1866,399,1586) ORDER BY dt.relations DESC,dp.role ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-05 01:04:55' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-05 01:04:55' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-05 01:04:55' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-05 01:04:55' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 297 AND l.year = 2003
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events2003 e WHERE e.league_id IN (25443) 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.0021  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 (25443) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (3361,1036,21313,325753) ORDER BY rp.in_squad = 1 DESC
0.0023  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 297 AND l.year = 2003
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events2003 e WHERE e.league_id IN (25443) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0019  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 (25443) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (405005,432929) ORDER BY rp.in_squad = 1 DESC
0.0021  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 297 AND l.year = 2003
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events2003 e WHERE e.league_id IN (25443) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10