4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
16 jugadores
España Sub 20 España Sub 20
Agustín Agustín 64 años 192cm 84kg POR
A. Cedrún A. Cedrún 63 años 198cm 97kg POR
Manolo Manolo 63 años 180cm 75kg DEF
Ondina Ondina 63 años 175cm 80kg DEF
Juanito Juanito 62 años 172cm 67kg DEF
Diego Diego 64 años 183cm 76kg DEF
Serafín Serafín 64 años DEF
Carreras Carreras 64 años DEF
Pardo Pardo 64 años DEF
Merayo Merayo 63 años MED
Pedro Pablo Pedro Pablo 63 años 171cm 66kg MED
Julio Prieto Julio Prieto 63 años MED
Lumbreras Lumbreras 63 años 177cm 74kg MED
Gregory Gregory 64 años 176cm 76kg MED
Víctor Víctor 64 años 177cm 75kg DEL
Luque Luque 63 años 164cm 60kg DEL
13 jugadores
Países Bajos Sub 20 Países Bajos
H. Van Breukelen H. Van Breukelen 67 años POR
Evert Bleuming Evert Bleuming 64 años DEF
S. Troost S. Troost 64 años DEF
Robert Verbeek Robert Verbeek 62 años DEF
Ronald Weijsters Ronald Weijsters 64 años DEF
John Scheve John Scheve 64 años DEF
Michel Valke Michel Valke 64 años MED
Martin Jol Martin Jol 68 años MED
Wim Balm Wim Balm 64 años MED
Ton Lokhoff Ton Lokhoff 64 años MED
Ruud Kaiser Ruud Kaiser 63 años DEL
Willy Carbo Willy Carbo 64 años DEL
Ronald Lengkeek Ronald Lengkeek 63 años 85kg DEL

Equipos de esta liga

2

  USO DE MEMORIA  
4,317,712 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0028
Controller Execution Time ( Home / Category )  0.0716
Total Execution Time  0.0745
  CADENA URL  
/amistosos_selecciones_sub201980/grupo1/jugadores
  GET DATOS  
$_GET['/amistosos_selecciones_sub201980/grupo1/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0018  SELECT type FROM routes WHERE alias = 'amistosos_selecciones_sub201980'
0.0041  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'amistosos_selecciones_sub20' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1980 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1988 AND type_rel = 3
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1988 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0022  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 (1253756,1253747,1253234,1252467,1252219) ORDER BY n.cover_points DESC, update_date DESC
0.0020  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 1988 GROUP BY l.categoryId
0.0024  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=1988 GROUP BY l.year ORDER BY l.year DESC
0.0022  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 = 57102 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 57102 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0030  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 = 57102 AND dt.id IN (6040,63595) 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-28 08:04:59' 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-28 08:04:59' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 08:04:59' 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-28 08:04:59' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0025  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'amistosos_selecciones_sub20' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1980 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0023  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1988 AND l.year = 1980
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events1980 e WHERE e.league_id IN (57102) 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.0022  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 (57102) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (397065,495795) ORDER BY rp.in_squad = 1 DESC
0.0021  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1988 AND l.year = 1980
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events1980 e WHERE e.league_id IN (57102) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0022  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1988 AND l.year = 1980
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events1980 e WHERE e.league_id IN (57102) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10