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

Resultados de Fútbol

Leicester

Entrenador: Enzo Maresca

Temporada 2023/2024

TEMPORADA 2023/2024

CHAMPIONSHIP
Equipo		PJ	GF	GC	Puntos
1	Leicester	44	86	39	94
2	Leeds United	44	80	37	90
3	Ipswich Town	43	85	53	89
4	Southampton	44	85	61	84
5	West	44	67	44	72
6	Norwich City	44	77	61	72
7	Hull City	43	62	54	66
8	Coventry	42	66	52	63
9	Middlesbroug	44	64	60	63
10	Preston	44	56	61	63
11	Cardiff City	44	50	61	62
12	Bristol City	44	51	47	59
13	Sunderland	44	52	51	56
14	Swansea City	44	57	62	56
15	Watford	44	59	58	53
16	Millwall	44	43	55	53
17	Stoke City	44	44	60	50
18	Queens Park	44	41	57	50
19	Blackburn	44	58	74	49
20	Plymouth	44	58	69	48
21	Sheffield	44	39	68	47
22	Birmingham	44	48	64	46
23	Huddersfield	44	47	74	44
24	Rotherham	44	32	85	24

TEMPORADA 2022/2023

PREMIER LEAGUE
Equipo		PJ	GF	GC	Puntos
1	Manchester	38	94	33	89
2	Arsenal	38	88	43	84
3	Manchester	38	58	43	75
4	Newcastle	38	68	33	71
5	Liverpool	38	75	47	67
6	Brighton	38	72	53	62
7	Aston Villa	38	51	46	61
8	Tottenham	38	70	63	60
9	Brentford	38	58	46	59
10	Fulham	38	55	53	52
11	Crystal	38	40	49	45
12	Chelsea	38	38	47	44
13	Wolves	38	31	58	41
14	West Ham	38	42	55	40
15	Bournemouth	38	37	71	39
16	Nottingham	38	38	68	38
17	Everton	38	34	57	36
18	Leicester	38	51	68	34
19	Leeds United	38	48	78	31
20	Southampton	38	36	73	25

TEMPORADA 2021/2022

PREMIER LEAGUE
Equipo		PJ	GF	GC	Puntos
1	Manchester	38	99	26	93
2	Liverpool	38	94	26	92
3	Chelsea	38	76	33	74
4	Tottenham	38	69	40	71
5	Arsenal	38	61	48	69
6	Manchester	38	57	57	58
7	West Ham	38	60	51	56
8	Leicester	38	62	59	52
9	Brighton	38	42	44	51
10	Wolves	38	38	43	51
11	Newcastle	38	44	62	49
12	Crystal	38	50	46	48
13	Brentford	38	48	56	46
14	Aston Villa	38	52	54	45
15	Southampton	38	43	67	40
16	Everton	38	43	66	39
17	Leeds United	38	42	79	38
18	Burnley	38	34	53	35
19	Watford	38	34	77	23
20	Norwich City	38	23	84	22

TEMPORADA 2020/2021

PREMIER LEAGUE
Equipo		PJ	GF	GC	Puntos
1	Manchester	38	83	32	86
2	Manchester	38	73	44	74
3	Liverpool	38	68	42	69
4	Chelsea	38	58	36	67
5	Leicester	38	68	50	66
6	West Ham	38	62	47	65
7	Tottenham	38	68	45	62
8	Arsenal	38	55	39	61
9	Leeds United	38	62	54	59
10	Everton	38	47	48	59
11	Aston Villa	38	55	46	55
12	Newcastle	38	46	62	45
13	Wolves	38	36	52	45
14	Crystal	38	41	66	44
15	Southampton	38	47	68	43
16	Brighton	38	40	46	41
17	Burnley	38	33	55	39
18	Fulham	38	27	53	28
19	West	38	35	76	26
20	Sheffield	38	20	63	23

TEMPORADA 2019/2020

PREMIER LEAGUE
Equipo		PJ	GF	GC	Puntos
1	Liverpool	38	85	33	99
2	Manchester	38	102	35	81
3	Manchester	38	66	36	66
4	Chelsea	38	69	54	66
5	Leicester	38	67	41	62
6	Tottenham	38	61	47	59
7	Wolves	38	51	40	59
8	Arsenal	38	56	48	56
9	Sheffield	38	39	39	54
10	Burnley	38	43	50	54
11	Southampton	38	51	60	52
12	Everton	38	44	56	49
13	Newcastle	38	38	58	44
14	Crystal	38	31	50	43
15	Brighton	38	39	54	41
16	West Ham	38	49	62	39
17	Aston Villa	38	41	67	35
18	Bournemouth	38	40	65	34
19	Watford	38	36	64	34
20	Norwich City	38	26	75	21

