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

Workington

Temporada 2023/2024

TEMPORADA 2023/2024

NON LEAGUE PREMIER GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Radcliffe	40	103	58	87
2	Macclesfield	40	84	47	77
3	Marine	40	87	44	76
4	Warrington	40	65	42	75
5	Worksop Town	40	72	49	70
6	Hyde	40	68	48	67
7	Ashton	40	73	63	67
8	Gainsborough	40	66	63	63
9	Lancaster	40	60	62	62
10	Guiseley	40	69	63	61
11	Ilkeston	40	69	62	60
12	Whitby Town	40	60	50	56
13	Morpeth Town	40	76	81	50
14	United	40	55	77	48
15	Matlock Town	40	62	77	47
16	Bamber	40	63	82	47
17	Workington	40	67	81	44
18	Basford	40	44	65	37
19	Bradford	40	50	85	30
20	Stafford	40	36	81	30
21	Atherton	40	47	96	25
22	Marske	0	0	0	0

TEMPORADA 2022/2023

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

TEMPORADA 2021/2022

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

TEMPORADA 2020/2021

NON LEAGUE DIVISION 1 GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Brighouse	0	0	0	0
2	Workington	0	0	0	0
3	Tadcaster	0	0	0	0
4	Runcorn	0	0	0	0
5	Ramsbottom	0	0	0	0
6	Ossett	0	0	0	0
7	Marine	0	0	0	0
8	Kendal Town	0	0	0	0
9	Clitheroe	0	0	0	0
10	Marske	0	0	0	0
11	Widnes	0	0	0	0
12	Trafford	0	0	0	0
13	Prescot	0	0	0	0
14	$Pontefract Collieries$ Pontefract	0	0	0	0
15	Pickering	0	0	0	0
16	Mossley	0	0	0	0
17	Dunston UTS	0	0	0	0
18	City	0	0	0	0
19	Colne FC	0	0	0	0

TEMPORADA 2019/2020

NON LEAGUE DIVISION 1 GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Workington	30	75	25	68
2	Ramsbottom	28	71	36	61
3	Marine	28	63	29	55
4	$Pontefract Collieries$ Pontefract	25	47	24	52
5	Marske	24	45	23	47
6	Mossley	29	37	45	42
7	Clitheroe	29	44	39	41
8	Brighouse	28	36	41	39
9	Runcorn	27	41	40	38
10	Tadcaster	26	36	30	37
11	Trafford	28	42	36	35
12	Dunston UTS	27	38	41	35
13	Widnes	28	43	44	33
14	Prescot	29	32	39	33
15	City	27	32	45	32
16	Colne FC	25	31	31	30
17	Droylsden	30	28	75	27
18	Ossett	28	38	57	22
19	Kendal Town	28	29	70	21
20	Pickering	28	34	72	16

TEMPORADA 2018/2019

NON LEAGUE PREMIER GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Farsley	40	82	40	90
2	South	40	86	41	87
3	Warrington	40	69	33	84
4	Nantwich	40	70	59	69
5	Buxton	40	60	45	66
6	Gainsborough	40	53	41	65
7	Basford	40	82	67	61
8	Scarborough	40	70	56	61
9	Witton	40	45	41	58
10	Hyde	40	58	53	53
11	Whitby Town	40	48	59	49
12	Lancaster	40	42	61	49
13	Hednesford	40	51	63	48
14	Stafford	40	62	70	47
15	Matlock Town	40	58	79	44
16	Bamber	40	62	67	42
17	Stalybridge	40	46	62	42
18	Grantham	40	39	72	42
19	Mickleover	40	37	61	41
20	Marine	40	39	54	40
21	Workington	40	38	73	29
22	North	0	0	0	0

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

