Histórico Bromsgrove Sporting - Non League Premier G 1

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.

NON LEAGUE PREMIER GRUPO 1
1	Needham	40	74	34	85
2	Telford	40	69	34	82
3	Leamington	40	61	32	71
4	Redditch	40	65	52	70
5	Mickleover	40	77	43	69
6	Stratford	40	69	57	69
7	Stamford	40	80	58	66
8	Halesowen	40	54	50	62
9	Ives Town	40	87	72	58
10	Royston Town	40	63	61	57
11	Coalville	40	68	57	55
12	Stourbridge	40	52	50	52
13	Leiston	40	56	71	52
14	Barwell	40	64	65	51
15	Kettering	40	49	74	48
16	Alvechurch	40	49	70	45
17	Bromsgrove	40	44	51	44
18	AFC Sudbury	40	53	62	40
19	Hitchin Town	40	46	64	39
20	Long Eaton.	40	39	109	22
21	Berkhamsted	40	31	84	21
22	Nuneaton	0	0	0	0

NON LEAGUE PREMIER GRUPO 1
1	Tamworth	42	93	40	89
2	Coalville	42	92	42	89
3	Leiston	42	84	47	85
4	Nuneaton	42	67	45	79
5	Rushall	42	71	52	73
6	Mickleover	42	82	66	72
7	Ilkeston	42	79	66	61
8	Barwell	42	69	63	61
9	Redditch	42	57	59	61
10	Stourbridge	42	69	56	59
11	Alvechurch	42	63	65	59
12	Hitchin Town	42	52	60	59
13	Royston Town	42	63	73	55
14	Stratford	42	58	70	52
15	Basford	42	49	62	52
16	Ives Town	42	64	72	50
17	Needham	42	46	54	48
18	Bromsgrove	42	58	78	48
19	Kings	42	45	69	39
20	Hednesford	42	45	76	31
21	Rushden	42	40	87	31
22	Bedford Town	42	49	93	30

NON LEAGUE PREMIER GRUPO 3
1	Banbury	40	92	32	102
2	Peterborough	40	94	46	79
3	Coalville	40	86	47	78
4	Rushall	40	80	54	69
5	Alvechurch	40	57	41	65
6	Rushden	40	57	49	65
7	Leiston	40	59	65	60
8	Royston Town	40	65	51	59
9	Hednesford	40	66	64	54
10	Tamworth	40	58	58	54
11	Stourbridge	40	61	71	53
12	Needham	40	66	69	49
13	Stratford	40	48	70	47
14	Ives Town	40	57	90	47
15	Redditch	40	38	50	45
16	Nuneaton	40	51	62	42
17	Hitchin Town	40	47	58	42
18	Bromsgrove	40	36	59	42
19	Barwell	40	57	78	41
20	Biggleswade	40	47	64	34
21	Lowestoft	40	49	93	33

NON LEAGUE PREMIER GRUPO 2
1	Coalville	7	21	5	17
2	Needham	7	17	7	17
3	Stratford	8	17	16	15
4	Rushall	8	14	12	13
5	Tamworth	7	13	8	12
6	Redditch	8	14	11	12
7	Royston Town	8	12	11	11
8	Kings	9	11	11	11
9	Stourbridge	7	8	5	10
10	Hitchin Town	7	12	14	10
11	Ives Town	6	11	13	10
12	Peterborough	6	10	5	9
13	Rushden	7	14	11	9
14	Lowestoft	7	8	9	9
15	Nuneaton	8	14	13	8
16	Alvechurch	9	12	16	8
17	Banbury	7	9	13	8
18	Bromsgrove	8	9	17	8
19	Hednesford	8	12	16	7
20	Biggleswade	7	11	15	7
21	Leiston	8	11	21	5
22	Barwell	7	6	17	4

NON LEAGUE PREMIER GRUPO 2
1	Tamworth	30	63	27	65
2	Peterborough	32	87	43	64
3	Royston Town	30	62	28	63
4	Bromsgrove	32	80	43	57
5	Rushall	33	58	43	53
6	Banbury	32	48	31	52
7	Coalville	30	51	32	51
8	Nuneaton	33	57	46	50
9	Kings	30	51	41	50
10	Stourbridge	31	50	52	50
11	Rushden	29	49	43	49
12	Barwell	32	58	53	48
13	Hednesford	31	47	41	46
14	Needham	32	41	39	45
15	Lowestoft	32	48	60	41
16	Biggleswade	29	42	46	40
17	Hitchin Town	32	43	49	39
18	Stratford	33	42	74	28
19	Leiston	32	39	87	26
20	Ives Town	33	33	76	23
21	Alvechurch	29	25	55	17
22	Redditch	33	24	89	12

