4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
14 jugadores
Valencia Valencia
Santiago Cañizares Santiago Cañizares 54 años 180cm 77kg POR
M. Pellegrino M. Pellegrino 52 años 193cm 83kg DEF
Gerardo Gerardo 49 años 172cm 69kg DEF
Raúl Albiol Raúl Albiol 38 años 190cm 82kg DEF
Miroslav Djukic Miroslav Djukic 58 años 177cm 75kg DEF
Amedeo Carboni Amedeo Carboni 59 años 180cm 76kg DEF
R. Baraja R. Baraja 48 años 180cm 75kg MED
Didier Deschamps Didier Deschamps 55 años 174cm 71kg MED
Parri Parri 42 años 174cm 71kg MED
Kily González Kily González 49 años 175cm 71kg MED
Milla Milla 58 años 173cm 69kg MED
Elías González Elías González 44 años MED
Juan Sánchez Juan Sánchez 51 años 173cm 70kg DEL
Castillo Castillo 48 años 172cm 68kg DEL
17 jugadores
Parma Parma
Davide Micillo Davide Micillo 53 años 190cm 85kg POR
Matteo Guardalben Matteo Guardalben 49 años 188cm 83kg POR
Luigi Sartor Luigi Sartor 49 años 185cm 77kg DEF
F. Cannavaro F. Cannavaro 50 años 176cm 75kg DEF
L. Thuram L. Thuram 52 años 185cm 77kg DEF
Stefano Torrisi Stefano Torrisi 52 años 185cm 71kg DEF
Giampiero Maini Giampiero Maini 52 años 179cm 69kg MED
Sérgio Conceição Sérgio Conceição 49 años 176cm 77kg MED
J. Montaño J. Montaño 41 años 175cm 85kg MED
Diego Fuser Diego Fuser 55 años 183cm 77kg MED
Johan Micoud Johan Micoud 50 años 188cm 77kg MED
S. Lamouchi S. Lamouchi 52 años 175cm 72kg MED
P. Strada P. Strada 54 años 175cm 67kg MED
Dino Baggio Dino Baggio 52 años 188cm 72kg MED
Amoroso Amoroso 49 años 180cm 76kg DEL
Patrick M'boma Patrick M'boma 53 años 185cm 85kg DEL
M. Di Vaio M. Di Vaio 47 años 179cm 78kg DEL

Equipos de esta liga

4

  USO DE MEMORIA  
4,304,048 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0024
Controller Execution Time ( Home / Category )  0.0578
Total Execution Time  0.0603
  CADENA URL  
/partidos_amistosos2001/grupo1/jugadores
  GET DATOS  
$_GET['/partidos_amistosos2001/grupo1/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0018  SELECT type FROM routes WHERE alias = 'partidos_amistosos2001'
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'partidos_amistosos' AND (l.group_code = 1 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=1 DESC LIMIT 1
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=153 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 = 44816 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 44816 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0034  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 = 44816 AND dt.id IN (712,2647,2563,1927) ORDER BY dt.relations DESC,dp.role ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 21:15:48' 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-04-27 21:15:48' 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-04-27 21:15:48' 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-04-27 21:15:48' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'partidos_amistosos' 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.0020  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 153 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 (44816) 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.0020  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 153 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 (44816) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0020  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 153 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 (44816) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10