NATIONAL LEAGUE NORTH
Equipo		PJ	GF	GC	Puntos
1	Telford	42	82	53	85
2	North	42	80	51	82
3	Altrincham	42	95	51	81
4	Hednesford	42	87	65	78
5	Guiseley	42	78	56	78
6	Boston	42	85	60	72
7	Brackley	42	66	45	67
8	Solihull	42	63	52	65
9	Harrogate	42	75	59	63
10	Bradford	42	66	70	57
11	Barrow	42	50	56	56
12	Colwyn Bay	42	63	67	55
13	Leamington	42	54	53	52
14	Stockport	42	58	57	50
15	Worcester	42	40	53	50
16	Gainsborough	42	67	86	45
17	Gloucester	42	64	77	44
18	Vauxhall	42	43	74	44
19	Stalybridge	42	57	88	39
20	Oxford City	42	50	70	37
21	Histon	42	42	76	32
22	Workington	42	39	85	28

TEMPORADA 2012/2013

NATIONAL LEAGUE NORTH
Equipo		PJ	GF	GC	Puntos
1	Chester	42	103	32	107
2	Guiseley	42	83	45	91
3	Brackley	42	76	44	85
4	Altrincham	42	100	51	80
5	Halifax Town	42	86	38	75
6	Harrogate	42	72	50	69
7	Bradford	42	75	52	66
8	Gainsborough	42	68	45	66
9	Solihull	42	58	54	60
10	Oxford City	42	62	57	55
11	Gloucester	42	54	63	54
12	Vauxhall	42	58	64	53
13	Stalybridge	42	55	62	52
14	Workington	42	60	68	52
15	Worcester	42	57	62	50
16	Boston	42	68	73	49
17	Bishops	42	58	74	49
18	Colwyn Bay	42	57	78	49
19	Histon	42	48	73	44
20	Corby Town	42	66	92	44
21	Droylsden	42	43	124	22
22	Hinckley	42	37	143	7

TEMPORADA 2011/2012

NATIONAL LEAGUE NORTH
Equipo		PJ	GF	GC	Puntos
1	Hyde	42	90	36	90
2	Guiseley	42	87	50	85
3	Halifax Town	42	80	59	74
4	Gainsborough	42	74	61	74
5	Nuneaton	42	74	41	72
6	Stalybridge	42	83	64	71
7	Worcester	42	63	58	65
8	Altrincham	42	90	71	61
9	Droylsden	42	83	86	59
10	Bishops	42	70	75	58
11	Boston	42	60	67	54
12	Colwyn Bay	42	55	70	53
13	Workington	42	56	61	52
14	Gloucester	42	53	60	52
15	Harrogate	42	59	69	52
16	Histon	42	67	72	51
17	Corby Town	42	65	71	50
18	Vauxhall	42	63	78	50
19	Solihull	42	44	54	49
20	Hinckley	42	75	90	48
21	Blyth	42	51	81	34
22	Eastwood	42	37	105	20

TEMPORADA 2010/2011

NATIONAL LEAGUE NORTH
Equipo		PJ	GF	GC	Puntos
1	Alfreton	40	97	33	92
2	Telford	40	71	29	82
3	Boston	40	72	33	79
4	Eastwood	40	82	50	73
5	Guiseley	40	56	41	73
6	Nuneaton	40	66	44	72
7	Solihull	40	66	49	64
8	Droylsden	40	69	67	60
9	Blyth	40	61	54	58
10	Stalybridge	40	64	55	57
11	Workington	40	52	60	54
12	Harrogate	40	53	66	50
13	Corby Town	40	58	80	49
14	Gloucester	40	49	63	47
15	Hinckley	40	76	76	46
16	Worcester	40	49	55	46
17	Vauxhall	40	52	71	45
18	Gainsborough	40	50	74	41
19	Hyde	40	44	73	36
20	Stafford	40	39	78	32
21	Redditch	40	30	105	9

TEMPORADA 2009/2010

