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

Leek Town

Temporada 2023/2024

TEMPORADA 2023/2024

NON LEAGUE DIVISION 1 GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Leek Town	38	85	44	78
2	Runcorn	38	63	39	68
3	Prescot	38	59	41	67
4	Bootle FC	37	60	43	66
5	Witton	38	65	59	63
6	City	37	67	47	60
7	Clitheroe	38	69	56	58
8	Avro	38	49	43	58
9	Nantwich	38	61	47	57
10	Chasetown	38	52	50	56
11	Widnes	37	57	43	54
12	Stalybridge	38	56	59	53
13	Hanley Town	38	37	46	47
14	Newcastle	38	44	51	45
15	Mossley	38	43	56	45
16	Vauxhall	38	51	73	44
17	Kidsgrove	37	56	71	39
18	Trafford	38	40	57	39
19	Hednesford	38	44	68	32
20	1874	38	24	89	18

TEMPORADA 2022/2023

NON LEAGUE DIVISION 1 GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Macclesfield	38	95	27	90
2	Leek Town	38	70	38	76
3	Workington	38	71	39	75
4	Clitheroe	38	70	50	64
5	Runcorn	38	58	38	63
6	Witton	38	61	50	59
7	Mossley	38	58	49	58
8	Prescot	38	51	50	53
9	Kidsgrove	38	49	55	51
10	Trafford	38	51	55	50
11	Skelmersdale	38	58	74	48
12	City	38	50	59	46
13	Bootle FC	38	51	61	46
14	1874	38	44	50	45
15	Newcastle	38	39	67	45
16	Hanley Town	38	50	61	44
17	Widnes	38	40	66	44
18	Glossop	38	44	58	39
19	Colne FC	38	38	57	37
20	Ramsbottom	38	38	82	24

TEMPORADA 2021/2022

NON LEAGUE DIVISION 1 GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Warrington	38	93	36	85
2	Workington	38	72	27	84
3	Leek Town	38	74	36	79
4	Marine	38	63	40	77
5	Runcorn	38	72	39	76
6	Clitheroe	38	78	44	71
7	Bootle FC	38	76	63	62
8	Mossley	38	60	59	57
9	City	38	48	51	53
10	Kidsgrove	38	51	53	50
11	Trafford	38	56	55	49
12	1874	38	59	58	47
13	Widnes	38	46	45	47
14	Colne FC	38	39	54	44
15	Ramsbottom	38	47	62	42
16	Newcastle	38	49	64	40
17	Glossop	38	36	55	40
18	Prescot	38	49	70	39
19	Kendal Town	38	28	90	12
20	Market	38	21	116	12

TEMPORADA 2020/2021

NON LEAGUE DIVISION 1 GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Belper Town	0	0	0	0
2	Frickley	0	0	0	0
3	Glossop	0	0	0	0
4	Ilkeston	0	0	0	0
5	Kidsgrove	0	0	0	0
6	Lincoln	0	0	0	0
7	Loughborough	0	0	0	0
8	Sheffield	0	0	0	0
9	Sutton	0	0	0	0
10	Market	0	0	0	0
11	Worksop Town	0	0	0	0
12	Carlton Town	0	0	0	0
13	Chasetown	0	0	0	0
14	Cleethorpes	0	0	0	0
15	Leek Town	0	0	0	0
16	Newcastle	0	0	0	0
17	Spalding	0	0	0	0
18	Stamford	0	0	0	0
19	Stocksbridge	0	0	0	0
20	Wisbech Town	0	0	0	0

TEMPORADA 2019/2020

NON LEAGUE DIVISION 1 GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Leek Town	28	64	19	72
2	Stamford	29	74	27	70
3	Cleethorpes	29	67	40	57
4	Belper Town	26	44	29	49
5	Carlton Town	25	51	33	45
6	Frickley	30	47	42	45
7	Sutton	28	45	34	44
8	Stocksbridge	29	48	45	44
9	Ilkeston	31	50	48	42
10	Kidsgrove	27	42	31	39
11	Loughborough	29	43	45	39
12	Worksop Town	31	41	54	38
13	Sheffield	26	48	45	37
14	Spalding	28	32	46	32
15	Glossop	29	30	44	30
16	Chasetown	29	36	51	29
17	Newcastle	30	42	55	28
18	Lincoln	29	30	60	27
19	Market	30	34	85	20
20	Wisbech Town	29	29	64	18

TEMPORADA 2018/2019

