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

Información
  • Nombre del equipo Derby County
  • Nombre completo Derby County Football Club
  • Nombre corto DER
  • País Inglaterra
  • Ciudad Derby
  • Entrenador Paul Warne
  • URL del equipo en RF //m.resultados-futbol.com/Derby-County-Fc
Otros Datos
  • Año de Fundación 1884
  • Presupuesto 14000000
  • Patrocinador 32Red
  • Marca de Ropa Umbro
  • Socios 14000
Internet

Información sobre el estadio

  • Nombre del estadio iPro Stadium
  • Capacidad 33597
  • Dirección Pride Park, Royal Way
  • Teléfono +44 (870) 444 1884
  • Fax +44 (1332) 667 540
  • Año de construcción 1997
  • Tamaño 104x64
iPro Stadium

Histórico de participación

FA Cup
Premier League
Championship
EFL Cup
Partidos Amistosos
14 veces
Championship - Play Offs Ascenso
5 veces
EFL Trophy
3 veces
(2024, 2024, 2023)
Champions League
2 veces
(1976, 1973)
League One
2 veces
(2024, 2023)
Europa League
2 veces
(1977, 1975)
Community Shield
1 vez
(1976)
Trofeo Colombino
1 vez
(1974)
Trofeo Costa del Sol
1 vez
(1975)

Partidos del Derby County

Ir al LIVESCORE
12 Sep 17  Finalizado Barnsley Barnsley
3 - 2
Derby County Derby County 2
22 Ago 17  Finalizado Grimsby Town Tarjeta RojaGrimsby Town
0 - 1
Derby County Derby County 42
06 May 18  Finalizado Derby County Derby County
4 - 1
Barnsley Barnsley 6
28 Abr 18  Finalizado Aston Villa Aston Villa
1 - 1
Derby County Derby County 23
24 Abr 18  Finalizado Derby County Derby County
3 - 1
Cardiff City Cardiff City 128
21 Abr 18  Finalizado Derby County Derby County
1 - 2
Middlesbrough Middlesbrough 20
14 Abr 18  Finalizado Burton Albion Burton Albion
3 - 1
Derby County Derby County 23
11 Abr 18  Finalizado Wolves Wolves
2 - 0
Derby County Derby County 71
07 Abr 18  Finalizado Derby County Derby County
3 - 0
Bolton Wanderers Bolton Wanderers 7
02 Abr 18  Finalizado Preston North End Preston North End
0 - 1
Derby County Derby County 74
30 Mar 18  Finalizado Derby County Derby County
1 - 4
Sunderland Sunderland 148
11 Mar 18  Finalizado Nottingham Forest Nottingham Forest
0 - 0
Derby County Derby CountyTarjeta Roja 15
06 Mar 18  Finalizado Queens Park Rangers Queens Park Rangers
1 - 1
Derby County Derby County 25
03 Mar 18  Finalizado Derby County Derby County
1 - 2
Fulham Fulham 14
24 Feb 18  Finalizado Reading Reading
3 - 3
Derby County Derby CountyTarjeta Roja 7
21 Feb 18  Finalizado Derby County Derby County
2 - 2
Leeds United Leeds United 69
13 Feb 18  Finalizado Sheffield Wednesday Sheffield Wednesday
2 - 0
Derby County Derby County 72
10 Feb 18  Finalizado Derby County Derby County
1 - 1
Norwich City Norwich City 7
03 Feb 18  Finalizado Derby County Derby County
3 - 0
Brentford BrentfordTarjeta Roja 0
30 Ene 18  Finalizado Millwall Millwall
0 - 0
Derby County Derby County 17
19 Ene 18  Finalizado Derby County Derby County
0 - 0
Bristol City Bristol City 53
13 Ene 18  Finalizado Birmingham City Birmingham City
0 - 3
Derby County Derby County 7
01 Ene 18  Finalizado Derby County Derby County
1 - 1
Sheffield United Sheffield United 21
30 Dic 17  Finalizado Ipswich Town Ipswich Town
1 - 2
Derby County Derby County 5
26 Dic 17  Finalizado Hull City Hull City
0 - 0
Derby County Derby County 19
23 Dic 17  Finalizado Derby County Derby County
3 - 0
Millwall Millwall 6
16 Dic 17  Finalizado Derby County Derby County
2 - 0
Aston Villa Aston Villa 48
09 Dic 17  Finalizado Barnsley Barnsley
0 - 3
Derby County Derby County 0
02 Dic 17  Finalizado Derby County Derby County
1 - 0
Burton Albion Burton Albion 8
28 Nov 17  Finalizado Derby County Derby County
0 - 1
Ipswich Town Ipswich Town 25
25 Nov 17  Finalizado Middlesbrough Tarjeta RojaMiddlesbrough
0 - 3
Derby County Derby County 4
21 Nov 17  Finalizado Derby County Derby County
2 - 0
Queens Park Rangers Queens Park Rangers 1
18 Nov 17  Finalizado Fulham Fulham
1 - 1
Derby County Derby County 4
04 Nov 17  Finalizado Derby County Derby County
2 - 4
Reading Reading 4
31 Oct 17  Finalizado Leeds United Leeds United
1 - 2
Derby County Derby County 8
28 Oct 17  Finalizado Norwich City Norwich City
1 - 2
Derby County Derby County 1
21 Oct 17  Finalizado Derby County Derby County
2 - 0
Sheffield Wednesday Sheffield WednesdayTarjeta Roja 0
15 Oct 17  Finalizado Derby County Derby County
2 - 0
Nottingham Forest Nottingham Forest 2
30 Sep 17  Finalizado Cardiff City Cardiff City
0 - 0
Derby County Derby County 9
26 Sep 17  Finalizado Brentford Brentford
1 - 1
Derby County Derby County 5
23 Sep 17  Finalizado Derby County Derby County
1 - 1
Birmingham City Birmingham City 1
16 Sep 17  Finalizado Bristol City Bristol City
4 - 1
Derby County Derby County 0
08 Sep 17  Finalizado Derby County Derby County
5 - 0
Hull City Hull City 30
26 Ago 17  Finalizado Sheffield United Sheffield United
3 - 1
Derby County Derby County 0
19 Ago 17  Finalizado Bolton Wanderers Bolton Wanderers
1 - 2
Derby County Derby County 3
15 Ago 17  Finalizado Derby County Derby County
1 - 0
Preston North End Preston North End 16
12 Ago 17  Finalizado Derby County Derby County
0 - 2
Wolves Wolves 10
04 Ago 17  Finalizado Sunderland Sunderland
1 - 1
Derby County Derby County 25
29 Jul 17  Finalizado Derby County Derby County
1 - 2
Hoffenheim Hoffenheim 1
25 Jul 17  Finalizado Northampton Northampton
1 - 0
Derby County Derby County 0
22 Jul 17  Finalizado Kaiserslautern Kaiserslautern
0 - 2
Derby County Derby County 0
18 Jul 17  Finalizado Port Vale Port Vale
0 - 1
Derby County Derby County 3
18 Jul 17  Finalizado Doncaster Rovers Doncaster Rovers
1 - 1
Derby County Derby County 12
15 Jul 17  Finalizado Macclesfield Town Macclesfield Town
0 - 2
Derby County Derby County 3
11 Jul 17  Finalizado Kidderminster Harriers Kidderminster Harriers
0 - 4
Derby County Derby County 2

