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 18 España Sub 18
Arriaga Arriaga 81 años POR
Rodri Rodri 81 años 177cm 76kg POR
Campos Campos DEF
Elcoro Elcoro DEF
Martínez Jayo Martínez Jayo 81 años 174cm 74kg DEF
Gallego Gallego 80 años 177cm 75kg DEF
Oliveros Oliveros 82 años 165cm 67kg MED
Montesinos Montesinos 67 años 172cm 65kg MED
Guedes Guedes 28 años MED
Urtiaga Urtiaga 81 años 183cm 82kg DEL
Noverges Noverges 81 años DEL
Amas Amas 80 años 169cm 68kg DEL
Erviti Erviti 81 años 177cm 76kg DEL
Jesús Jesús 79 años DEL
Cabello Cabello 81 años 171cm 72kg DEL
Iznata Iznata 75 años 175cm 68kg DEL
10 jugadores
Portugal Sub 18 Portugal Sub 18
Rui Rui 81 años POR
Nogueira Nogueira 81 años DEF
Oliveira Duarte Oliveira Duarte 81 años DEF
Moreira Moreira 80 años DEF
Carriço Carriço 79 años MED
Crispim Crispim 81 años MED
Fernando Peres Fernando Peres 77 años MED
Jorge Jorge 81 años MED
António Simões António Simões 80 años DEL
Serafim Serafim 80 años DEL
12 jugadores
Inglaterra Sub 18 Inglaterra
John Jackson John Jackson 58 años POR
B. Robinson B. Robinson DEF
E. Brookes E. Brookes DEF
David Bickles David Bickles 80 años DEF
Jones Jones DEF
Gates Gates DEF
Hasen Hasen MED
Eric Redrobe Eric Redrobe 79 años MED
David Metchick David Metchick 80 años MED
Ray Bloomfield Ray Bloomfield 79 años MED
Colin Shaw Colin Shaw 80 años DEL
F. Lee F. Lee 79 años DEL
11 jugadores
Turquia Sub 18 Turquia Sub 18
Urul Urul 82 años POR
Doğru Doğru DEF
Gürsu Gürsu DEF
N. Doğan N. Doğan 81 años MED
Ünsal Ünsal MED
Doğan Tepeçalı Doğan Tepeçalı 77 años MED
A. Çevrim A. Çevrim 82 años MED
Tuncay Becedek Tuncay Becedek 81 años 173cm 68kg MED
Nuri Toygun Nuri Toygun MED
Güneş Güneş DEL
Bilge Tarhan Bilge Tarhan 83 años 172cm DEL
1 jugadores
Austria Sub 18 Austria Sub 18
Gunther Kaltenbrunner Gunther Kaltenbrunner 80 años DEL
11 jugadores
RD Alemania Sub 18 Alemania
Sepp Maier Sepp Maier 80 años POR
Germann Germann DEF
B. Patzke B. Patzke 81 años DEF
Hensel Hensel DEF
Grieben Grieben MED
Rainer Waberski Rainer Waberski 80 años MED
Heinz-Rüdiger Voß Heinz-Rüdiger Voß 79 años MED
C. Vogler C. Vogler 81 años MED
Horst Wild Horst Wild 80 años MED
W. Overath W. Overath 80 años MED
Gerhard Elfert Gerhard Elfert 81 años MED

  USO DE MEMORIA  
4,495,264 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0026
Controller Execution Time ( Home / Category )  0.3189
Total Execution Time  0.3215
  CADENA URL  
/amistosos_selecciones_sub181961/grupo1/jugadores
  GET DATOS  
$_GET['/amistosos_selecciones_sub181961/grupo1/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0128  SELECT type FROM routes WHERE alias = 'amistosos_selecciones_sub181961'
0.0261  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 = 1961 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0133  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 = 58817 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0131  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 58817 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0155  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 = 58817 AND dt.id IN (100563,64379,64461,101249,62983,138053) ORDER BY dt.relations DESC,dp.role ASC
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 04:21:22' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 04:21:22' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0124  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 04:21:22' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 04:21:22' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  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 = 1961 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0126  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1990 AND l.year = 1961
0.0126  SELECT e.action, count(e.action) as total, e.player_id FROM events1961 e WHERE e.league_id IN (58817) 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.0129  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 (58817) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (255013,976976,255007,273681,255122,255271,382786,422006,519859,674135) ORDER BY rp.in_squad = 1 DESC
0.0126  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1990 AND l.year = 1961
0.0129  SELECT e.action, count(e.action) as total, e.player_id FROM events1961 e WHERE e.league_id IN (58817) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0129  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1990 AND l.year = 1961
0.0126  SELECT e.action, count(e.action) as total, e.player_id FROM events1961 e WHERE e.league_id IN (58817) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10