Sitios
- Twitter
Notificaciones 0
Amigos 0
Actividad

No hay actividad de la comunidad para mostrarte.

4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

Derby County

Entrenador: Paul Warne

Temporada 2013/2014

Información sobre Derby County

Enviar Datos

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 testing.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

Sitio Web https://www.dcfc.co.uk/
Twitter principal @dcfcofficial

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

Histórico de participación

FA Cup

68 veces

(2024, 2023, 2022, 2021, 2020, 2019, 2018, 2017, 2016, 2015, 2014, 2013, 2012, 2011, 2010, 2009, 2008, 2007, 2006, 2005, 2004, 2003, 2002, 2001, 2000, 1999, 1998, 1997, 1996, 1995, 1994, 1993, 1992, 1991, 1990, 1989, 1988, 1987, 1986, 1984, 1983, 1978, 1977, 1976, 1973, 1972, 1970, 1950, 1949, 1948, 1946, 1936, 1933, 1928, 1923, 1911, 1909, 1907, 1906, 1905, 1904, 1903, 1902, 1899, 1898, 1897, 1896, 1894)

Premier League

67 veces

(2008, 2002, 2001, 2000, 1999, 1998, 1997, 1991, 1990, 1989, 1988, 1980, 1979, 1978, 1977, 1976, 1975, 1974, 1973, 1972, 1971, 1970, 1956, 1953, 1952, 1951, 1950, 1949, 1948, 1947, 1940, 1939, 1938, 1937, 1936, 1935, 1934, 1933, 1932, 1931, 1930, 1929, 1928, 1927, 1921, 1920, 1914, 1913, 1907, 1906, 1905, 1904, 1903, 1902, 1901, 1900, 1899, 1898, 1897, 1896, 1895, 1894, 1893, 1892, 1891, 1890, 1889)

Championship

54 veces

(2022, 2021, 2020, 2019, 2018, 2017, 2016, 2015, 2014, 2013, 2012, 2011, 2010, 2009, 2007, 2006, 2005, 2004, 2003, 1996, 1995, 1994, 1993, 1992, 1987, 1984, 1983, 1982, 1981, 1969, 1968, 1967, 1966, 1965, 1964, 1963, 1962, 1961, 1960, 1959, 1958, 1955, 1954, 1926, 1925, 1924, 1923, 1922, 1915, 1912, 1911, 1910, 1909, 1908)

Partidos Amistosos

14 veces

(2024, 2023, 2022, 2021, 2020, 2019, 2018, 2017, 2016, 2015, 2014, 2013, 2012, 2011)

Championship - Play Offs Ascenso

5 veces

(2019, 2018, 2016, 2014, 2007)

Partidos del Derby County

Ir al LIVESCORE

FA Cup »

05 Ene 14

Finalizado

Derby County

0 - 2

Chelsea

EFL Cup »

24 Sep 13	Finalizado	Leicester	2 - 1	Derby County
27 Ago 13	Finalizado	Derby County	5 - 0	Brentford
06 Ago 13	Finalizado	Oldham Athletic AFC	0 - 1	Derby County

Championship »

