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

Stourbridge

Temporada 2023/2024

TEMPORADA 2023/2024

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

TEMPORADA 2022/2023

NON LEAGUE PREMIER GRUPO 1
Equipo		PJ	GF	GC	Puntos
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

TEMPORADA 2021/2022

NON LEAGUE PREMIER GRUPO 3
Equipo		PJ	GF	GC	Puntos
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

TEMPORADA 2020/2021

NON LEAGUE PREMIER GRUPO 2
Equipo		PJ	GF	GC	Puntos
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

TEMPORADA 2019/2020

NON LEAGUE PREMIER GRUPO 2
Equipo		PJ	GF	GC	Puntos
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

TEMPORADA 2018/2019

NON LEAGUE PREMIER GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Kettering	42	84	41	94
2	Kings Lynn.	42	80	41	80
3	Stourbridge	42	79	40	78
4	Alvechurch	42	66	53	73
5	Stratford	42	55	49	72
6	Coalville	42	78	66	67
7	Biggleswade	42	67	54	66
8	Rushall	42	56	49	62
9	Rushden	42	60	49	61
10	Royston Town	42	59	53	61
11	Needham	42	68	65	60
12	Tamworth	42	64	46	58
13	Ives Town	42	36	43	55
14	Banbury	42	53	55	53
15	Lowestoft	42	55	60	51
16	Redditch	42	63	79	50
17	Barwell	42	55	55	49
18	Hitchin Town	42	50	71	48
19	Leiston	42	54	73	47
20	Neots Town	42	32	73	36
21	Halesowen	42	26	66	32
22	Bedworth	42	32	91	19

TEMPORADA 2017/2018

NON LEAGUE PREMIER GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Altrincham	46	101	42	95
2	Ashton	46	85	59	82
3	Warrington	46	72	49	82
4	Grantham	46	90	55	81
5	Farsley	46	87	69	80
6	Shaw Lane A.	46	79	62	79
7	Witton	46	83	63	70
8	Rushall	45	72	78	65
9	Barwell	46	65	67	64
10	Buxton	46	71	66	64
11	Workington	46	72	69	62
12	Stourbridge	46	67	56	62
13	Stafford	46	54	58	61
14	Mickleover	46	68	60	61
15	Matlock Town	46	69	75	60
16	Nantwich	46	62	72	57
17	Hednesford	45	59	78	56
18	Lancaster	46	66	72	55
19	Marine	46	67	78	53
20	Coalville	46	70	92	52
21	Whitby Town	46	60	82	50
22	Stalybridge	46	57	90	48
23	Halesowen	46	48	76	45
24	Sutton	46	52	108	35

TEMPORADA 2016/2017

NON LEAGUE PREMIER GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Blyth	46	114	44	101
2	Spennymoor	46	96	48	87
3	Stourbridge	46	84	51	85
4	Workington	46	73	56	83
5	Nantwich	46	86	59	81
6	Whitby Town	46	64	56	79
7	Buxton	46	81	54	78
8	Grantham	46	74	57	76
9	Matlock Town	46	68	58	75
10	Warrington	46	65	57	74
11	Ashton	46	85	78	68
12	Rushall	46	60	60	64
13	Stafford	46	63	60	63
14	Barwell	46	58	53	62
15	Hednesford	46	68	65	61
16	Mickleover	46	68	71	60
17	Coalville	46	71	79	55
18	Marine	46	62	74	55
19	Halesowen	46	46	70	51
20	Sutton	46	49	79	47
21	Corby Town	46	49	72	46
22	Frickley	46	47	97	39
23	Ilkeston	46	31	86	27
24	Skelmersdale	46	40	118	24

TEMPORADA 2015/2016

NON LEAGUE PREMIER GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Darlington	46	106	42	104
2	Blyth	46	89	42	98
3	Salford City	46	95	48	91
4	Ashton	46	90	52	87
5	Workington	46	78	50	86
6	Stourbridge	46	90	63	84
7	Frickley	46	70	46	77
8	Nantwich	46	94	62	75
9	Barwell	46	82	66	73
10	Rushall	46	74	61	69
11	Buxton	46	72	74	67
12	Sutton	46	59	66	62
13	Halesowen	46	53	63	62
14	Skelmersdale	46	67	82	54
15	Ilkeston	46	61	80	54
16	Matlock Town	46	59	80	52
17	Marine	46	53	62	51
18	Grantham	46	51	85	51
19	Whitby Town	46	60	79	47
20	Mickleover	46	50	74	46
21	Stamford	46	71	97	45
22	Hyde	46	53	91	38
23	Colwyn Bay	46	51	95	38
24	Ramsbottom	46	44	112	28

TEMPORADA 2014/2015

