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

Soham Town Rangers

Temporada 2023/2024

TEMPORADA 2023/2024

COMBINED COUNTIES LEAGUE GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Mildenhall	36	73	16	92
2	Newmarket	36	92	44	78
3	Thetford	37	85	42	73
4	Mulbarton	37	83	46	73
5	Dereham Town	36	77	48	69
6	Harleston	36	74	53	65
7	Downham Town	36	66	43	60
8	Fakenham	37	65	46	59
9	Walsham	36	66	48	55
10	Lakenheath	36	70	72	52
11	Hadleigh	36	52	68	44
12	Soham Town.	36	56	79	44
13	Sheringham	37	47	70	39
14	Woodbridge	36	43	59	36
15	Long Melford	37	33	70	33
16	Ely City	36	44	69	32
17	Brantham	37	41	71	32
18	Heacham FC	37	31	73	31
19	Kirkley	37	32	85	21
20	Norwich	10	4	32	3

TEMPORADA 2022/2023

COMBINED COUNTIES LEAGUE GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Ipswich	37	93	36	86
2	Thetford	36	101	46	79
3	Woodbridge	36	71	48	70
4	Harleston	37	72	41	67
5	Lakenheath	37	77	57	67
6	Mildenhall	36	76	49	62
7	Sheringham	36	76	50	62
8	Norwich	37	72	50	59
9	Hadleigh	36	61	46	57
10	Mulbarton	36	58	40	52
11	Newmarket	37	71	59	52
12	Long Melford	37	52	65	49
13	Brantham	36	55	64	45
14	Walsham	37	64	67	41
15	Soham Town.	37	60	71	38
16	Kirkley	36	48	59	38
17	Ely City	36	40	82	33
18	Fakenham	36	49	76	32
19	Haverhill	36	38	95	24
20	Whitton	36	26	159	9

TEMPORADA 2021/2022

NON LEAGUE DIVISION 1 GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Ilkeston	38	97	42	87
2	Stamford	38	95	36	84
3	Halesowen	38	92	39	83
4	Chasetown	38	79	38	82
5	Belper Town	38	73	51	73
6	Carlton Town	38	71	48	68
7	Coleshill	38	71	49	61
8	Sporting	38	76	68	60
9	Cambridge	38	60	58	54
10	Spalding	38	47	56	53
11	Shepshed	38	55	60	51
12	Bedworth	38	47	59	47
13	Loughborough	38	71	76	45
14	Yaxley FC	38	59	95	41
15	Corby Town	38	56	66	40
16	Daventry	38	50	80	39
17	Sutton	38	42	62	37
18	Histon	38	37	91	24
19	Soham Town.	38	42	91	21
20	Wisbech Town	38	35	90	18

TEMPORADA 2020/2021

NON LEAGUE DIVISION 1 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Tilbury	8	14	9	16
2	AFC Sudbury	8	15	14	12
3	Maldon	5	9	3	11
4	Bury Town	4	9	2	10
5	Heybridge	8	10	9	10
6	Histon	6	10	9	10
7	Soham Town.	7	7	7	10
8	Grays	6	5	6	10
9	Aveley	6	8	9	9
10	Romford	8	7	10	9
11	Coggeshall	6	7	6	8
12	Dereham Town	7	7	7	8
13	Felixstowe	5	7	7	8
14	Great	7	11	14	8
15	Canvey	5	8	5	6
16	Hullbridge	5	11	9	6
17	Cambridge	4	3	3	6
18	Brentwood	5	5	6	6
19	Basildon	6	11	9	5
20	Witham Town	8	7	27	3

TEMPORADA 2019/2020

NON LEAGUE DIVISION 1 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Maldon	26	65	20	65
2	Aveley	26	66	31	51
3	Tilbury	27	49	30	50
4	Heybridge	29	54	43	50
5	Bury Town	29	49	41	50
6	Coggeshall	26	40	24	46
7	Great	28	45	36	43
8	Dereham Town	29	52	43	41
9	Cambridge	28	42	39	39
10	Canvey	27	49	54	38
11	AFC Sudbury	26	42	42	37
12	Histon	28	40	53	36
13	Soham Town.	28	41	47	34
14	Grays	29	41	47	31
15	Witham Town	28	36	63	29
16	Hullbridge	27	33	53	28
17	Brentwood	28	41	54	26
18	Felixstowe	29	40	62	25
19	Romford	25	41	66	24
20	Basildon	25	29	47	23

TEMPORADA 2018/2019

