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

Merthyr Town

Temporada 2023/2024

TEMPORADA 2023/2024

NON LEAGUE PREMIER GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Chesham	42	83	46	90
2	AFC Totton	42	89	45	81
3	Salisbury	42	70	46	79
4	Gosport	42	75	43	78
5	Bracknell	42	84	71	68
6	Merthyr Town	42	85	59	67
7	Walton	42	78	67	65
8	Hungerford	42	77	70	64
9	Dorchester	42	66	77	60
10	Hendon	42	70	65	58
11	Winchester	42	63	67	57
12	Basingstoke	42	69	83	53
13	Poole Town	42	70	76	52
14	Tiverton	42	64	74	52
15	Sholing	42	52	63	49
16	Swindon	42	73	92	49
17	Hanwell Town	42	64	71	48
18	Plymouth	42	60	68	48
19	Beaconsfield	42	63	78	48
20	Hayes	42	59	67	46
21	Harrow	42	60	97	39
22	Didcot Town	42	45	94	28

TEMPORADA 2022/2023

NON LEAGUE PREMIER GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Weston-super	42	89	32	93
2	Bracknell	42	100	53	90
3	Truro City	42	88	41	89
4	Poole Town	42	86	51	80
5	Chesham	42	88	57	79
6	Swindon	42	88	66	77
7	Hayes	42	80	58	71
8	Metropolitan	42	61	59	61
9	Merthyr Town	42	73	64	60
10	Plymouth	42	63	62	58
11	Beaconsfield	42	75	73	57
12	Tiverton	42	62	77	55
13	Dorchester	42	57	79	54
14	Hanwell Town	42	55	65	50
15	Salisbury	42	55	71	49
16	Winchester	42	56	72	48
17	Gosport	42	58	78	47
18	Hendon	42	55	81	38
19	Harrow	42	44	80	37
20	North Leigh	42	50	86	34
21	Yate Town	42	50	92	34
22	Hartley	42	40	76	32

TEMPORADA 2021/2022

NON LEAGUE PREMIER GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Taunton Town	42	83	42	91
2	Hayes	42	100	39	86
3	Farnborough	42	73	44	85
4	Metropolitan	42	72	46	81
5	Weston-super	42	72	42	78
6	Chesham	42	80	50	77
7	Yate Town	42	66	48	72
8	Truro City	42	62	54	70
9	Gosport	42	65	56	66
10	Poole Town	42	74	69	64
11	Walton	42	53	61	58
12	Swindon	42	63	63	57
13	Tiverton	42	61	63	53
14	Harrow	42	63	77	52
15	Salisbury	42	49	75	48
16	Hendon	42	58	70	47
17	Beaconsfield	42	70	92	46
18	Hartley	42	56	75	44
19	Dorchester	42	41	58	41
20	Kings	42	49	68	37
21	Merthyr Town	42	47	94	26
22	Wimborne	42	35	106	19

TEMPORADA 2020/2021

NON LEAGUE PREMIER GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Poole Town	7	16	7	19
2	Tiverton	7	21	4	18
3	Salisbury	7	17	7	17
4	Truro City	8	17	9	16
5	Metropolitan	8	14	11	14
6	Swindon	7	12	10	12
7	Chesham	7	6	4	12
8	Taunton Town	6	8	5	11
9	Hendon	8	12	10	11
10	Hayes	7	11	8	10
11	Gosport	7	11	9	8
12	Walton	6	8	13	7
13	Wimborne	6	5	12	7
14	Hartley	6	5	9	6
15	Weston-super	6	8	10	5
16	Harrow	7	11	14	5
17	Yate Town	8	8	17	5
18	Farnborough	8	7	16	4
19	Dorchester	7	5	17	4
20	Beaconsfield	7	4	14	2
21	Merthyr Town	0	0	0	0

TEMPORADA 2019/2020

NON LEAGUE PREMIER GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Truro City	31	65	30	67
2	Chesham	33	70	45	64
3	Hayes	32	65	42	57
4	Swindon	32	50	41	57
5	Tiverton	29	69	41	55
6	Taunton Town	31	63	53	53
7	Salisbury	30	57	42	51
8	Gosport	33	35	32	49
9	Poole Town	26	45	28	45
10	Weston-super	28	49	45	42
11	Farnborough	30	41	43	42
12	Metropolitan	29	43	47	40
13	Hendon	31	48	51	39
14	Merthyr Town	31	37	37	38
15	Wimborne	32	39	47	37
16	Hartley	27	38	39	36
17	Harrow	34	44	62	36
18	Blackfield	30	31	48	32
19	Yate Town	31	38	56	29
20	Walton	32	38	69	26
21	Beaconsfield	31	28	51	25
22	Dorchester	31	36	80	18

TEMPORADA 2018/2019

