26 Jul 20	Finalizado	Leicester	0 - 2	Manchester United	208
19 Jul 20	Finalizado	Tottenham Hotspur	3 - 0	Leicester	164
16 Jul 20	Finalizado	Leicester	2 - 0	Sheffield United	87
12 Jul 20	Finalizado	AFC Bournemouth	4 - 1	Leicester	110
07 Jul 20	Finalizado	Arsenal	1 - 1	Leicester	181
04 Jul 20	Finalizado	Leicester	3 - 0	Crystal Palace	116
01 Jul 20	Finalizado	Everton	2 - 1	Leicester	91
23 Jun 20	Finalizado	Leicester	0 - 0	Brighton & Hove Albion	217
20 Jun 20	Finalizado	Watford	1 - 1	Leicester	109
09 Mar 20	Finalizado	Leicester	4 - 0	Aston Villa	124
28 Feb 20	Finalizado	Norwich City	1 - 0	Leicester	159
22 Feb 20	Finalizado	Leicester	0 - 1	Manchester City	124
14 Feb 20	Finalizado	Wolves	0 - 0	Leicester	179
01 Feb 20	Finalizado	Leicester	2 - 2	Chelsea	181
22 Ene 20	Finalizado	Leicester	4 - 1	West Ham	70
19 Ene 20	Finalizado	Burnley	2 - 1	Leicester	82
11 Ene 20	Finalizado	Leicester	1 - 2	Southampton	347
01 Ene 20	Finalizado	Newcastle	0 - 3	Leicester	65
28 Dic 19	Finalizado	West Ham	1 - 2	Leicester	155
26 Dic 19	Finalizado	Leicester	0 - 4	Liverpool	532
21 Dic 19	Finalizado	Manchester City	3 - 1	Leicester	126
14 Dic 19	Finalizado	Leicester	1 - 1	Norwich City	156
08 Dic 19	Finalizado	Aston Villa	1 - 4	Leicester	74
04 Dic 19	Finalizado	Leicester	2 - 0	Watford	211
01 Dic 19	Finalizado	Leicester	2 - 1	Everton	220
23 Nov 19	Finalizado	Brighton & Hove Albion	0 - 2	Leicester	64
09 Nov 19	Finalizado	Leicester	2 - 0	Arsenal	180
03 Nov 19	Finalizado	Crystal Palace	0 - 2	Leicester	86
25 Oct 19	Finalizado	Southampton	0 - 9	Leicester	332
19 Oct 19	Finalizado	Leicester	2 - 1	Burnley	36
05 Oct 19	Finalizado	Liverpool	2 - 1	Leicester	166
29 Sep 19	Finalizado	Leicester	5 - 0	Newcastle	59
21 Sep 19	Finalizado	Leicester	2 - 1	Tottenham Hotspur	253
14 Sep 19	Finalizado	Manchester United	1 - 0	Leicester	70
31 Ago 19	Finalizado	Leicester	3 - 1	AFC Bournemouth	22
24 Ago 19	Finalizado	Sheffield United	1 - 2	Leicester	47
18 Ago 19	Finalizado	Chelsea	1 - 1	Leicester	192
11 Ago 19	Finalizado	Leicester	0 - 0	Wolves	195

FA Cup »

28 Jun 20	Finalizado	Leicester	0 - 1	Chelsea	88
04 Mar 20	Finalizado	Leicester	1 - 0	Birmingham City	75
25 Ene 20	Finalizado	Brentford	0 - 1	Leicester	51
04 Ene 20	Finalizado	Leicester	2 - 0	Wigan Athletic	13

EFL Cup »

28 Ene 20	Finalizado	Aston Villa	2 - 1	Leicester	108
08 Ene 20	Finalizado	Leicester	1 - 1	Aston Villa	332
18 Dic 19	Finalizado	Everton	2 - 2	Leicester	58
29 Oct 19	Finalizado	Burton Albion	1 - 3	Leicester	10
24 Sep 19	Finalizado	Luton Town	0 - 4	Leicester	8
28 Ago 19	Finalizado	Newcastle	1 - 1	Leicester	42

Partidos Amistosos »

