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

Market Drayton Town

Temporada 2022/2023

TEMPORADA 2022/2023

COMBINED COUNTIES LEAGUE GRUPO 16
Equipo		PJ	GF	GC	Puntos
1	Walsall Wood	36	67	33	79
2	Lye Town	36	81	44	75
3	Racing Club	37	84	46	70
4	Highgate	36	82	45	68
5	Romulus	36	80	50	68
6	Darlaston	36	59	35	65
7	Stourport	37	57	39	65
8	Shifnal Town	36	64	38	64
9	Atherstone	36	57	52	54
10	Lichfield	37	62	57	53
11	Whitchurch	36	64	61	52
12	Wulfrunians	37	56	56	49
13	Studley FC	37	53	55	49
14	Tividale	36	44	54	46
15	Stone	37	48	71	44
16	Bewdley Town	37	58	84	42
17	Worcester	37	35	66	32
18	Wolv.	37	31	79	27
19	Uttoxeter	37	30	84	21
20	Market	36	27	90	11

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 5
Equipo		PJ	GF	GC	Puntos
1	Belper Town	0	0	0	0
2	Frickley	0	0	0	0
3	Glossop	0	0	0	0
4	Ilkeston	0	0	0	0
5	Kidsgrove	0	0	0	0
6	Lincoln	0	0	0	0
7	Loughborough	0	0	0	0
8	Sheffield	0	0	0	0
9	Sutton	0	0	0	0
10	Market	0	0	0	0
11	Worksop Town	0	0	0	0
12	Carlton Town	0	0	0	0
13	Chasetown	0	0	0	0
14	Cleethorpes	0	0	0	0
15	Leek Town	0	0	0	0
16	Newcastle	0	0	0	0
17	Spalding	0	0	0	0
18	Stamford	0	0	0	0
19	Stocksbridge	0	0	0	0
20	Wisbech Town	0	0	0	0

TEMPORADA 2019/2020

NON LEAGUE DIVISION 1 GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Leek Town	28	64	19	72
2	Stamford	29	74	27	70
3	Cleethorpes	29	67	40	57
4	Belper Town	26	44	29	49
5	Carlton Town	25	51	33	45
6	Frickley	30	47	42	45
7	Sutton	28	45	34	44
8	Stocksbridge	29	48	45	44
9	Ilkeston	31	50	48	42
10	Kidsgrove	27	42	31	39
11	Loughborough	29	43	45	39
12	Worksop Town	31	41	54	38
13	Sheffield	26	48	45	37
14	Spalding	28	32	46	32
15	Glossop	29	30	44	30
16	Chasetown	29	36	51	29
17	Newcastle	30	42	55	28
18	Lincoln	29	30	60	27
19	Market	30	34	85	20
20	Wisbech Town	29	29	64	18

TEMPORADA 2018/2019

NON LEAGUE DIVISION 1 GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Atherton	38	89	34	82
2	Radcliffe	38	73	34	75
3	Leek Town	38	78	34	74
4	Colne FC	38	71	44	73
5	Ramsbottom	38	78	41	72
6	Runcorn	38	69	50	72
7	Prescot	38	84	54	69
8	Mossley	38	66	51	65
9	Trafford	38	53	44	61
10	Kidsgrove	38	58	40	58
11	Colwyn Bay	38	73	66	52
12	Widnes	38	60	61	51
13	Chasetown	38	61	63	46
14	Droylsden	38	61	72	43
15	Newcastle	38	52	74	40
16	Market	37	53	90	40
17	Glossop	38	41	74	31
18	Clitheroe	38	45	88	28
19	Kendal Town	37	28	92	16
20	Skelmersdale	38	24	111	13

TEMPORADA 2017/2018

NON LEAGUE DIVISION 1 GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Basford	42	101	42	100
2	Frickley	42	117	61	85
3	Alvechurch	42	78	49	85
4	Bedworth	42	73	58	74
5	Chasetown	42	83	64	73
6	Stamford	42	66	34	71
7	Leek Town	42	80	50	68
8	Lincoln	42	85	81	68
9	Cleethorpes	42	82	57	67
10	Corby Town	42	74	75	60
11	Stocksbridge	42	75	66	53
12	Peterborough	42	70	78	51
13	Spalding	42	52	62	50
14	Loughborough	42	61	78	49
15	Sheffield	42	66	85	45
16	Belper Town	42	46	90	45
17	Gresley	42	49	91	43
18	Kidsgrove	42	70	90	42
19	Carlton Town	42	66	76	41
20	Newcastle	42	49	73	39
21	Market	42	51	97	39
22	Romulus	42	57	94	35

TEMPORADA 2016/2017

NON LEAGUE DIVISION 1 GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Shaw Lane A.	42	104	36	102
2	Witton	42	96	40	97
3	Spalding	42	74	42	79
4	Basford	42	78	53	73
5	Stocksbridge	42	67	50	73
6	Rushden	42	73	52	71
7	Newcastle	42	59	59	67
8	Lincoln	42	67	61	65
9	Leek Town	42	63	63	64
10	Belper Town	42	55	55	58
11	Bedworth	42	73	72	57
12	Kidsgrove	42	72	66	55
13	Romulus	42	65	75	51
14	Market	42	60	93	50
15	Stamford	42	61	76	49
16	Sheffield	42	62	60	48
17	Chasetown	42	64	75	47
18	Gresley	42	56	83	45
19	Carlton Town	42	48	68	42
20	Northwich	42	53	89	36
21	Loughborough	42	45	94	34
22	Rugby Town	42	44	77	30