NON LEAGUE DIVISION 1 GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Atherton	38	89	34	82
2	Radcliffe	38	73	34	75
3	Leek Town	38	78	34	74
4	Colne FC	38	71	44	73
5	Ramsbottom	38	78	41	72
6	Runcorn	38	69	50	72
7	Prescot	38	84	54	69
8	Mossley	38	66	51	65
9	Trafford	38	53	44	61
10	Kidsgrove	38	58	40	58
11	Colwyn Bay	38	73	66	52
12	Widnes	38	60	61	51
13	Chasetown	38	61	63	46
14	Droylsden	38	61	72	43
15	Newcastle	38	52	74	40
16	Market	37	53	90	40
17	Glossop	38	41	74	31
18	Clitheroe	38	45	88	28
19	Kendal Town	37	28	92	16
20	Skelmersdale	38	24	111	13

TEMPORADA 2017/2018

NON LEAGUE DIVISION 1 GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Basford	42	101	42	100
2	Frickley	42	117	61	85
3	Alvechurch	42	78	49	85
4	Bedworth	42	73	58	74
5	Chasetown	42	83	64	73
6	Stamford	42	66	34	71
7	Leek Town	42	80	50	68
8	Lincoln	42	85	81	68
9	Cleethorpes	42	82	57	67
10	Corby Town	42	74	75	60
11	Stocksbridge	42	75	66	53
12	Peterborough	42	70	78	51
13	Spalding	42	52	62	50
14	Loughborough	42	61	78	49
15	Sheffield	42	66	85	45
16	Belper Town	42	46	90	45
17	Gresley	42	49	91	43
18	Kidsgrove	42	70	90	42
19	Carlton Town	42	66	76	41
20	Newcastle	42	49	73	39
21	Market	42	51	97	39
22	Romulus	42	57	94	35

TEMPORADA 2016/2017

NON LEAGUE DIVISION 1 GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Shaw Lane A.	42	104	36	102
2	Witton	42	96	40	97
3	Spalding	42	74	42	79
4	Basford	42	78	53	73
5	Stocksbridge	42	67	50	73
6	Rushden	42	73	52	71
7	Newcastle	42	59	59	67
8	Lincoln	42	67	61	65
9	Leek Town	42	63	63	64
10	Belper Town	42	55	55	58
11	Bedworth	42	73	72	57
12	Kidsgrove	42	72	66	55
13	Romulus	42	65	75	51
14	Market	42	60	93	50
15	Stamford	42	61	76	49
16	Sheffield	42	62	60	48
17	Chasetown	42	64	75	47
18	Gresley	42	56	83	45
19	Carlton Town	42	48	68	42
20	Northwich	42	53	89	36
21	Loughborough	42	45	94	34
22	Rugby Town	42	44	77	30

TEMPORADA 2015/2016

NON LEAGUE DIVISION 1 GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Stafford	42	79	31	95
2	Shaw Lane A.	42	95	40	94
3	Coalville	42	81	46	85
4	Basford	42	67	42	76
5	Lincoln	42	70	46	74
6	Stocksbridge	42	72	53	69
7	Chasetown	42	68	49	68
8	Leek Town	42	61	56	63
9	Rugby Town	42	73	68	60
10	Romulus	42	76	74	60
11	Market	42	65	65	58
12	Spalding	42	52	54	56
13	Belper Town	42	66	65	54
14	Newcastle	42	65	68	53
15	Kidsgrove	42	81	78	50
16	Gresley	42	58	75	50
17	Sheffield	42	61	71	47
18	Carlton Town	42	60	72	47
19	Goole	42	51	87	38
20	Loughborough	42	60	108	35
21	Daventry	42	43	113	33
22	Tividale	42	52	95	26

TEMPORADA 2014/2015

NON LEAGUE DIVISION 1 GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Mickleover	42	105	40	98
2	Leek Town	42	91	37	91
3	Newcastle	42	92	46	87
4	Sutton	42	75	41	83
5	Gresley	42	96	51	81
6	Stafford	42	68	33	81
7	Spalding	42	84	41	79
8	Tividale	42	65	43	71
9	Lincoln	42	71	53	66
10	Coalville	42	76	71	61
11	Norton	42	79	75	61
12	Romulus	42	69	65	61
13	Chasetown	42	60	64	51
14	Loughborough	42	71	87	48
15	Sheffield	42	72	92	48
16	Goole	42	52	66	45
17	Stocksbridge	42	53	84	41
18	Carlton Town	42	52	79	39
19	Market	42	66	109	37
20	Kidsgrove	42	48	96	36
21	Rainworth	42	46	91	30
22	Brigg Town	42	26	153	12