NATIONAL LEAGUE NORTH
Equipo		PJ	GF	GC	Puntos
1	Southport	40	91	45	86
2	Fleetwood	40	86	44	85
3	Alfreton	40	77	45	74
4	Workington	40	46	37	70
5	Droylsden	40	82	62	64
6	Corby Town	40	73	62	63
7	Hinckley	40	60	52	62
8	Ilkeston	40	53	45	61
9	Northwich	40	62	55	58
10	Stalybridge	40	71	64	55
11	Eastwood	40	50	55	54
12	Telford	40	52	55	51
13	Blyth	40	67	72	48
14	Gainsborough	40	50	57	47
15	Hyde	40	45	72	45
16	Stafford	40	59	70	44
17	Solihull	40	47	58	42
18	Gloucester	40	47	59	42
19	Redditch	40	49	83	38
20	Vauxhall	40	45	81	35
21	Harrogate	40	41	80	30

TEMPORADA 2008/2009

NATIONAL LEAGUE NORTH
Equipo		PJ	GF	GC	Puntos
1	Tamworth	42	70	41	85
2	Gateshead	42	81	48	80
3	Alfreton	42	81	48	77
4	Telford	42	65	34	76
5	Southport	42	63	36	76
6	Stalybridge	42	71	50	70
7	Droylsden	42	64	44	68
8	Fleetwood	42	70	66	62
9	Harrogate	42	66	57	61
10	Hinckley	42	56	59	57
11	Vauxhall	42	51	67	53
12	Workington	42	54	55	51
13	Gainsborough	42	57	63	50
14	Redditch	42	49	61	50
15	Blyth	42	50	58	49
16	Solihull	42	49	73	49
17	Kings Lynn.	42	50	60	48
18	Stafford	42	41	56	48
19	Farsley	42	58	65	47
20	Hyde	42	57	80	42
21	Burscough	42	43	80	36
22	Hucknall	42	39	84	28

TEMPORADA 2007/2008

NATIONAL LEAGUE NORTH
Equipo		PJ	GF	GC	Puntos
1	Kettering	42	93	34	97
2	Telford	42	70	43	80
3	Stalybridge	42	88	51	79
4	Southport	42	77	50	77
5	Barrow	42	70	39	76
6	Harrogate	42	55	41	74
7	Nuneaton	42	58	40	71
8	Burscough	42	62	58	65
9	Hyde	42	84	66	63
10	Boston	42	65	57	59
11	Gainsborough	42	62	65	57
12	Worcester	42	48	68	54
13	Redditch	42	41	58	53
14	Workington	42	52	56	50
15	Tamworth	42	53	59	50
16	Alfreton	42	49	54	47
17	Solihull	42	50	76	47
18	Blyth	42	52	62	46
19	Hinckley	42	48	69	45
20	Hucknall	42	53	75	39
21	Vauxhall	42	42	100	28
22	Leigh	42	36	87	26

TEMPORADA 2006/2007

NATIONAL LEAGUE NORTH
Equipo		PJ	GF	GC	Puntos
1	Droylsden	42	85	55	78
2	Kettering	42	75	58	73
3	Workington	42	61	46	70
4	Hinckley	42	68	54	69
5	Farsley	42	58	51	68
6	Harrogate	42	58	41	67
7	Blyth	42	57	49	66
8	Hyde	42	79	62	65
9	Worcester	42	67	54	62
10	Nuneaton	42	54	45	60
11	Moor Green	42	53	51	59
12	Gainsborough	42	51	57	56
13	Hucknall	42	69	69	54
14	Alfreton	42	44	50	54
15	Vauxhall	42	62	64	51
16	Barrow	42	47	48	50
17	Leigh	42	47	61	49
18	Stalybridge	42	64	81	49
19	Redditch	42	61	68	48
20	Scarborough	42	50	45	45
21	Worksop Town	42	44	62	45
22	Lancaster	42	27	110	1

TEMPORADA 2005/2006

