4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
11 jugadores
Aston Villa Aston Villa
Nigel Spink Nigel Spink 65 años 188cm 92kg POR
Shaun Teale Shaun Teale 60 años DEF
P. Mcgrath P. Mcgrath 64 años DEF
S. Staunton S. Staunton 55 años 185cm 81kg DEF
Earl Barrett Earl Barrett 57 años 180cm 70kg DEF
Garry Parker Garry Parker 58 años 180cm 78kg MED
Ray Houghton Ray Houghton 62 años MED
Kevin Richardson Kevin Richardson 61 años 170cm 66kg MED
Atkinson Atkinson 48 años 183cm 87kg DEL
Dwight Yorke Dwight Yorke 52 años 178cm 78kg DEL
Dean Saunders Dean Saunders 57 años 173cm 66kg DEL
20 jugadores
Manchester United Manchester
G. Walsh G. Walsh 56 años 190cm 94kg POR
Peter Schmeichel Peter Schmeichel 60 años 193cm POR
Denis Irwin Denis Irwin 58 años 173cm 68kg DEF
Paul Parker Paul Parker 60 años 170cm 75kg DEF
Steve Bruce Steve Bruce 63 años 183cm 83kg DEF
C. Blackmore C. Blackmore 59 años 170cm 77kg DEF
G. Pallister G. Pallister 58 años 193cm 93kg DEF
Lee Martin Lee Martin 56 años 180cm 80kg DEF
Mike Phelan Mike Phelan 61 años 180cm 70kg MED
R. Giggs R. Giggs 50 años 180cm 68kg MED
N. Webb N. Webb 60 años 185cm 83kg MED
Darren Ferguson Darren Ferguson 52 años 178cm 65kg MED
Keith Gillespie Keith Gillespie 49 años 175cm 70kg MED
D. Beckham D. Beckham 48 años 183cm 85kg MED
Paul Ince Paul Ince 56 años 178cm 77kg MED
L. Sharpe L. Sharpe 52 años 183cm 81kg MED
Danny Wallace Danny Wallace 60 años 165cm 66kg DEL
Brian Mcclair Brian Mcclair 60 años 178cm 82kg DEL
Mark Hughes Mark Hughes 60 años 178cm 84kg DEL
A. Kanchelskis A. Kanchelskis 55 años 178cm 82kg DEL
13 jugadores
Sheffield Wednesday Sheffield
Chris Woods Chris Woods 64 años 188cm 88kg POR
Warhurst Warhurst 54 años 185cm 77kg DEF
R. Nilsson R. Nilsson 60 años 178cm 74kg DEF
V. Anderson V. Anderson 67 años 184cm DEF
Phil King Phil King 56 años DEF
Graham Hyde Graham Hyde 53 años 173cm 78kg MED
C. Palmer C. Palmer 58 años 188cm 83kg MED
John Harkes John Harkes 57 años 178cm 75kg MED
Danny Wilson Danny Wilson 64 años MED
John Sheridan John Sheridan 59 años 178cm 77kg MED
C. Waddle C. Waddle 63 años 188cm 82kg DEL
Mark Bright Mark Bright 61 años 183cm 82kg DEL
David Hirst David Hirst 56 años 180cm 96kg DEL
13 jugadores
Arsenal Arsenal
David Seaman David Seaman 60 años 193cm 93kg POR
S. Morrow S. Morrow 53 años 183cm 71kg DEF
Tony Adams Tony Adams 57 años 190cm 88kg DEF
David O'Leary David O'Leary 65 años 184cm 79kg DEF
N. Winterburn N. Winterburn 60 años 173cm 72kg DEF
Andy Linighan Andy Linighan 61 años DEF
R. Parlour R. Parlour 51 años 178cm 75kg MED
I. Selley I. Selley 49 años 175cm 64kg MED
Paul Davis Paul Davis 62 años MED
Paul Merson Paul Merson 56 años 183cm 83kg DEL
Ian Wright Ian Wright 60 años 175cm 73kg DEL
Kevin Campbell Kevin Campbell 54 años 185cm 83kg DEL
Alan Smith Alan Smith 61 años 191cm 77kg DEL

  USO DE MEMORIA  
4,564,744 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0034
Controller Execution Time ( Home / Category )  0.0722
Total Execution Time  0.0756
  CADENA URL  
/capital_one_cup1993/grupo0/jugadores
  GET DATOS  
$_GET['/capital_one_cup1993/grupo0/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0017  SELECT type FROM routes WHERE alias = 'capital_one_cup1993'
0.0039  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'capital_one_cup' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1993 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=523 AND type_rel = 3
0.0036  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 523 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0021  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 (1303703,1303683,1303702,1303025,1299029) ORDER BY n.cover_points DESC, update_date DESC
0.0025  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 = 23239 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 23239 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0039  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 = 23239 AND dt.id IN (263,297,507,526,752,916,1017,1538,3845,1633,1635,1796,1825,2327,2438,2523,2748,5651,9182,502,2804,1533,569,2429,9184,1689,508,9187,2004,2369,1183,1337,436,751,9759,1600) ORDER BY dt.relations DESC,dp.role ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 07:46:11' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 07:46:11' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 07:46:11' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 07:46:11' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 523 AND l.year = 1993
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events1993 e WHERE e.league_id IN (23239) 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.0023  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 (23239) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (257149,265602,265722,265878,266102,434725) ORDER BY rp.in_squad = 1 DESC
0.0019  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 523 AND l.year = 1993
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events1993 e WHERE e.league_id IN (23239) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0019  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 (23239) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (265674,265875) ORDER BY rp.in_squad = 1 DESC
0.0027  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 523 AND l.year = 1993
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events1993 e WHERE e.league_id IN (23239) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10