TEMPORADA 2015/2016

NON LEAGUE DIVISION 1 GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Stafford	42	79	31	95
2	Shaw Lane A.	42	95	40	94
3	Coalville	42	81	46	85
4	Basford	42	67	42	76
5	Lincoln	42	70	46	74
6	Stocksbridge	42	72	53	69
7	Chasetown	42	68	49	68
8	Leek Town	42	61	56	63
9	Rugby Town	42	73	68	60
10	Romulus	42	76	74	60
11	Market	42	65	65	58
12	Spalding	42	52	54	56
13	Belper Town	42	66	65	54
14	Newcastle	42	65	68	53
15	Kidsgrove	42	81	78	50
16	Gresley	42	58	75	50
17	Sheffield	42	61	71	47
18	Carlton Town	42	60	72	47
19	Goole	42	51	87	38
20	Loughborough	42	60	108	35
21	Daventry	42	43	113	33
22	Tividale	42	52	95	26

TEMPORADA 2014/2015

NON LEAGUE DIVISION 1 GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Mickleover	42	105	40	98
2	Leek Town	42	91	37	91
3	Newcastle	42	92	46	87
4	Sutton	42	75	41	83
5	Gresley	42	96	51	81
6	Stafford	42	68	33	81
7	Spalding	42	84	41	79
8	Tividale	42	65	43	71
9	Lincoln	42	71	53	66
10	Coalville	42	76	71	61
11	Norton	42	79	75	61
12	Romulus	42	69	65	61
13	Chasetown	42	60	64	51
14	Loughborough	42	71	87	48
15	Sheffield	42	72	92	48
16	Goole	42	52	66	45
17	Stocksbridge	42	53	84	41
18	Carlton Town	42	52	79	39
19	Market	42	66	109	37
20	Kidsgrove	42	48	96	36
21	Rainworth	42	46	91	30
22	Brigg Town	42	26	153	12

TEMPORADA 2013/2014

NON LEAGUE DIVISION 1 GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Halesowen	40	80	38	91
2	Coalville	40	101	35	89
3	Leek Town	40	86	35	88
4	Belper Town	40	98	50	81
5	Mickleover	40	82	62	73
6	Sutton	40	74	52	64
7	Scarborough	40	73	57	61
8	Newcastle	40	66	65	59
9	Gresley	40	66	67	56
10	Carlton Town	40	58	55	55
11	Romulus	40	66	64	55
12	Chasetown	40	52	59	52
13	Goole	40	60	76	51
14	Loughborough	40	62	77	47
15	Rainworth	40	53	72	46
16	Sheffield	39	65	76	43
17	Lincoln	40	55	89	36
18	Brigg Town	40	49	94	35
19	Market	40	56	105	35
20	Bedworth	39	44	79	33
21	Kidsgrove	40	41	80	30
22	Eastwood	0	0	0	0

TEMPORADA 2012/2013

NON LEAGUE DIVISION 1 GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Kings Lynn.	42	86	46	92
2	Coalville	42	108	44	86
3	Belper Town	42	95	42	82
4	Stamford	42	97	58	76
5	Chasetown	42	83	51	74
6	Sutton	42	81	61	74
7	Halesowen	42	79	65	74
8	Northwich	42	88	58	67
9	Sheffield	42	85	82	63
10	Leek Town	42	72	60	59
11	Gresley	42	75	77	58
12	Carlton Town	42	67	68	56
13	Brigg Town	42	62	76	53
14	Rainworth	42	59	75	51
15	Market	42	68	78	50
16	Loughborough	42	75	75	49
17	Newcastle	42	45	58	46
18	Kidsgrove	42	75	89	43
19	Romulus	42	52	78	42
20	Lincoln	42	64	102	36
21	Mickleover	42	51	92	34
22	Hucknall	42	39	171	16

TEMPORADA 2011/2012

NON LEAGUE DIVISION 1 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Grantham	42	92	44	94
2	Carlton Town	42	101	52	83
3	Ilkeston	42	93	44	83
4	Sheffield	42	93	62	75
5	Leek Town	42	77	60	74
6	Belper Town	42	74	57	74
7	Stamford	42	77	75	68
8	Loughborough	42	80	61	65
9	New Mills	42	79	76	63
10	Goole	42	72	78	62
11	Hucknall	42	54	61	57
12	Sutton	42	72	63	55
13	Kidsgrove	42	62	59	55
14	Coalville	42	69	72	55
15	Newcastle	42	59	70	52
16	Market	42	61	84	47
17	Brigg Town	42	52	76	45
18	Lincoln	42	65	85	43
19	Rainworth	42	38	55	41
20	Romulus	42	56	85	36
21	Quorn	42	48	85	27
22	Shepshed	42	45	115	25