TEMPORADA 2018/2019

PREMIER LEAGUE
Equipo		PJ	GF	GC	Puntos
1	Manchester	38	95	23	98
2	Liverpool	38	89	22	97
3	Chelsea	38	63	39	72
4	Tottenham	38	67	39	71
5	Arsenal	38	73	51	70
6	Manchester	38	65	54	66
7	Wolves	38	47	46	57
8	Everton	38	54	46	54
9	Leicester	38	51	48	52
10	West Ham	38	52	55	52
11	Watford	38	52	59	50
12	Crystal	38	51	53	49
13	Newcastle	38	42	48	45
14	Bournemouth	38	56	70	45
15	Burnley	38	45	68	40
16	Southampton	38	45	65	39
17	Brighton	38	35	60	36
18	Cardiff City	38	34	69	34
19	Fulham	38	34	81	26
20	Huddersfield	38	22	76	16

TEMPORADA 2017/2018

PREMIER LEAGUE
Equipo		PJ	GF	GC	Puntos
1	Manchester	38	106	27	100
2	Manchester	38	68	28	81
3	Tottenham	38	74	36	77
4	Liverpool	38	84	38	75
5	Chelsea	38	62	38	70
6	Arsenal	38	74	51	63
7	Burnley	38	36	39	54
8	Everton	38	44	58	49
9	Leicester	38	56	60	47
10	Newcastle	38	39	47	44
11	Crystal	38	45	55	44
12	Bournemouth	38	45	61	44
13	West Ham	38	48	68	42
14	Watford	38	44	64	41
15	Brighton	38	34	54	40
16	Huddersfield	38	28	58	37
17	Southampton	38	37	56	36
18	Swansea City	38	28	56	33
19	Stoke City	38	35	68	33
20	West	38	31	56	31

TEMPORADA 2016/2017

PREMIER LEAGUE
Equipo		PJ	GF	GC	Puntos
1	Chelsea	38	85	33	93
2	Tottenham	38	86	26	86
3	Manchester	38	80	39	78
4	Liverpool	38	78	42	76
5	Arsenal	38	77	44	75
6	Manchester	38	54	29	69
7	Everton	38	62	44	61
8	Southampton	38	41	48	46
9	Bournemouth	38	55	67	46
10	West	38	43	51	45
11	West Ham	38	47	64	45
12	Leicester	38	48	63	44
13	Stoke City	38	41	56	44
14	Crystal	38	50	63	41
15	Swansea City	38	45	70	41
16	Burnley	38	39	55	40
17	Watford	38	40	68	40
18	Hull City	38	37	80	34
19	Middlesbroug	38	27	53	28
20	Sunderland	38	29	69	24

TEMPORADA 2015/2016

PREMIER LEAGUE
Equipo		PJ	GF	GC	Puntos
1	Leicester	38	68	36	81
2	Arsenal	38	65	36	71
3	Tottenham	38	69	35	70
4	Manchester	38	71	41	66
5	Manchester	38	49	35	66
6	Southampton	38	59	41	63
7	West Ham	38	65	51	62
8	Liverpool	38	63	50	60
9	Stoke City	38	41	55	51
10	Chelsea	38	59	53	50
11	Everton	38	59	55	47
12	Swansea City	38	42	52	47
13	Watford	38	40	50	45
14	West	38	34	48	43
15	Crystal	38	39	51	42
16	Bournemouth	38	45	67	42
17	Sunderland	38	48	62	39
18	Newcastle	38	44	65	37
19	Norwich City	38	39	67	34
20	Aston Villa	38	27	76	17

TEMPORADA 2014/2015

PREMIER LEAGUE
Equipo		PJ	GF	GC	Puntos
1	Chelsea	38	73	32	87
2	Manchester	38	83	38	79
3	Arsenal	38	71	36	75
4	Manchester	38	62	37	70
5	Tottenham	38	58	53	64
6	Liverpool	38	52	48	62
7	Southampton	38	54	33	60
8	Swansea City	38	46	49	56
9	Stoke City	38	48	45	54
10	Crystal	38	47	51	48
11	Everton	38	48	50	47
12	West Ham	38	44	47	47
13	West	38	38	51	44
14	Leicester	38	46	55	41
15	Newcastle	38	40	63	39
16	Sunderland	38	31	53	38
17	Aston Villa	38	31	57	38
18	Hull City	38	33	51	35
19	Burnley	38	28	53	33
20	Queens Park	38	42	73	30

