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

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

FA Cup 1974

13 jugadores
Liverpool Liverpool
Ray Clemence Ray Clemence 72 años 183cm 80kg POR
P. Thompson P. Thompson 70 años 183cm 74kg DEF
Tommy Smith Tommy Smith 79 años DEF
Chris Lawler Chris Lawler 80 años DEF
Alec Lindsay Alec Lindsay 76 años DEF
Phil Boersma Phil Boersma 74 años MED
Brian Hall Brian Hall 78 años MED
Ian Callaghan Ian Callaghan 82 años MED
Steve Heighway Steve Heighway 76 años MED
Emlyn Hughes Emlyn Hughes 57 años MED
P. Cormack P. Cormack 77 años MED
K. Keegan K. Keegan 73 años DEL
John Toshack John Toshack 75 años DEL
14 jugadores
Newcastle Newcastle
W. Mcfaul W. Mcfaul 80 años POR
Alan Kennedy Alan Kennedy 69 años DEF
Dave Craig Dave Craig 79 años 173cm 71kg DEF
Frank Clark Frank Clark 80 años DEF
Patrick Howard Patrick Howard 76 años DEF
Bobby Moncur Bobby Moncur 79 años DEF
Jimmy Smith Jimmy Smith 77 años MED
Terry Hibbitt Terry Hibbitt 76 años MED
Tommy Gibb Tommy Gibb 79 años MED
Thomas Cassidy Thomas Cassidy 73 años 170cm 79kg MED
Terry Mcdermott Terry Mcdermott 72 años MED
John Tudor John Tudor 77 años MED
Malcolm Macdonald Malcolm Macdonald 74 años DEL
Stewart Barrowclough Stewart Barrowclough 72 años DEL
11 jugadores
Nottingham Forest Nottingham
Jim Barron Jim Barron 80 años POR
Bob Chapman Bob Chapman 77 años DEF
L. O'kane L. O'kane 75 años DEF
John Winfield John Winfield 81 años DEF
Dave Serella Dave Serella 71 años DEF
Paul Richardson Paul Richardson 74 años MED
Duncan Mckenzie Duncan Mckenzie 73 años MED
George Lyall George Lyall 76 años MED
I. Bowyer I. Bowyer 72 años MED
Martin O'neill Martin O'neill 72 años MED
Neil Martin Neil Martin 83 años DEL
12 jugadores
Leicester Leicester
P. Shilton P. Shilton 74 años POR
Graham Cross Graham Cross 80 años DEF
Malcolm Munro Malcolm Munro 70 años DEF
Stephen Whitworth Stephen Whitworth 72 años DEF
Dennis Rofe Dennis Rofe 73 años 170cm DEF
Jon Sammels Jon Sammels 78 años MED
Joe Waters Joe Waters 70 años MED
Keith Weller Keith Weller 77 años MED
Michael Stringfellow Michael Stringfellow 81 años MED
Steve Earle Steve Earle 79 años MED
Leonard Glover Leonard Glover 80 años DEL
Frank Worthington Frank Worthington 72 años DEL
11 jugadores
Burnley Burnley
Alan Stevenson Alan Stevenson 73 años POR
Colin Waldron Colin Waldron 75 años DEF
K. Newton K. Newton 56 años DEF
Douglas Collins Douglas Collins 78 años MED
Peter Noble Peter Noble 79 años MED
Geoff Nulty Geoff Nulty 75 años MED
Jim Thomson Jim Thomson 77 años MED
Martin Dobson Martin Dobson 76 años MED
Frank Casper Frank Casper 79 años 178cm DEL
Leighton James Leighton James 71 años DEL
Paul Fletcher Paul Fletcher 73 años DEL
12 jugadores
Bristol City Bristol City
David Rodgers David Rodgers 72 años DEF
Gerry Sweeney Gerry Sweeney 78 años DEF
Gary Collier Gary Collier 69 años 185cm DEF
Donald Gillies Donald Gillies 72 años DEF
Brian Drysdale Brian Drysdale 81 años DEF
Keith Fear Keith Fear 71 años 170cm MED
John Emanuel John Emanuel 76 años MED
Trevor Tainton Trevor Tainton 75 años 173cm MED
Raymond Cashley Raymond Cashley 72 años MED
Gerald Gow Gerald Gow 71 años MED
Thomas Ritchie Thomas Ritchie 72 años MED
Ernie Hunt Ernie Hunt 81 años DEL

  USO DE MEMORIA  
4,602,776 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.3694
Total Execution Time  0.3715
  CADENA URL  
/fa_cup1974/grupo0/jugadores
  GET DATOS  
$_GET['/fa_cup1974/grupo0/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0144  SELECT type FROM routes WHERE alias = 'fa_cup1974'
0.0293  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 = 1974 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0145  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 = 14747 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0145  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 14747 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0183  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 = 14747 AND dt.id IN (1538,3845,1796,1825,569,548,2044,9761) ORDER BY dt.relations DESC,dp.role ASC
0.0148  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-03 11:48:36' 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=2 AND last_update > '2024-05-03 11:48:36' 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=4 AND last_update > '2024-05-03 11:48:36' 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-03 11:48:36' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0148  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 139 AND l.year = 1974
0.0147  SELECT e.action, count(e.action) as total, e.player_id FROM events1974 e WHERE e.league_id IN (14747) 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.0154  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 (14747) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (370326,413959,396719,372694,452901,453985) ORDER BY rp.in_squad = 1 DESC
0.0163  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 139 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 (14747) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0149  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 (14747) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (370310,452791) ORDER BY rp.in_squad = 1 DESC
0.0146  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 139 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 (14747) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10