Has elegido rechazar las cookies basadas en consentimiento que utilizamos principalmente para gestionar la publicidad y las recomendaciones de contenido.

En adelante, para aceder a nuestra web tienes que elegir alguna de las siguientes opciones.

Has cambiado de idea y quieres
NAVEGAR GRATIS Y CON PUBLICIDAD...

Navega por besoccer.com y resultados-futbol.com con publicidad personalizada, seguimiento y cookies de forma gratuita.

Optar por esta opción te permitirá mantener tu experiencia de navegación como hasta ahora. Al aceptar las cookies y tecnologías similares, estás dando tu consentimiento para que recopilemos y utilicemos tu información de navegación con el propósito de adaptar la publicidad y la personalización según tus intereses. La presencia de esta publicidad es crucial para continuar proporcionando contenido de calidad, sevicios eficientes a los usuarios y mejorar la experiencia general de uso.

Nosotros y nuestros socios hacemos el siguiente tratamiento de datos: almacenamiento y acceso a información de geolocalización con propósitos de publicidad dirigida, almacenamiento y acceso a información de geolocalización para realizar estudios de mercado, almacenar o acceder a información en un dispositivo, analizar activamente las características del dispositivo para su identificación, compartir tus análisis de navegación y grupos de interés con terceros, crear un perfil para la personalización de contenidos, crear un perfil publicitario personalizado, desarrollar y mejorar productos, enriquecer el perfil con información de terceros, medir el rendimiento de los anuncios, medir el rendimiento del contenido, seleccionar anuncios básicos, seleccionar anuncios personalizados, seleccionar contenido personalizado, utilizar datos de localización geográfica precisa, utilizar estudios de mercado a fin de generar información sobre el público.

Aceptar y continuar gratis

...O sigues prefiriendo rechazar las cookies y entonces
CONTINÚA REGISTRÁNDOTE Y SUSCRIBIÉNDOTE

Navega por besoccer.com y resultados-futbol.com sin publicidad ni seguimiento suscribiéndote a nuestra web por 0,50 € al día.

Además de abonar la suscripción, es necesario realizar un registro previo para acceder. El mismo perfil de usuario es compartido entre los sitios besoccer.com y resultados-futbol.com

Accede por 0,50 € al día

Para saber más, consulta nuestra Política de Cookies.

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

North Leigh

Temporada 2023/2024

TEMPORADA 2023/2024

NON LEAGUE DIVISION 1 GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Biggleswade	34	69	38	66
2	Bedford Town	34	72	37	63
3	Ware	34	67	55	59
4	Waltham	35	67	53	58
5	Dunstable	34	71	65	58
6	Welwyn	34	76	73	53
7	Cirencester	34	60	42	51
8	Stotfold FC	34	61	55	49
9	Hadley	33	59	55	49
10	Kings	35	71	71	48
11	Biggleswade	32	58	54	44
12	North Leigh	33	52	70	43
13	Leighton	34	51	59	42
14	Barton	34	53	59	41
15	Hertford	33	51	66	41
16	Kidlington	34	46	59	40
17	Aylesbury	33	57	69	39
18	Thame United	34	46	67	34
19	Kempston	34	35	75	29

TEMPORADA 2022/2023

NON LEAGUE PREMIER GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Weston-super	42	89	32	93
2	Bracknell	42	100	53	90
3	Truro City	42	88	41	89
4	Poole Town	42	86	51	80
5	Chesham	42	88	57	79
6	Swindon	42	88	66	77
7	Hayes	42	80	58	71
8	Metropolitan	42	61	59	61
9	Merthyr Town	42	73	64	60
10	Plymouth	42	63	62	58
11	Beaconsfield	42	75	73	57
12	Tiverton	42	62	77	55
13	Dorchester	42	57	79	54
14	Hanwell Town	42	55	65	50
15	Salisbury	42	55	71	49
16	Winchester	42	56	72	48
17	Gosport	42	58	78	47
18	Hendon	42	55	81	38
19	Harrow	42	44	80	37
20	North Leigh	42	50	86	34
21	Yate Town	42	50	92	34
22	Hartley	42	40	76	32

