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

Leeds United

Entrenador: Daniel Farke

Temporada 2019/2020

Información sobre Leeds United

Enviar Datos

Información

Nombre del equipo Leeds United
Nombre completo Leeds United Association Football Club
Nombre corto LEE
País Inglaterra
Ciudad Leeds
Entrenador Daniel Farke
URL del equipo en RF testing.resultados-futbol.com/Leeds-United-Afc

Otros Datos

Año de Fundación 1919
Patrocinador SBOTOP
Marca de Ropa Adidas

Internet

Sitio Web https://www.leedsunited.com/
Twitter principal @LUFC

Información sobre el estadio

Nombre del estadio Elland Road
Capacidad 40204
Dirección Elland Road
Teléfono +44 (113) 367 6000
Fax +44 (113) 367 6050
Año de construcción 1904
Tamaño 105x68 metros

Histórico de participación

FA Cup

55 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, 1985, 1984, 1983, 1979, 1977, 1975, 1973, 1972, 1970, 1968, 1967, 1965, 1963, 1952, 1950, 1936)

Premier League

54 veces

(2023, 2022, 2021, 2004, 2003, 2002, 2001, 2000, 1999, 1998, 1997, 1996, 1995, 1994, 1993, 1992, 1991, 1982, 1981, 1980, 1979, 1978, 1977, 1976, 1975, 1974, 1973, 1972, 1971, 1970, 1969, 1968, 1967, 1966, 1965, 1960, 1959, 1958, 1957, 1947, 1940, 1939, 1938, 1937, 1936, 1935, 1934, 1933, 1931, 1930, 1929, 1927, 1926, 1925)

EFL Cup

48 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, 1986, 1985, 1979, 1978, 1975, 1969, 1968, 1967, 1966, 1964, 1961)

Championship

41 veces

(2024, 2020, 2019, 2018, 2017, 2016, 2015, 2014, 2013, 2012, 2011, 2007, 2006, 2005, 1990, 1989, 1988, 1987, 1986, 1985, 1984, 1983, 1964, 1963, 1962, 1961, 1956, 1955, 1954, 1953, 1952, 1951, 1950, 1949, 1948, 1932, 1928, 1924, 1923, 1922, 1921)

Partidos Amistosos

14 veces

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

Europa League

8 veces

(2003, 2002, 2000, 1999, 1996, 1980, 1974, 1972)

Champions League Grupo 8

6 veces

(2001, 2001, 2001, 1993, 1975, 1970)

Copa de Ferias

6 veces

(1972, 1971, 1969, 1968, 1967, 1966)

Championship - Play Offs Ascenso

3 veces

(2019, 2016, 2006)

Fase Previa Champions League Grupo 3

2 veces

(2001, 1993)

League One - Play Offs Ascenso

2 veces

(2009, 2008)

Partidos del Leeds United

Ir al LIVESCORE

FA Cup »

06 Ene 20

Finalizado

Arsenal

1 - 0

Leeds United

203

EFL Cup »

	27 Ago 19	Finalizado	Leeds United	2 - 2	Stoke City			41
	13 Ago 19	Finalizado	Salford City	0 - 3	Leeds United			3

Championship »