02 Ago 19	Finalizado	Leicester	2 - 1	Atalanta	78
27 Jul 19	Finalizado	Rotherham United	2 - 2	Leicester	0
27 Jul 19	Finalizado	Stoke City	1 - 2	Leicester	3
23 Jul 19	Finalizado	Cambridge United	0 - 3	Leicester	36
20 Jul 19	Finalizado	Cheltenham Town	1 - 2	Leicester	3
16 Jul 19	Finalizado	Scunthorpe United	0 - 1	Leicester	4

Estadísticas

GOLEADORES

AMARILLAS

ROJAS

Plantilla del Leicester Temporada 2019/2020

		Edad	Altura	Peso
Portero
12	Daniel Ward	30	191	88	-	-	-
35	E. Jakupovic	39	191	82	-	-	-
1	K. Schmeichel	37	189	89	-	-	2
Defensa
3	Ben Chilwell	27	180	76	3	-	3
28	C. Fuchs	38	186	82	-	-	-
4	C. Söyüncü	27	185	80	1	1	4
18	D. Amartey	29	186	76	-	-	-
39	Darnell Johnson	25	185	83	-	-	-
2	James Justin	26	183	71	-	-	1
6	Jonny Evans	36	188	77	1	1	8
56	Luke Thomas	22	181	68	-	-	-
11	M. Albrighton	34	175	67	-	-	2
29	R. Bennett	34	188	77	-	-	2
21	Ricardo Pereira	30	175	70	3	-	1
5	W. Morgan	40	185	93	-	-	-
Centrocampista
33	Bartosz Kapustka	27	179	72	-	-	-
26	Dennis Praet	29	181	78	1	-	2
20	H. Choudhury	26	178	64	1	1	4
10	J. Maddison	27	175	73	6	-	4
22	Matty James	32	181	73	-	-	-
24	N. Mendy	31	168	68	-	-	-
25	W. Ndidi	27	183	81	2	-	6
8	Y. Tielemans	26	177	72	3	-	2
Delantero
17	Ayoze	30	178	66	8	-	-
7	Demarai Gray	27	183	75	2	-	1
45	George Hirst	25	191	70	-	-	-
15	Harvey Barnes	26	182	66	6	-	-
9	Jamie Vardy	37	179	76	23	-	3
14	K. Iheanacho	27	185	77	5	-	1

Noticias del Leicester

Ver últimas noticias

La conexión Málaga-Mánchester que ha devuelto al Leicester a la Premier

Víctor Miralles - Sábado, 27 Abril 2024

0 594

Tras solo una temporada en el Championship, el Leicester City vuelve a ser de Premier League. El equipo de los ex malaguistas (y 'citizens') Enzo Maresca y Willy Caballero logró el ascenso matemático sin tener que jugar, ya que su perseguidor, el Leeds United, perdió con el QPR (4-0).

A Charles Aránguiz se lo rifan

BeSoccer - Miércoles, 29 Julio 2015

0 350

Leicester, Olympique de Marsella y Bayer son los equipos que están tratando de hacerse con el fichaje de Aránguiz.

A Cambiasso le salen dos pretendientes de la Premier

Isabel Ruiz - Miércoles, 22 Julio 2015

0 1.255

Cambiasso no va a renovar con el Leicester y otros equipos de la Premier ya se han interesado en él.

El Leicester confirma que negocia la vuelta del argentino Esteban Cambiasso

BeSoccer - Lunes, 20 Julio 2015

0 793

El director deportivo de Leicester City, el inglés Jon Rudkin, ha confirmado este lunes que el conjunto inglés está negociando con el centrocampista argentino Esteban Cambiasso su posible regreso al equipo de cara a la próxima temporada.

Ranieri regresa a la Premier para dirigir al Leicester City

BeSoccer - Martes, 14 Julio 2015

0 293

Los 'foxes' no tenían técnico para la próxima campaña después de la polémica destitución de Nigel Pearson, salvador del equipo la última temporada.

Ver más noticias del equipo»

Pos	Equipos	Pts
1		Liverpool	99
2		Manchester City	81
3		Manchester United	66
4		Chelsea	66
5		Leicester	62
6		Tottenham Hotspur	59
7		Wolves	59
8		Arsenal	56
9		Sheffield United	54
10		Burnley	54
11		Southampton	52
12		Everton	49
13		Newcastle	44
14		Crystal Palace	43
15		Brighton & Hove Albion	41
16		West Ham	39
17		Aston Villa	35
18		AFC Bournemouth	34
19		Watford	34
20		Norwich City	21