NON LEAGUE DIVISION 1 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Bowers	38	96	25	92
2	Aveley	38	84	49	80
3	Maldon	38	86	46	79
4	Coggeshall	38	79	43	74
5	Heybridge	38	70	51	74
6	Bury Town	38	72	63	59
7	Grays	38	65	64	53
8	AFC Sudbury	38	71	72	52
9	Canvey	38	51	50	51
10	Tilbury	38	64	64	50
11	Felixstowe	38	56	66	50
12	Dereham Town	38	71	82	47
13	Barking	38	49	63	47
14	Brentwood	38	71	77	45
15	Great	38	55	72	41
16	Soham Town.	38	44	64	40
17	Basildon	38	37	71	39
18	Witham Town	38	38	68	34
19	Romford	38	48	82	34
20	Mildenhall	38	47	82	27

TEMPORADA 2017/2018

NON LEAGUE DIVISION 1 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Hornchurch	46	97	35	103
2	Potters Town	46	87	42	93
3	Bowers	46	94	48	89
4	Haringey	46	84	49	89
5	Heybridge	46	105	53	87
6	Canvey	46	100	65	80
7	Dereham Town	46	75	63	71
8	Maldon	46	94	83	69
9	Bury Town	46	67	65	65
10	Barking	45	63	62	64
11	Witham Town	46	59	66	62
12	AFC Sudbury	46	57	66	59
13	Soham Town.	46	67	73	58
14	Aveley	46	61	67	57
15	Hertford	46	55	85	57
16	Tilbury	46	73	95	56
17	Grays	45	71	80	53
18	Cheshunt	46	72	103	50
19	Waltham	46	73	87	49
20	Ware	46	49	81	48
21	Brentwood	46	71	96	46
22	Mildenhall	46	54	86	46
23	Romford	46	51	97	41
24	Norwich	46	63	95	40

TEMPORADA 2016/2017

NON LEAGUE DIVISION 1 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Brightlingse	46	114	57	103
2	Maldon	46	107	51	91
3	Thurrock	46	84	39	89
4	Hornchurch	46	78	42	85
5	Haringey	46	108	74	81
6	Bowers	46	102	66	78
7	Aveley	46	75	64	76
8	Phoenix	46	71	72	75
9	Norwich	46	70	61	74
10	Cheshunt	46	85	72	71
11	Bury Town	46	74	66	69
12	Tilbury	46	67	73	64
13	Witham Town	46	77	80	59
14	Brentwood	46	63	77	56
15	Athletic	46	53	76	56
16	Romford	46	59	90	56
17	Thamesmead	46	70	78	54
18	Dereham Town	46	70	89	54
19	Soham Town.	46	62	78	53
20	Waltham	46	57	73	51
21	Heybridge	46	64	81	51
22	Ware	46	66	84	51
23	Wroxham	46	42	103	25
24	Great	46	49	121	25

TEMPORADA 2015/2016

NON LEAGUE DIVISION 1 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	AFC Sudbury	46	90	49	105
2	Thurrock	46	99	52	96
3	Harlow Town	46	92	47	96
4	Cray	46	98	52	90
5	Hornchurch	46	87	35	86
6	Cheshunt	46	88	50	80
7	Maldon	46	89	66	78
8	Brightlingse	46	76	55	77
9	Dereham Town	46	82	61	74
10	Thamesmead	46	74	63	74
11	Tilbury	46	85	66	69
12	Aveley	46	84	71	68
13	Bury Town	46	74	68	62
14	Phoenix	46	60	74	56
15	Haringey	46	61	76	50
16	Romford	46	59	83	48
17	Soham Town.	46	61	90	48
18	Great	46	69	103	47
19	Witham Town	46	59	96	45
20	Heybridge	46	59	87	44
21	Waltham	46	54	80	41
22	Wroxham	46	50	89	40
23	Barkingside	46	55	97	37
24	Redbridge	46	46	141	28

TEMPORADA 2014/2015

NON LEAGUE DIVISION 1 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Needham	41	90	38	95
2	Harlow Town	41	99	51	93
3	AFC Sudbury	41	74	45	80
4	Brentwood	40	73	54	78
5	Wroxham	41	92	50	76
6	Thurrock	42	90	50	75
7	Dereham Town	41	77	58	73
8	Brightlingse	41	72	50	70
9	Ware	41	70	52	60
10	Aveley	41	72	67	60
11	Tilbury	41	59	65	56
12	Soham Town.	41	68	79	56
13	Heybridge	42	64	73	55
14	Thamesmead	41	54	62	51
15	Waltham	40	69	74	49
16	Great	41	75	79	48
17	Cheshunt	41	59	73	48
18	Maldon	41	53	70	45
19	Redbridge	41	59	96	41
20	Chatham Town	41	45	64	40
21	Romford	41	61	86	39
22	Barkingside	40	50	84	37
23	Cray	40	58	83	34
24	Burnham	41	47	127	18