NATIONAL LEAGUE NORTH
Equipo		PJ	GF	GC	Puntos
1	Northwich	42	97	49	92
2	Stafford	42	68	34	85
3	Nuneaton	42	68	43	77
4	Droylsden	42	80	56	72
5	Harrogate	42	66	56	71
6	Kettering	42	63	49	67
7	Stalybridge	42	74	54	66
8	Worcester	42	58	46	62
9	Moor Green	42	67	64	61
10	Hinckley	42	60	55	58
11	Hyde	42	68	61	56
12	Hucknall	42	56	54	55
13	Workington	42	60	62	55
14	Barrow	42	62	67	47
15	Lancaster	42	52	66	47
16	Gainsborough	42	45	65	46
17	Alfreton	42	46	58	45
18	Vauxhall	42	50	71	43
19	Worksop Town	42	46	71	41
20	Leigh	42	45	79	40
21	Redditch	42	52	78	39
22	Hednesford	42	42	87	35

TEMPORADA 2004/2005

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

Competiciones que juega

Grupo 4

Non League Premier Grupo 4

Pos	Equipos		Pts
1		Radcliffe Borough	87
2		Macclesfield Town	77
3		Marine	76
4		Warrington Rylands 1906 FC	75
5		Worksop Town	70
6		Hyde	67
7		Ashton United	67
8		Gainsborough Trinity	63
9		Lancaster City	62
10		Guiseley	61
11		Ilkeston Town FC	60
12		Whitby Town	56
13		Morpeth Town	50
14		United of Manchester	48
15		Matlock Town	47
16		Bamber Bridge	47
17		Workington	44
18		Basford United	37
19		Bradford Park Avenue	30
20		Stafford Rangers	30
21		Atherton Collieries	25
22		Marske United	0

	Ascenso : Radcliffe Borough
	Playoff Ascenso : Macclesfield Town, Marine, Warrington Rylands 1906 FC, Worksop Town
	Descenso : Bradford Park Avenue, Stafford Rangers, Atherton Collieries, Marske United

RIVALES EN FA Cup

RIVALES EN FA Trophy

RIVALES EN Non League Premi.

USO DE MEMORIA

9,035,104 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1856
Total Execution Time	0.1868

CADENA URL

/historico/Workington

GET DATOS

$_GET['/historico/Workington']

POST DATOS

No hay datos POST existentes

CONSULTAS (47)

0.0049	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 = 'Workington' 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=5511 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=5511 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=5511 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020	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=5511 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020	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=5511 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=5511 AND type_rel = 2
0.0019	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=562 AND type_rel = 3
0.0023	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 562 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0023	SELECT /53 bs_news_model/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (1290901,1227363,1202560,1153265,1096842) ORDER BY n.cover_points DESC, update_date DESC
0.0037	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 = '5511' ORDER BY l.year DESC,cat.coefficient DESC
0.0035	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 = '5511' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0037	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 = '5511' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0035	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=5511 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0024	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 (72855,72728,72677,71549,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.0025	SELECT count(id) as num_players from rel_players WHERE league_id = 72855 AND teamId = 5511
0.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 71549 AND teamId = 5511
0.0055	SELECT count(id) as num_players from rel_players WHERE league_id = 72728 AND teamId = 5511
0.0031	SELECT count(id) as num_players from rel_players WHERE league_id = 72677 AND teamId = 5511
0.0024	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 5511
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 = '5511' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '5511' 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 = '5511' 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 = 72855 WHERE rp.league_id = 72855 AND rp.teamId = 5511 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 = 72855 WHERE rp.league_id = 72855 AND rp.teamId = 5511 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 = 72855 WHERE rp.league_id = 72855 AND rp.teamId = 5511 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026	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 = 5511 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0041	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 = 72855 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 = 68459 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.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* `tables2022` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 63533 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.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 = 58742 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.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 = 50969 AND t.round = 31 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.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* `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 = 44472 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0041	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.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* `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.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 = 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.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* `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.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 = 2513 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* `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 = 2011 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 = 1632 AND t.round = 42 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* `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 = 1285 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* `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 = 12904 AND t.round = 42 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* `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 = 12903 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 = 12902 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* `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 = 12901 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* `tables2006` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 12900 AND t.round = 42 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* `tables2005` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 24370 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Workington

Workington

Selecciona un equipo

Competiciones que juega

Non League Premier Grupo 4

RIVALES EN FA Cup

RIVALES EN FA Trophy

RIVALES EN Non League Premi.