TEMPORADA 2013/2014

CHAMPIONSHIP
Equipo		PJ	GF	GC	Puntos
1	Leicester	46	83	43	102
2	Burnley	46	72	37	93
3	Derby County	46	84	52	85
4	Queens Park	46	60	44	80
5	Wigan	46	61	48	73
6	Brighton	46	55	40	72
7	Reading	46	70	56	71
8	Blackburn	46	70	62	70
9	Ipswich Town	46	60	54	68
10	Bournemouth	46	67	66	66
11	Nottingham	46	67	64	65
12	Middlesbroug	46	62	50	64
13	Watford	46	74	64	60
14	Bolton	46	59	60	59
15	Leeds United	46	59	67	57
16	Sheffield	46	63	65	53
17	Huddersfield	46	58	65	53
18	Charlton	46	41	61	51
19	Millwall	46	46	74	48
20	Blackpool	46	38	66	46
21	Birmingham	46	58	74	44
22	Doncaster	46	39	70	44
23	Barnsley	46	44	77	39
24	Yeovil Town	46	44	75	37

TEMPORADA 2012/2013

CHAMPIONSHIP
Equipo		PJ	GF	GC	Puntos
1	Cardiff City	46	72	45	87
2	Hull City	46	61	52	79
3	Watford	46	85	58	77
4	Brighton	46	69	43	75
5	Crystal	46	73	62	72
6	Leicester	46	71	48	68
7	Bolton	46	69	61	68
8	Nottingham	46	63	59	67
9	Charlton	46	65	59	65
10	Derby County	46	65	62	61
11	Burnley	46	62	60	61
12	Birmingham	46	63	69	61
13	Leeds United	46	57	66	61
14	Ipswich Town	46	48	61	60
15	Blackpool	46	62	63	59
16	Middlesbroug	46	61	70	59
17	Blackburn	46	55	62	58
18	Sheffield	46	53	61	58
19	Huddersfield	46	53	73	58
20	Millwall	46	51	62	56
21	Barnsley	46	56	70	55
22	Peterborough	46	66	75	54
23	Wolves	46	55	69	51
24	Bristol City	46	59	84	41

TEMPORADA 2011/2012

CHAMPIONSHIP
Equipo		PJ	GF	GC	Puntos
1	Reading	46	69	41	89
2	Southampton	46	85	46	88
3	West Ham	46	81	48	86
4	Birmingham	46	78	51	76
5	Blackpool	46	79	59	75
6	Cardiff City	46	66	53	75
7	Middlesbroug	46	52	51	70
8	Hull City	46	47	44	68
9	Leicester	46	66	55	66
10	Brighton	46	52	52	66
11	Watford	46	56	64	64
12	Derby County	46	50	58	64
13	Burnley	46	61	58	62
14	Leeds United	46	65	68	61
15	Ipswich Town	46	69	77	61
16	Millwall	46	55	57	57
17	Crystal	46	46	51	56
18	Portsmouth	46	50	59	50
19	Peterborough	46	67	77	50
20	Nottingham	46	48	63	50
21	Bristol City	46	44	68	49
22	Barnsley	46	49	74	48
23	Coventry	46	41	65	40
24	Doncaster	46	43	80	36

TEMPORADA 2010/2011

CHAMPIONSHIP
Equipo		PJ	GF	GC	Puntos
1	Queens Park	46	71	32	88
2	Norwich City	46	83	58	84
3	Swansea City	46	69	42	80
4	Cardiff City	46	76	54	80
5	Reading	46	77	51	77
6	Nottingham	46	69	50	75
7	Leeds United	46	81	70	72
8	Burnley	46	65	61	68
9	Millwall	46	62	48	67
10	Leicester	46	76	71	67
11	Hull City	46	52	51	65
12	Middlesbroug	46	68	68	62
13	Ipswich Town	46	62	68	62
14	Watford	46	77	71	61
15	Bristol City	46	62	65	60
16	Portsmouth	46	53	60	58
17	Barnsley	46	55	66	56
18	Coventry	46	54	58	55
19	Derby County	46	58	71	49
20	Crystal	46	44	69	48
21	Doncaster	46	55	81	48
22	Preston	46	54	79	42
23	Sheffield	46	44	79	42
24	Scunthorpe	46	43	87	42