NON LEAGUE PREMIER GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Weymouth	42	96	51	86
2	Taunton Town	42	89	56	85
3	Metropolitan	42	91	64	78
4	Salisbury	42	97	69	77
5	Poole Town	42	84	59	70
6	Kings	42	65	61	69
7	Harrow	42	97	77	63
8	Hartley	42	82	70	63
9	Farnborough	42	72	72	62
10	Chesham	42	54	55	59
11	Swindon	42	70	59	58
12	Beaconsfield	42	65	65	58
13	Merthyr Town	42	68	67	54
14	Wimborne	42	72	75	52
15	Dorchester	42	67	75	52
16	Hendon	42	64	74	52
17	Walton	42	69	78	51
18	Tiverton	42	65	75	51
19	Gosport	42	63	70	50
20	Basingstoke	42	81	82	49
21	Frome Town	42	45	74	37
22	Staines Town	42	40	168	12

TEMPORADA 2017/2018

NON LEAGUE PREMIER GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Hereford	46	110	34	110
2	Slough Town	46	111	49	99
3	Kettering	46	122	56	97
4	Kings Lynn.	46	96	40	97
5	Weymouth	46	103	48	97
6	Tiverton	46	78	69	78
7	Chesham	46	86	58	77
8	Royston Town	46	84	65	77
9	Banbury	46	90	59	72
10	Basingstoke	46	91	73	68
11	Hitchin Town	46	67	66	66
12	Neots Town	46	79	79	64
13	Frome Town	46	78	96	61
14	Biggleswade	46	53	62	56
15	Redditch	46	73	73	55
16	Stratford	46	68	81	55
17	Merthyr Town	46	76	98	53
18	Bishops	46	74	79	52
19	Dorchester	46	62	83	51
20	Farnborough	46	82	120	51
21	Kings	46	64	97	41
22	Ives Town	46	54	105	33
23	Gosport	46	41	142	20
24	Dunstable	46	27	137	17

TEMPORADA 2016/2017

NON LEAGUE PREMIER GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Chippenham	46	94	48	101
2	Leamington	46	74	32	92
3	Merthyr Town	46	92	43	89
4	Hitchin Town	46	79	46	85
5	Slough Town	46	84	56	85
6	Banbury	46	68	40	82
7	Kettering	46	88	66	75
8	Biggleswade	46	86	60	74
9	Frome Town	46	80	68	73
10	Weymouth	46	79	58	66
11	Chesham	46	67	62	64
12	Basingstoke	46	65	72	62
13	Kings Lynn.	46	60	69	60
14	Stratford	46	64	66	56
15	Ives Town	46	49	70	56
16	Dunstable	46	46	65	54
17	Redditch	46	54	75	50
18	Dorchester	46	52	82	48
19	Neots Town	46	66	102	48
20	Kings	46	57	72	47
21	Cambridge	46	47	73	47
22	Cirencester	46	55	92	42
23	Hayes	46	48	81	41
24	Cinderford	46	50	106	28

TEMPORADA 2015/2016

NON LEAGUE PREMIER GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Poole Town	46	87	36	91
2	Redditch	46	82	37	87
3	Hitchin Town	46	78	51	84
4	Hungerford	46	73	43	83
5	Leamington	46	60	38	83
6	Kettering	46	83	54	79
7	Weymouth	46	63	39	77
8	Chippenham	46	78	54	76
9	Kings Lynn.	46	59	58	67
10	Merthyr Town	46	69	58	66
11	Chesham	46	72	70	64
12	Dunstable	46	68	68	62
13	Dorchester	46	67	69	62
14	Frome Town	46	53	73	61
15	Cirencester	46	70	78	60
16	Biggleswade	46	76	83	58
17	Slough Town	46	67	77	57
18	Stratford	46	59	68	50
19	Cambridge	46	64	81	50
20	Neots Town	46	69	78	48
21	Bedworth	46	58	107	44
22	Histon	46	63	98	40
23	Paulton	46	39	89	37
24	Bideford	46	38	88	37

TEMPORADA 2014/2015

NON LEAGUE DIVISION 1 GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Merthyr Town	42	122	34	102
2	Evesham	42	94	36	91
3	Stratford	42	82	40	89
4	Taunton Town	42	71	42	80
5	Larkhall	42	82	50	77
6	Yate Town	42	79	52	72
7	Didcot Town	42	95	66	71
8	North Leigh	42	99	58	67
9	Cinderford	42	79	48	67
10	Mangotsfield	42	73	58	67
11	Shortwood	42	77	55	65
12	Bridgwater	42	67	59	62
13	Wimborne	42	71	68	61
14	Swindon	42	81	79	56
15	AFC Totton	42	65	75	53
16	Tiverton	42	60	69	49
17	Sholing	42	48	75	43
18	Clevedon	42	53	111	34
19	Fleet Town	42	46	100	29
20	Wantage Town	42	43	100	28
21	Bishop's	42	52	143	22
22	Bashley	42	23	144	12

TEMPORADA 2013/2014

