4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
FA Cup 1973
1972/1973

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

FA Cup 1973

West Bromwich Albion West Bromwich A.
Peter Latchford Peter Latchford 71 años POR
Ray Wilson Ray Wilson 77 años DEF
Alistair Robertson Alistair Robertson 71 años DEF
John Wile John Wile 77 años DEF
Gordon Nisbet Gordon Nisbet 72 años DEF
Asa Hartford Asa Hartford 73 años 170cm 67kg MED
Len Cantello Len Cantello 72 años 176cm 76kg MED
W. Johnston W. Johnston 77 años 170cm 69kg MED
Alistair Brown Alistair Brown 73 años MED
Alan Merrick Alan Merrick 73 años 178cm MED
Tony Brown Tony Brown 78 años DEL
J. Astle J. Astle 59 años 182cm 73kg DEL
Sheffield Wednesday Sheffield
Peter Springett Peter Springett 78 años POR
John Holsgrove John Holsgrove 78 años DEF
Billy Henderson Billy Henderson DEF
P. Rodrigues P. Rodrigues 80 años DEF
Dave Clements Dave Clements 78 años MED
Roy Coyle Roy Coyle 78 años 175cm 72kg MED
Brian Joicey Brian Joicey 78 años MED
Tommy Craig Tommy Craig 73 años 173cm MED
Colin Prophett Colin Prophett 77 años MED
Eric Potts Eric Potts 74 años DEL
John Sissons John Sissons 78 años DEL
Dave Sunley Dave Sunley 72 años DEL
Chelsea Chelsea
J. Phillips J. Phillips 72 años POR
Marvin Hinton Marvin Hinton 84 años DEF
E. Mccreadie E. Mccreadie 84 años DEF
John Dempsey John Dempsey 78 años DEF
Ron Harris Ron Harris 79 años DEF
John Hollins John Hollins 76 años MED
John Boyle John Boyle 77 años MED
Alan Hudson Alan Hudson 72 años MED
Stephen Kember Stephen Kember 75 años MED
Christopher Garland Christopher Garland 74 años MED
Ian Britton Ian Britton 69 años MED
Gary Locke Gary Locke 69 años MED
Peter Houseman Peter Houseman 78 años DEL
Bill Garner Bill Garner 76 años DEL
P. Osgood P. Osgood 59 años 187cm 79kg DEL
Arsenal Arsenal
R. Wilson R. Wilson 82 años 183cm POR
Peter Simpson Peter Simpson 79 años DEF
Pat Rice Pat Rice 75 años DEF
S. Nelson S. Nelson 75 años 178cm 70kg DEF
Jeff Blockley Jeff Blockley 74 años DEF
P. Storey P. Storey 78 años 175cm DEF
A. Ball A. Ball 61 años MED
Charlie George Charlie George 73 años MED
Bob Mcnab Bob Mcnab 80 años 170cm 71kg MED
Eddie Kelly Eddie Kelly 73 años MED
Ray Kennedy Ray Kennedy 70 años 180cm 80kg MED
Frank Mclintock Frank Mclintock 84 años 175cm 73kg MED
George Armstrong George Armstrong 79 años DEL
J. Radford J. Radford 77 años DEL
Sunderland Sunderland
Jimmy Montgomery Jimmy Montgomery 80 años POR
Ron Guthrie Ron Guthrie 80 años DEF
Richie Pitt Richie Pitt 72 años DEF
David Young David Young 78 años 177cm 68kg DEF
Dick Malone Dick Malone 76 años DEF
Mick Horswill Mick Horswill 71 años 179cm MED
Bobby Kerr Bobby Kerr 76 años MED
Billy Hughes Billy Hughes 75 años 175cm MED
Ian Porterfield Ian Porterfield 78 años MED
Brian Chambers Brian Chambers 74 años MED
Dave Watson Dave Watson 77 años MED
Vic Halom Vic Halom 75 años DEL
D. Tueart D. Tueart 74 años 173cm DEL
Derby County Derby County
Colin Boulton Colin Boulton 78 años 180cm POR
Steve Powell Steve Powell 68 años DEF
Roy Mcfarland Roy Mcfarland 76 años DEF
Ron Webster Ron Webster 80 años DEF
David Nish David Nish 76 años 178cm DEF
Colin Todd Colin Todd 75 años DEF
A. Durban A. Durban 82 años MED
John Mcgovern John Mcgovern 74 años MED
A. Gemmill A. Gemmill 77 años 165cm 71kg MED
J. O'hare J. O'hare 77 años DEL
Kevin Hector Kevin Hector 79 años DEL
Roger Davies Roger Davies 73 años 191cm DEL
Wolves Wolves
Phil Parkes Phil Parkes 76 años 193cm POR
John Mcalle John Mcalle 74 años DEF
F. Munro F. Munro 76 años DEF
Gerry Taylor Gerry Taylor 76 años DEF
Derek Parkin Derek Parkin 76 años DEF
Bernard Shaw Bernard Shaw 79 años DEF
Kenny Hibbitt Kenny Hibbitt 73 años MED
Mike Bailey Mike Bailey 82 años 170cm 71kg MED
Barry Powell Barry Powell 70 años MED
A. Dougan A. Dougan 69 años 190cm 80kg MED
Dave Wagstaffe Dave Wagstaffe 81 años DEL
John Richards John Richards 73 años DEL
Manchester City Manchester City
Joe Corrigan Joe Corrigan 75 años POR
Derek Jeffries Derek Jeffries 73 años 177cm DEF
Colin Barrett Colin Barrett 71 años DEF
Tommy Booth Tommy Booth 74 años DEF
Tony Book Tony Book 88 años DEF
W. Donachie W. Donachie 72 años 175cm 72kg DEF
Mike Doyle Mike Doyle 77 años MED
C. Bell C. Bell 74 años 182cm MED
Tony Towers Tony Towers 72 años 174cm MED
Mike Summerbee Mike Summerbee 81 años DEL
Ian Mellor Ian Mellor 74 años DEL
F. Lee F. Lee 79 años DEL
R. Marsh R. Marsh 79 años DEL
Leeds United Leeds United
D. Harvey D. Harvey 76 años 180cm 78kg POR
P. Reaney P. Reaney 79 años DEF
T. Cherry T. Cherry 72 años DEF
Gordon Mcqueen Gordon Mcqueen 70 años DEF
N. Hunter N. Hunter 76 años DEF
Jack Charlton Jack Charlton 85 años DEF
P. Madeley P. Madeley 79 años DEF
Terry Yorath Terry Yorath 74 años MED
Johnny Giles Johnny Giles 83 años 170cm 63kg MED
Mick Bates Mick Bates 73 años MED
Peter Lorimer Peter Lorimer 74 años MED
Eddie Gray Eddie Gray 76 años MED
W. Bremner W. Bremner 54 años 166cm 68kg MED
Joe Jordan Joe Jordan 72 años 185cm DEL
Allan Clarke Allan Clarke 77 años DEL
Mick Jones Mick Jones 79 años DEL
Luton Town Luton Town
Keith Barber Keith Barber 76 años POR
John Ryan John Ryan 76 años DEF
Bobby Thomson Bobby Thomson 80 años DEF
John Moore John Moore 80 años DEF
Don Shanks Don Shanks 71 años DEF
Derek Hales Derek Hales 72 años MED
Alan Garner Alan Garner 73 años MED
Gordon Hindson Gordon Hindson 74 años MED
Vivian Busby Vivian Busby 74 años MED
Peter Anderson Peter Anderson 74 años MED
Jimmy Ryan Jimmy Ryan 78 años 175cm MED
J. Aston J. Aston 76 años DEL

  USO DE MEMORIA  
