4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
26 jugadores
España Sub 17 España Sub 17
Belman Belman 52 años 182cm 82kg POR
Conde Conde 54 años 185cm 83kg POR
Cano Cano 54 años 185cm 80kg POR
Santiago Cañizares Santiago Cañizares 54 años 180cm 77kg POR
Cerdán Cerdán 54 años 177cm 73kg DEF
Ramón Ramón 54 años 176cm 75kg DEF
Ovidio Ovidio 54 años 171cm 63kg DEF
Puado Puado 54 años DEF
Goyo Goyo 54 años 176cm 74kg DEF
Tomàs Tomàs 53 años 180cm 77kg DEF
Txomin Larrainzar Txomin Larrainzar 54 años 181cm 73kg DEF
Tomy Tomy 54 años 175cm 68kg DEF
Monsalvete Monsalvete 54 años MED
Justo Justo 54 años 176cm 72kg MED
Billabona Billabona 54 años 175cm 71kg MED
Vallés Vallés 54 años MED
Ballester Ballester 54 años 175cm 70kg MED
Cornago Cornago 54 años 172cm 71kg MED
Vidal Vidal 54 años 171cm 68kg MED
Rodri Rodri 54 años MED
Morán Morán 54 años 177cm 79kg MED
Gele Gele 54 años DEL
Aguilà Aguilà 53 años 179cm 73kg DEL
Martín Criado Martín Criado 54 años DEL
Pinilla Pinilla 53 años 176cm 74kg DEL
Gamboa Gamboa 53 años 178cm 73kg DEL
14 jugadores
Francia Sub 17 Francia Sub 17
Bruno Clément Bruno Clément 54 años POR
Stéphane Mahé Stéphane Mahé 55 años DEF
Pascal Fugier Pascal Fugier 55 años DEF
Bagur Bagur DEF
Patrick Valéry Patrick Valéry 54 años 173cm 84kg DEF
Pavon Pavon 55 años 180cm 74kg MED
Christian Navarro Christian Navarro 55 años 166cm 60kg MED
Suic Suic MED
Gérard Placide Gérard Placide 55 años 180cm 72kg MED
Eric Lestrade Eric Lestrade 55 años 175cm 69kg MED
Jean-Luc Vasseur Jean-Luc Vasseur 55 años MED
Randolph Gohi Randolph Gohi 55 años 173cm MED
Sousisseau Sousisseau MED
David Zitelli David Zitelli 55 años 182cm 77kg DEL
1 jugadores
Yugoslavia Sub 17 Yugoslavia
Vladan Lukić Vladan Lukić 54 años 182cm 76kg DEL

  USO DE MEMORIA  
4,386,336 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.4219
Total Execution Time  0.4238
  CADENA URL  
/amistosos_selecciones_sub171987/grupo1/jugadores
  GET DATOS  
$_GET['/amistosos_selecciones_sub171987/grupo1/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (21)  
0.0145  SELECT type FROM routes WHERE alias = 'amistosos_selecciones_sub171987'
0.0292  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'amistosos_selecciones_sub17' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1987 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1991 AND type_rel = 3
0.0150  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1991 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0147  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 (1279115,1185480,1129476,883585,791361) ORDER BY n.cover_points DESC, update_date DESC
0.0145  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1991 ORDER BY order_id ASC
0.0145  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 = 59400 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0145  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 59400 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0149  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 = 59400 AND dt.id IN (60953,63712,138225) ORDER BY dt.relations DESC,dp.role ASC
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-03 06:45:31' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-03 06:45:31' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0148  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-03 06:45:31' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-03 06:45:31' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0152  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'amistosos_selecciones_sub17' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1987 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0149  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1991 AND l.year = 1987
0.0148  SELECT e.action, count(e.action) as total, e.player_id FROM events1987 e WHERE e.league_id IN (59400) 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.0147  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 (59400) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (258973,261067,261293,269756) ORDER BY rp.in_squad = 1 DESC
0.0146  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1991 AND l.year = 1987
0.0145  SELECT e.action, count(e.action) as total, e.player_id FROM events1987 e WHERE e.league_id IN (59400) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0148  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1991 AND l.year = 1987
0.0146  SELECT e.action, count(e.action) as total, e.player_id FROM events1987 e WHERE e.league_id IN (59400) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10