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

Brentwood Town

Temporada 2023/2024

TEMPORADA 2023/2024

NON LEAGUE DIVISION 1 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Lowestoft	34	87	38	75
2	Bowers	34	68	43	73
3	Felixstowe	34	72	38	71
4	Brentwood	34	67	30	69
5	Bury Town	34	81	46	68
6	Walthamstow	35	59	48	59
7	Heybridge	34	51	43	57
8	Brightlingse	34	64	50	54
9	Maldon	35	65	60	49
10	Basildon	34	61	57	49
11	Gorleston	34	53	49	44
12	Wroxham	34	44	47	42
13	Redbridge	33	50	58	41
14	Witham Town	34	50	59	39
15	New Salamis	34	56	73	35
16	Grays	34	43	65	30
17	Ipswich	34	36	67	29
18	Enfield FC	33	29	79	19
19	Stowmarket	34	31	117	6
20	East	0	0	0	0

TEMPORADA 2022/2023

NON LEAGUE DIVISION 1 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Hashtag	38	101	35	98
2	AFC Sudbury	38	91	33	91
3	Lowestoft	38	89	50	77
4	Grays	38	62	40	72
5	Felixstowe	38	74	44	69
6	Heybridge	38	66	40	69
7	Stowmarket	38	63	44	66
8	Brentwood	38	57	50	55
9	New Salamis	38	63	65	55
10	Wroxham	38	52	55	50
11	Bury Town	38	37	41	50
12	East	38	46	55	49
13	Gorleston	38	49	71	44
14	Basildon	38	44	63	40
15	Maldon	38	40	58	39
16	Witham Town	38	43	75	35
17	Great	38	49	88	30
18	Coggeshall	38	28	60	28
19	Tilbury	38	36	77	27
20	Hullbridge	38	35	81	22

TEMPORADA 2021/2022

NON LEAGUE DIVISION 1 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Aveley	38	94	37	80
2	Canvey	38	100	42	78
3	Brentwood	38	73	41	75
4	Stowmarket	38	75	39	73
5	Felixstowe	38	60	45	72
6	Grays	38	69	38	68
7	AFC Sudbury	38	57	46	63
8	Hashtag	38	60	49	62
9	Maldon	38	74	63	60
10	Dereham Town	38	63	53	60
11	Heybridge	38	77	73	53
12	Bury Town	38	63	71	44
13	Coggeshall	38	53	68	43
14	Tilbury	38	57	68	41
15	Great	38	58	74	40
16	Hullbridge	38	43	72	39
17	Basildon	38	35	60	35
18	Barking	38	51	79	35
19	Witham Town	38	40	71	33
20	Romford	38	26	139	13

TEMPORADA 2020/2021

NON LEAGUE DIVISION 1 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Tilbury	8	14	9	16
2	AFC Sudbury	8	15	14	12
3	Maldon	5	9	3	11
4	Bury Town	4	9	2	10
5	Heybridge	8	10	9	10
6	Histon	6	10	9	10
7	Soham Town.	7	7	7	10
8	Grays	6	5	6	10
9	Aveley	6	8	9	9
10	Romford	8	7	10	9
11	Coggeshall	6	7	6	8
12	Dereham Town	7	7	7	8
13	Felixstowe	5	7	7	8
14	Great	7	11	14	8
15	Canvey	5	8	5	6
16	Hullbridge	5	11	9	6
17	Cambridge	4	3	3	6
18	Brentwood	5	5	6	6
19	Basildon	6	11	9	5
20	Witham Town	8	7	27	3

TEMPORADA 2019/2020

NON LEAGUE DIVISION 1 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Maldon	26	65	20	65
2	Aveley	26	66	31	51
3	Tilbury	27	49	30	50
4	Heybridge	29	54	43	50
5	Bury Town	29	49	41	50
6	Coggeshall	26	40	24	46
7	Great	28	45	36	43
8	Dereham Town	29	52	43	41
9	Cambridge	28	42	39	39
10	Canvey	27	49	54	38
11	AFC Sudbury	26	42	42	37
12	Histon	28	40	53	36
13	Soham Town.	28	41	47	34
14	Grays	29	41	47	31
15	Witham Town	28	36	63	29
16	Hullbridge	27	33	53	28
17	Brentwood	28	41	54	26
18	Felixstowe	29	40	62	25
19	Romford	25	41	66	24
20	Basildon	25	29	47	23

TEMPORADA 2018/2019