4,860,760 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0022
Controller Execution Time ( Home / Category )  0.4069
Total Execution Time  0.4091
  CADENA URL  
/fa_cup1973/grupo0/jugadores
  GET DATOS  
$_GET['/fa_cup1973/grupo0/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0125  SELECT type FROM routes WHERE alias = 'fa_cup1973'
0.0256  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 = 1973 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0128  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=139 AND type_rel = 3
0.0219  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.0143  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 (1314087,1312285,1312282,1312279,1311961) ORDER BY n.cover_points DESC, update_date DESC
0.0130  SELECT id,name,alias,stepParent FROM categories WHERE parentId=10 ORDER BY order_id ASC
0.0135  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 = 14752 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0135  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 14752 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0164  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 = 14752 AND dt.id IN (263,526,752,916,1633,2327,2438,2748,5651,1533,1600,9189,1341,1694,2044,9193) ORDER BY dt.relations DESC,dp.role ASC
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-09 11:18:48' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-09 11:18:48' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-09 11:18:48' 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-05-09 11:18:48' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0128  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 139 AND l.year = 1973
0.0129  SELECT e.action, count(e.action) as total, e.player_id FROM events1973 e WHERE e.league_id IN (14752) 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.0135  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 (14752) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (452408,372753,382830,388370,443027,526784,370307,372752,382835,388145) ORDER BY rp.in_squad = 1 DESC
0.0140  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 139 AND l.year = 1973
0.0134  SELECT e.action, count(e.action) as total, e.player_id FROM events1973 e WHERE e.league_id IN (14752) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0143  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 (14752) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (443241,387883,410325,422078,422317,422409,443027,443156,452667,454109) ORDER BY rp.in_squad = 1 DESC
0.0133  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 139 AND l.year = 1973
0.0128  SELECT e.action, count(e.action) as total, e.player_id FROM events1973 e WHERE e.league_id IN (14752) AND (e.action = 3 or e.action = 4) 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 (14752) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (443241,455280,3305356) ORDER BY rp.in_squad = 1 DESC