TEMPORADA 2013/2014

NON LEAGUE DIVISION 1 GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Halesowen	40	80	38	91
2	Coalville	40	101	35	89
3	Leek Town	40	86	35	88
4	Belper Town	40	98	50	81
5	Mickleover	40	82	62	73
6	Sutton	40	74	52	64
7	Scarborough	40	73	57	61
8	Newcastle	40	66	65	59
9	Gresley	40	66	67	56
10	Carlton Town	40	58	55	55
11	Romulus	40	66	64	55
12	Chasetown	40	52	59	52
13	Goole	40	60	76	51
14	Loughborough	40	62	77	47
15	Rainworth	40	53	72	46
16	Sheffield	39	65	76	43
17	Lincoln	40	55	89	36
18	Brigg Town	40	49	94	35
19	Market	40	56	105	35
20	Bedworth	39	44	79	33
21	Kidsgrove	40	41	80	30
22	Eastwood	0	0	0	0

TEMPORADA 2012/2013

NON LEAGUE DIVISION 1 GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Kings Lynn.	42	86	46	92
2	Coalville	42	108	44	86
3	Belper Town	42	95	42	82
4	Stamford	42	97	58	76
5	Chasetown	42	83	51	74
6	Sutton	42	81	61	74
7	Halesowen	42	79	65	74
8	Northwich	42	88	58	67
9	Sheffield	42	85	82	63
10	Leek Town	42	72	60	59
11	Gresley	42	75	77	58
12	Carlton Town	42	67	68	56
13	Brigg Town	42	62	76	53
14	Rainworth	42	59	75	51
15	Market	42	68	78	50
16	Loughborough	42	75	75	49
17	Newcastle	42	45	58	46
18	Kidsgrove	42	75	89	43
19	Romulus	42	52	78	42
20	Lincoln	42	64	102	36
21	Mickleover	42	51	92	34
22	Hucknall	42	39	171	16

TEMPORADA 2011/2012

NON LEAGUE DIVISION 1 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Grantham	42	92	44	94
2	Carlton Town	42	101	52	83
3	Ilkeston	42	93	44	83
4	Sheffield	42	93	62	75
5	Leek Town	42	77	60	74
6	Belper Town	42	74	57	74
7	Stamford	42	77	75	68
8	Loughborough	42	80	61	65
9	New Mills	42	79	76	63
10	Goole	42	72	78	62
11	Hucknall	42	54	61	57
12	Sutton	42	72	63	55
13	Kidsgrove	42	62	59	55
14	Coalville	42	69	72	55
15	Newcastle	42	59	70	52
16	Market	42	61	84	47
17	Brigg Town	42	52	76	45
18	Lincoln	42	65	85	43
19	Rainworth	42	38	55	41
20	Romulus	42	56	85	36
21	Quorn	42	48	85	27
22	Shepshed	42	45	115	25

TEMPORADA 2010/2011

NON LEAGUE DIVISION 1 GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Barwell	42	84	46	94
2	Newcastle	42	104	48	90
3	Rushall	42	78	45	81
4	Brigg Town	42	74	58	80
5	Grantham	42	69	48	79
6	Sutton	42	89	60	75
7	Kidsgrove	42	88	59	75
8	Carlton Town	42	88	50	73
9	Glapwell	42	82	58	69
10	Romulus	42	71	65	67
11	Sheffield	42	73	86	55
12	Lincoln	42	70	77	54
13	Goole	42	79	93	54
14	Belper Town	42	70	74	53
15	Quorn	42	57	61	47
16	Leek Town	42	64	74	47
17	Loughborough	42	72	89	46
18	Market	42	67	91	44
19	Stamford	42	62	74	42
20	Rainworth	42	53	85	40
21	Shepshed	42	44	103	21
22	Spalding	42	33	127	16

TEMPORADA 2009/2010

NON LEAGUE DIVISION 1 GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Mickleover	42	93	51	89
2	Chasetown	42	78	42	82
3	Glapwell	42	73	42	81
4	Kidsgrove	42	93	50	78
5	Sheffield	42	74	50	73
6	Belper Town	42	83	55	71
7	Witton	42	76	53	67
8	Leek Town	42	68	61	67
9	Carlton Town	42	74	68	66
10	Stamford	42	77	54	64
11	Grantham	42	62	56	62
12	Rushall	42	68	61	59
13	Market	42	71	81	53
14	Loughborough	42	70	80	53
15	Brigg Town	42	60	77	52
16	Cammell	42	51	66	50
17	Shepshed	42	44	55	48
18	Goole	42	70	84	46
19	Lincoln	42	57	67	44
20	Quorn	42	55	78	40
21	Spalding	42	33	111	20
22	Willenhall	42	21	109	19