Pos

Equipos

Pts

Brighton & Hove Albion

	Champions League : Liverpool, Manchester City, Manchester United, Chelsea
	Europa League : Leicester
	Previa de Europa League : Tottenham Hotspur, Arsenal
	Descenso : AFC Bournemouth, Watford, Norwich City

Champions League : Liverpool, Manchester City, Manchester United, Chelsea

Europa League : Leicester

Previa de Europa League : Tottenham Hotspur, Arsenal

Descenso : AFC Bournemouth, Watford, Norwich City

USO DE MEMORIA

6,428,216 bytes

BENCHMARKS

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.6381
Total Execution Time	0.6400

CADENA URL

/Leicester-City-Fc/2020

GET DATOS

$_GET['/Leicester-City-Fc/2020']

POST DATOS

No hay datos POST existentes

CONSULTAS (32)

0.0156	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 = 'Leicester-City-Fc' 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.0127	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=1538 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128	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=1538 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130	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=1538 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0136	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=1538 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0132	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=1538 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1538 AND type_rel = 2
0.0305	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1538 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0138	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 (1312774,2482,3173,3443,4219) ORDER BY n.cover_points DESC, update_date DESC
0.0214	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 = '1538' AND l.year = 2020 ORDER BY l.year DESC,cat.coefficient DESC
0.0191	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 = '1538' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0131	(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 = 1538 or c.datateam2 = 1538) AND l.year = 2020 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0148	(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 = 1538 or c.datateam2 = 1538) AND l.year = 2020 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0132	(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 = 1538 or c.datateam2 = 1538) AND l.year = 2020)
0.0140	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=1538 AND l.year in (2019,2020,2021) ORDER BY l.id DESC, l.year DESC ;
0.0126	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 (60338,58520,58495,57338,56547) 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.0131	SELECT count(id) as num_players from rel_players WHERE league_id = 57338 AND teamId = 1538
0.0131	SELECT count(id) as num_players from rel_players WHERE league_id = 60338 AND teamId = 1538
0.0136	SELECT count(id) as num_players from rel_players WHERE league_id = 58520 AND teamId = 1538
0.0134	SELECT count(id) as num_players from rel_players WHERE league_id = 58495 AND teamId = 1538
0.0272	SELECT count(id) as num_players from rel_players WHERE league_id = 56547 AND teamId = 1538
0.0151	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 = 49845 WHERE rp.league_id = 49845 AND rp.teamId = 1538 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.0149	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 = 49845 WHERE rp.league_id = 49845 AND rp.teamId = 1538 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0144	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 = 49845 WHERE rp.league_id = 49845 AND rp.teamId = 1538 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0141	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 = 1538 AND rp.league_id = 49845 AND l.year= 2020 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0139	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=6279986 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0132	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=6279986
0.0168	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=6279986 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.0170	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=6279986 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0149	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=6279986 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0157	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=6279986 AND (e.action = 22) 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=6279986 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC

Leicester

Información sobre Leicester

Información

Otros Datos

Internet

Opciones de envio

Datos del equipo

Información sobre el estadio

Histórico de participación

Championship

FA Cup

Premier League

EFL Cup

Partidos Amistosos

Europa League Grupo 3

Community Shield

Champions League Grupo 0

Championship - Play Offs Ascenso

Conference League Grupo 0

League One

EFL Trophy

International Champions Cup Grupo 1

Trofeo Premier League Asia

Recopa de Europa

Partidos del Leicester

Estadísticas

Plantilla del Leicester Temporada 2019/2020

Noticias del Leicester

La conexión Málaga-Mánchester que ha devuelto al Leicester a la Premier

A Charles Aránguiz se lo rifan

A Cambiasso le salen dos pretendientes de la Premier

El Leicester confirma que negocia la vuelta del argentino Esteban Cambiasso

Ranieri regresa a la Premier para dirigir al Leicester City

Leicester

Selecciona un equipo

Competiciones que juega

Premier League

RIVALES EN EFL Cup

RIVALES EN FA Cup

RIVALES EN Premier League