Burnley

Entrenador: Vincent Kompany

Temporada 2000/2001

Información sobre Burnley

Enviar Datos

Información

Nombre del equipo Burnley
Nombre completo Burnley Football Club
Nombre corto BUR
País Inglaterra
Ciudad Burnley
Entrenador Vincent Kompany
URL del equipo en RF //m.resultados-futbol.com/Burnley-Fc

Otros Datos

Año de Fundación 1882
Presupuesto 10000000
Patrocinador Spreadex Sports
Marca de Ropa Umbro
Socios 12000

Internet

Sitio Web www.burnleyfootballclub.com
Twitter principal @BurnleyOfficial

Información sobre el estadio

Nombre del estadio Turf Moor
Capacidad 22546
Dirección Harry Potts Way
Teléfono +44 (870) 443 1882
Fax +44 (1282) 700 014
Año de construcción 1883
Tamaño 103x56

Histórico de participación

FA Cup

64 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, 1985, 1984, 1983, 1979, 1977, 1974, 1970, 1969, 1962, 1961, 1960, 1959, 1957, 1953, 1952, 1950, 1947, 1935, 1933, 1924, 1914, 1913, 1911, 1909, 1902, 1901, 1898, 1896)

Premier League

60 veces

(2024, 2022, 2021, 2020, 2019, 2018, 2017, 2015, 2010, 1976, 1975, 1974, 1971, 1970, 1969, 1968, 1967, 1966, 1965, 1964, 1963, 1962, 1961, 1960, 1959, 1958, 1957, 1956, 1955, 1954, 1953, 1952, 1951, 1950, 1949, 1948, 1930, 1929, 1928, 1927, 1926, 1925, 1924, 1923, 1922, 1921, 1920, 1915, 1914, 1900, 1899, 1897, 1896, 1895, 1894, 1893, 1892, 1891, 1890, 1889)

Championship

48 veces

(2023, 2016, 2014, 2013, 2012, 2011, 2009, 2008, 2007, 2006, 2005, 2004, 2003, 2002, 2001, 1995, 1983, 1980, 1979, 1978, 1977, 1973, 1972, 1947, 1940, 1939, 1938, 1937, 1936, 1935, 1934, 1933, 1932, 1931, 1913, 1912, 1911, 1910, 1909, 1908, 1907, 1906, 1905, 1904, 1903, 1902, 1901, 1898)

Partidos Amistosos

12 veces

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

League One

6 veces

(2000, 1999, 1998, 1997, 1996, 1994)

Fase Previa Europa League Grupo 4

3 veces

(2019, 2019, 2019)

Championship - Play Offs Ascenso

1 vez

(2009)

Partidos del Burnley

Ir al LIVESCORE

FA Cup »

	23 Ene 01	Finalizado	Scunthorpe United	1 - 1	Burnley			0
	06 Ene 01	Finalizado	Burnley	2 - 2	Scunthorpe United			0

EFL Cup »

26 Sep 00	Finalizado	Crystal Palace	1 - 1	Burnley
19 Sep 00	Finalizado	Burnley	2 - 2	Crystal Palace
05 Sep 00	Finalizado	Hartlepool United	3 - 2	Burnley
22 Ago 00	Finalizado	Burnley	4 - 1	Hartlepool United

Championship »