TEMPORADA 2009/2010

CHAMPIONSHIP
Equipo		PJ	GF	GC	Puntos
1	Newcastle	46	90	35	102
2	West	46	89	48	91
3	Nottingham	46	65	40	79
4	Cardiff City	46	73	54	76
5	Leicester	46	61	45	76
6	Blackpool	46	74	58	70
7	Swansea City	46	40	37	69
8	Sheffield	46	62	55	65
9	Reading	46	68	63	63
10	Bristol City	46	56	65	63
11	Middlesbroug	46	58	50	62
12	Doncaster	46	59	58	60
13	Crystal	46	50	53	59
14	Queens Park	46	58	65	57
15	Derby County	46	53	63	56
16	Ipswich Town	46	50	61	56
17	Watford	46	61	68	54
18	Preston	46	58	73	54
19	Barnsley	46	53	69	54
20	Coventry	46	47	64	54
21	Scunthorpe	46	62	84	52
22	Sheffield	46	49	69	47
23	Plymouth	46	43	68	41
24	Peterborough	46	46	80	34

TEMPORADA 2008/2009

LEAGUE ONE
Equipo		PJ	GF	GC	Puntos
1	Leicester	46	84	39	96
2	Peterborough	46	78	54	89
3	Milton	46	83	47	87
4	Leeds United	46	77	49	84
5	Millwall	46	63	53	82
6	Scunthorpe	46	82	63	76
7	Tranmere	46	62	49	74
8	Southend	46	58	61	71
9	Huddersfield	46	62	65	68
10	Oldham	46	66	65	65
11	Bristol	46	79	61	63
12	Colchester	46	58	58	63
13	Walsall	46	61	66	61
14	Stockport	46	59	57	60
15	Leyton	46	45	57	56
16	Swindon Town	46	68	71	53
17	Brighton	46	55	70	52
18	Yeovil Town	46	41	66	51
19	Hartlepool	46	66	79	50
20	Carlisle	46	56	69	50
21	Northampton	46	61	65	49
22	Crewe	46	59	82	46
23	Cheltenham	46	51	91	39
24	Hereford	46	42	79	34

TEMPORADA 2007/2008

CHAMPIONSHIP
Equipo		PJ	GF	GC	Puntos
1	West	46	88	55	81
2	Stoke City	46	69	55	79
3	Hull City	46	65	47	75
4	Bristol City	46	54	53	74
5	Crystal	46	58	42	71
6	Watford	46	62	56	70
7	Wolves	46	53	48	70
8	Ipswich Town	46	65	56	69
9	Sheffield	46	56	51	66
10	Plymouth	46	60	50	64
11	Charlton	46	63	58	64
12	Cardiff City	46	59	55	64
13	Burnley	46	60	67	62
14	Queens Park	46	60	66	58
15	Preston	46	50	56	56
16	Sheffield	46	54	55	55
17	Norwich City	46	49	59	55
18	Barnsley	46	52	65	55
19	Blackpool	46	59	64	54
20	Southampton	46	56	72	54
21	Coventry	46	52	64	53
22	Leicester	46	42	45	52
23	Scunthorpe	46	46	69	46
24	Colchester	46	62	86	38

TEMPORADA 2006/2007

CHAMPIONSHIP
Equipo		PJ	GF	GC	Puntos
1	Sunderland	46	76	47	88
2	Birmingham	46	67	42	86
3	Derby County	46	62	46	84
4	West	46	81	55	76
5	Wolves	46	59	56	76
6	Southampton	46	77	53	75
7	Preston	46	64	53	74
8	Stoke City	46	62	41	73
9	Sheffield	46	70	66	71
10	Colchester	46	70	56	69
11	Plymouth	46	63	62	67
12	Crystal	46	59	51	65
13	Cardiff City	46	57	53	64
14	Ipswich Town	46	64	59	62
15	Burnley	46	52	49	57
16	Norwich City	46	56	71	57
17	Coventry	46	47	62	56
18	Queens Park	46	54	68	53
19	Leicester	46	49	64	53
20	Barnsley	46	53	85	50
21	Hull City	46	51	67	49
22	Leeds United	46	46	72	46
23	Southend	46	47	80	42
24	Luton Town	46	53	81	40

TEMPORADA 2005/2006

