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

Curzon Ashton

Temporada 2016/2017

TEMPORADA 2016/2017

NATIONAL LEAGUE NORTH
Equipo		PJ	GF	GC	Puntos
1	Fylde	42	109	60	88
2	Kidderminste	42	76	41	82
3	Halifax Town	42	81	43	80
4	Salford City	42	79	44	77
5	Darlington	42	89	67	76
6	Chorley	42	60	41	74
7	Brackley	42	66	43	73
8	Stockport	42	59	41	73
9	Tamworth	42	73	67	69
10	Gloucester	42	69	61	64
11	Harrogate	42	71	63	59
12	Nuneaton	42	67	69	55
13	United	42	69	68	54
14	Curzon	42	63	72	52
15	Boston	42	54	72	47
16	Bradford	42	46	74	43
17	Telford	42	38	57	42
18	Alfreton	42	62	95	42
19	Gainsborough	42	51	84	36
20	Worcester	42	44	63	35
21	Stalybridge	42	40	89	29
22	Altrincham	42	39	91	21

TEMPORADA 2015/2016

NATIONAL LEAGUE NORTH
Equipo		PJ	GF	GC	Puntos
1	Solihull	42	84	48	85
2	North	42	82	49	76
3	Fylde	42	76	53	75
4	Nuneaton	42	71	46	73
5	Harrogate	42	73	46	72
6	Boston	42	73	60	71
7	Tamworth	42	55	45	63
8	Chorley	42	64	55	63
9	Stockport	42	50	49	59
10	Alfreton	42	58	54	58
11	Curzon	42	55	52	57
12	Stalybridge	42	62	75	53
13	United	42	60	75	53
14	Bradford	42	51	59	50
15	Gloucester	42	39	49	50
16	Gainsborough	42	46	62	50
17	Worcester	42	55	61	48
18	Telford	42	47	60	47
19	Brackley	42	45	54	46
20	Lowestoft	42	48	69	46
21	Hednesford	42	50	77	38
22	Corby Town	42	47	93	32

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 DIVISION 1 GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Curzon	42	92	36	99
2	Darlington	42	101	37	90
3	Warrington	42	86	47	87
4	Bamber	42	81	45	83
5	Ramsbottom	42	112	57	83
6	Lancaster	42	75	52	80
7	Farsley	42	76	51	75
8	Ossett Town	42	66	63	65
9	Northwich	42	73	52	63
10	Kendal Town	42	83	84	56
11	Cammell	42	65	64	54
12	Salford City	42	68	80	52
13	Harrogate	42	52	66	48
14	Burscough	42	58	82	48
15	Mossley	42	73	90	47
16	New Mills	42	68	95	45
17	Clitheroe	42	55	81	43
18	Radcliffe	42	57	93	43
19	Padiham	42	61	92	42
20	Prescot	42	63	86	40
21	Ossett	42	40	80	29
22	Wakefield	42	55	127	28

TEMPORADA 2012/2013

NON LEAGUE DIVISION 1 GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Skelmersdale	42	110	41	102
2	Cammell	42	86	58	86
3	New Mills	42	107	69	85
4	Trafford	42	93	44	80
5	Mossley	42	83	48	80
6	Ramsbottom	42	97	49	79
7	Curzon	42	98	67	73
8	Clitheroe	42	66	63	73
9	Bamber	42	86	58	70
10	Warrington	42	76	54	69
11	Burscough	42	81	64	59
12	Ossett Town	42	67	65	55
13	Lancaster	42	70	73	53
14	Farsley	42	72	80	49
15	Radcliffe	42	68	69	48
16	Salford City	42	65	79	46
17	Prescot	42	51	67	46
18	Harrogate	42	47	89	41
19	Wakefield	42	38	119	27
20	Ossett	42	49	96	25
21	Goole	42	44	89	23
22	Garforth	42	44	157	16

TEMPORADA 2011/2012