06 May 01	Finalizado	Burnley	2 - 0	Watford
28 Abr 01	Finalizado	Sheffield United	2 - 0	Burnley
24 Abr 01	Finalizado	Burnley	2 - 1	Tranmere Rovers
21 Abr 01	Finalizado	Burnley	0 - 0	Birmingham City
16 Abr 01	Finalizado	Norwich City	2 - 3	Burnley
14 Abr 01	Finalizado	Burnley	1 - 1	West Bromwich Albion
10 Abr 01	Finalizado	Wimbledon FC	0 - 2	Burnley
06 Abr 01	Finalizado	Burnley	3 - 0	Preston North End
01 Abr 01	Finalizado	Blackburn Rovers	5 - 0	Burnley
24 Mar 01	Finalizado	Burnley	2 - 1	Queens Park Rangers
17 Mar 01	Finalizado	Sheffield Wednesday	2 - 0	Burnley
13 Mar 01	Finalizado	Watford	0 - 1	Burnley
06 Mar 01	Finalizado	Stockport County	0 - 0	Burnley
03 Mar 01	Finalizado	Portsmouth	2 - 0	Burnley
24 Feb 01	Finalizado	Burnley	1 - 0	Huddersfield Town
20 Feb 01	Finalizado	Burnley	2 - 1	Fulham
17 Feb 01	Finalizado	Grimsby Town	1 - 0	Burnley
10 Feb 01	Finalizado	Burnley	1 - 2	Crystal Palace
03 Feb 01	Finalizado	Crewe Alexandra	4 - 2	Burnley
20 Ene 01	Finalizado	Burnley	2 - 1	Barnsley
13 Ene 01	Finalizado	Gillingham	0 - 0	Burnley
01 Ene 01	Finalizado	Burnley	1 - 2	Wolves
26 Dic 00	Finalizado	Barnsley	1 - 0	Burnley
23 Dic 00	Finalizado	Burnley	0 - 2	Bolton Wanderers
17 Dic 00	Finalizado	Burnley	0 - 2	Blackburn Rovers
09 Dic 00	Finalizado	Preston North End	2 - 1	Burnley
02 Dic 00	Finalizado	Burnley	1 - 0	Nottingham Forest
21 Nov 00	Finalizado	Burnley	2 - 0	Norwich City
18 Nov 00	Finalizado	Birmingham City	3 - 2	Burnley
11 Nov 00	Finalizado	Burnley	2 - 0	Sheffield United
04 Nov 00	Finalizado	West Bromwich Albion	1 - 1	Burnley
31 Oct 00	Finalizado	Burnley	1 - 0	Crewe Alexandra
25 Oct 00	Finalizado	Nottingham Forest	5 - 0	Burnley
21 Oct 00	Finalizado	Queens Park Rangers	0 - 1	Burnley
17 Oct 00	Finalizado	Burnley	1 - 0	Sheffield Wednesday
14 Oct 00	Finalizado	Burnley	2 - 1	Stockport County
06 Oct 00	Finalizado	Tranmere Rovers	2 - 3	Burnley
30 Sep 00	Finalizado	Burnley	1 - 1	Portsmouth
23 Sep 00	Finalizado	Huddersfield Town	0 - 1	Burnley
16 Sep 00	Finalizado	Burnley	1 - 1	Grimsby Town
12 Sep 00	Finalizado	Fulham	3 - 1	Burnley
09 Sep 00	Finalizado	Crystal Palace	0 - 1	Burnley
28 Ago 00	Finalizado	Burnley	1 - 1	Gillingham
26 Ago 00	Finalizado	Wolves	1 - 0	Burnley
19 Ago 00	Finalizado	Burnley	1 - 0	Wimbledon FC
12 Ago 00	Finalizado	Bolton Wanderers	1 - 1	Burnley

Estadísticas

GOLEADORES

AMARILLAS

Ball12

ROJAS

Ball2

Briscoe1

Micky Mellon1

I. Thomas-Moore1

Plantilla del Burnley Temporada 2000/2001

		Edad	Altura	Peso
Portero
	Nikos Michopoulos	54	-	-	-	-	-
	Paul Crichton	55	183	77	-	-	-
Defensa
	Briscoe	48	180	76	-	1	-
	Chris Brass	48	175	73	-	-	-
	Dean West	51	178	73	-	-	-
	Ian Cox	53	-	-	1	-	4
	Mitchell Thomas	59	188	76	-	-	7
	Paul Weller	49	173	70	3	-	9
Centrocampista
	Ball	59	179	78	2	2	12
	Bradley Maylett	43	173	65	-	-	-
	Gordon Armstrong	56	183	81	-	-	2
15	Graham Branch	52	188	76	5	-	7
	Leonard Johnrose	54	180	79	1	-	3
	Micky Mellon	52	178	81	1	1	9
	Paul Cook	57	180	70	3	-	5
	Steve Davis	55	188	92	5	-	8
Delantero
	Andrew Cooke	50	183	79	2	-	3
	Andy Payton	56	177	68	9	-	1
	Anthony Shandran	42	175	80	-	-	-
	G. Little	48	191	83	3	-	2
	G. Taylor	51	-	-	4	-	3
	I. Thomas-Moore	47	180	77	12	1	7
	Mullin	48	183	72	3	-	2
	P. Gray	55	-	-	1	-	-
	Paul Smith	48	180	71	1	-	4
	Robinson	45	178	69	-	-	2
	Ronnie Jepson	60	186	83	-	-	-

Noticias del Burnley

Ver últimas noticias

Horarios y partidos de la jornada 36 de Premier League 2023-24

BeSoccer - Miércoles, 01 Mayo 2024

3 44.418

La Premier League sigue su transcurso de partidos y con la trigésimo sexta jornada de encuentros se esperan una cantidad importante de duelos emocionantes, cosa a la que ya nos acostumbra este torneo. Encuentra aquí los días y horarios de Premier League.

Otra vez el Onana héroe-villano, otra vez el United mediocre

BeSoccer - Sábado, 27 Abril 2024

0 8.177

André Onana fue el culpable de que el Burnley llegase a la recta final a cero, pero también fue el responsable del penalti que le dio un punto a los visitantes. El Manchester United no pasó del 1-1 en Old Trafford frente a un rival que lucha por no descender y se complica la 6ª posición.

Oxlade, Alexis y Giroud en el ataque de un Arsenal que se mide al Burnley con Vokes y Gray arriba