22 Jul 20	Finalizado	Leeds United	4 - 0	Charlton Athletic	40
19 Jul 20	Finalizado	Derby County	1 - 3	Leeds United	62
16 Jul 20	Finalizado	Leeds United	1 - 0	Barnsley	119
12 Jul 20	Finalizado	Swansea City	0 - 1	Leeds United	100
09 Jul 20	Finalizado	Leeds United	5 - 0	Stoke City	72
04 Jul 20	Finalizado	Blackburn Rovers	1 - 3	Leeds United	23
30 Jun 20	Finalizado	Leeds United	1 - 1	Luton Town	63
27 Jun 20	Finalizado	Leeds United	3 - 0	Fulham	11
21 Jun 20	Finalizado	Cardiff City	2 - 0	Leeds United	35
07 Mar 20	Finalizado	Leeds United	2 - 0	Huddersfield Town	6
29 Feb 20	Finalizado	Hull City	0 - 4	Leeds United	29
26 Feb 20	Finalizado	Middlesbrough	0 - 1	Leeds United	9
22 Feb 20	Finalizado	Leeds United	1 - 0	Reading	9
15 Feb 20	Finalizado	Leeds United	1 - 0	Bristol City	27
11 Feb 20	Finalizado	Brentford	1 - 1	Leeds United	52
08 Feb 20	Finalizado	Nottingham Forest	2 - 0	Leeds United	18
01 Feb 20	Finalizado	Leeds United	0 - 1	Wigan Athletic	24
28 Ene 20	Finalizado	Leeds United	3 - 2	Millwall	53
18 Ene 20	Finalizado	Queens Park Rangers	1 - 0	Leeds United	18
11 Ene 20	Finalizado	Leeds United	0 - 2	Sheffield Wednesday	26
01 Ene 20	Finalizado	West Bromwich Albion	1 - 1	Leeds United	45
29 Dic 19	Finalizado	Birmingham City	4 - 5	Leeds United	55
26 Dic 19	Finalizado	Leeds United	1 - 1	Preston North End	63
21 Dic 19	Finalizado	Fulham	2 - 1	Leeds United	13
14 Dic 19	Finalizado	Leeds United	3 - 3	Cardiff City	14
10 Dic 19	Finalizado	Leeds United	2 - 0	Hull City	23
07 Dic 19	Finalizado	Huddersfield Town	0 - 2	Leeds United	22
30 Nov 19	Finalizado	Leeds United	4 - 0	Middlesbrough	5
26 Nov 19	Finalizado	Reading	0 - 1	Leeds United	9
23 Nov 19	Finalizado	Luton Town	1 - 2	Leeds United	6
09 Nov 19	Finalizado	Leeds United	2 - 1	Blackburn Rovers	6
02 Nov 19	Finalizado	Leeds United	2 - 0	Queens Park Rangers	6
26 Oct 19	Finalizado	Sheffield Wednesday	0 - 0	Leeds United	7
22 Oct 19	Finalizado	Preston North End	1 - 1	Leeds United	12
19 Oct 19	Finalizado	Leeds United	1 - 0	Birmingham City	15
05 Oct 19	Finalizado	Millwall	2 - 1	Leeds United	6
01 Oct 19	Finalizado	Leeds United	1 - 0	West Bromwich Albion	27
28 Sep 19	Finalizado	Charlton Athletic	1 - 0	Leeds United	7
21 Sep 19	Finalizado	Leeds United	1 - 1	Derby County	28
15 Sep 19	Finalizado	Barnsley	0 - 2	Leeds United	16
31 Ago 19	Finalizado	Leeds United	0 - 1	Swansea City	26
24 Ago 19	Finalizado	Stoke City	0 - 3	Leeds United	8
21 Ago 19	Finalizado	Leeds United	1 - 0	Brentford	106
17 Ago 19	Finalizado	Wigan Athletic	0 - 2	Leeds United	8
10 Ago 19	Finalizado	Leeds United	1 - 1	Nottingham Forest	45
04 Ago 19	Finalizado	Bristol City	1 - 3	Leeds United	24

Partidos Amistosos »

27 Jul 19	Finalizado	Cagliari	1 - 1	Leeds United	1
27 Jul 19	Finalizado	Leeds United	3 - 2	Girona	22
24 Jul 19	Finalizado	Oxford United	0 - 0	Leeds United	0
~~22 Jul 19~~	Aplazado	Southend United	-	Leeds United	0
20 Jul 19	Finalizado	Western Sydney Wanderers	1 - 2	Leeds United	4
17 Jul 19	Finalizado	Manchester United	4 - 0	Leeds United	17
11 Jul 19	Finalizado	Guiseley	1 - 2	Leeds United	10
10 Jul 19	Finalizado	York City	0 - 5	Leeds United	2

Estadísticas

GOLEADORES

AMARILLAS

ROJAS

Plantilla del Leeds United Temporada 2019/2020

		Edad	Altura	Peso