TEMPORADA 2013/2014

NON LEAGUE DIVISION 1 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Athletic	46	115	54	99
2	Witham Town	46	109	54	98
3	Heybridge	46	108	59	93
4	Harlow Town	46	105	59	91
5	Thurrock	46	99	60	87
6	Needham	46	85	44	87
7	Dereham Town	46	98	65	77
8	Soham Town.	46	92	75	76
9	AFC Sudbury	46	76	63	76
10	Maldon	46	82	68	76
11	Romford	46	76	69	68
12	Chatham Town	46	74	76	68
13	Aveley	46	81	81	65
14	Redbridge	46	78	84	59
15	Cheshunt	46	74	75	53
16	Burnham	46	69	100	52
17	Waltham	46	71	89	50
18	Tilbury	46	55	75	50
19	Brentwood	46	72	91	49
20	Barkingside	46	76	120	46
21	Ware	46	73	93	45
22	Wroxham	46	77	123	36
23	Walthamstow	46	43	118	25
24	Erith	46	44	137	22

TEMPORADA 2012/2013

NON LEAGUE DIVISION 1 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Grays	42	96	38	102
2	Maldon	42	101	48	89
3	Thamesmead	42	85	49	88
4	Witham Town	42	71	47	79
5	Aveley	42	92	58	78
6	Heybridge	42	102	55	73
7	Soham Town.	42	95	75	73
8	Romford	42	72	72	64
9	Tilbury	42	69	62	63
10	Brentwood	42	63	62	59
11	Cheshunt	42	75	73	58
12	Potters Town	42	64	68	58
13	Waltham	42	60	70	53
14	Chatham Town	42	59	65	52
15	Wroxham	42	68	64	50
16	Needham	42	61	62	49
17	AFC Sudbury	42	57	84	45
18	Walthamstow	42	54	72	40
19	Ware	42	59	105	36
20	Harlow Town	42	45	82	35
21	Redbridge	42	42	105	27
22	Ilford FC	42	32	106	20

TEMPORADA 2011/2012

NON LEAGUE DIVISION 1 GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Leiston	42	99	41	91
2	Enfield Town	42	96	46	90
3	Grays	42	80	47	80
4	Tilbury	42	82	62	80
5	Needham	42	104	56	77
6	Redbridge	42	80	59	73
7	Harlow Town	42	70	49	71
8	AFC Sudbury	42	65	57	69
9	Brentwood	42	58	42	62
10	Thamesmead	42	68	71	58
11	Maldon	42	62	66	58
12	Potters Town	42	67	76	57
13	Romford	42	64	73	57
14	Waltham	42	79	76	55
15	Chatham Town	42	54	63	54
16	Heybridge	42	59	64	52
17	Walthamstow	42	59	95	43
18	Cheshunt	42	42	83	39
19	Soham Town.	42	55	93	34
20	Ilford FC	42	47	85	30
21	Ware	42	40	78	30
22	Great	42	43	91	29

TEMPORADA 2010/2011

NON LEAGUE DIVISION 1 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Arlesey Town	42	108	34	97
2	Hitchin Town	42	107	44	87
3	Daventry	42	95	47	87
4	Biggleswade	42	89	51	81
5	Slough Town	42	91	66	76
6	Rugby Town	42	74	56	71
7	Leighton	42	72	50	69
8	Aylesbury	42	73	62	68
9	Woodford	42	61	59	63
10	Bedfont Town	42	66	66	63
11	Marlow FC	42	68	65	54
12	Barton	42	59	64	51
13	Uxbridge	42	76	87	50
14	Burnham	42	61	87	49
15	Bedworth	42	49	62	48
16	Ashford Town	42	69	85	47
17	Soham Town.	42	55	81	40
18	North	42	51	86	40
19	AFC Hayes	42	54	96	39
20	Northwood	42	59	106	39
21	Atherstone	42	61	118	36
22	Beaconsfield	42	49	75	33

TEMPORADA 2009/2010

