4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
12 jugadores
Queens Park Rangers Queens Park Ran.
Paul Barron Paul Barron 70 años POR
T. Fenwick T. Fenwick 64 años DEF
A. Mcdonald A. Mcdonald 48 años 188cm 79kg DEF
Warren Neill Warren Neill 61 años 173cm 74kg DEF
Ian Dawes Ian Dawes 61 años 171cm 73kg DEF
Stephen Wicks Stephen Wicks 67 años DEF
Martin Allen Martin Allen 58 años 178cm 70kg MED
R. James R. James 40 años 180cm 82kg MED
Leroy Rosenior Leroy Rosenior 59 años MED
Gary Bannister Gary Bannister 63 años 173cm 70kg DEL
J. Byrne J. Byrne 63 años DEL
Robinson Robinson 61 años 182cm 82kg DEL
12 jugadores
Oxford United Oxford United
Malcolm Shotton Malcolm Shotton 67 años DEF
Gary Briggs Gary Briggs 64 años 191cm DEF
D. Langan D. Langan 67 años DEF
Trevor Hebberd Trevor Hebberd 65 años 180cm MED
Alan Judge Alan Judge 63 años 180cm 73kg MED
John Trewick John Trewick 66 años MED
Kevin Brock Kevin Brock 61 años MED
Ray Houghton Ray Houghton 62 años MED
Andy Thomas Andy Thomas 61 años MED
Les Phillips Les Phillips 61 años 173cm MED
J. Charles J. Charles 64 años 185cm DEL
J. Aldridge J. Aldridge 65 años 181cm 72kg DEL

  USO DE MEMORIA  
4,351,704 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0636
Total Execution Time  0.0655
  CADENA URL  
/capital_one_cup1986/grupo0/jugadores
  GET DATOS  
$_GET['/capital_one_cup1986/grupo0/jugadores']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0018  SELECT type FROM routes WHERE alias = 'capital_one_cup1986'
0.0038  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 = 1986 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=523 AND type_rel = 3
0.0033  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.0023  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.0020  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 = 23225 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  SELECT dt.id FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 23225 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 36
0.0024  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 = 23225 AND dt.id IN (263,297,752,916,1017,3845,1633,1635,1796,1825,2327,2523,2748,502,2804,1533,2429,2004,2369,1183,9759,1600,9189,1387,1824,2044,9181,6339,5652,9183,2743,9200) 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-05-09 18:25:39' 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-05-09 18:25:39' 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-05-09 18:25:39' 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-05-09 18:25:39' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 523 AND l.year = 1986
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events1986 e WHERE e.league_id IN (23225) 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.0020  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 (23225) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (354604,421326,435213) ORDER BY rp.in_squad = 1 DESC
0.0019  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 523 AND l.year = 1986
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events1986 e WHERE e.league_id IN (23225) 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 l.id FROM leagues_webci l WHERE l.categoryId = 523 AND l.year = 1986
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events1986 e WHERE e.league_id IN (23225) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10