Portero
25	Elia Caprile	22	191	74	-	-	-
1	Illan Meslier	24	197	75	-	-	-
13	Kiko Casilla	37	191	84	-	-	2
13	W. Huffer	25	191	78	-	-	-
Defensa
3	B. Douglas	34	176	69	-	-	-
33	B. Hosannah	25	175	68	-	-	-
5	Ben White	26	186	78	1	-	6
	C. Shaughnessy	27	191	74	-	-	-
	Cody Drameh	22	175	69	-	-	-
10	E. Alioski	32	171	63	6	-	8
28	G. Berardi	35	179	72	-	1	1
46	J. Shackelton	24	168	70	2	-	-
40	L. Davis	24	182	65	-	-	-
6	Liam Cooper	32	186	73	2	-	2
2	Luke Ayling	32	183	72	4	-	9
49	O. Casey	23	188	78	-	-	-
34	P. Struijk	24	190	75	-	-	1
15	S. Dallas	33	183	81	5	-	7
Centrocampista
4	Adam Forshaw	32	175	70	-	-	3
38	Alfie Mccalmont	24	175	63	-	-	-
48	J. Stevens	24	178	70	-	-	-
23	Kalvin Phillips	28	179	72	2	1	9
44	M. Bogusz	22	175	68	-	-	-
43	Mateusz Klich	33	183	68	6	-	8
	O. Bouy	30	181	72	-	-	-
19	P. Hernández	39	173	64	9	-	6
36	R. Gotts	24	177	71	-	-	-
Delantero
17	Hélder Costa	30	179	73	4	-	3
7	Ian Poveda	24	167	64	-	-	-
22	Jack Harrison	27	175	70	6	-	1
9	Patrick Bamford	30	185	71	16	-	4
11	Tyler Roberts	25	180	75	4	-	1

Noticias del Leeds United

Ver últimas noticias

Chilavert atizó a Bielsa por la crisis de Chile

BeSoccer - Lunes, 28 Octubre 2019

0 203

Marcelo Bielsa se manifestó durante la semana pasada a través de varios mensajes en favor de las manifestaciones en Chile. Chilavert, en contra, le acusó de estar "a favor de delincuentes".

Moyes podría esquivar el paro

BeSoccer - Jueves, 19 Noviembre 2015

0 700

El técnico inglés tendría ya una oferta de un club de la Championship para hacerse cargo de un proyecto con el objetivo del ascenso a la Premier.

Lewis Cook, en el punto de mira del United

Enrique Salvatierra - Martes, 17 Noviembre 2015

1 583

El jugador del Leeds es una de las promesas que más convence en Old Trafford para liderar una nueva camada de jugadores ingleses en los 'Diablos Rojos'.

Batalla campal en el Leeds-Eintracht de pretemporada

BeSoccer - Miércoles, 22 Julio 2015

6 3.922

Los disturbios producidos en el partido dejaron 5 personas heridas y 25 detenidos al término del encuentro 'amistoso' que ambos clubes disputaron en Austria.

El Leeds anuncia la suspensión del amistoso frente al Athletic en Austria

BeSoccer - Lunes, 22 Junio 2015

0 207

El Leeds United ha anunciado la suspensión del amistoso que le iba a enfrentar al Athletic Club el próximo 21 de julio en Austria debido a la previa de la Liga Europa que deberá disputar el equipo bilbaíno los días 30 de julio y 6 de agosto.

Ver más noticias del equipo»

Competiciones que juega

Championship

Pos	Equipos		Pts
1		Leeds United	93
2		West Bromwich Albion	83
3		Brentford	81
4		Fulham	81
5		Cardiff City	73
6		Swansea City	70
7		Nottingham Forest	70
8		Millwall	68
9		Preston North End	66
10		Derby County	64
11		Blackburn Rovers	63
12		Bristol City	63
13		Queens Park Rangers	58
14		Reading	56
15		Stoke City	56
16		Sheffield Wednesday	56
17		Middlesbrough	53
18		Huddersfield Town	51
19		Luton Town	51
20		Birmingham City	50
21		Barnsley	49
22		Charlton Athletic	48
23		Wigan Athletic	47
24		Hull City	45

	Ascenso : Leeds United, West Bromwich Albion
	Playoff Ascenso : Brentford, Fulham, Cardiff City, Swansea City
	Descenso : Charlton Athletic, Wigan Athletic, Hull City

