4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
13 jugadores
Nottingham Forest Nottingham
Steve Sutton Steve Sutton 63 años 185cm POR
Stephen Chettle Stephen Chettle 55 años 185cm 86kg DEF
S. Pearce S. Pearce 62 años 178cm 79kg DEF
Desmond Walker Desmond Walker 58 años 180cm 75kg DEF
Brian Laws Brian Laws 62 años 178cm 72kg MED
N. Webb N. Webb 60 años 185cm 83kg MED
Steve Hodge Steve Hodge 61 años MED
Terry Wilson Terry Wilson 55 años 184cm MED
Garry Parker Garry Parker 58 años 180cm 78kg MED
Lee Glover Lee Glover 54 años 178cm 77kg MED
Thomas Gaynor Thomas Gaynor 61 años DEL
Chapman Chapman 64 años 188cm 83kg DEL
Nigel Clough Nigel Clough 58 años 175cm 78kg DEL
13 jugadores
Luton Town Luton Town
Sealey Sealey 43 años 185cm 85kg POR
Steve Foster Steve Foster 66 años 183cm 80kg DEF
Grimes Grimes 65 años 181cm 72kg DEF
Dave Beaumont Dave Beaumont 60 años DEF
Tim Breacker Tim Breacker 58 años 180cm 83kg DEF
David Preece David Preece 60 años 168cm 72kg MED
Ricky Hill Ricky Hill 65 años MED
Kingsley Black Kingsley Black 55 años 178cm 76kg MED
Danny Wilson Danny Wilson 64 años MED
Darron Mcdonough Darron Mcdonough 61 años MED
Meade Meade 61 años DEL
Mick Harford Mick Harford 65 años 190cm 91kg DEL
Roy Wegerle Roy Wegerle 60 años DEL

  USO DE MEMORIA  
4,414,456 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.2629
Total Execution Time  0.2650
  CADENA URL  
/capital_one_cup1989/grupo0/jugadores
  GET DATOS  
$_GET['/capital_one_cup1989/grupo0/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0018  SELECT type FROM routes WHERE alias = 'capital_one_cup1989'
0.1428  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 = 1989 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.0168  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.0057  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.0056  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 = 23232 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0083  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 23232 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0069  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 = 23232 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.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 10:14:09' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0031  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 10:14:09' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0021  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 10:14:09' 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=3 AND last_update > '2024-04-28 10:14:09' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0069  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 523 AND l.year = 1989
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events1989 e WHERE e.league_id IN (23232) 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.0042  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 (23232) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (265981,266079,322592) ORDER BY rp.in_squad = 1 DESC
0.0086  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 523 AND l.year = 1989
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events1989 e WHERE e.league_id IN (23232) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0081  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 523 AND l.year = 1989
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events1989 e WHERE e.league_id IN (23232) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10