TEMPORADA 2021/2022

NON LEAGUE DIVISION 1 GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Bedford Town	38	100	28	91
2	Berkhamsted	38	64	29	81
3	Dunstable	38	64	33	73
4	Ware	38	90	47	71
5	Welwyn	38	80	48	71
6	North Leigh	38	69	42	68
7	Harlow Town	38	71	49	61
8	Thame United	38	64	45	60
9	Biggleswade	38	62	56	60
10	Neots Town	38	57	53	53
11	Waltham	38	64	64	52
12	FC Romania	38	71	83	48
13	Didcot Town	38	50	69	47
14	Aylesbury	38	64	70	43
15	Barton	38	47	63	41
16	Hertford	38	58	82	36
17	Kidlington	38	47	86	35
18	Kempston	38	50	102	29
19	Colney Heath	38	35	92	23
20	Wantage Town	38	37	103	20

TEMPORADA 2020/2021

NON LEAGUE DIVISION 1 GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Barton	0	0	0	0
2	Dunstable	0	0	0	0
3	Bedford Town	0	0	0	0
4	Bedworth	0	0	0	0
5	Kempston	0	0	0	0
6	North Leigh	0	0	0	0
7	Welwyn	0	0	0	0
8	Yaxley FC	0	0	0	0
9	Aylesbury	0	0	0	0
10	Coleshill	0	0	0	0
11	Wantage Town	0	0	0	0
12	Berkhamsted	0	0	0	0
13	Biggleswade	0	0	0	0
14	Corby Town	0	0	0	0
15	Daventry	0	0	0	0
16	Didcot Town	0	0	0	0
17	Halesowen	0	0	0	0
18	Neots Town	0	0	0	0
19	Thame United	0	0	0	0
20	Kidlington	0	0	0	0

TEMPORADA 2019/2020

NON LEAGUE DIVISION 1 GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Berkhamsted	28	69	24	64
2	Halesowen	27	72	19	63
3	Corby Town	28	64	26	59
4	Welwyn	28	59	34	51
5	Aylesbury	29	49	30	49
6	Biggleswade	27	44	33	44
7	Barton	29	65	55	44
8	Bedworth	27	46	44	44
9	Yaxley FC	29	55	55	42
10	North Leigh	27	50	50	42
11	Thame United	27	52	35	41
12	Bedford Town	29	49	54	40
13	Daventry	28	42	48	40
14	Coleshill	28	50	47	36
15	Kidlington	28	34	48	33
16	Dunstable	28	50	54	31
17	Didcot Town	27	20	44	25
18	Neots Town	28	33	59	21
19	Kempston	27	25	68	14
20	Wantage Town	27	16	117	4

TEMPORADA 2018/2019

NON LEAGUE DIVISION 1 GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Peterborough	38	109	28	95
2	Bromsgrove	38	108	44	87
3	Corby Town	38	106	60	77
4	Bedford Town	38	84	52	65
5	Sutton	38	65	49	62
6	Berkhamsted	38	68	53	59
7	Didcot Town	38	69	61	58
8	Thame United	38	60	61	57
9	Coleshill	38	60	58	56
10	Dunstable	38	58	71	55
11	Yaxley FC	38	72	92	49
12	Cambridge	38	58	54	47
13	Welwyn	38	52	64	43
14	Kempston	38	58	75	43
15	Aylesbury	38	62	86	42
16	Barton	38	45	68	41
17	North Leigh	38	67	106	34
18	Kidlington	38	43	82	34
19	Aylesbury	38	42	79	31
20	Dunstable	38	49	92	31

TEMPORADA 2017/2018

NON LEAGUE DIVISION 1 GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Taunton Town	42	107	41	103
2	Salisbury	42	108	55	84
3	Wimborne	42	104	57	77
4	Evesham	42	73	53	76
5	Swindon	42	86	54	74
6	Didcot Town	42	89	63	73
7	Cirencester	42	93	74	73
8	Bideford	42	79	58	72
9	Bristol	42	83	61	69
10	AFC Totton	42	65	49	66
11	Winchester	42	73	66	61
12	Kidlington	42	80	64	57
13	Yate Town	42	72	74	56
14	Cinderford	42	81	71	54
15	Larkhall	42	66	78	45
16	Mangotsfield	42	53	86	41
17	Shortwood	42	63	124	40
18	North Leigh	42	53	84	38
19	Paulton	42	57	81	37
20	Slimbridge	42	54	130	35
21	Barnstaple	42	53	105	29
22	Bishop's	42	43	107	27