RIVALES EN Championship

RIVALES EN EFL Cup

RIVALES EN FA Cup

USO DE MEMORIA

6,555,480 bytes

BENCHMARKS

Loading Time Base Classes	0.0021
Controller Execution Time ( Home / Category )	0.9153
Total Execution Time	0.9174

CADENA URL

/Leeds-United-Afc/2020

GET DATOS

$_GET['/Leeds-United-Afc/2020']

POST DATOS

No hay datos POST existentes

CONSULTAS (43)

0.0145	SELECT type FROM routes WHERE alias = 'leeds-united-afc'
0.0257	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 = 'Leeds-United-Afc' AND l.year = 2020 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.0153	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=1533 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150	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=1533 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=1533 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0148	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=1533 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0154	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=1533 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0173	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 = 50152
0.0194	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 = 49506
0.0149	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1533 AND type_rel = 2
0.0218	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1533 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0151	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 (734582,476,3378,22909,23414) ORDER BY n.cover_points DESC, update_date DESC
0.0192	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 = '1533' AND l.year = 2020 ORDER BY l.year DESC,cat.coefficient DESC
0.0179	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 = '1533' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0154	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 = 49880 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 = 50152 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0174	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 = 50579 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0155	(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 calendars2020 as c ON c.league_id = l.id WHERE (c.datateam1 = 1533 or c.datateam2 = 1533) AND l.year = 2020 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0175	(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 calendars2020 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 = 1533 or c.datateam2 = 1533) AND l.year = 2020 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0152	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2020 as c ON c.league_id = l.id INNER JOIN events2020 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 = 1533 or c.datateam2 = 1533) AND l.year = 2020)
0.0162	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=1533 AND l.year in (2019,2020,2021) ORDER BY l.id DESC, l.year DESC ;
0.0151	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 (58520,58495,57338,56547,49880,49674) 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.0163	SELECT count(id) as num_players from rel_players WHERE league_id = 57338 AND teamId = 1533
0.0192	SELECT count(id) as num_players from rel_players WHERE league_id = 49880 AND teamId = 1533
0.0160	SELECT count(id) as num_players from rel_players WHERE league_id = 58520 AND teamId = 1533
0.0158	SELECT count(id) as num_players from rel_players WHERE league_id = 58495 AND teamId = 1533
0.0156	SELECT count(id) as num_players from rel_players WHERE league_id = 49674 AND teamId = 1533
0.0445	SELECT count(id) as num_players from rel_players WHERE league_id = 56547 AND teamId = 1533
0.0160	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM* `tables2020` 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 = 49880 AND t.round = 46 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0153	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 = '1533' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '1533' and rp.type = 4
0.0147	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 = '1533' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 events2020 e ON e.player_id = p.id AND e.league_id = 49880 WHERE rp.league_id = 49880 AND rp.teamId = 1533 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.0186	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 events2020 e ON e.player_id = p.id AND e.league_id = 49880 WHERE rp.league_id = 49880 AND rp.teamId = 1533 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0214	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 events2020 e ON e.player_id = p.id AND e.league_id = 49880 WHERE rp.league_id = 49880 AND rp.teamId = 1533 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0190	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 = 1533 AND rp.league_id = 49880 AND l.year= 2020 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0151	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=6280368 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0146	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=6280368
0.0165	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 events2020 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6280368 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.0160	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 events2020 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6280368 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0178	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 events2020 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6280368 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0187	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 events2020 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6280368 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0189	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 events2020 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6280368 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC


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

Leeds United

Información sobre Leeds United

Información

Otros Datos

Internet

Opciones de envio

Datos del equipo

Información sobre el estadio

Histórico de participación

Partidos del Leeds United

Estadísticas

Plantilla del Leeds United Temporada 2019/2020

Noticias del Leeds United

Leeds United

Selecciona un equipo

Competiciones que juega

RIVALES EN Championship

RIVALES EN EFL Cup

RIVALES EN FA Cup