NON LEAGUE PREMIER GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	United	46	78	37	92
2	Workington	46	63	39	90
3	Ashton	46	75	54	84
4	Curzon	46	79	47	81
5	Ilkeston	46	79	56	81
6	Blyth	46	84	54	79
7	Skelmersdale	46	58	48	73
8	Barwell	46	69	63	73
9	Rushall	46	76	64	72
10	Buxton	46	70	57	71
11	Halesowen	46	56	48	59
12	Grantham	46	64	72	59
13	Whitby Town	46	56	63	58
14	Matlock Town	46	57	60	56
15	Nantwich	46	61	76	55
16	Stourbridge	46	59	72	53
17	Ramsbottom	46	66	80	53
18	Kings Lynn.	46	60	81	52
19	Stamford	46	57	75	51
20	Frickley	46	60	73	50
21	Marine	46	58	69	49
22	Witton	46	58	86	49
23	Trafford	46	58	93	33
24	Belper Town	46	62	96	32

TEMPORADA 2013/2014

NON LEAGUE PREMIER GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Hemel	31	101	28	72
2	Chesham	31	73	34	62
3	Albans City	30	69	35	61
4	Cambridge	28	63	31	61
5	Stourbridge	31	83	35	57
6	Bideford	33	62	44	53
7	Poole Town	23	50	26	50
8	Corby Town	29	42	38	45
9	Arlesey Town	33	58	56	45
10	Hitchin Town	30	43	35	44
11	Hungerford	26	47	32	42
12	Biggleswade	29	55	41	42
13	Weymouth	30	43	58	41
14	Banbury	31	49	65	41
15	Truro City	31	45	60	39
16	Burnham	31	43	59	38
17	Frome Town	32	42	59	37
18	Redditch	29	43	64	37
19	Chippenham	30	41	65	32
20	Neots Town	32	48	56	32
21	AFC Totton	27	34	86	15
22	Bedford Town	32	34	90	14
23	Bashley	27	21	81	9
24	Hinckley	10	9	20	6

TEMPORADA 2012/2013

NON LEAGUE PREMIER GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Hemel	2	4	2	4
2	Gosport	2	4	3	4
3	Stourbridge	1	1	2	0
4	Chesham	1	0	2	0

TEMPORADA 2011/2012

NON LEAGUE PREMIER GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Brackley	42	92	48	85
2	Oxford City	42	68	41	77
3	AFC Totton	42	81	43	74
4	Chesham	42	76	53	73
5	Cambridge	42	78	52	72
6	Stourbridge	42	67	45	72
7	Leamington	42	60	47	69
8	Albans City	42	72	77	62
9	Barwell	42	70	61	61
10	Bedford Town	42	60	69	55
11	Chippenham	42	55	53	53
12	Frome Town	42	44	49	52
13	Bashley	42	58	74	52
14	Hitchin Town	42	54	57	51
15	Redditch	42	45	50	51
16	Banbury	42	54	61	49
17	Weymouth	42	54	75	48
18	Arlesey Town	42	43	60	47
19	Hemel	42	46	66	44
20	Evesham	42	49	71	44
21	Swindon	42	50	86	44
22	Cirencester	42	40	78	30

TEMPORADA 2010/2011

NON LEAGUE PREMIER GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Truro City	38	85	33	81
2	Salisbury	39	82	44	79
3	Hednesford	38	74	38	77
4	Cambridge	38	72	39	76
5	Leamington	38	62	35	72
6	Chesham	38	61	29	70
7	Chippenham	38	52	38	65
8	Stourbridge	38	64	57	59
9	Brackley	38	65	45	55
10	Swindon	39	53	57	55
11	Bashley	38	53	57	49
12	Evesham	38	52	47	48
13	Cirencester	38	58	65	46
14	Oxford City	38	43	51	42
15	Hemel	38	46	56	41
16	Banbury	38	44	62	41
17	Weymouth	38	50	82	41
18	Bedford Town	38	40	74	34
19	Didcot Town	38	39	66	31
20	Tiverton	38	33	76	28
21	Halesowen	38	24	101	23

TEMPORADA 2009/2010

NON LEAGUE PREMIER GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Farnborough	42	100	44	93
2	Nuneaton	42	90	37	88
3	Halesowen	42	84	53	80
4	Chippenham	42	67	43	74
5	Hednesford	42	79	51	73
6	Brackley	42	83	61	72
7	Cambridge	42	73	44	71
8	Bashley	42	79	61	71
9	Stourbridge	42	80	65	70
10	Leamington	42	84	75	65
11	Truro City	42	78	65	62
12	Banbury	42	53	67	55
13	Oxford City	42	65	67	54
14	Merthyr	42	62	73	47
15	Swindon	42	48	76	44
16	Didcot Town	42	56	70	41
17	Evesham	42	35	52	41
18	Bedford Town	42	50	88	37
19	Tiverton	42	35	61	36
20	Hemel	42	50	81	34
21	Clevedon	42	48	92	29
22	Rugby Town	42	41	114	20

TEMPORADA 2008/2009

