4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
31 jugadores
España Sub 18 España Sub 18
Arévalo Arévalo 71 años POR
Urruti Urruti 49 años 182cm 80kg POR
Sánchez Sánchez 72 años 179cm 74kg POR
Campa Campa POR
Barrera Barrera 72 años DEF
Gisasola Gisasola 71 años 180cm 78kg DEF
Ávila Ávila 71 años 170cm 70kg DEF
Tanco Tanco 71 años 182cm 79kg DEF
Espinal Espinal DEF
Juan Carrasco Juan Carrasco 72 años DEF
Borja Borja DEF
Uceda Uceda 72 años 182cm 74kg DEF
Ávalos Ávalos 72 años DEF
Juan Ballester Juan Ballester DEF
Martínez Martínez 72 años MED
Solsona Solsona 72 años 169cm 67kg MED
Ortega Ortega 72 años 174cm 74kg MED
Planas Planas 72 años MED
Jódar Jódar MED
M. Gual M. Gual MED
Leal Leal 70 años MED
Sebas Sebas 71 años 178cm 68kg MED
Zuluaga Zuluaga 71 años MED
Salazar Salazar 72 años DEL
Juanito Juanito 37 años 169cm 70kg DEL
Gallardo Gallardo DEL
Mori Mori 72 años 176cm 74kg DEL
Porteros Porteros 72 años DEL
Alvarito Alvarito 72 años 170cm 72kg DEL
C. Santillana C. Santillana 71 años 175cm 74kg DEL
José Arteche José Arteche DEL
14 jugadores
Portugal Sub 18 Portugal Sub 18
Matos Matos 68 años POR
Raúl Raúl 70 años DEF
A. Lima Pereira A. Lima Pereira 69 años DEF
César César 71 años DEF
Laranjeira Laranjeira 72 años DEF
João Cardoso João Cardoso 72 años DEF
José Lino José Lino 73 años MED
Palhares Palhares 69 años MED
Fernando Barbosa Fernando Barbosa 70 años 173cm 64kg MED
Duarte Duarte MED
Vítor Oliveira Vítor Oliveira 70 años MED
Samuel Fraguito Samuel Fraguito 72 años 172cm 70kg MED
Vivas Vivas 68 años MED
Faria Faria DEL
12 jugadores
Francia Sub 18 Francia Sub 18
J. Bertrand-Demanes J. Bertrand-Demanes 71 años 192cm 83kg POR
Bernard Gardon Bernard Gardon 72 años 180cm 78kg DEF
Alain Hopquin Alain Hopquin 72 años 180cm 78kg DEF
Becker Becker 72 años 177cm MED
Pierre Neubert Pierre Neubert 71 años 180cm 74kg MED
J. Santini J. Santini 72 años MED
Gilbert Carrié Gilbert Carrié 71 años 173cm 72kg MED
Claude Arribas Claude Arribas 72 años 180cm 72kg MED
Bernard Boissier Bernard Boissier 71 años MED
Antoine Gianquinto Antoine Gianquinto 72 años 175cm 73kg MED
Hervé Gauthier Hervé Gauthier 74 años 175cm 72kg MED
Jean-Marc Giachetti Jean-Marc Giachetti 71 años 175cm 70kg MED

  USO DE MEMORIA  
4,477,832 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.0680
Total Execution Time  0.0701
  CADENA URL  
/amistosos_selecciones_sub181970/grupo1/jugadores
  GET DATOS  
$_GET['/amistosos_selecciones_sub181970/grupo1/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (21)  
0.0017  SELECT type FROM routes WHERE alias = 'amistosos_selecciones_sub181970'
0.0039  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'amistosos_selecciones_sub18' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1970 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=1990 AND type_rel = 3
0.0019  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1990 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0021  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 (1201248,1200785,1186209,1091815,1067523) ORDER BY n.cover_points DESC, update_date DESC
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1990 ORDER BY order_id ASC
0.0019  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 = 58751 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 = 58751 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 = 58751 AND dt.id IN (100563,64379,106119) 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-04-28 01:53:20' 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=2 AND last_update > '2024-04-28 01:53:20' 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-28 01:53:20' 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 01:53:20' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'amistosos_selecciones_sub18' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1970 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0018  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1990 AND l.year = 1970
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events1970 e WHERE e.league_id IN (58751) 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 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 (58751) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (974573,256048,421668,440830,440920,440488,441109,957536) ORDER BY rp.in_squad = 1 DESC
0.0019  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1990 AND l.year = 1970
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events1970 e WHERE e.league_id IN (58751) 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 l.id FROM leagues_webci l WHERE l.categoryId = 1990 AND l.year = 1970
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events1970 e WHERE e.league_id IN (58751) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10