TEMPORADA 2016/2017

NON LEAGUE DIVISION 1 GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Hereford	42	108	32	107
2	Salisbury	42	118	52	89
3	Taunton Town	42	114	42	88
4	Tiverton	42	92	50	88
5	Evesham	42	88	50	80
6	North Leigh	42	84	65	75
7	Swindon	42	85	57	72
8	Mangotsfield	42	73	69	70
9	Shortwood	42	65	77	62
10	Bideford	42	61	58	57
11	Wimborne	42	67	68	57
12	Didcot Town	42	70	71	54
13	Larkhall	42	69	69	53
14	Winchester	42	62	70	53
15	Paulton	42	62	69	51
16	Bishop's	42	66	86	50
17	Barnstaple	42	52	68	45
18	Yate Town	42	49	77	44
19	AFC Totton	42	49	86	39
20	Slimbridge	42	47	90	37
21	Wantage Town	42	29	110	21
22	Bridgwater	42	23	117	10

TEMPORADA 2015/2016

NON LEAGUE DIVISION 1 GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Cinderford	42	80	29	96
2	Banbury	42	97	38	94
3	Taunton Town	42	94	34	89
4	Swindon	42	81	42	87
5	Winchester	42	97	49	83
6	Evesham	42	92	38	81
7	Shortwood	42	88	59	78
8	Tiverton	42	76	48	72
9	North Leigh	42	79	53	68
10	Didcot Town	42	82	57	64
11	Larkhall	42	62	65	55
12	Bishop's	42	55	66	55
13	Marlow FC	42	68	79	52
14	Mangotsfield	42	59	65	48
15	AFC Totton	42	73	81	48
16	Yate Town	42	48	62	47
17	Wimborne	42	65	80	44
18	Slimbridge	42	46	57	42
19	Bridgwater	42	42	83	34
20	Wantage Town	42	45	100	29
21	Burnham	42	43	99	26
22	Bashley	42	13	201	2

TEMPORADA 2014/2015

NON LEAGUE DIVISION 1 GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Merthyr Town	42	122	34	102
2	Evesham	42	94	36	91
3	Stratford	42	82	40	89
4	Taunton Town	42	71	42	80
5	Larkhall	42	82	50	77
6	Yate Town	42	79	52	72
7	Didcot Town	42	95	66	71
8	North Leigh	42	99	58	67
9	Cinderford	42	79	48	67
10	Mangotsfield	42	73	58	67
11	Shortwood	42	77	55	65
12	Bridgwater	42	67	59	62
13	Wimborne	42	71	68	61
14	Swindon	42	81	79	56
15	AFC Totton	42	65	75	53
16	Tiverton	42	60	69	49
17	Sholing	42	48	75	43
18	Clevedon	42	53	111	34
19	Fleet Town	42	46	100	29
20	Wantage Town	42	43	100	28
21	Bishop's	42	52	143	22
22	Bashley	42	23	144	12

TEMPORADA 2013/2014

NON LEAGUE DIVISION 1 GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Cirencester	42	95	45	92
2	Merthyr Town	42	111	58	89
3	Tiverton	42	80	51	86
4	Paulton	42	102	54	81
5	Swindon	42	91	52	79
6	Shortwood	42	91	44	78
7	North Leigh	42	84	46	72
8	Taunton Town	42	71	58	70
9	Yate Town	42	81	69	68
10	Stratford	42	103	86	62
11	Mangotsfield	42	65	62	61
12	Didcot Town	42	70	85	57
13	Wimborne	42	78	70	55
14	Bridgwater	42	62	64	53
15	Cinderford	42	69	79	49
16	Evesham	42	66	80	47
17	Clevedon	42	48	96	41
18	Godalming	42	47	79	39
19	Thatcham	42	41	99	39
20	Bishop's	42	52	94	34
21	Fleet Town	42	43	90	29
22	Guildford	42	45	134	27

