4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
17 jugadores
Barcelona Barcelona
Richard Dutruel Richard Dutruel 51 años 192cm 86kg POR
M. Reiziger M. Reiziger 51 años 178cm 71kg DEF
C. Puyol C. Puyol 46 años 178cm 80kg DEF
Sergi Sergi 52 años 173cm 64kg DEF
Frank De Boer Frank De Boer 53 años 179cm 79kg DEF
Pep Guardiola Pep Guardiola 53 años 180cm 76kg MED
Gerard Gerard 45 años 180cm 70kg MED
Simão Simão 44 años 173cm 64kg MED
Xavi Xavi 44 años 170cm 68kg MED
P. Cocu P. Cocu 53 años 183cm 70kg MED
E. Petit E. Petit 53 años 185cm 70kg MED
B. Zenden B. Zenden 47 años 174cm 70kg MED
Rivaldo Rivaldo 52 años 186cm 83kg DEL
Dani Dani 49 años 183cm 73kg DEL
Marc Overmars Marc Overmars 51 años 174cm 71kg DEL
Alfonso Alfonso 51 años 178cm 64kg DEL
P. Kluivert P. Kluivert 47 años 188cm 77kg DEL
17 jugadores
PSV PSV
R. Waterreus R. Waterreus 53 años POR
I. Kralj I. Kralj 51 años POR
W. Bouma W. Bouma 45 años 180cm 82kg DEF
C. Van Der Weerden C. Van Der Weerden 51 años DEF
K. Hofland K. Hofland 44 años 185cm 73kg DEF
Jürgen Dirkx Jürgen Dirkx 48 años 183cm DEF
A. Ooijer A. Ooijer 49 años 185cm 74kg DEF
M. Van Bommel M. Van Bommel 47 años 187cm 85kg MED
A. Bruggink A. Bruggink 46 años 184cm 81kg MED
T. Iwan T. Iwan 52 años MED
Robert Fuchs Robert Fuchs 49 años 170cm 64kg MED
J. Vogel J. Vogel 47 años 178cm 70kg MED
J. Kolkka J. Kolkka 49 años 175cm 70kg MED
D. Rommedahl D. Rommedahl 45 años 178cm 73kg MED
B. Van Der Doelen B. Van Der Doelen 47 años 178cm 70kg MED
T. Lucius T. Lucius 47 años 182cm 76kg MED
Cláudio Tauá Cláudio Tauá 45 años DEL

Equipos de esta liga

2

  USO DE MEMORIA  
4,320,480 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0599
Total Execution Time  0.0619
  CADENA URL  
/trofeo-joan-gamper2001/grupo0/jugadores
  GET DATOS  
$_GET['/trofeo-joan-gamper2001/grupo0/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0018  SELECT type FROM routes WHERE alias = 'trofeo-joan-gamper2001'
0.0038  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'trofeo-joan-gamper' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2001 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2824 AND type_rel = 3
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=2824 ORDER BY order_id ASC
0.0020  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 = 72404 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 = 72404 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0025  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 = 72404 AND dt.id IN (429,2023) 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-08 19:16:22' 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-08 19:16:22' 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-08 19:16:22' 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-08 19:16:22' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 2824 AND l.year = 2001
0.0020  SELECT e.action, count(e.action) as total, e.player_id FROM events2001 e WHERE e.league_id IN (72404) 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 (72404) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (27385,89153,372098) ORDER BY rp.in_squad = 1 DESC
0.0020  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 2824 AND l.year = 2001
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events2001 e WHERE e.league_id IN (72404) 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 (72404) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (1578,30091) ORDER BY rp.in_squad = 1 DESC
0.0021  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 2824 AND l.year = 2001
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events2001 e WHERE e.league_id IN (72404) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10