NON LEAGUE DIVISION 1 GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Bury Town	42	115	40	102
2	Hitchin Town	42	91	36	100
3	Burnham	42	67	43	87
4	Chesham	42	76	41	80
5	Slough Town	42	87	54	77
6	Sutton	42	93	61	77
7	Woodford	42	70	68	62
8	Romulus	42	66	48	61
9	Arlesey Town	42	58	48	61
10	Leighton	42	63	66	60
11	Soham Town.	42	73	80	58
12	Biggleswade	42	56	63	55
13	Atherstone	42	65	82	54
14	AFC Sudbury	42	55	54	51
15	Marlow FC	42	64	65	50
16	Bedworth	42	59	72	47
17	Stourport	42	63	69	43
18	Rothwell	42	53	80	41
19	Bromsgrove	42	45	68	39
20	Beaconsfield	42	46	96	32
21	Barton	42	49	95	27
22	Aylesbury	42	48	133	18

TEMPORADA 2008/2009

NON LEAGUE DIVISION 1 GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Leamington	42	114	44	101
2	Nuneaton	42	85	31	92
3	Atherstone	42	82	45	85
4	Chasetown	42	67	31	84
5	Chesham	42	70	38	76
6	Sutton	42	79	62	76
7	Bury Town	42	88	41	75
8	Leighton	42	57	46	67
9	Marlow FC	42	65	53	66
10	Aylesbury	42	65	58	64
11	Romulus	42	60	42	61
12	AFC Sudbury	42	66	65	61
13	Bromsgrove	42	58	53	53
14	Bedworth	42	50	66	49
15	Soham Town.	42	48	79	46
16	Stourport	42	46	74	40
17	Barton	42	50	79	40
18	Arlesey Town	42	40	70	38
19	Dunstable	42	54	89	36
20	Rothwell	42	35	79	36
21	Woodford	42	38	80	34
22	Malvern Town	42	27	119	16

Competiciones que juega

Grupo 4

Combined Counties League Grupo 4

Pos	Equipos		Pts
1		Mildenhall Town FC	92
2		Newmarket Town	78
3		Thetford Town	73
4		Mulbarton Wanderers	73
5		Dereham Town	69
6		Harleston Town	65
7		Downham Town	60
8		Fakenham Town	59
9		Walsham Le Willows	55
10		Lakenheath FC	52
11		Hadleigh United	44
12		Soham Town Rangers	44
13		Sheringham	39
14		Woodbridge Town	36
15		Long Melford	33
16		Ely City	32
17		Brantham Athletic	32
18		Heacham FC	31
19		Kirkley & Pakefield	21
20		Norwich United	3

RIVALES EN Combined Countie.

RIVALES EN FA Cup

USO DE MEMORIA

7,857,632 bytes

BENCHMARKS

Loading Time Base Classes	0.0013
Controller Execution Time ( Home / Category )	0.1437
Total Execution Time	0.1451

CADENA URL

/historico/Soham-Town-Rangers

GET DATOS

$_GET['/historico/Soham-Town-Rangers']

POST DATOS

No hay datos POST existentes

CONSULTAS (36)

0.0034	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 = 'Soham-Town-Rangers' 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.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=10470 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=10470 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=10470 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=10470 AND type_rel = 2
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2490 AND type_rel = 3
0.0030	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 = '10470' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0028	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 = '10470' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0026	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=10470 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019	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 (73097,72728,67320) 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.0018	SELECT count(id) as num_players from rel_players WHERE league_id = 73097 AND teamId = 10470
0.0019	SELECT count(id) as num_players from rel_players WHERE league_id = 72728 AND teamId = 10470
0.0019	SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 10470
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 = '10470' 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 = '10470' and rp.type = 4
0.0022	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 = '10470' 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 events2024 e ON e.player_id = p.id AND e.league_id = 73097 WHERE rp.league_id = 73097 AND rp.teamId = 10470 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.0018	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 = 73097 WHERE rp.league_id = 73097 AND rp.teamId = 10470 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021	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 = 73097 WHERE rp.league_id = 73097 AND rp.teamId = 10470 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024	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 = 10470 AND l.year <= 2024 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* `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 = 73097 AND t.round = 10 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* `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 = 68435 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* `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 = 63532 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* `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 = 58739 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 = 50966 AND t.round = 30 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 = 44456 AND t.round = 38 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* `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 = 39168 AND t.round = 46 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* `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 = 33751 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* `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 = 15613 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 = 4392 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* `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 = 3489 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* `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 = 24863 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033	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 = 24888 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* `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 = 24893 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* `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 = 24920 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* `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 = 25010 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Soham Town Rangers

Soham Town Rangers

Selecciona un equipo

Competiciones que juega

Combined Counties League Grupo 4

RIVALES EN Combined Countie.

RIVALES EN FA Cup