TEMPORADA 2010/2011

NON LEAGUE DIVISION 1 GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Barwell	42	84	46	94
2	Newcastle	42	104	48	90
3	Rushall	42	78	45	81
4	Brigg Town	42	74	58	80
5	Grantham	42	69	48	79
6	Sutton	42	89	60	75
7	Kidsgrove	42	88	59	75
8	Carlton Town	42	88	50	73
9	Glapwell	42	82	58	69
10	Romulus	42	71	65	67
11	Sheffield	42	73	86	55
12	Lincoln	42	70	77	54
13	Goole	42	79	93	54
14	Belper Town	42	70	74	53
15	Quorn	42	57	61	47
16	Leek Town	42	64	74	47
17	Loughborough	42	72	89	46
18	Market	42	67	91	44
19	Stamford	42	62	74	42
20	Rainworth	42	53	85	40
21	Shepshed	42	44	103	21
22	Spalding	42	33	127	16

TEMPORADA 2009/2010

NON LEAGUE DIVISION 1 GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Mickleover	42	93	51	89
2	Chasetown	42	78	42	82
3	Glapwell	42	73	42	81
4	Kidsgrove	42	93	50	78
5	Sheffield	42	74	50	73
6	Belper Town	42	83	55	71
7	Witton	42	76	53	67
8	Leek Town	42	68	61	67
9	Carlton Town	42	74	68	66
10	Stamford	42	77	54	64
11	Grantham	42	62	56	62
12	Rushall	42	68	61	59
13	Market	42	71	81	53
14	Loughborough	42	70	80	53
15	Brigg Town	42	60	77	52
16	Cammell	42	51	66	50
17	Shepshed	42	44	55	48
18	Goole	42	70	84	46
19	Lincoln	42	57	67	44
20	Quorn	42	55	78	40
21	Spalding	42	33	111	20
22	Willenhall	42	21	109	19

Competiciones que juega

Combined Counties League Grupo 16

Pos	Equipos		Pts
1		Walsall Wood	79
2		Lye Town	75
3		Racing Club Warwick	70
4		Highgate United	68
5		Romulus	68
6		Darlaston Town	65
7		Stourport Swifts	65
8		Shifnal Town	64
9		Atherstone Town	54
10		Lichfield City	53
11		Whitchurch Alport	52
12		AFC Wulfrunians	49
13		Studley FC	49
14		Tividale	46
15		Stone Old Alleynians	44
16		Bewdley Town	42
17		Worcester City	32
18		Wolv. Casuals	27
19		Uttoxeter Town	21
20		Market Drayton Town	11

	Ascenso : Walsall Wood
	Descenso : Uttoxeter Town, Market Drayton Town

RIVALES EN Combined Countie.

RIVALES EN FA Cup

USO DE MEMORIA

7,488,792 bytes

BENCHMARKS

Loading Time Base Classes	0.0015
Controller Execution Time ( Home / Category )	0.1516
Total Execution Time	0.1532

CADENA URL

/historico/Market-Drayton-Town

GET DATOS

$_GET['/historico/Market-Drayton-Town']

POST DATOS

No hay datos POST existentes

CONSULTAS (35)

0.0041	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 = 68446
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=10808 AND type_rel = 2
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2490 AND type_rel = 3
0.0027	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 = '10808' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0024	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 = '10808' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019	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 = 68446 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023	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=10808 AND l.year in (2022,2023,2024) 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 (68446,68334,67320,63973,63533) 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.0019	SELECT count(id) as num_players from rel_players WHERE league_id = 63533 AND teamId = 10808
0.0018	SELECT count(id) as num_players from rel_players WHERE league_id = 68446 AND teamId = 10808
0.0018	SELECT count(id) as num_players from rel_players WHERE league_id = 68334 AND teamId = 10808
0.0019	SELECT count(id) as num_players from rel_players WHERE league_id = 63973 AND teamId = 10808
0.0018	SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 10808
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 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 = 68446 AND t.round = 9 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 = '10808' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '10808' and rp.type = 4
0.0020	SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '10808' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0019	SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2023 e ON e.player_id = p.id AND e.league_id = 68446 WHERE rp.league_id = 68446 AND rp.teamId = 10808 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019	SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2023 e ON e.player_id = p.id AND e.league_id = 68446 WHERE rp.league_id = 68446 AND rp.teamId = 10808 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019	SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2023 e ON e.player_id = p.id AND e.league_id = 68446 WHERE rp.league_id = 68446 AND rp.teamId = 10808 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 = 10808 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 = 68446 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.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 = 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.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* `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 = 58743 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 50970 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.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* `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 = 44462 AND t.round = 38 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 = 39171 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* `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 = 33757 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* `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 = 15618 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* `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 = 4170 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* `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 = 3493 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* `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 = 24868 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0060	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 = 24882 AND t.round = 42 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* `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 = 24908 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032	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 = 24918 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Market Drayton Town

Market Drayton Town

Selecciona un equipo

Competiciones que juega

Combined Counties League Grupo 16

RIVALES EN Combined Countie.

RIVALES EN FA Cup