TEMPORADA 2012/2013

NON LEAGUE DIVISION 1 GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Poole Town	42	82	36	98
2	Hungerford	42	71	44	84
3	Merthyr Town	42	84	38	83
4	Swindon	42	79	51	81
5	Paulton	42	64	54	75
6	Yate Town	42	69	63	69
7	Sholing	42	87	56	68
8	Shortwood	42	62	45	67
9	North Leigh	42	70	69	61
10	Cinderford	42	61	66	59
11	Cirencester	42	54	57	58
12	Wimborne	42	59	60	55
13	Mangotsfield	42	53	61	55
14	Evesham	42	49	58	51
15	Clevedon	42	61	67	49
16	Tiverton	42	51	58	47
17	Didcot Town	42	59	76	46
18	Taunton Town	42	59	85	44
19	Bridgwater	42	52	78	40
20	Abingdon	42	42	66	38
21	Bishop's	42	49	66	37
22	Winchester	42	42	105	29

TEMPORADA 2011/2012

NON LEAGUE DIVISION 1 GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Bideford	40	77	41	92
2	Poole Town	40	78	39	81
3	Gosport	40	73	44	80
4	Sholing	40	71	43	74
5	Hungerford	40	65	44	71
6	North Leigh	40	90	63	68
7	Paulton	40	60	39	64
8	Thatcham	40	51	42	62
9	Tiverton	40	52	42	59
10	Cinderford	40	49	39	59
11	Bishop's	40	40	42	59
12	Halesowen	40	55	56	51
13	Yate Town	40	58	59	50
14	Mangotsfield	40	62	66	49
15	Bridgwater	40	47	77	43
16	Didcot Town	40	39	68	42
17	Taunton Town	40	47	76	40
18	Abingdon	40	35	69	37
19	Wimborne	40	50	77	35
20	Clevedon	40	51	75	33
21	Stourport	40	39	88	20

TEMPORADA 2010/2011

NON LEAGUE DIVISION 1 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	AFC Totton	38	119	33	94
2	Sholing	38	85	26	89
3	Mangotsfield	38	77	46	82
4	Frome Town	38	75	31	73
5	Hungerford	38	56	40	62
6	Thatcham	38	67	43	61
7	North Leigh	38	76	77	61
8	Almondsbury	38	61	53	60
9	Gosport	38	58	62	55
10	Paulton	38	62	61	54
11	Taunton Town	38	45	47	54
12	Bideford	38	64	71	54
13	Cinderford	38	58	58	53
14	Bishop's	38	43	54	41
15	Stourport	39	51	78	40
16	Abingdon	38	54	82	39
17	Yate Town	38	41	48	38
18	Bridgwater	39	46	85	37
19	Wimborne	38	43	73	35
20	Clevedon	38	43	82	25
21	Andover	38	31	105	11

TEMPORADA 2009/2010

NON LEAGUE DIVISION 1 GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Windsor Eton	42	84	20	101
2	AFC Totton	42	105	36	100
3	Bridgwater	42	83	30	89
4	Sholing	42	90	52	82
5	Cirencester	42	91	46	78
6	Frome Town	42	68	44	75
7	Paulton	42	73	58	70
8	Gosport	42	80	59	67
9	Mangotsfield	42	77	67	62
10	North Leigh	42	83	72	61
11	Bishop's	42	64	64	58
12	Thatcham	42	76	72	57
13	Yate Town	42	58	64	55
14	Abingdon	42	65	84	52
15	Uxbridge	42	70	85	48
16	Cinderford	42	66	78	47
17	Hungerford	42	53	68	45
18	Bedfont Town	42	77	90	44
19	Taunton Town	42	50	85	40
20	Andover	42	54	85	38
21	AFC Hayes	42	55	105	25
22	Bracknell	42	29	187	6

TEMPORADA 2008/2009