NON LEAGUE DIVISION 1 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Fylde	42	90	29	99
2	Curzon	42	91	44	92
3	Witton	42	101	44	90
4	Farsley	42	86	48	81
5	Garforth	42	95	63	79
6	Lancaster	42	80	48	77
7	Skelmersdale	42	94	60	75
8	Woodley	42	71	51	71
9	Durham City	42	81	80	62
10	Bamber	42	69	68	60
11	Warrington	42	69	71	60
12	Trafford	42	70	66	56
13	Salford City	42	69	73	52
14	Mossley	42	66	75	45
15	Radcliffe	42	54	75	45
16	Prescot	42	53	71	42
17	Ossett Town	42	41	84	42
18	Ossett	42	59	95	39
19	Clitheroe	42	51	76	38
20	Wakefield	42	38	77	33
21	Harrogate	42	54	115	31
22	Cammell	42	34	103	28

TEMPORADA 2010/2011

NON LEAGUE DIVISION 1 GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Chester	44	107	36	97
2	Skelmersdale	44	117	48	97
3	Chorley	44	87	43	86
4	Curzon	44	85	49	85
5	Fylde	44	91	59	81
6	Clitheroe	44	82	70	70
7	Bamber	44	70	60	70
8	Lancaster	44	80	61	68
9	Warrington	44	70	52	67
10	Witton	44	75	64	62
11	Woodley	44	71	75	62
12	Salford City	44	68	73	62
13	Garforth	44	67	71	52
14	Trafford	44	73	92	52
15	Mossley	44	75	77	51
16	Wakefield	44	55	74	50
17	Durham City	44	75	92	48
18	Radcliffe	44	60	89	48
19	Cammell	44	66	94	47
20	Harrogate	44	82	103	46
21	Prescot	44	52	79	42
22	Ossett	44	60	134	26
23	Leigh	44	39	112	23

TEMPORADA 2009/2010

NON LEAGUE DIVISION 1 GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Halifax Town	42	108	38	100
2	Lancaster	42	95	45	96
3	Curzon	42	93	50	81
4	Colwyn Bay	42	77	57	75
5	Skelmersdale	42	80	56	74
6	Leigh	42	81	51	71
7	Mossley	42	73	67	65
8	Clitheroe	42	72	66	62
9	Warrington	42	65	69	60
10	Radcliffe	42	65	78	57
11	Salford City	42	63	74	56
12	Trafford	42	79	73	53
13	Fylde	42	67	79	53
14	Bamber	42	58	67	52
15	Harrogate	42	58	79	52
16	Prescot	42	51	68	50
17	Chorley	42	56	76	49
18	Wakefield	42	49	58	48
19	Woodley	42	53	67	45
20	Garforth	42	64	94	40
21	Ossett	42	52	91	28
22	Rossendale	42	38	94	25

TEMPORADA 2008/2009

NON LEAGUE DIVISION 1 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Durham City	40	98	41	87
2	Skelmersdale	40	96	51	86
3	Colwyn Bay	40	72	49	76
4	Newcastle	40	93	54	73
5	Curzon	41	68	45	71
6	Ossett	40	76	61	66
7	Lancaster	39	68	63	64
8	Halifax Town	41	72	54	63
9	Wakefield	40	65	62	56
10	Mossley	40	63	70	54
11	Bamber	40	69	78	53
12	Clitheroe	40	64	76	52
13	Woodley	40	57	74	51
14	Chorley	40	56	66	47
15	Trafford	40	72	83	46
16	Garforth	40	77	99	44
17	Radcliffe	40	51	66	42
18	Harrogate	40	58	82	42
19	Warrington	40	50	73	41
20	Salford City	40	59	107	36
21	Rossendale	39	52	82	33

TEMPORADA 2007/2008

NON LEAGUE DIVISION 1 GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Bradford	42	91	43	82
2	United	42	91	49	81
3	Skelmersdale	42	94	46	78
4	Curzon	42	78	48	78
5	Bamber	42	70	54	74
6	Ossett	42	77	65	70
7	Wakefield	41	57	46	64
8	Newcastle	41	68	57	60
9	Rossendale	42	66	74	59
10	Garforth	42	60	63	56
11	Lancaster	42	54	70	54
12	Harrogate	42	51	58	51
13	Clitheroe	42	63	77	50
14	Chorley	42	56	80	42
15	Mossley	42	60	100	42
16	Radcliffe	42	53	75	38
17	Woodley	42	38	65	34
18	Bridlington	42	42	99	32

