4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Derby County

Derby County

Entrenador: Paul Warne

Temporada 2016/2017

Estadísticas

ASISTENCIAS
Tom Ince6
J. Russell4
Chris Baird3
J. Butterfield3
Ikechi Anya3
Will Hughes3
C. Martin2
Bradley Johnson2
A. Weimann2
Marcus Olsson2
Craig Bryson2
Abdoul Camara1
R. Keogh1
Scott Carson1
A. Pearce1
M. Vydra1
D. Nugent1
Jamie Hanson1
ENTRA
D. Bent15
A. Weimann14
M. Vydra13
Abdoul Camara12
Ikechi Anya12
Craig Bryson11
Will Hughes10
J. Russell7
N. Blackman7
C. Martin6
Jamie Hanson6
J. Butterfield6
D. Nugent6
Chris Baird5
Tom Ince4
C. Christie3
Mason Bennett2
Julien De Sart1
Max Lowe1
J. Wilson1
A. Pearce1
Jason Shackell1
SALE
J. Russell17
D. Bent14
Will Hughes12
Tom Ince12
M. Vydra11
J. Butterfield11
C. Martin9
Craig Bryson8
D. Nugent7
A. Weimann7
Bradley Johnson6
Ikechi Anya6
Marcus Olsson6
Chris Baird4
Julien De Sart3
J. Wilson3
Abdoul Camara2
Max Lowe1
Jason Shackell1
N. Blackman1
Jamie Hanson1
A. Pearce1
R. Keogh1
C. Forsyth1
Jeff Hendrick1
C. Christie1

  USO DE MEMORIA  
5,720,152 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  1.0330
Total Execution Time  1.0342
  CADENA URL  
/estadisticas/Derby-County-Fc/2017
  GET DATOS  
$_GET['/estadisticas/Derby-County-Fc/2017']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.1901  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=916 AND type_rel = 2
0.0125  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 916 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0060  SELECT /*35 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 (4320,14163,30924,31965,32142) ORDER BY n.cover_points DESC, update_date DESC
0.0834  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '916' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0461  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=916 AND l.year in (2016,2017,2018) ORDER BY l.id DESC, l.year DESC ;
0.0037  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (43386,38989,38752,38634,38427) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 38634 AND teamId = 916
0.0131  SELECT count(id) as num_players from rel_players WHERE league_id = 38989 AND teamId = 916
0.0069  SELECT count(id) as num_players from rel_players WHERE league_id = 38752 AND teamId = 916
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 43386 AND teamId = 916
0.0403  SELECT count(id) as num_players from rel_players WHERE league_id = 38427 AND teamId = 916
0.0047  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2017` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 30627 AND t.round = 46 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0090  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2017 e ON e.player_id = p.id AND e.league_id = 30627 WHERE rp.league_id = 30627 AND rp.teamId = 916 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0095  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2017 e ON e.player_id = p.id AND e.league_id = 30627 WHERE rp.league_id = 30627 AND rp.teamId = 916 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0083  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2017 e ON e.player_id = p.id AND e.league_id = 30627 WHERE rp.league_id = 30627 AND rp.teamId = 916 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.4414  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2017 e ON e.player_id = p.id AND e.league_id = 30627 WHERE rp.league_id = 30627 AND rp.teamId = 916 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0538  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2017 e ON e.player_id = p.id AND e.league_id = 30627 WHERE rp.league_id = 30627 AND rp.teamId = 916 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0428  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2017 e ON e.player_id = p.id AND e.league_id = 30627 WHERE rp.league_id = 30627 AND rp.teamId = 916 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30