NON LEAGUE DIVISION 1 GRUPO 4
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

Pos	Equipos	Pts
1		Needham Market	85
2		AFC Telford United	82
3		Leamington	71
4		Redditch United	70
5		Mickleover Sports FC	69
6		Stratford Town	69
7		Stamford	66
8		Halesowen Town	62
9		St Ives Town	58
10		Royston Town	57
11		Coalville Town	55
12		Stourbridge	52
13		Leiston	52
14		Barwell	51
15		Kettering Town	48
16		Alvechurch FC	45
17		Bromsgrove Sporting	44
18		AFC Sudbury	40
19		Hitchin Town	39
20		Long Eaton United	22
21		Berkhamsted	21
22		Nuneaton Town	0

	Ascenso : Needham Market
	Playoff Ascenso : AFC Telford United, Leamington, Redditch United, Mickleover Sports FC
	Descenso : Hitchin Town, Long Eaton United, Berkhamsted, Nuneaton Town

USO DE MEMORIA

6,334,568 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.6493
Total Execution Time	0.6505

CADENA URL

/historico/Bromsgrove-Sporting

GET DATOS

$_GET['/historico/Bromsgrove-Sporting']

POST DATOS

No hay datos POST existentes

CONSULTAS (33)

0.0156	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 = 'Bromsgrove-Sporting' 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.0147	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=20395 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=20395 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0149	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=20395 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150	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=20395 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150	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=20395 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0301	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 = 72852
0.0145	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=20395 AND type_rel = 2
0.0153	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 = '20395' ORDER BY l.year DESC,cat.coefficient DESC
0.0154	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 = '20395' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0152	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 = '20395' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0148	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 = 72852 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0156	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=20395 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0154	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 (72852,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.0158	SELECT count(id) as num_players from rel_players WHERE league_id = 72852 AND teamId = 20395
0.0154	SELECT count(id) as num_players from rel_players WHERE league_id = 72728 AND teamId = 20395
0.0207	SELECT count(id) as num_players from rel_players WHERE league_id = 72677 AND teamId = 20395
0.0154	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 20395
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 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 = 72852 AND t.round = 42 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0147	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 = '20395' 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 = '20395' 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 = '20395' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0156	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 = 72852 WHERE rp.league_id = 72852 AND rp.teamId = 20395 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.0192	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 = 72852 WHERE rp.league_id = 72852 AND rp.teamId = 20395 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0173	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 = 72852 WHERE rp.league_id = 72852 AND rp.teamId = 20395 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0172	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 = 20395 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0169	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 = 72852 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.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* `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 = 68450 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.0154	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 = 63526 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.0160	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 = 58614 AND t.round = 9 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0159	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 = 50618 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0159	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.0156	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 = 72852 ORDER BY nameShow LIMIT 100

Bromsgrove Sporting

Bromsgrove Sporting

Selecciona un equipo

Competiciones que juega

Non League Premier Grupo 1

RIVALES EN FA Cup

RIVALES EN FA Trophy

RIVALES EN Non League Premi.

NON LEAGUE PREMIER GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Needham	40	74	34	85
2	Telford	40	69	34	82
3	Leamington	40	61	32	71
4	Redditch	40	65	52	70
5	Mickleover	40	77	43	69
6	Stratford	40	69	57	69
7	Stamford	40	80	58	66
8	Halesowen	40	54	50	62
9	Ives Town	40	87	72	58
10	Royston Town	40	63	61	57
11	Coalville	40	68	57	55
12	Stourbridge	40	52	50	52
13	Leiston	40	56	71	52
14	Barwell	40	64	65	51
15	Kettering	40	49	74	48
16	Alvechurch	40	49	70	45
17	Bromsgrove	40	44	51	44
18	AFC Sudbury	40	53	62	40
19	Hitchin Town	40	46	64	39
20	Long Eaton.	40	39	109	22
21	Berkhamsted	40	31	84	21
22	Nuneaton	0	0	0	0