NON LEAGUE DIVISION 1 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Bowers	38	96	25	92
2	Aveley	38	84	49	80
3	Maldon	38	86	46	79
4	Coggeshall	38	79	43	74
5	Heybridge	38	70	51	74
6	Bury Town	38	72	63	59
7	Grays	38	65	64	53
8	AFC Sudbury	38	71	72	52
9	Canvey	38	51	50	51
10	Tilbury	38	64	64	50
11	Felixstowe	38	56	66	50
12	Dereham Town	38	71	82	47
13	Barking	38	49	63	47
14	Brentwood	38	71	77	45
15	Great	38	55	72	41
16	Soham Town.	38	44	64	40
17	Basildon	38	37	71	39
18	Witham Town	38	38	68	34
19	Romford	38	48	82	34
20	Mildenhall	38	47	82	27

TEMPORADA 2017/2018

NON LEAGUE DIVISION 1 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Hornchurch	46	97	35	103
2	Potters Town	46	87	42	93
3	Bowers	46	94	48	89
4	Haringey	46	84	49	89
5	Heybridge	46	105	53	87
6	Canvey	46	100	65	80
7	Dereham Town	46	75	63	71
8	Maldon	46	94	83	69
9	Bury Town	46	67	65	65
10	Barking	45	63	62	64
11	Witham Town	46	59	66	62
12	AFC Sudbury	46	57	66	59
13	Soham Town.	46	67	73	58
14	Aveley	46	61	67	57
15	Hertford	46	55	85	57
16	Tilbury	46	73	95	56
17	Grays	45	71	80	53
18	Cheshunt	46	72	103	50
19	Waltham	46	73	87	49
20	Ware	46	49	81	48
21	Brentwood	46	71	96	46
22	Mildenhall	46	54	86	46
23	Romford	46	51	97	41
24	Norwich	46	63	95	40

TEMPORADA 2016/2017

NON LEAGUE DIVISION 1 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Brightlingse	46	114	57	103
2	Maldon	46	107	51	91
3	Thurrock	46	84	39	89
4	Hornchurch	46	78	42	85
5	Haringey	46	108	74	81
6	Bowers	46	102	66	78
7	Aveley	46	75	64	76
8	Phoenix	46	71	72	75
9	Norwich	46	70	61	74
10	Cheshunt	46	85	72	71
11	Bury Town	46	74	66	69
12	Tilbury	46	67	73	64
13	Witham Town	46	77	80	59
14	Brentwood	46	63	77	56
15	Athletic	46	53	76	56
16	Romford	46	59	90	56
17	Thamesmead	46	70	78	54
18	Dereham Town	46	70	89	54
19	Soham Town.	46	62	78	53
20	Waltham	46	57	73	51
21	Heybridge	46	64	81	51
22	Ware	46	66	84	51
23	Wroxham	46	42	103	25
24	Great	46	49	121	25

TEMPORADA 2015/2016

NON LEAGUE PREMIER GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Hampton	46	105	52	95
2	Bognor Regis	46	95	42	94
3	East	46	107	53	91
4	Tonbridge	46	90	49	85
5	Dulwich	46	93	58	81
6	Enfield Town	46	74	47	80
7	Kingstonian	46	78	64	73
8	Leiston	46	72	57	72
9	Billericay	46	76	53	71
10	Merstham	46	74	80	62
11	Leatherhead	46	67	81	62
12	Metropolitan	46	60	79	61
13	Wingate	46	66	70	60
14	Canvey	46	69	89	60
15	Grays	46	63	75	56
16	Staines Town	46	53	74	55
17	Harrow	46	66	80	54
18	Farnborough	46	65	88	53
19	Needham	46	52	76	53
20	Hendon	46	68	85	52
21	Burgess Hill	46	57	73	50
22	Brentwood	46	51	80	40
23	Lewes	46	48	87	34
24	Athletic	46	46	103	34

TEMPORADA 2014/2015

NON LEAGUE DIVISION 1 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Needham	41	90	38	95
2	Harlow Town	41	99	51	93
3	AFC Sudbury	41	74	45	80
4	Brentwood	40	73	54	78
5	Wroxham	41	92	50	76
6	Thurrock	42	90	50	75
7	Dereham Town	41	77	58	73
8	Brightlingse	41	72	50	70
9	Ware	41	70	52	60
10	Aveley	41	72	67	60
11	Tilbury	41	59	65	56
12	Soham Town.	41	68	79	56
13	Heybridge	42	64	73	55
14	Thamesmead	41	54	62	51
15	Waltham	40	69	74	49
16	Great	41	75	79	48
17	Cheshunt	41	59	73	48
18	Maldon	41	53	70	45
19	Redbridge	41	59	96	41
20	Chatham Town	41	45	64	40
21	Romford	41	61	86	39
22	Barkingside	40	50	84	37
23	Cray	40	58	83	34
24	Burnham	41	47	127	18

TEMPORADA 2013/2014