03 May 14	Finalizado	Leeds United	1 - 1	Derby County	0
26 Abr 14	Finalizado	Derby County	4 - 2	Watford	0
21 Abr 14	Finalizado	Derby County	2 - 1	Barnsley	2
18 Abr 14	Finalizado	Doncaster Rovers	0 - 2	Derby County	1
12 Abr 14	Finalizado	Derby County	3 - 1	Huddersfield Town	1
08 Abr 14	Finalizado	Blackpool	1 - 3	Derby County	2
05 Abr 14	Finalizado	Middlesbrough	1 - 0	Derby County	1
29 Mar 14	Finalizado	Derby County	3 - 0	Charlton Athletic	0
25 Mar 14	Finalizado	Ipswich Town	2 - 1	Derby County	0
22 Mar 14	Finalizado	Derby County	5 - 0	Nottingham Forest	1
15 Mar 14	Finalizado	Reading	0 - 0	Derby County	0
11 Mar 14	Finalizado	Derby County	0 - 0	Bolton Wanderers	0
08 Mar 14	Finalizado	Derby County	0 - 1	Millwall	0
01 Mar 14	Finalizado	Burnley	2 - 0	Derby County	0
22 Feb 14	Finalizado	Derby County	1 - 0	AFC Bournemouth	0
18 Feb 14	Finalizado	Sheffield Wednesday	0 - 1	Derby County	3
10 Feb 14	Finalizado	Derby County	1 - 0	Queens Park Rangers	19
01 Feb 14	Finalizado	Birmingham City	3 - 3	Derby County	0
28 Ene 14	Finalizado	Derby County	3 - 2	Yeovil Town	28
25 Ene 14	Finalizado	Blackburn Rovers	1 - 1	Derby County	0
18 Ene 14	Finalizado	Derby County	1 - 0	Brighton & Hove Albion	0
10 Ene 14	Finalizado	Leicester	4 - 1	Derby County	0
01 Ene 14	Finalizado	Derby County	0 - 1	Wigan Athletic	0
29 Dic 13	Finalizado	Barnsley	1 - 2	Derby County	2
26 Dic 13	Finalizado	Huddersfield Town	1 - 1	Derby County	0
21 Dic 13	Finalizado	Derby County	3 - 1	Doncaster Rovers	0
14 Dic 13	Finalizado	Charlton Athletic	0 - 2	Derby County	0
07 Dic 13	Finalizado	Derby County	5 - 1	Blackpool	1
04 Dic 13	Finalizado	Derby County	2 - 1	Middlesbrough	1
01 Dic 13	Finalizado	Wigan Athletic	1 - 3	Derby County	0
23 Nov 13	Finalizado	AFC Bournemouth	0 - 1	Derby County	0
09 Nov 13	Finalizado	Derby County	3 - 0	Sheffield Wednesday	0
02 Nov 13	Finalizado	Queens Park Rangers	2 - 1	Derby County	0
26 Oct 13	Finalizado	Derby County	1 - 1	Birmingham City	0
19 Oct 13	Finalizado	Watford	2 - 3	Derby County	0
05 Oct 13	Finalizado	Derby County	3 - 1	Leeds United	1
01 Oct 13	Finalizado	Derby County	4 - 4	Ipswich Town	2
28 Sep 13	Finalizado	Nottingham Forest	1 - 0	Derby County	0
21 Sep 13	Finalizado	Derby County	1 - 3	Reading	0
17 Sep 13	Finalizado	Bolton Wanderers	2 - 2	Derby County	0
14 Sep 13	Finalizado	Millwall	1 - 5	Derby County	0
31 Ago 13	Finalizado	Derby County	0 - 3	Burnley	0
24 Ago 13	Finalizado	Yeovil Town	0 - 3	Derby County	0
17 Ago 13	Finalizado	Derby County	0 - 1	Leicester	0
10 Ago 13	Finalizado	Brighton & Hove Albion	1 - 2	Derby County	0
04 Ago 13	Finalizado	Derby County	1 - 1	Blackburn Rovers	0

Partidos Amistosos »

27 Jul 13

Finalizado

Derby County

0 - 2

West Bromwich Albion

Championship - Play Offs Ascenso »

24 May 14	Finalizado	Derby County	0 - 1	Queens Park Rangers	59
11 May 14	Finalizado	Derby County	4 - 1	Brighton & Hove Albion	3
08 May 14	Finalizado	Brighton & Hove Albion	1 - 2	Derby County	24

Estadísticas

GOLEADORES

AMARILLAS

ROJAS

Plantilla del Derby County Temporada 2013/2014

		Edad	Altura	Peso
Portero
26	A. Legzdins	37	190	77	-	-	-
	A. Smithies	34	189	84	-	-	3
	F. Fielding	36	185	76	-	-	-
1	L. Grant	41	193	83	-	-	3
24	M. Morch	30	-	-	-	-	-
13	S. Deeney	41	185	73	-	-	-
Defensa
2	Adam Smith	33	174	78	-	-	3
33	Andre Wisdom	30	186	78	-	-	3
16	B. Davies	42	170	67	-	-	1
3	C. Forsyth	35	189	83	2	-	9
	G. Roberts	46	173	74	-	-	-
25	J. Buxton	39	180	83	2	-	3
	J. O'connor	39	178	78	-	-	-
34	K. Cissé	40	187	82	-	-	1
17	K. Freeman	32	178	73	-	-	1
12	L. Naylor	44	178	76	-	-	-
15	M. O'brien	31	180	77	-	-	-
29	Max Lowe	26	175	70	-	-	-
35	Michael Keane	31	188	68	3	-	-
6	R. Keogh	37	188	87	1	1	4
	S. Barker	41	188	79	-	-	-
	S. Galinski	30	185	-	-	-	-
21	V. Gjokaj	30	190	76	-	-	-
27	Z. Whitbread	40	188	71	1	-	2
Centrocampista
	C. Doyle	32	188	84	-	-	-
4	Craig Bryson	37	170	60	16	-	6
34	G. Thorne	31	188	83	1	-	5
30	J. Bailey	35	183	79	-	-	-
14	J. Eustace	44	178	75	1	-	9
26	Jamie Hanson	28	193	78	-	-	-
8	Jeff Hendrick	32	185	79	4	-	1
7	P. Coutts	35	183	75	-	-	3
12	T. Naylor	32	181	72	-	-	-
19	Will Hughes	29	185	74	3	-	5
Delantero
22	C. Ball	31	185	66	-	-	-
9	C. Martin	35	184	73	20	1	9
18	C. Sammon	37	188	75	2	-	1
11	J. Russell	34	178	67	9	-	1
10	J. Ward	37	165	68	7	-	3
31	K. Thomas	28	190	76	-	-	-
12	M. Jacobs	32	175	74	-	-	-
20	Mason Bennett	27	178	65	1	-	-
	N. Tyson	41	183	64	-	-	1
