4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
17 jugadores
España Sub 18 España Sub 18
Corral Corral 68 años 180cm 78kg POR
Llopico Llopico 68 años POR
Padrón Padrón DEF
Marcelino Marcelino 68 años 171cm 68kg DEF
Pulido Pulido 56 años 175cm 73kg DEF
San José San José 68 años 176cm 69kg DEF
Urbanos Urbanos 54 años 176cm 71kg DEF
Cruz Cruz DEF
Fraguas Fraguas 67 años DEF
Juani Juani 68 años MED
Vitoria Vitoria 54 años 172cm 73kg MED
Angelín Angelín 67 años MED
Gallego Gallego 68 años MED
Tino Tino MED
Rebollo Rebollo 68 años 175cm 72kg DEL
Martín Roales Martín Roales 68 años DEL
Mompeán Mompeán 66 años DEL
14 jugadores
Portugal Sub 18 Portugal Sub 18
Walter Walter 68 años POR
E. Gomes E. Gomes 68 años DEF
Roque Roque 50 años DEF
Tavares Tavares 50 años DEF
Ricardo Formosinho Ricardo Formosinho 67 años MED
Dinis Dinis 68 años MED
Lito Lito 67 años MED
Barrinha Barrinha 68 años MED
Fernando Martins Fernando Martins 50 años MED
Pinto Pinto 49 años MED
Isidro Isidro 68 años MED
Mamadu Seidi Mamadu Seidi 68 años DEL
Libanio Libanio 67 años DEL
F. Gomes F. Gomes 66 años DEL
16 jugadores
Italia Sub 18 Italia Sub 18
Alessandro Saccardi Alessandro Saccardi POR
Filippo Citterio Filippo Citterio 68 años 188cm 70kg DEF
Roberto Catterina Roberto Catterina 67 años DEF
Fabiano Brambilla Fabiano Brambilla 67 años DEF
Berni Berni DEF
Giuliano Vincenzi Giuliano Vincenzi 74 años DEF
Roberto Galbiati Roberto Galbiati 66 años 176cm 72kg MED
Bertocchi Bertocchi MED
Roberto Biasotti Roberto Biasotti 67 años MED
Ceccato Ceccato MED
Roberto Cesati Roberto Cesati 67 años 175cm MED
Ettore Donati Ettore Donati 68 años MED
Alessandro Zagano Alessandro Zagano 68 años 178cm 73kg MED
Sambucco Sambucco DEL
P. Rossi P. Rossi 64 años DEL
Salvatore Garritano Salvatore Garritano 68 años DEL
13 jugadores
Suecia Sub 18 Suecia Sub 18
Kjell Spangberg Kjell Spangberg POR
B. Andersson B. Andersson 72 años 177cm DEF
Christian Pestat Christian Pestat DEF
Ronny Gyllix Ronny Gyllix DEF
Goran Peterson Goran Peterson MED
Per-Gosta Nordahl Per-Gosta Nordahl MED
Soren Borjesson Soren Borjesson 68 años MED
Ola Rydstrand Ola Rydstrand 68 años 182cm 74kg MED
Roger Gustafsson Roger Gustafsson 72 años MED
Glenn Holm Glenn Holm 68 años MED
Peter Dahlqvist Peter Dahlqvist 68 años MED
Tommy Hansson Tommy Hansson 67 años MED
Stellan Nilsson Stellan Nilsson DEL
1 jugadores
Grecia Sub 18 Grecia Sub 18
C. Ardizoglou C. Ardizoglou 71 años DEL

  USO DE MEMORIA  
4,503,176 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3837
Total Execution Time  0.3857
  CADENA URL  
/amistosos_selecciones_sub181974/grupo1/jugadores
  GET DATOS  
$_GET['/amistosos_selecciones_sub181974/grupo1/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.0144  SELECT type FROM routes WHERE alias = 'amistosos_selecciones_sub181974'
0.0298  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 = 1974 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0148  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1990 ORDER BY order_id ASC
0.0153  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 = 58718 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0151  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 58718 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0176  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 = 58718 AND dt.id IN (100563,64379,6334,66257,101500) ORDER BY dt.relations DESC,dp.role ASC
0.0149  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-05 03:06:55' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0150  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-05 03:06:55' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0144  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-05 03:06:55' 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-05 03:06:55' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0150  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 = 1974 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0146  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1990 AND l.year = 1974
0.0149  SELECT e.action, count(e.action) as total, e.player_id FROM events1974 e WHERE e.league_id IN (58718) 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.0155  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 (58718) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (256039,256057,261221,372686,389916,771319) ORDER BY rp.in_squad = 1 DESC
0.0156  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1990 AND l.year = 1974
0.0152  SELECT e.action, count(e.action) as total, e.player_id FROM events1974 e WHERE e.league_id IN (58718) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0146  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1990 AND l.year = 1974
0.0145  SELECT e.action, count(e.action) as total, e.player_id FROM events1974 e WHERE e.league_id IN (58718) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10