Miguel Moreno - Sábado, 30 Enero 2016

0 965

Ya se conocen las alineaciones del Arsenal-Burnley que se disputa hoy en la FA Cup.

Paul Robinson, nuevo refuerzo del Burnley hasta final de temporada

BeSoccer - Martes, 26 Enero 2016

0 304

El guardameta Paul Robinson, libre desde que salió del Blackburn Rovers, es el nuevo refuerzo del Burnley hasta final de temporada.

Long seguirá un año más en el Barnsley

BeSoccer - Jueves, 21 Enero 2016

0 136

Kevin Long seguirá en el Barnsley hasta el 30 de enero de 2017 tras la ampliación de contrato de su cesión.

Ver más noticias del equipo»

Pos	Equipos	Pts
1		Fulham	101
2		Blackburn Rovers	91
3		Bolton Wanderers	87
4		Preston North End	78
5		Birmingham City	78
6		West Bromwich Albion	74
7		Burnley	72
8		Wimbledon FC	69
9		Watford	69
10		Sheffield United	68
11		Nottingham Forest	68
12		Wolves	55
13		Gillingham	55
14		Crewe Alexandra	55
15		Norwich City	54
16		Barnsley	54
17		Sheffield Wednesday	53
18		Grimsby Town	52
19		Stockport County	51
20		Portsmouth	49
21		Crystal Palace	49
22		Huddersfield Town	48
23		Queens Park Rangers	40
24		Tranmere Rovers	38

Pos

Equipos

Pts

101

USO DE MEMORIA

6,277,536 bytes

BENCHMARKS

Loading Time Base Classes	0.0018
Controller Execution Time ( Home / Category )	0.1661
Total Execution Time	0.1679

CADENA URL

/Burnley-Fc/2001

GET DATOS

$_GET['/Burnley-Fc/2001']

POST DATOS

No hay datos POST existentes

CONSULTAS (34)

0.0051	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 = 'Burnley-Fc' AND l.year = 2001 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.0018	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=569 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=569 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=569 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=569 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0024	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 = 14436
0.0023	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 = 23228
0.0043	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 = '569' AND l.year = 2001 ORDER BY l.year DESC,cat.coefficient DESC
0.0036	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 = '569' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019	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 = 467 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022	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 = 23228 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023	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 = 14436 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024	(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 calendars2001 as c ON c.league_id = l.id WHERE (c.datateam1 = 569 or c.datateam2 = 569) AND l.year = 2001 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0030	(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 calendars2001 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 = 569 or c.datateam2 = 569) AND l.year = 2001 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0028	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2001 as c ON c.league_id = l.id INNER JOIN events2001 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 = 569 or c.datateam2 = 569) AND l.year = 2001)
0.0035	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=569 AND l.year in (2000,2001,2002) ORDER BY l.id DESC, l.year DESC ;
0.0018	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 (23230,14442,484,467) 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.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 467 AND teamId = 569
0.0017	SELECT count(id) as num_players from rel_players WHERE league_id = 484 AND teamId = 569
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 14442 AND teamId = 569
0.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 23230 AND teamId = 569
0.0038	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM* `tables2001` 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 = 467 AND t.round = 46 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0032	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 events2001 e ON e.player_id = p.id AND e.league_id = 467 WHERE rp.league_id = 467 AND rp.teamId = 569 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.0029	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 events2001 e ON e.player_id = p.id AND e.league_id = 467 WHERE rp.league_id = 467 AND rp.teamId = 569 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028	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 events2001 e ON e.player_id = p.id AND e.league_id = 467 WHERE rp.league_id = 467 AND rp.teamId = 569 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023	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 = 569 AND rp.league_id = 467 AND l.year= 2001 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0022	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=14349 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0018	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=14349
0.0025	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 events2001 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=14349 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.0026	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 events2001 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=14349 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0026	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 events2001 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=14349 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0023	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 events2001 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=14349 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0024	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 events2001 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=14349 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC
0.0019	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 = 467 ORDER BY nameShow LIMIT 100

Burnley

Información sobre Burnley

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

League One

Community Shield

Fase Previa Europa League Grupo 4

Champions League

Championship - Play Offs Ascenso

Copa de Ferias

Partidos del Burnley

Estadísticas

Plantilla del Burnley Temporada 2000/2001

Noticias del Burnley

Horarios y partidos de la jornada 36 de Premier League 2023-24

Otra vez el Onana héroe-villano, otra vez el United mediocre

Oxlade, Alexis y Giroud en el ataque de un Arsenal que se mide al Burnley con Vokes y Gray arriba

Paul Robinson, nuevo refuerzo del Burnley hasta final de temporada

Long seguirá un año más en el Barnsley

Burnley

Selecciona un equipo

Competiciones que juega

Championship

RIVALES EN Championship

RIVALES EN EFL Cup

RIVALES EN FA Cup