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

Romford

Temporada 2023/2024

TEMPORADA 2023/2024

COMBINED COUNTIES LEAGUE GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Tilbury	38	78	27	86
2	Romford	37	86	49	77
3	Woodford	37	81	47	74
4	Barking	37	75	47	67
5	Sporting	37	75	54	67
6	Great	35	76	46	60
7	Saffron	37	60	55	60
8	Stanway	37	68	50	57
9	Little	38	65	57	55
10	Athletic	37	58	54	52
11	Halstead	37	70	67	51
12	Hullbridge	37	51	56	49
13	West Essex	38	67	76	42
14	White Ensign	37	49	65	40
15	Clacton	36	56	79	40
16	Buckhurst	37	48	70	39
17	Takeley	36	56	73	38
18	Frenford FC	38	52	83	35
19	Ilford FC	37	55	108	32
20	Coggeshall	37	40	103	17

TEMPORADA 2022/2023

COMBINED COUNTIES LEAGUE GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Enfield FC	38	114	36	92
2	Redbridge	37	81	32	87
3	Clacton	38	76	59	73
4	Woodford	36	84	46	72
5	Athletic	38	76	44	69
6	Takeley	38	78	48	67
7	Barking	38	81	64	65
8	Saffron	38	78	65	61
9	Stansted	38	65	47	60
10	West Essex	38	70	48	59
11	Stanway	38	60	61	52
12	Little	38	57	66	52
13	White Ensign	38	60	83	49
14	Romford	38	72	69	47
15	Halstead	38	54	71	42
16	Ilford FC	38	51	76	40
17	Buckhurst	38	61	70	39
18	Sawbridgewor	38	32	83	26
19	Clapton	38	33	114	18
20	Southend	37	21	122	9

TEMPORADA 2021/2022

NON LEAGUE DIVISION 1 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Aveley	38	94	37	80
2	Canvey	38	100	42	78
3	Brentwood	38	73	41	75
4	Stowmarket	38	75	39	73
5	Felixstowe	38	60	45	72
6	Grays	38	69	38	68
7	AFC Sudbury	38	57	46	63
8	Hashtag	38	60	49	62
9	Maldon	38	74	63	60
10	Dereham Town	38	63	53	60
11	Heybridge	38	77	73	53
12	Bury Town	38	63	71	44
13	Coggeshall	38	53	68	43
14	Tilbury	38	57	68	41
15	Great	38	58	74	40
16	Hullbridge	38	43	72	39
17	Basildon	38	35	60	35
18	Barking	38	51	79	35
19	Witham Town	38	40	71	33
20	Romford	38	26	139	13

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 3
Equipo		PJ	GF	GC	Puntos
1	East	40	92	38	95
2	Needham	40	95	49	87
3	Wingate	40	72	54	72
4	Harlow Town	40	61	51	71
5	Brentwood	40	75	55	69
6	Enfield Town	40	76	44	68
7	AFC Sudbury	40	82	64	66
8	Maldon	40	70	67	63
9	Heybridge	40	81	59	61
10	Grays	40	69	51	61
11	Waltham	40	75	63	58
12	Romford	40	63	66	55
13	Potters Town	40	60	68	51
14	Ware	40	57	77	45
15	Great	40	60	82	44
16	Redbridge	40	51	79	39
17	Thamesmead	40	42	71	39
18	Cheshunt	40	49	81	38
19	Tilbury	40	41	66	37
20	Ilford FC	40	42	81	32
21	Walthamstow	40	43	90	26

TEMPORADA 2009/2010

NON LEAGUE DIVISION 1 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Lowestoft	42	115	37	101
2	Concord	42	94	42	86
3	Wingate	42	88	55	81
4	Enfield Town	42	81	47	80
5	East	42	102	59	77
6	Heybridge	42	67	56	71
7	Thamesmead	42	67	56	67
8	Athletic	42	61	53	67
9	Great	42	67	70	64
10	Northwood	42	65	61	61
11	Tilbury	42	61	60	56
12	Brentwood	42	53	53	52
13	Romford	42	71	88	52
14	Potters Town	42	51	67	50
15	Cheshunt	42	57	83	50
16	Walthamstow	42	51	75	48
17	Maldon	42	54	74	45
18	Ilford FC	42	47	72	43
19	Redbridge	42	41	62	42
20	Ware	42	57	84	42
21	Leyton FC	42	40	84	30
22	Harlow Town	42	46	98	25

Competiciones que juega

Grupo 1

Combined Counties League Grupo 1

Pos	Equipos		Pts
1		Tilbury	86
2		Romford	77
3		Woodford Town	74
4		Barking	67
5		Sporting Bengal United	67
6		Great Wakering Rovers	60
7		Saffron Walden Town FC	60
8		Stanway Rovers FC	57
9		Little Oakley	55
10		Athletic Newham	52
11		Halstead Town	51
12		Hullbridge Sports	49
13		West Essex	42
14		White Ensign	40
15		Clacton	40
16		Buckhurst Hill	39
17		Takeley	38
18		Frenford FC	35
19		Ilford FC	32
20		Coggeshall Town	17

	Ascenso : Tilbury
	Posible siguiente ronda : Romford
	Descenso : Ilford FC, Coggeshall Town

RIVALES EN Combined Countie.

RIVALES EN FA Cup

USO DE MEMORIA

7,737,816 bytes

BENCHMARKS

Loading Time Base Classes	0.0025
Controller Execution Time ( Home / Category )	0.1915
Total Execution Time	0.1940

CADENA URL

/historico/Romford

GET DATOS

$_GET['/historico/Romford']

POST DATOS

No hay datos POST existentes

CONSULTAS (40)

0.0065	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 = 'Romford' 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.0021	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=10391 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021	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=10391 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0047	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=10391 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=10391 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0055	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 = 72982
0.0031	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=10391 AND type_rel = 2
0.0024	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2490 AND type_rel = 3
0.0039	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 = '10391' ORDER BY l.year DESC,cat.coefficient DESC
0.0023	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 = '10391' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0022	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 = '10391' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020	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 = 72982 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=10391 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 (72982,72728,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.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 72982 AND teamId = 10391
0.0019	SELECT count(id) as num_players from rel_players WHERE league_id = 72728 AND teamId = 10391
0.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 10391
0.0136	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM* `tables2024` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 72982 AND t.round = 10 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020	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 = '10391' 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 = '10391' 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 = '10391' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 72982 WHERE rp.league_id = 72982 AND rp.teamId = 10391 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.0022	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 = 72982 WHERE rp.league_id = 72982 AND rp.teamId = 10391 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0020	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 = 72982 WHERE rp.league_id = 72982 AND rp.teamId = 10391 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0030	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 = 10391 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 72982 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.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* `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 = 68436 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.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* `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 = 63528 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.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* `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.0028	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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.0026	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2019` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 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.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* `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.0029	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.0029	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.0027	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2015` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 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.0028	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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.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* `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.0037	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 = 24900 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* `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 = 24912 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Romford

Romford

Selecciona un equipo

Competiciones que juega

Combined Counties League Grupo 1

RIVALES EN Combined Countie.

RIVALES EN FA Cup