CHAMPIONSHIP
Equipo		PJ	GF	GC	Puntos
1	Reading	46	99	32	106
2	Sheffield	46	76	46	90
3	Watford	46	77	53	81
4	Preston	46	59	30	80
5	Leeds United	46	57	38	78
6	Crystal	46	67	48	75
7	Wolves	46	50	42	67
8	Coventry	46	62	65	63
9	Norwich City	46	56	65	62
10	Luton Town	46	66	67	61
11	Cardiff City	46	58	59	60
12	Southampton	46	49	50	58
13	Stoke City	46	54	63	58
14	Plymouth	46	39	46	56
15	Ipswich Town	46	53	66	56
16	Leicester	46	51	59	54
17	Burnley	46	46	54	54
18	Hull City	46	49	55	52
19	Sheffield	46	39	52	52
20	Derby County	46	53	67	50
21	Queens Park	46	50	65	50
22	Crewe	46	57	86	42
23	Millwall	46	35	62	40
24	Brighton	46	39	71	38

TEMPORADA 2004/2005

CHAMPIONSHIP
Equipo		PJ	GF	GC	Puntos
1	Sunderland	46	76	41	94
2	Wigan	46	79	35	87
3	Ipswich Town	46	85	56	85
4	Derby County	46	71	60	76
5	Preston	46	67	58	75
6	West Ham	46	66	56	73
7	Reading	46	51	44	70
8	Sheffield	46	57	56	67
9	Wolves	46	72	59	66
10	Millwall	46	51	45	66
11	Queens Park	46	54	58	62
12	Stoke City	46	36	38	61
13	Burnley	46	38	39	60
14	Leeds United	46	49	52	60
15	Leicester	46	49	46	57
16	Cardiff City	46	48	51	54
17	Plymouth	46	52	64	53
18	Watford	46	52	59	52
19	Coventry	46	61	73	52
20	Brighton	46	40	65	51
21	Crewe	46	66	86	50
22	Gillingham	46	45	66	50
23	Nottingham	46	42	66	44
24	Rotherham	46	35	69	29

Competiciones que juega

Championship

Pos	Equipos		Pts
1		Leicester	94
2		Leeds United	90
3		Ipswich Town	89
4		Southampton	84
5		West Bromwich Albion	72
6		Norwich City	72
7		Hull City	66
8		Coventry City	63
9		Middlesbrough	63
10		Preston North End	63
11		Cardiff City	62
12		Bristol City	59
13		Sunderland	56
14		Swansea City	56
15		Watford	53
16		Millwall	53
17		Stoke City	50
18		Queens Park Rangers	50
19		Blackburn Rovers	49
20		Plymouth Argyle	48
21		Sheffield Wednesday	47
22		Birmingham City	46
23		Huddersfield Town	44
24		Rotherham United	24

	Ascenso : Leicester, Leeds United
	Playoff Ascenso : Ipswich Town, Southampton, West Bromwich Albion, Norwich City
	Descenso : Birmingham City, Huddersfield Town, Rotherham United

RIVALES EN Championship

RIVALES EN EFL Cup

RIVALES EN FA Cup

USO DE MEMORIA

9,380,568 bytes

BENCHMARKS

Loading Time Base Classes	0.0014
Controller Execution Time ( Home / Category )	0.4827
Total Execution Time	0.4841

CADENA URL

/historico/Leicester-City-Fc

GET DATOS

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

POST DATOS

No hay datos POST existentes

CONSULTAS (24)

0.0126	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1538 AND type_rel = 2
0.0193	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.0133	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 (1312316,1312289,1312186,3173,3443) ORDER BY n.cover_points DESC, update_date DESC
0.0155	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.0128	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 = 72033 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0141	SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 1538 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0254	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2023` 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 = 67672 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0139	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2022` 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 = 62729 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2021` 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 = 57338 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId 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 = 49845 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2019` 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 = 43543 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0137	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2018` 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 = 38633 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2017` 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 = 29314 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0156	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2016` 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 = 15131 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2015` 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 = 3773 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId 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 team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2013` 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 = 1919 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2011` 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 = 1070 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2010` 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 = 879 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2009` 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 = 442 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2008` 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 = 156 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2007` 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 = 155 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2006` 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 = 154 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128	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 = 72033 ORDER BY nameShow LIMIT 100


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

Resultados de Fútbol

Leicester

Leicester

Selecciona un equipo

Competiciones que juega

Championship

RIVALES EN Championship

RIVALES EN EFL Cup

RIVALES EN FA Cup