4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 1953
Temporada Siguiente »
FA Cup 1953
1952/1953

copa inglesa, copa de inglaterra, the emirates fa cup,

FA Cup 1953

11 jugadores
Bolton Wanderers Bolton Wanderers
Stan Hanson Stan Hanson 108 años POR
T. Banks T. Banks 94 años 171cm 74kg DEF
Johnny Wheeler Johnny Wheeler 95 años MED
Malcolm Barrass Malcolm Barrass 99 años MED
Eric Bell Eric Bell 94 años MED
John Ball John Ball 99 años 178cm MED
Harold Hassall Harold Hassall 95 años MED
N. Lofthouse N. Lofthouse 85 años DEL
Bobby Langton Bobby Langton 105 años DEL
Willie Moir Willie Moir 102 años DEL
Doug Holden Doug Holden 90 años DEL
11 jugadores
Blackpool Blackpool
George Farm George Farm 99 años POR
Tommy Garrett Tommy Garrett 98 años DEF
Eddie Shimwell Eddie Shimwell 104 años MED
Harry Johnston Harry Johnston 54 años MED
Cyril Robinson Cyril Robinson 95 años MED
Ewan Fenton Ewan Fenton 94 años MED
Bill Perry Bill Perry 93 años DEL
Ernie Taylor Ernie Taylor 98 años 163cm DEL
S. Matthews S. Matthews 85 años DEL
J. Mudie J. Mudie 61 años 168cm 67kg DEL
S. Mortensen S. Mortensen 69 años 174cm 74kg DEL

  USO DE MEMORIA  
4,405,424 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.2606
Total Execution Time  0.2627
  CADENA URL  
/fa_cup1953/grupo0/jugadores
  GET DATOS  
$_GET['/fa_cup1953/grupo0/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (16)  
0.0106  SELECT type FROM routes WHERE alias = 'fa_cup1953'
0.0214  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'fa_cup' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1953 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0108  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 = 14932 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0107  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 14932 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0108  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 = 14932 AND dt.id IN (263,297,526,752,1017,1633,1635,1796,1825,2438,2523,2748,9182,502,569,2429,9184,508,9187,2369,1337,436,1600,9178,1341,9211,9194,9183,9179,2813,4465,64380) ORDER BY dt.relations DESC,dp.role ASC
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 18:34:37' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 18:34:37' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 18:34:37' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 18:34:37' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0107  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 139 AND l.year = 1953
0.0105  SELECT e.action, count(e.action) as total, e.player_id FROM events1953 e WHERE e.league_id IN (14932) 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.0107  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 (14932) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (389323,383153,854597,854607,910211) ORDER BY rp.in_squad = 1 DESC
0.0108  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 139 AND l.year = 1953
0.0106  SELECT e.action, count(e.action) as total, e.player_id FROM events1953 e WHERE e.league_id IN (14932) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0108  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 139 AND l.year = 1953
0.0106  SELECT e.action, count(e.action) as total, e.player_id FROM events1953 e WHERE e.league_id IN (14932) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10