4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
20 jugadores
Italia Sub 21 Italia Sub 21
Michelangelo Rampulla Michelangelo Rampulla 61 años 181cm 74kg POR
Ubaldo Righetti Ubaldo Righetti 61 años DEF
R. Ferri R. Ferri 60 años 181cm 77kg DEF
G. Bergomi G. Bergomi 60 años 183cm 82kg DEF
Dario Bonetti Dario Bonetti 62 años 187cm DEF
Sergio Battistini Sergio Battistini 60 años DEF
Nicola Caricola Nicola Caricola 61 años 180cm DEF
Giuseppe Dossena Giuseppe Dossena 65 años MED
Alberico Evani Alberico Evani 61 años 174cm 63kg MED
Roberto Galia Roberto Galia 61 años MED
Andrea Icardi Andrea Icardi 60 años 171cm 67kg MED
B. Vignola B. Vignola 64 años MED
Massimo Mauro Massimo Mauro 61 años MED
Massimo Bonini Massimo Bonini 64 años MED
Claudio Valigi Claudio Valigi 62 años 178cm 72kg MED
Paolo Monelli Paolo Monelli 61 años 183cm 77kg DEL
Giuseppe Galderisi Giuseppe Galderisi 61 años 170cm 69kg DEL
Bruno Giordano Bruno Giordano 67 años 175cm 68kg DEL
Gianluca Vialli Gianluca Vialli 58 años 180cm 77kg DEL
Roberto Mancini Roberto Mancini 59 años 179cm 78kg DEL
26 jugadores
España Sub 21 España Sub 21
A. Zubizarreta A. Zubizarreta 62 años 187cm 86kg POR
Fernando Fernando 62 años 179cm 79kg POR
Bermell Bermell 62 años 182cm 77kg POR
De La Fuente De La Fuente 62 años 172cm 73kg DEF
Salva Salva 63 años 181cm 77kg DEF
Esteban Esteban 63 años 174cm 74kg DEF
Fabregat Fabregat 62 años 175cm 73kg DEF
Francis Francis 61 años 183cm 78kg DEF
Miguel Ángel Miguel Ángel 62 años 182cm 72kg DEF
Pariente Pariente 59 años 181cm 75kg DEF
Javi Javi 61 años DEF
Chendo Chendo 62 años 175cm 73kg DEF
Serna Serna 60 años 184cm 77kg DEF
Elgezábal Elgezábal 60 años MED
Robert Robert 61 años 179cm 72kg MED
Urbano Urbano 62 años 183cm 79kg MED
Michel Michel 61 años 182cm 77kg MED
Marina Marina 62 años 164cm 63kg MED
Francisco Francisco 61 años 182cm 77kg MED
Salvador Mejías Salvador Mejías 61 años 170cm 68kg DEL
Zurdi Zurdi 61 años 170cm 65kg DEL
Ayneto Ayneto 62 años 187cm DEL
Cholo Cholo 62 años 175cm 71kg DEL
Márquez Márquez 62 años 176cm 72kg DEL
Julio Salinas Julio Salinas 61 años 188cm 80kg DEL
Eloy Eloy 59 años 167cm 65kg DEL

Equipos de esta liga

2

  USO DE MEMORIA  
4,394,032 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3128
Total Execution Time  0.3147
  CADENA URL  
/amistosos_selecciones_sub211983/grupo1/jugadores
  GET DATOS  
$_GET['/amistosos_selecciones_sub211983/grupo1/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (21)  
0.0105  SELECT type FROM routes WHERE alias = 'amistosos_selecciones_sub211983'
0.0217  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'amistosos_selecciones_sub21' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1983 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0106  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1975 AND type_rel = 3
0.0108  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1975 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0110  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 (1307533,1307508,1307361,1306837,1306579) ORDER BY n.cover_points DESC, update_date DESC
0.0107  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1975 ORDER BY order_id ASC
0.0110  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 = 57015 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0110  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 57015 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0113  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 = 57015 AND dt.id IN (6326,5621) ORDER BY dt.relations DESC,dp.role ASC
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-30 22:20:21' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-30 22:20:21' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-30 22:20:21' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-30 22:20:21' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0112  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'amistosos_selecciones_sub21' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1983 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0107  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1975 AND l.year = 1983
0.0106  SELECT e.action, count(e.action) as total, e.player_id FROM events1983 e WHERE e.league_id IN (57015) 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.0108  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 (57015) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (252425,256621,264966,265366,370258,403065) ORDER BY rp.in_squad = 1 DESC
0.0111  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1975 AND l.year = 1983
0.0107  SELECT e.action, count(e.action) as total, e.player_id FROM events1983 e WHERE e.league_id IN (57015) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0108  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1975 AND l.year = 1983
0.0106  SELECT e.action, count(e.action) as total, e.player_id FROM events1983 e WHERE e.league_id IN (57015) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10