NON LEAGUE PREMIER GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Corby Town	42	85	38	84
2	Farnborough	42	67	36	83
3	Gloucester	42	80	45	75
4	Hemel	42	71	48	70
5	Cambridge	41	61	40	70
6	Chippenham	42	64	51	68
7	Oxford City	42	76	55	67
8	Merthyr	42	66	55	67
9	Halesowen	42	65	73	63
10	Evesham	42	48	39	61
11	Brackley	42	69	62	57
12	Tiverton	42	51	50	57
13	Swindon	42	59	61	57
14	Bashley	42	52	58	57
15	Bedford Town	41	44	54	50
16	Stourbridge	42	62	78	50
17	Rugby Town	42	63	71	43
18	Clevedon	43	52	82	43
19	Banbury	42	43	83	41
20	Hitchin Town	42	57	79	40
21	Yate Town	43	56	92	39
22	Mangotsfield	42	39	80	36

TEMPORADA 2007/2008

NON LEAGUE DIVISION 1 GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Evesham	40	68	24	91
2	Leamington	40	74	27	89
3	Sutton	41	94	52	80
4	Stourbridge	40	97	48	78
5	Rushall	40	68	23	76
6	Chesham	40	78	40	76
7	Chasetown	40	71	38	75
8	Aylesbury	40	64	49	66
9	Leighton	41	59	43	63
10	Romulus	39	57	50	61
11	Barton	40	54	45	58
12	Bishop's	40	63	61	58
13	Willenhall	40	53	58	49
14	Dunstable	40	63	65	47
15	Bedworth	40	40	51	46
16	Cinderford	40	47	82	42
17	Stourport	39	37	78	37
18	Rothwell	40	34	69	32
19	Woodford	40	30	88	27
20	Malvern Town	40	34	95	18
21	Berkhamsted	40	27	126	10

TEMPORADA 2006/2007

NON LEAGUE DIVISION 1 GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Brackley	41	92	53	88
2	Bromsgrove	42	86	62	76
3	Willenhall	42	67	47	72
4	Chasetown	41	57	39	72
5	Evesham	42	66	51	72
6	Aylesbury	42	58	42	71
7	Stourbridge	42	70	53	66
8	Woodford	42	71	54	65
9	Cinderford	42	70	60	64
10	Rothwell	42	72	61	61
11	Dunstable	42	64	53	60
12	Sutton	42	62	63	57
13	Bishop's	42	68	66	56
14	Solihull	42	72	84	56
15	Rushall	42	56	55	54
16	Bedworth	42	73	83	47
17	Malvern Town	42	46	66	47
18	Leighton	41	44	58	44
19	Spalding	42	45	62	42
20	Barton	41	51	90	42
21	Berkhamsted	42	53	97	37
22	Stourport	42	43	87	34

Competiciones que juega

Grupo 1

Non League Premier Grupo 1

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

RIVALES EN FA Cup

RIVALES EN FA Trophy

RIVALES EN Non League Premi.

USO DE MEMORIA

8,522,488 bytes

BENCHMARKS

Loading Time Base Classes	0.0013
Controller Execution Time ( Home / Category )	0.1987
Total Execution Time	0.2000

CADENA URL

/historico/Stourbridge

GET DATOS

$_GET['/historico/Stourbridge']

POST DATOS

No hay datos POST existentes

CONSULTAS (47)

0.0036	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 = 'Stourbridge' 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.0019	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=6345 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=6345 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=6345 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=6345 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=6345 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 = 72852
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6345 AND type_rel = 2
0.0023	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 6345 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0029	SELECT /35 bs_news_model/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (130317,158291) ORDER BY n.cover_points DESC, update_date DESC
0.0038	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 = '6345' ORDER BY l.year DESC,cat.coefficient DESC
0.0042	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 = '6345' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0033	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 = '6345' 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 = 72852 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0032	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=6345 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0020	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.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 72852 AND teamId = 6345
0.0030	SELECT count(id) as num_players from rel_players WHERE league_id = 72728 AND teamId = 6345
0.0025	SELECT count(id) as num_players from rel_players WHERE league_id = 72677 AND teamId = 6345
0.0027	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 6345
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 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.0021	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 = '6345' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0024	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '6345' 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 = '6345' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0036	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 = 6345 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.0026	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 = 6345 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025	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 = 6345 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027	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 = 6345 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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.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 = 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.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* `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.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 = 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.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* `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.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* `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 = 44470 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* `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 = 39018 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 = 33746 AND t.round = 46 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* `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 = 15597 AND t.round = 46 ORDER BY team.conference 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* `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 = 4013 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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* `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 = 3474 AND t.round = 46 ORDER BY team.conference 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* `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 = 24450 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020	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 = 24451 AND t.round = 2 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* `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 = 24430 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* `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 = 24420 AND t.round = 40 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0061	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 = 24418 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* `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 = 24405 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* `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 = 25030 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0042	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 = 25064 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Stourbridge

Stourbridge

Selecciona un equipo

Competiciones que juega

Non League Premier Grupo 1

RIVALES EN FA Cup

RIVALES EN FA Trophy

RIVALES EN Non League Premi.