TEMPORADA 2008/2009

NON LEAGUE DIVISION 1 GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Retford	38	88	34	81
2	Belper Town	37	78	36	81
3	Stocksbridge	38	92	44	75
4	Rushall	38	63	42	68
5	Glapwell	38	78	58	68
6	Carlton Town	37	78	49	67
7	Stamford	38	65	51	61
8	Shepshed	38	61	61	56
9	Leek Town	38	63	60	54
10	Lincoln	39	58	69	51
11	Sheffield	38	67	69	50
12	Quorn	38	54	63	48
13	Grantham	38	49	65	47
14	Loughborough	38	45	58	46
15	Goole	38	62	85	44
16	Kidsgrove	38	49	62	41
17	Spalding	39	45	82	40
18	Willenhall	38	55	74	38
19	Gresley	38	41	78	25
20	Brigg Town	38	41	92	14

TEMPORADA 2007/2008

NON LEAGUE PREMIER GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Witton	40	85	25	92
2	Fleetwood	38	78	37	87
3	Gateshead	38	85	42	79
4	Eastwood	39	58	44	66
5	Buxton	37	55	43	65
6	Guiseley	40	63	43	64
7	Marine	39	67	63	58
8	Hednesford	39	62	64	53
9	North	41	59	80	49
10	Worksop Town	39	56	62	48
11	Kendal Town	39	60	68	47
12	Ashton	39	60	71	45
13	Matlock Town	39	53	65	45
14	Frickley	38	49	63	45
15	Ilkeston	40	66	72	44
16	Leek Town	39	53	65	44
17	Ossett Town	40	48	60	44
18	Prescot	38	45	57	44
19	Whitby Town	39	64	75	43
20	Stamford	39	57	83	43
21	Lincoln	40	44	85	29

TEMPORADA 2006/2007

NON LEAGUE PREMIER GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Burscough	41	79	36	80
2	Witton	42	90	48	80
3	Telford	42	72	40	78
4	Marine	42	70	53	74
5	Matlock Town	42	70	43	72
6	Guiseley	41	70	48	68
7	Hednesford	42	49	41	68
8	Ossett Town	43	65	52	67
9	Fleetwood	42	71	60	67
10	Gateshead	42	75	57	65
11	Whitby Town	42	63	78	60
12	Ilkeston	42	66	62	59
13	North	42	54	61	54
14	Prescot	42	52	56	53
15	Lincoln	42	40	58	51
16	Frickley	42	50	69	49
17	Leek Town	42	49	61	48
18	Ashton	42	52	72	48
19	Kendal Town	42	59	79	47
20	Mossley	42	48	79	35
21	Radcliffe	43	39	75	32
22	Grantham	42	39	94	17

TEMPORADA 2005/2006

NON LEAGUE PREMIER GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Blyth	43	84	32	92
2	Frickley	42	73	36	86
3	Marine	42	61	25	81
4	Farsley	42	84	34	79
5	North	42	77	54	73
6	Whitby Town	41	59	57	64
7	Witton	42	67	53	60
8	Burscough	41	62	63	60
9	Telford	42	54	52	59
10	Ossett Town	42	57	61	58
11	Matlock Town	41	57	54	56
12	Leek Town	42	50	53	56
13	Prescot	42	49	60	53
14	Guiseley	41	45	58	51
15	Ashton	42	62	63	49
16	Ilkeston	42	48	51	49
17	Gateshead	41	50	75	45
18	Radcliffe	42	54	62	44
19	Lincoln	41	42	61	43
20	Wakefield	42	38	69	42
21	Bradford	42	63	86	39
22	Runcorn	43	36	113	29

TEMPORADA 2004/2005

