15 May 16	Finalizado	Chelsea	1 - 1	Leicester	407
07 May 16	Finalizado	Leicester	3 - 1	Everton	518
01 May 16	Finalizado	Manchester United	1 - 1	Leicester	1743
24 Abr 16	Finalizado	Leicester	4 - 0	Swansea City	513
17 Abr 16	Finalizado	Leicester	2 - 2	West Ham	977
10 Abr 16	Finalizado	Sunderland	0 - 2	Leicester	654
03 Abr 16	Finalizado	Leicester	1 - 0	Southampton	580
19 Mar 16	Finalizado	Crystal Palace	0 - 1	Leicester	306
14 Mar 16	Finalizado	Leicester	1 - 0	Newcastle	950
05 Mar 16	Finalizado	Watford	0 - 1	Leicester	326
01 Mar 16	Finalizado	Leicester	2 - 2	West Bromwich Albion	1073
27 Feb 16	Finalizado	Leicester	1 - 0	Norwich City	213
14 Feb 16	Finalizado	Arsenal	2 - 1	Leicester	1405
06 Feb 16	Finalizado	Manchester City	1 - 3	Leicester	1213
02 Feb 16	Finalizado	Leicester	2 - 0	Liverpool	891
23 Ene 16	Finalizado	Leicester	3 - 0	Stoke City	146
16 Ene 16	Finalizado	Aston Villa	1 - 1	Leicester	376
13 Ene 16	Finalizado	Tottenham Hotspur	0 - 1	Leicester	245
02 Ene 16	Finalizado	Leicester	0 - 0	AFC Bournemouth	371
29 Dic 15	Finalizado	Leicester	0 - 0	Manchester City	1778
26 Dic 15	Finalizado	Liverpool	1 - 0	Leicester	707
19 Dic 15	Finalizado	Everton	2 - 3	Leicester	509
14 Dic 15	Finalizado	Leicester	2 - 1	Chelsea	2251
05 Dic 15	Finalizado	Swansea City	0 - 3	Leicester	449
28 Nov 15	Finalizado	Leicester	1 - 1	Manchester United	828
21 Nov 15	Finalizado	Newcastle	0 - 3	Leicester	134
07 Nov 15	Finalizado	Leicester	2 - 1	Watford	143
31 Oct 15	Finalizado	West Bromwich Albion	2 - 3	Leicester	119
24 Oct 15	Finalizado	Leicester	1 - 0	Crystal Palace	163
17 Oct 15	Finalizado	Southampton	2 - 2	Leicester	164
03 Oct 15	Finalizado	Norwich City	1 - 2	Leicester	46
26 Sep 15	Finalizado	Leicester	2 - 5	Arsenal	234
19 Sep 15	Finalizado	Stoke City	2 - 2	Leicester	197
13 Sep 15	Finalizado	Leicester	3 - 2	Aston Villa	158
29 Ago 15	Finalizado	AFC Bournemouth	1 - 1	Leicester	132
22 Ago 15	Finalizado	Leicester	1 - 1	Tottenham Hotspur	194
15 Ago 15	Finalizado	West Ham	1 - 2	Leicester	154
08 Ago 15	Finalizado	Leicester	4 - 2	Sunderland	181

FA Cup »

	20 Ene 16	Finalizado	Leicester	0 - 2	Tottenham Hotspur			223
	10 Ene 16	Finalizado	Tottenham Hotspur	2 - 2	Leicester			105

EFL Cup »

27 Oct 15	Finalizado	Hull City	1 - 1	Leicester	123
22 Sep 15	Finalizado	Leicester	2 - 1	West Ham	49
25 Ago 15	Finalizado	Bury	1 - 4	Leicester	5

Partidos Amistosos »

01 Ago 15	Finalizado	Birmingham City	2 - 3	Leicester	1
29 Jul 15	Finalizado	Rotherham United	1 - 2	Leicester	1
28 Jul 15	Finalizado	Burton Albion	1 - 2	Leicester	1
25 Jul 15	Finalizado	Mansfield Town	1 - 1	Leicester	0
21 Jul 15	Finalizado	Lincoln City	1 - 3	Leicester	0

Estadísticas

GOLEADORES

AMARILLAS

ROJAS

Plantilla del Leicester Temporada 2015/2016

		Edad	Altura	Peso
Portero
	Ben Hamer	36	193	78	-	-	-
	Daniel Iversen	26	191	80	-	-	-
41	J. Maddison	29	189	81	-	-	-
1	K. Schmeichel	37	189	89	-	-	2
32	M. Schwarzer	51	194	85	-	-	-
Defensa
30	Ben Chilwell	27	180	76	-	-	-
28	C. Fuchs	38	186	82	-	-	4
13	D. Amartey	29	186	76	-	-	-
17	D. Simpson	37	177	77	-	1	5
15	Jeffrey Schlupp	31	178	72	1	-	4
	Liam Moore	31	186	86	-	-	-