NON LEAGUE DIVISION 1 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Athletic	46	115	54	99
2	Witham Town	46	109	54	98
3	Heybridge	46	108	59	93
4	Harlow Town	46	105	59	91
5	Thurrock	46	99	60	87
6	Needham	46	85	44	87
7	Dereham Town	46	98	65	77
8	Soham Town.	46	92	75	76
9	AFC Sudbury	46	76	63	76
10	Maldon	46	82	68	76
11	Romford	46	76	69	68
12	Chatham Town	46	74	76	68
13	Aveley	46	81	81	65
14	Redbridge	46	78	84	59
15	Cheshunt	46	74	75	53
16	Burnham	46	69	100	52
17	Waltham	46	71	89	50
18	Tilbury	46	55	75	50
19	Brentwood	46	72	91	49
20	Barkingside	46	76	120	46
21	Ware	46	73	93	45
22	Wroxham	46	77	123	36
23	Walthamstow	46	43	118	25
24	Erith	46	44	137	22

TEMPORADA 2012/2013

NON LEAGUE DIVISION 1 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Grays	42	96	38	102
2	Maldon	42	101	48	89
3	Thamesmead	42	85	49	88
4	Witham Town	42	71	47	79
5	Aveley	42	92	58	78
6	Heybridge	42	102	55	73
7	Soham Town.	42	95	75	73
8	Romford	42	72	72	64
9	Tilbury	42	69	62	63
10	Brentwood	42	63	62	59
11	Cheshunt	42	75	73	58
12	Potters Town	42	64	68	58
13	Waltham	42	60	70	53
14	Chatham Town	42	59	65	52
15	Wroxham	42	68	64	50
16	Needham	42	61	62	49
17	AFC Sudbury	42	57	84	45
18	Walthamstow	42	54	72	40
19	Ware	42	59	105	36
20	Harlow Town	42	45	82	35
21	Redbridge	42	42	105	27
22	Ilford FC	42	32	106	20

TEMPORADA 2011/2012

NON LEAGUE DIVISION 1 GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Leiston	42	99	41	91
2	Enfield Town	42	96	46	90
3	Grays	42	80	47	80
4	Tilbury	42	82	62	80
5	Needham	42	104	56	77
6	Redbridge	42	80	59	73
7	Harlow Town	42	70	49	71
8	AFC Sudbury	42	65	57	69
9	Brentwood	42	58	42	62
10	Thamesmead	42	68	71	58
11	Maldon	42	62	66	58
12	Potters Town	42	67	76	57
13	Romford	42	64	73	57
14	Waltham	42	79	76	55
15	Chatham Town	42	54	63	54
16	Heybridge	42	59	64	52
17	Walthamstow	42	59	95	43
18	Cheshunt	42	42	83	39
19	Soham Town.	42	55	93	34
20	Ilford FC	42	47	85	30
21	Ware	42	40	78	30
22	Great	42	43	91	29

TEMPORADA 2010/2011

NON LEAGUE DIVISION 1 GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	East	40	92	38	95
2	Needham	40	95	49	87
3	Wingate	40	72	54	72
4	Harlow Town	40	61	51	71
5	Brentwood	40	75	55	69
6	Enfield Town	40	76	44	68
7	AFC Sudbury	40	82	64	66
8	Maldon	40	70	67	63
9	Heybridge	40	81	59	61
10	Grays	40	69	51	61
11	Waltham	40	75	63	58
12	Romford	40	63	66	55
13	Potters Town	40	60	68	51
14	Ware	40	57	77	45
15	Great	40	60	82	44
16	Redbridge	40	51	79	39
17	Thamesmead	40	42	71	39
18	Cheshunt	40	49	81	38
19	Tilbury	40	41	66	37
20	Ilford FC	40	42	81	32
21	Walthamstow	40	43	90	26

TEMPORADA 2009/2010

NON LEAGUE DIVISION 1 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Lowestoft	42	115	37	101
2	Concord	42	94	42	86
3	Wingate	42	88	55	81
4	Enfield Town	42	81	47	80
5	East	42	102	59	77
6	Heybridge	42	67	56	71
7	Thamesmead	42	67	56	67
8	Athletic	42	61	53	67
9	Great	42	67	70	64
10	Northwood	42	65	61	61
11	Tilbury	42	61	60	56
12	Brentwood	42	53	53	52
13	Romford	42	71	88	52
14	Potters Town	42	51	67	50
15	Cheshunt	42	57	83	50
16	Walthamstow	42	51	75	48
17	Maldon	42	54	74	45
18	Ilford FC	42	47	72	43
19	Redbridge	42	41	62	42
20	Ware	42	57	84	42
21	Leyton FC	42	40	84	30
22	Harlow Town	42	46	98	25

TEMPORADA 2008/2009