NON LEAGUE PREMIER GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Workington	43	75	31	88
2	Hyde	42	80	43	86
3	Farsley	42	81	41	83
4	Whitby Town	41	63	47	79
5	Burscough	42	93	74	70
6	Guiseley	43	74	65	64
7	Prescot	41	61	53	64
8	Witton	41	54	42	61
9	Radcliffe	43	61	64	60
10	Leek Town	41	62	50	59
11	Matlock Town	43	60	69	55
12	Wakefield	42	60	67	52
13	Blyth	41	51	55	49
14	Lincoln	41	53	64	47
15	Marine	42	53	60	46
16	Ossett Town	42	53	62	46
17	Spennymoor	42	44	65	46
18	Gateshead	42	61	84	45
19	Frickley	42	44	57	44
20	Bishop	42	51	74	40
21	Bamber	42	48	92	34
22	Bridlington	42	43	66	33

Competiciones que juega

Grupo 6

Non League Division 1 Grupo 6

Pos	Equipos		Pts
1		Leek Town	78
2		Runcorn Linnets	68
3		Prescot Cables	67
4		Bootle FC	66
5		Witton Albion	63
6		City of Liverpool	60
7		Clitheroe	58
8		Avro	58
9		Nantwich Town	57
10		Chasetown	56
11		Widnes	54
12		Stalybridge Celtic	53
13		Hanley Town	47
14		Newcastle Town	45
15		Mossley	45
16		Vauxhall Motors	44
17		Kidsgrove Athletic	39
18		Trafford	39
19		Hednesford Town	32
20		1874 Northwich	18

	Ascenso : Leek Town
	Playoff Ascenso : Runcorn Linnets, Prescot Cables, Bootle FC, Witton Albion
	Descenso : Hednesford Town, 1874 Northwich

RIVALES EN FA Cup

RIVALES EN FA Trophy

RIVALES EN Non League Divis.

USO DE MEMORIA

8,823,000 bytes

BENCHMARKS

Loading Time Base Classes	0.0015
Controller Execution Time ( Home / Category )	0.1997
Total Execution Time	0.2012

CADENA URL

/historico/Leek-Town

GET DATOS

$_GET['/historico/Leek-Town']

POST DATOS

No hay datos POST existentes

CONSULTAS (50)

0.0030	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 = 'Leek-Town' AND l.year = 2024 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=10815 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=10815 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0017	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=10815 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=10815 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=10815 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0040	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 = 72984
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=10815 AND type_rel = 2
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=565 AND type_rel = 3
0.0020	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 565 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0023	SELECT /53 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 (1222282,1006257,894718,815160,813452) ORDER BY n.cover_points DESC, update_date DESC
0.0028	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 = '10815' ORDER BY l.year DESC,cat.coefficient DESC
0.0023	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 = '10815' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0025	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 = '10815' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021	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 = 72984 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023	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=10815 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019	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 (72984,72728,72677,71432) 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.0019	SELECT count(id) as num_players from rel_players WHERE league_id = 72984 AND teamId = 10815
0.0019	SELECT count(id) as num_players from rel_players WHERE league_id = 72728 AND teamId = 10815
0.0019	SELECT count(id) as num_players from rel_players WHERE league_id = 72677 AND teamId = 10815
0.0019	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 10815
0.0025	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM* `tables2024` 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 = 72984 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0022	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 = '10815' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '10815' and rp.type = 4
0.0021	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 = '10815' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0021	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 events2024 e ON e.player_id = p.id AND e.league_id = 72984 WHERE rp.league_id = 72984 AND rp.teamId = 10815 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.0020	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 events2024 e ON e.player_id = p.id AND e.league_id = 72984 WHERE rp.league_id = 72984 AND rp.teamId = 10815 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0020	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 events2024 e ON e.player_id = p.id AND e.league_id = 72984 WHERE rp.league_id = 72984 AND rp.teamId = 10815 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028	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 = 10815 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0026	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* `tables2024` 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 = 72984 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.0027	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 = 68459 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.0027	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 = 63533 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.0027	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 = 58743 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.0030	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 = 50970 AND t.round = 31 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034	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 = 44462 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0040	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 = 39171 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0043	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 = 33757 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0044	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 = 15618 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0047	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 = 4170 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0053	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 = 3493 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0055	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 = 24868 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0051	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* `tables2012` 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 = 24882 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0040	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 = 24908 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0035	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 = 24918 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030	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 = 25007 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031	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 = 24400 AND t.round = 41 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031	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 = 24385 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0035	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 = 24378 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034	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* `tables2005` 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 = 24370 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	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 = 72984 ORDER BY nameShow LIMIT 100

Leek Town

Leek Town

Selecciona un equipo

Competiciones que juega

Non League Division 1 Grupo 6

RIVALES EN FA Cup

RIVALES EN FA Trophy

RIVALES EN Non League Divis.