11	M. Albrighton	34	175	67	2	-	4
27	M. Wasilewski	43	186	88	-	-	2
6	Robert Huth	39	191	88	3	-	8
5	W. Morgan	40	185	93	2	-	3
Centrocampista
10	A. King	35	184	74	2	-	2
4	Danny Drinkwater	34	177	70	2	1	5
33	Gokhan Inler	39	183	77	-	-	-
	Matty James	32	181	73	-	-	-
14	N. Kanté	33	171	68	1	-	3
Delantero
22	Demarai Gray	27	183	75	-	-	-
	Faiq Bolkiah	25	175	69	-	-	-
36	J. Dodoo	28	183	70	-	-	-
9	Jamie Vardy	37	179	76	24	1	7
23	L. Ulloa	37	185	75	6	-	-
24	N. Dyer	36	165	57	1	-	1
26	R. Mahrez	33	179	61	17	-	1
20	S. Okazaki	38	175	70	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 12.246

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		Leicester	81
2		Arsenal	71
3		Tottenham Hotspur	70
4		Manchester City	66
5		Manchester United	66
6		Southampton	63
7		West Ham	62
8		Liverpool	60
9		Stoke City	51
10		Chelsea	50
11		Everton	47
12		Swansea City	47
13		Watford	45
14		West Bromwich Albion	43
15		Crystal Palace	42
16		AFC Bournemouth	42
17		Sunderland	39
18		Newcastle	37
19		Norwich City	34
20		Aston Villa	17

Pos

Equipos

Pts

	Champions League : Leicester, Arsenal, Tottenham Hotspur
	Previa de Champions : Manchester City
	Europa League : Manchester United, Southampton, West Ham
	Descenso : Newcastle, Norwich City, Aston Villa

Champions League : Leicester, Arsenal, Tottenham Hotspur

Previa de Champions : Manchester City

Europa League : Manchester United, Southampton, West Ham

Descenso : Newcastle, Norwich City, Aston Villa

USO DE MEMORIA

6,365,456 bytes

BENCHMARKS

Loading Time Base Classes	0.0020
Controller Execution Time ( Home / Category )	0.2269
Total Execution Time	0.2289

CADENA URL

/leicester-city-fc/2016

GET DATOS

$_GET['/leicester-city-fc/2016']

POST DATOS

No hay datos POST existentes

CONSULTAS (35)

0.0057	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 = 2016 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.0020	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.0020	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.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=1538 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	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.0019	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.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1538 AND type_rel = 2
0.0053	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.0025	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.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 = '1538' AND l.year = 2016 ORDER BY l.year DESC,cat.coefficient DESC
0.0039	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.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 calendars2016 as c ON c.league_id = l.id WHERE (c.datateam1 = 1538 or c.datateam2 = 1538) AND l.year = 2016 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0031	(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 calendars2016 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 = 2016 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0034	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2016 as c ON c.league_id = l.id INNER JOIN events2016 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 = 2016)
0.0048	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 (2015,2016,2017) ORDER BY l.id DESC, l.year DESC ;
0.0022	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 (38655,38619,37540,33979,33348,30386,29314,22265) 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.0024	SELECT count(id) as num_players from rel_players WHERE league_id = 29314 AND teamId = 1538
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 37540 AND teamId = 1538
0.0044	SELECT count(id) as num_players from rel_players WHERE league_id = 33979 AND teamId = 1538
0.0029	SELECT count(id) as num_players from rel_players WHERE league_id = 33348 AND teamId = 1538
0.0019	SELECT count(id) as num_players from rel_players WHERE league_id = 38619 AND teamId = 1538
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 22265 AND teamId = 1538
0.0102	SELECT count(id) as num_players from rel_players WHERE league_id = 30386 AND teamId = 1538
0.0029	SELECT count(id) as num_players from rel_players WHERE league_id = 38655 AND teamId = 1538
0.0075	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 events2016 e ON e.player_id = p.id AND e.league_id = 15131 WHERE rp.league_id = 15131 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.0060	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 events2016 e ON e.player_id = p.id AND e.league_id = 15131 WHERE rp.league_id = 15131 AND rp.teamId = 1538 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0046	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 events2016 e ON e.player_id = p.id AND e.league_id = 15131 WHERE rp.league_id = 15131 AND rp.teamId = 1538 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028	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 = 15131 AND l.year= 2016 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0032	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=210919 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0023	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=210919
0.0055	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 events2016 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=210919 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.0051	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 events2016 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=210919 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0041	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 events2016 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=210919 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0048	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 events2016 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=210919 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0055	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 events2016 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=210919 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 7

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 2015/2016

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