Plantilla del Derby County Temporada 2017/2018

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
35 29 gb 180 86 - - -
1 38 gb 188 85 - - 2
Defensa
16 35 ie 188 84 1 - -
14 30 gb 186 78 - - 3
33 39 sl 188 76 1 - 2
3 35 ss 189 83 - - 5
12 42 gb 185 76 - 1 3
47 23 gb 178 69 - - -
29 35 se 180 72 - - 3
6 37 ie 188 87 1 - 4
Centrocampista
19 32 at 179 76 5 - 7
15 37 gb 178 68 4 - 9
34 31 gb 188 83 - - 1
8 36 ss 170 72 - - -
36 37 wa 183 73 1 - 3
26 28 gb 193 78 - - 1
7 27 jm 175 68 2 - 2
44 37 gb 188 71 2 1 7
Delantero
32 37 gd 185 85 6 - 5
28 38 gb 180 76 9 - 5
45 25 gb 171 67 - - -
23 31 cz 180 74 21 - 2
17 33 gb 175 71 7 - 2
10 30 wa 175 69 6 - 6

Noticias del Derby County

Ver últimas noticias

El Derby County accede a dejar a Rawson cedido en el Rotherham hasta fin de temporada

Farrend Rawson terminará la temporada defendiendo la camiseta del Rotherham United, tras prolongar su cesión por parte del Derby County.

El Derby County pesca a un ex del Mallorca

El equipo inglés está cuajando una gran temporada y los últimos resultados también decantan la balanza a favor. Con el mercado de fichajes abierto, las nuevas incorporaciones son constantes y, esta vez, el Derby County ficha a un ex de la Liga española.

Precioso duelo entre los segundos de Mou y Ancelotti por el título

Los entrenadores asistentes elegidos en su día por José Mourinho y Carlo Ancelotti luchan por el título del Championship inglés, equivalente a la Segunda División Española.

Tom Ince dijo no al Inter para triunfar en la Premier

El jugador del Derby County Tom Ince tuvo la posibilidad de fichar por el Inter de Milán. El futbolista llegó a sentarse a negociar con los dirigentes del club, sin embargo, desestimó la oferta para seguir en el fútbol inglés.

Areola libra al Villarreal de caer vencido frente al Derby County