35	Patrick Bamford	30	185	71	8	-	2
32	S. Dawkins	36	177	73	4	-	2

Noticias del Derby County

Ver últimas noticias

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

Juan Ribón - Martes, 05 Enero 2016

0 101

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

Adrián Becerra - Martes, 05 Enero 2016

0 964

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

Sergio Álvarez - Martes, 29 Diciembre 2015

3 4.006

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

BeSoccer - Lunes, 28 Septiembre 2015

0 855

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

BeSoccer - Jueves, 30 Julio 2015

0 335

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).

Ver más noticias del equipo»

Competiciones que juega

Championship

Pos	Equipos		Pts
1		Leicester	102
2		Burnley	93
3		Derby County	85
4		Queens Park Rangers	80
5		Wigan Athletic	73
6		Brighton & Hove Albion	72
7		Reading	71
8		Blackburn Rovers	70
9		Ipswich Town	68
10		AFC Bournemouth	66
11		Nottingham Forest	65
12		Middlesbrough	64
13		Watford	60
14		Bolton Wanderers	59
15		Leeds United	57
16		Sheffield Wednesday	53
17		Huddersfield Town	53
18		Charlton Athletic	51
19		Millwall	48
20		Blackpool	46
21		Birmingham City	44
22		Doncaster Rovers	44
23		Barnsley	39
24		Yeovil Town	37

RIVALES EN Championship

RIVALES EN EFL Cup

RIVALES EN FA Cup

USO DE MEMORIA

6,780,216 bytes

BENCHMARKS

Loading Time Base Classes	0.0018
Controller Execution Time ( Home / Category )	0.8432
Total Execution Time	0.8451

CADENA URL

/Derby-County-Fc/2014

GET DATOS

$_GET['/Derby-County-Fc/2014']

POST DATOS

No hay datos POST existentes

CONSULTAS (40)

0.0169	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 = 2014 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.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.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.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.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.0152	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 = 3321
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 = 3664
0.0152	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 = 2399
0.0145	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.0159	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.0201	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 = 2014 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 = 2437 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0151	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 = 3321 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0150	(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 calendars2014 as c ON c.league_id = l.id WHERE (c.datateam1 = 916 or c.datateam2 = 916) AND l.year = 2014 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0199	(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 calendars2014 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 = 2014 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0200	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2014 as c ON c.league_id = l.id INNER JOIN events2014 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 = 2014)
0.0253	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 (2013,2014,2015) 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 (20550,4393,3812,3804,3664) 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.0150	SELECT count(id) as num_players from rel_players WHERE league_id = 3812 AND teamId = 916
0.0212	SELECT count(id) as num_players from rel_players WHERE league_id = 4393 AND teamId = 916
0.0180	SELECT count(id) as num_players from rel_players WHERE league_id = 20550 AND teamId = 916
0.0148	SELECT count(id) as num_players from rel_players WHERE league_id = 3664 AND teamId = 916
0.0199	SELECT count(id) as num_players from rel_players WHERE league_id = 3804 AND teamId = 916
0.0155	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM* `tables2014` 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 = 2437 AND t.round = 46 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0172	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 events2014 e ON e.player_id = p.id AND e.league_id = 2437 WHERE rp.league_id = 2437 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.0176	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 events2014 e ON e.player_id = p.id AND e.league_id = 2437 WHERE rp.league_id = 2437 AND rp.teamId = 916 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0180	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 events2014 e ON e.player_id = p.id AND e.league_id = 2437 WHERE rp.league_id = 2437 AND rp.teamId = 916 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0188	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 = 2437 AND l.year= 2014 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0186	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=51223 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0152	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=51223
0.0186	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 events2014 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=51223 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.0190	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 events2014 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=51223 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0173	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 events2014 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=51223 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0182	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 events2014 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=51223 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0158	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 events2014 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=51223 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 = 2437 ORDER BY nameShow LIMIT 100

Resultados de Fútbol

Derby County

Información sobre Derby County

Información

Otros Datos

Internet

Opciones de envio

Datos del equipo

Información sobre el estadio

Histórico de participación

FA Cup

Premier League

Championship

EFL Cup

Partidos Amistosos

Championship - Play Offs Ascenso

EFL Trophy

Champions League

League One

Europa League

Community Shield

Trofeo Colombino

Trofeo Costa del Sol

Partidos del Derby County

Estadísticas

Plantilla del Derby County Temporada 2013/2014

Noticias del Derby County

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

El Derby County pesca a un ex del Mallorca

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

Tom Ince dijo no al Inter para triunfar en la Premier

Areola libra al Villarreal de caer vencido frente al Derby County

Derby County

Selecciona un equipo

Competiciones que juega

Championship

RIVALES EN Championship

RIVALES EN EFL Cup

RIVALES EN FA Cup


	¿Has detectado algún error en la web? x Tipo de incidencia ¿Qué ocurre? Deja tu correo si quieres que te contactemos