Competiciones que juega

National League North

Pos	Equipos		Pts
1		Fylde	88
2		Kidderminster Harriers	82
3		FC Halifax Town	80
4		Salford City	77
5		Darlington FC	76
6		Chorley	74
7		Brackley Town	73
8		Stockport County	73
9		Tamworth	69
10		Gloucester City	64
11		Harrogate Town	59
12		Nuneaton Town	55
13		United of Manchester	54
14		Curzon Ashton	52
15		Boston United	47
16		Bradford Park Avenue	43
17		AFC Telford United	42
18		Alfreton Town	42
19		Gainsborough Trinity	36
20		Worcester City	35
21		Stalybridge Celtic	29
22		Altrincham	21

	Ascenso : Fylde
	Playoff Ascenso : Kidderminster Harriers, FC Halifax Town, Salford City, Darlington FC
	Descenso : Worcester City, Stalybridge Celtic, Altrincham

RIVALES EN National League.

RIVALES EN FA Cup

RIVALES EN FA Trophy

USO DE MEMORIA

7,089,160 bytes

BENCHMARKS

Loading Time Base Classes	0.0013
Controller Execution Time ( Home / Category )	0.1727
Total Execution Time	0.1740

CADENA URL

/historico/Curzon-Ashton/2017

GET DATOS

$_GET['/historico/Curzon-Ashton/2017']

POST DATOS

No hay datos POST existentes

CONSULTAS (38)

0.0033	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 = 'Curzon-Ashton' AND l.year = 2017 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=10679 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=10679 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=10679 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=10679 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=10679 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0026	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 = 33911
0.0024	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 = 33979
0.0028	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 = 37590
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=10679 AND type_rel = 2
0.0020	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 10679 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0020	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 (142760) ORDER BY n.cover_points DESC, update_date 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 = '10679' AND l.year = 2017 ORDER BY l.year DESC,cat.coefficient DESC
0.0030	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 = '10679' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022	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 = 33911 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0068	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 = 33979 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0040	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 = 37590 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0031	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=10679 AND l.year in (2016,2017,2018) ORDER BY l.id DESC, l.year DESC ;
0.0021	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 (48708,38989,38704,38427) 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.0026	SELECT count(id) as num_players from rel_players WHERE league_id = 38704 AND teamId = 10679
0.0035	SELECT count(id) as num_players from rel_players WHERE league_id = 38989 AND teamId = 10679
0.0019	SELECT count(id) as num_players from rel_players WHERE league_id = 48708 AND teamId = 10679
0.0028	SELECT count(id) as num_players from rel_players WHERE league_id = 38427 AND teamId = 10679
0.0029	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 33911 AND t.round = 42 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0089	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 events2017 e ON e.player_id = p.id AND e.league_id = 33911 WHERE rp.league_id = 33911 AND rp.teamId = 10679 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.0030	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 events2017 e ON e.player_id = p.id AND e.league_id = 33911 WHERE rp.league_id = 33911 AND rp.teamId = 10679 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0030	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 events2017 e ON e.player_id = p.id AND e.league_id = 33911 WHERE rp.league_id = 33911 AND rp.teamId = 10679 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0052	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 = 10679 AND l.year <= 2017 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0040	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 = 33911 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0046	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 = 15423 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0046	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.0056	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 = 3492 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0045	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 = 24866 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* `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 = 24880 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0035	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 = 24904 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031	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 = 24916 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0036	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 = 25006 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* `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 = 25021 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Curzon Ashton

Curzon Ashton

Selecciona un equipo

Competiciones que juega

National League North

RIVALES EN National League.

RIVALES EN FA Cup

RIVALES EN FA Trophy