Una buena actuación del portero Alphonse Aerola en la segunda parte, salvó al Villarreal de perder frente al Derby County en partido amistoso disputado en el Ipro Stadium de Derby (Reino Unido).




  USO DE MEMORIA  
6,576,432 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0029
Controller Execution Time ( Home / Category )  0.8581
Total Execution Time  0.8610
  CADENA URL  
/derby-county-fc/2018
  GET DATOS  
$_GET['/derby-county-fc/2018']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (45)  
0.0147  SELECT type FROM routes WHERE alias = 'derby-county-fc'
0.0248  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'derby-county-fc' AND l.year = 2018 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0149  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=916 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=916 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=916 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=916 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=916 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=916 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 38989
0.0150  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 38752
0.0150  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 43386
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=916 AND type_rel = 2
0.0150  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.0147  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.0160  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '916' AND l.year = 2018 ORDER BY l.year DESC,cat.coefficient DESC
0.0160  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.0147  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 38634 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0149  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 38752 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0168  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 38989 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0151  (SELECT cat.id as category_id, cat.logo, l.id,cat.alias,cat.name,l.group_code,l.total_group,cat.CountryCode,max(c.shedule) ult_partido,min(c.shedule) ini_partido,cat.coefficient FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2018 as c ON c.league_id = l.id WHERE (c.datateam1 = 916 or c.datateam2 = 916) AND l.year = 2018 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0155  (SELECT cat.id as category_id, l.year,cat.coefficient,c.extra,c.datateam1,c.datateam2,c.id as mid,c.r1,c.r2,c.shedule,c.team1,c.team2,l.id,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,c.comments as totalcomments FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2018 as c ON c.league_id = l.id INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN datateams dt2 ON dt2.id = t2.teamId WHERE (c.datateam1 = 916 or c.datateam2 = 916) AND l.year = 2018 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0151  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2018 as c ON c.league_id = l.id INNER JOIN events2018 as e ON e.team1id = c.team1 AND e.team2id = c.team2 AND (e.action = 3 OR e.action = 4) INNER JOIN rel_players rel ON rel.player_id = e.player_id AND rel.in_squad = 1 AND rel.league_id = e.league_id AND rel.in_squad = 1 WHERE (c.datateam1 = 916 or c.datateam2 = 916) AND l.year = 2018)
0.0158  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 (2017,2018,2019) ORDER BY l.id DESC, l.year DESC ;
0.0146  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 (49674,44547,43924,43565,43475) 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.0151  SELECT count(id) as num_players from rel_players WHERE league_id = 43565 AND teamId = 916
0.0155  SELECT count(id) as num_players from rel_players WHERE league_id = 44547 AND teamId = 916
0.0152  SELECT count(id) as num_players from rel_players WHERE league_id = 43924 AND teamId = 916
0.0145  SELECT count(id) as num_players from rel_players WHERE league_id = 49674 AND teamId = 916
0.0242  SELECT count(id) as num_players from rel_players WHERE league_id = 43475 AND teamId = 916
0.0152  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2018` 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 = 38634 AND t.round = 46 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0147  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '916' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0144  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '916' and rp.type = 4
0.0146  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '916' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0166  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 events2018 e ON e.player_id = p.id AND e.league_id = 38634 WHERE rp.league_id = 38634 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.0162  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 events2018 e ON e.player_id = p.id AND e.league_id = 38634 WHERE rp.league_id = 38634 AND rp.teamId = 916 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0159  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 events2018 e ON e.player_id = p.id AND e.league_id = 38634 WHERE rp.league_id = 38634 AND rp.teamId = 916 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0154  SELECT rp.team_id as teamId FROM rel_players AS rp inner join datateams as dt on rp.teamId=dt.id and rp.in_squad=1 INNER JOIN leagues as l ON l.id = rp.league_id WHERE dt.id = 916 AND rp.league_id = 38634 AND l.year= 2018 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0152  SELECT dp.id, dp.nick, dp.name, dp.last_name, dp.alias, dp.role, dp.height,dp.weight,dp.foot,dp.side,dp.birthdate,IF(dp.birthdate != '0000-00-00 00:00:00', YEAR(CURDATE())-YEAR(dp.birthdate) + IF(DATE_FORMAT(CURDATE(),'%m-%d') > DATE_FORMAT(dp.birthdate,'%m-%d'), 0, -1) , NULL) as age,rp.squadNumber,rp.captain,IF(dp.CountryCode IS NULL,'',dp.CountryCode) AS CountryCode,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id and rp.in_squad=1 WHERE rp.team_id=782892 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0145  SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=782892
0.0162  SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2018 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=782892 and (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY dp.id ORDER BY cuenta DESC
0.0154  SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2018 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=782892 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0151  SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2018 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=782892 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0152   SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2018 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=782892 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0152  SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2018 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=782892 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC
0.0146  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 38634 ORDER BY nameShow LIMIT 100