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

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

FA Cup 1957

11 jugadores
Manchester United Manchester
Ray Wood Ray Wood 92 años POR
R. Byrne R. Byrne 28 años DEF
Bill Foulkes Bill Foulkes 92 años DEF
Eddie Colman Eddie Colman 87 años DEF
Johnny Berry Johnny Berry 97 años MED
Duncan Edwards Duncan Edwards 21 años MED
Jackie Blanchflower Jackie Blanchflower 91 años 180cm 74kg MED
David Pegg David Pegg 88 años MED
Liam Whelan Liam Whelan 89 años MED
Bobby Charlton Bobby Charlton 86 años DEL
Tommy Taylor Tommy Taylor 26 años DEL
11 jugadores
Aston Villa Aston Villa
Nigel Sims Nigel Sims 86 años POR
Pat Saward Pat Saward 95 años DEF
Stan Lynn Stan Lynn 95 años 178cm DEF
Stan Crowther Stan Crowther 88 años MED
Peter Aldis Peter Aldis 97 años MED
Jimmy Dugdale Jimmy Dugdale 92 años MED
Johnny Dixon Johnny Dixon 100 años MED
Bill Myerscough Bill Myerscough 93 años 175cm DEL
Jackie Sewell Jackie Sewell 97 años DEL
Les Smith Les Smith 96 años DEL
P. Mcparland P. Mcparland 90 años DEL

  USO DE MEMORIA  
4,384,344 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0024
Controller Execution Time ( Home / Category )  0.4050
Total Execution Time  0.4074
  CADENA URL  
/fa_cup1957/grupo0/jugadores
  GET DATOS  
$_GET['/fa_cup1957/grupo0/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0145  SELECT type FROM routes WHERE alias = 'fa_cup1957'
0.0295  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 = 1957 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0149  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=139 AND type_rel = 3
0.0247  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 139 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0154  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 (1312285,1312282,1312279,1311961,1311952) ORDER BY n.cover_points DESC, update_date DESC
0.0150  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 = 14925 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0149  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 14925 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0150  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 = 14925 AND dt.id IN (263,297,1017,1635,1825,2523,2748,502,569,9184,508,1337,436,548,1694,80) 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-05 07:05:45' 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=2 AND last_update > '2024-05-05 07:05:45' 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 07:05:45' 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=3 AND last_update > '2024-05-05 07:05:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0146  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 139 AND l.year = 1957
0.0146  SELECT e.action, count(e.action) as total, e.player_id FROM events1957 e WHERE e.league_id IN (14925) 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 (14925) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (383051,395711) ORDER BY rp.in_squad = 1 DESC
0.0146  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 139 AND l.year = 1957
0.0146  SELECT e.action, count(e.action) as total, e.player_id FROM events1957 e WHERE e.league_id IN (14925) 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 = 139 AND l.year = 1957
0.0146  SELECT e.action, count(e.action) as total, e.player_id FROM events1957 e WHERE e.league_id IN (14925) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10