NON LEAGUE DIVISION 1 GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Truro City	42	120	49	95
2	Windsor Eton	42	77	44	85
3	AFC Totton	42	89	39	82
4	Beaconsfield	42	77	44	81
5	Didcot Town	42	91	52	73
6	Thatcham	42	74	58	68
7	Bridgwater	42	69	56	65
8	North Leigh	42	68	64	61
9	AFC Hayes	42	80	92	61
10	Paulton	42	65	62	58
11	Cinderford	42	71	75	56
12	Gosport	42	64	67	55
13	Uxbridge	42	76	72	54
14	Cirencester	42	78	79	52
15	Abingdon	42	63	77	52
16	Slough Town	42	62	91	45
17	Burnham	42	52	83	45
18	Bishop's	42	51	71	43
19	Andover	42	58	102	42
20	Winchester	42	47	84	38
21	Taunton Town	42	50	85	36
22	Bracknell	42	39	75	35

Competiciones que juega

Grupo 7

Non League Division 1 Grupo 7

Pos	Equipos		Pts
1		Biggleswade Town	66
2		Bedford Town	63
3		Ware	59
4		Waltham Abbey	58
5		AFC Dunstable	58
6		Welwyn Garden City	53
7		Cirencester Town	51
8		Stotfold FC	49
9		Hadley	49
10		Kings Langley	48
11		Biggleswade	44
12		North Leigh	43
13		Leighton Town	42
14		Barton Rovers	41
15		Hertford Town	41
16		Kidlington	40
17		Aylesbury United	39
18		Thame United FC	34
19		Kempston Rovers	29

	Ascenso : Biggleswade Town
	Playoff Ascenso : Bedford Town, Ware, Waltham Abbey, AFC Dunstable
	Descenso : Thame United FC, Kempston Rovers

RIVALES EN FA Cup

RIVALES EN FA Trophy

RIVALES EN Non League Divis.

USO DE MEMORIA

8,036,096 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.7472
Total Execution Time	0.7484

CADENA URL

/historico/North-Leigh

GET DATOS

$_GET['/historico/North-Leigh']

POST DATOS

No hay datos POST existentes

CONSULTAS (38)

0.0172	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 = 'North-Leigh' 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.0145	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=16696 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=16696 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=16696 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=16696 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146	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=16696 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0292	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 = 72986
0.0145	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=16696 AND type_rel = 2
0.0151	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 = '16696' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0149	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 = '16696' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0149	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=16696 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0146	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 (72986,72728,72677,71432,68451) 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.0148	SELECT count(id) as num_players from rel_players WHERE league_id = 68451 AND teamId = 16696
0.0148	SELECT count(id) as num_players from rel_players WHERE league_id = 72986 AND teamId = 16696
0.0149	SELECT count(id) as num_players from rel_players WHERE league_id = 72728 AND teamId = 16696
0.0149	SELECT count(id) as num_players from rel_players WHERE league_id = 72677 AND teamId = 16696
0.0146	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 16696
0.0146	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 = '16696' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '16696' and rp.type = 4
0.0147	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 = '16696' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0146	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 = 72986 WHERE rp.league_id = 72986 AND rp.teamId = 16696 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.0146	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 = 72986 WHERE rp.league_id = 72986 AND rp.teamId = 16696 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0146	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 = 72986 WHERE rp.league_id = 72986 AND rp.teamId = 16696 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0149	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 = 16696 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 68451 AND t.round = 42 ORDER BY team.conference ASC,t.position 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* `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 = 63534 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.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* `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 = 58744 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.0151	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 = 50971 AND t.round = 30 ORDER BY team.conference ASC,t.position 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* `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 = 44459 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151	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 = 39173 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0157	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 = 33755 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151	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 = 15616 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153	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 = 4171 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151	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 = 3496 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155	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 = 24886 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151	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 = 24895 AND t.round = 40 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151	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 = 24922 AND t.round = 42 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* `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 = 25012 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

North Leigh

North Leigh

Selecciona un equipo

Competiciones que juega

Non League Division 1 Grupo 7

RIVALES EN FA Cup

RIVALES EN FA Trophy

RIVALES EN Non League Divis.