NON LEAGUE DIVISION 1 GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Aveley	42	81	40	96
2	East	41	111	50	92
3	Brentwood	42	77	32	88
4	Concord	42	83	34	79
5	Waltham	41	84	45	79
6	Northwood	42	65	39	78
7	Wingate	43	69	52	70
8	Redbridge	42	61	50	64
9	Ware	42	69	75	61
10	Chatham Town	42	58	60	60
11	Tilbury	41	62	52	58
12	Enfield Town	41	71	67	58
13	Great	42	56	62	58
14	Cheshunt	42	60	71	56
15	Leyton FC	42	63	56	51
16	Maldon	42	48	63	48
17	Ilford FC	42	27	68	41
18	Thamesmead	42	46	73	40
19	Potters Town	43	53	75	37
20	Walthamstow	42	39	81	34
21	Witham Town	42	37	103	27
22	Hillingdon	42	35	107	16

TEMPORADA 2007/2008

NON LEAGUE DIVISION 1 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Dartford	43	112	42	92
2	Ware	43	113	59	82
3	Redbridge	42	70	43	81
4	AFC Sudbury	42	86	40	80
5	Canvey	42	82	39	79
6	Brentwood	41	68	48	74
7	Edgware	42	53	39	74
8	Bury Town	41	74	53	72
9	Maldon	41	77	61	67
10	Northwood	42	71	61	66
11	Aveley	42	68	65	66
12	Enfield Town	41	59	63	60
13	Great	43	65	69	48
14	Waltham	42	42	78	46
15	Arlesey Town	41	64	83	45
16	Witham Town	42	75	109	41
17	Potters Town	42	45	77	39
18	Wingate	42	45	72	35
19	Walthamstow	41	44	72	33
20	Tilbury	43	49	101	33
21	Ilford FC	42	47	95	32
22	Wivenhoe	42	46	86	31

Competiciones que juega

Grupo 1

Non League Division 1 Grupo 1

Pos	Equipos		Pts
1		Lowestoft Town	75
2		Bowers and Pitsea	73
3		Felixstowe & Walton Utd	71
4		Brentwood Town	69
5		Bury Town	68
6		Walthamstow	59
7		Heybridge Swifts	57
8		Brightlingsea Regent	54
9		Maldon & Tiptree	49
10		Basildon United	49
11		Gorleston	44
12		Wroxham	42
13		Redbridge	41
14		Witham Town	39
15		New Salamis	35
16		Grays Athletic	30
17		Ipswich Wanderers	29
18		Enfield FC	19
19		Stowmarket Town	6
20		East Thurrock United FC	0

	Ascenso : Lowestoft Town
	Playoff Ascenso : Bowers and Pitsea, Felixstowe & Walton Utd, Brentwood Town, Bury Town
	Descenso : Stowmarket Town, East Thurrock United FC

RIVALES EN FA Cup

RIVALES EN FA Trophy

RIVALES EN Non League Divis.

USO DE MEMORIA

8,355,200 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1519
Total Execution Time	0.1532

CADENA URL

/historico/Brentwood-Town

GET DATOS

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

POST DATOS

No hay datos POST existentes

CONSULTAS (40)

0.0038	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 = 'Brentwood-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=10483 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=10483 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=10483 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=10483 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=10483 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0023	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 = 72975
0.0019	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=10483 AND type_rel = 2
0.0026	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 = '10483' ORDER BY l.year DESC,cat.coefficient DESC
0.0024	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 = '10483' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0023	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 = '10483' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0025	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=10483 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 (72975,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.0018	SELECT count(id) as num_players from rel_players WHERE league_id = 72975 AND teamId = 10483
0.0019	SELECT count(id) as num_players from rel_players WHERE league_id = 72728 AND teamId = 10483
0.0019	SELECT count(id) as num_players from rel_players WHERE league_id = 72677 AND teamId = 10483
0.0018	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 10483
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 = '10483' 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 = '10483' and rp.type = 4
0.0020	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 = '10483' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0019	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 = 72975 WHERE rp.league_id = 72975 AND rp.teamId = 10483 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.0019	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 = 72975 WHERE rp.league_id = 72975 AND rp.teamId = 10483 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019	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 = 72975 WHERE rp.league_id = 72975 AND rp.teamId = 10483 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025	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 = 10483 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0022	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 = 72975 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.0024	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 = 68454 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.0022	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 = 63528 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.0022	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 = 58739 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.0023	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 = 50966 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.0039	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 = 39168 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 33751 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 15599 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024	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 = 4392 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 3489 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024	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 = 24863 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024	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 = 24888 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028	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 = 24900 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028	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 = 24912 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 = 25008 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 25015 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Brentwood Town

Brentwood Town

Selecciona un equipo

Competiciones que juega

Non League Division 1 Grupo 1

RIVALES EN FA Cup

RIVALES EN FA Trophy

RIVALES EN Non League Divis.