NON LEAGUE DIVISION 1 GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Cirencester	42	95	45	92
2	Merthyr Town	42	111	58	89
3	Tiverton	42	80	51	86
4	Paulton	42	102	54	81
5	Swindon	42	91	52	79
6	Shortwood	42	91	44	78
7	North Leigh	42	84	46	72
8	Taunton Town	42	71	58	70
9	Yate Town	42	81	69	68
10	Stratford	42	103	86	62
11	Mangotsfield	42	65	62	61
12	Didcot Town	42	70	85	57
13	Wimborne	42	78	70	55
14	Bridgwater	42	62	64	53
15	Cinderford	42	69	79	49
16	Evesham	42	66	80	47
17	Clevedon	42	48	96	41
18	Godalming	42	47	79	39
19	Thatcham	42	41	99	39
20	Bishop's	42	52	94	34
21	Fleet Town	42	43	90	29
22	Guildford	42	45	134	27

TEMPORADA 2012/2013

NON LEAGUE DIVISION 1 GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Poole Town	42	82	36	98
2	Hungerford	42	71	44	84
3	Merthyr Town	42	84	38	83
4	Swindon	42	79	51	81
5	Paulton	42	64	54	75
6	Yate Town	42	69	63	69
7	Sholing	42	87	56	68
8	Shortwood	42	62	45	67
9	North Leigh	42	70	69	61
10	Cinderford	42	61	66	59
11	Cirencester	42	54	57	58
12	Wimborne	42	59	60	55
13	Mangotsfield	42	53	61	55
14	Evesham	42	49	58	51
15	Clevedon	42	61	67	49
16	Tiverton	42	51	58	47
17	Didcot Town	42	59	76	46
18	Taunton Town	42	59	85	44
19	Bridgwater	42	52	78	40
20	Abingdon	42	42	66	38
21	Bishop's	42	49	66	37
22	Winchester	42	42	105	29

Competiciones que juega

Grupo 2

Non League Premier Grupo 2

Pos	Equipos		Pts
1		Chesham United	90
2		AFC Totton	81
3		Salisbury City	79
4		Gosport Borough	78
5		Bracknell Town FC	68
6		Merthyr Town	67
7		Walton & Hersham	65
8		Hungerford Town	64
9		Dorchester Town	60
10		Hendon	58
11		Winchester City	57
12		Basingstoke Town	53
13		Poole Town	52
14		Tiverton Town	52
15		Sholing	49
16		Swindon Supermarine	49
17		Hanwell Town	48
18		Plymouth Parkway	48
19		Beaconsfield	48
20		Hayes & Yeading United	46
21		Harrow Borough	39
22		Didcot Town	28

	Ascenso : Chesham United
	Playoff Ascenso : AFC Totton, Salisbury City, Gosport Borough, Bracknell Town FC
	Descenso : Beaconsfield, Hayes & Yeading United, Harrow Borough, Didcot Town

RIVALES EN FA Cup

RIVALES EN FA Trophy

RIVALES EN Non League Premi.

USO DE MEMORIA

7,435,776 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.5746
Total Execution Time	0.5758

CADENA URL

/historico/Merthyr-Town

GET DATOS

$_GET['/historico/Merthyr-Town']

POST DATOS

No hay datos POST existentes

CONSULTAS (41)

0.0117	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 = 'Merthyr-Town' 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.0105	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=16695 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105	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=16695 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105	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=16695 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105	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=16695 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0213	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 = 72853
0.0117	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 = 72677
0.0107	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=16695 AND type_rel = 2
0.0118	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 16695 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0107	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 (683278,809095) ORDER BY n.cover_points DESC, update_date DESC
0.0115	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 = '16695' ORDER BY l.year DESC,cat.coefficient DESC
0.0112	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 = '16695' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0120	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 = '16695' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0149	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 = 72677 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0111	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 = 72853 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0115	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=16695 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0107	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 (72853,72728,72677,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.0108	SELECT count(id) as num_players from rel_players WHERE league_id = 72853 AND teamId = 16695
0.0121	SELECT count(id) as num_players from rel_players WHERE league_id = 72728 AND teamId = 16695
0.0116	SELECT count(id) as num_players from rel_players WHERE league_id = 72677 AND teamId = 16695
0.0109	SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 16695
0.0112	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 = 72853 AND t.round = 42 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0107	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 = '16695' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0106	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '16695' and rp.type = 4
0.0107	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 = '16695' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0117	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 = 72853 WHERE rp.league_id = 72853 AND rp.teamId = 16695 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.0114	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 = 72853 WHERE rp.league_id = 72853 AND rp.teamId = 16695 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0112	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 = 72853 WHERE rp.league_id = 72853 AND rp.teamId = 16695 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0112	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 = 16695 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0113	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 = 72853 AND t.round = 42 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113	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 = 68451 AND t.round = 42 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113	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 = 63527 AND t.round = 42 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110	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 = 58615 AND t.round = 42 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112	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 = 50619 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112	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 = 44471 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113	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 = 39019 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112	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 = 33745 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113	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 = 15598 AND t.round = 46 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111	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 = 4171 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113	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 = 3496 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113	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 = 24875 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Merthyr Town

Merthyr Town

Selecciona un equipo

Competiciones que juega

Non League Premier Grupo 2

RIVALES EN FA Cup

RIVALES EN FA Trophy

RIVALES EN Non League Premi.