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

CF Pobla de Mafumet

Entrenador: Adolfo Baines

Temporada 2023/2024

TEMPORADA 2023/2024

TERCERA FEDERACIÓN GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Olot	32	50	19	73
2	L´Hospitale	32	52	27	63
3	Vilassar	32	39	26	57
4	Badalona	32	38	32	51
5	Tona	32	46	41	47
6	AE Prat	32	31	27	45
7	L'Escala	32	52	53	45
8	Reus Reddis	32	29	26	44
9	Montañesa	32	29	34	43
10	Mollerussa	32	30	42	42
11	FE Grama	32	37	44	41
12	CF Peralada	32	32	31	41
13	Girona FC B	32	45	38	40
14	Cristóbal	32	32	50	40
15	Pobla	32	29	37	35
16	Vilafranca	32	30	48	33
17	Castelldefel	32	29	43	30
18	Rapitenca	32	33	45	30

TEMPORADA 2022/2023

TERCERA FEDERACIÓN GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	CE Europa	30	42	21	60
2	Sant Andreu	30	50	31	56
3	Cristóbal	30	36	21	52
4	L´Hospitale	30	53	33	51
5	CF Peralada	30	41	33	49
6	Castelldefel	30	31	35	44
7	Pobla	30	40	35	43
8	Girona FC B	30	45	34	43
9	Montañesa	30	38	38	40
10	FE Grama	30	38	46	37
11	Tona	30	36	51	33
12	Rapitenca	30	37	48	32
13	Badalona	30	32	35	31
14	Vilafranca	30	38	55	30
15	Vilassar	30	33	47	28
16	UE Sants	30	29	56	24

TEMPORADA 2021/2022

TERCERA FEDERACIÓN GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	CE Manresa	32	43	21	64
2	Olot	32	53	32	61
3	Cristóbal	32	43	25	59
4	Girona FC B	32	38	25	58
5	Sant Andreu	32	47	33	53
6	L´Hospitale	32	43	37	49
7	Pobla	32	35	26	44
8	Vilassar	32	29	24	44
9	FE Grama	32	35	31	43
10	CF Peralada	32	39	31	42
11	Vilafranca	32	25	33	41
12	Castelldefel	32	33	39	40
13	UE Sants	32	32	41	34
14	Granollers	32	32	48	34
15	UE Figueres	32	29	37	32
16	Ascó	32	23	60	25
17	Guineueta	32	23	59	21

TEMPORADA 2020/2021

TERCERA DIVISIÓN GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	CE Europa	20	35	17	44
2	Vilafranca	20	33	16	40
3	Terrassa FC	20	23	11	35
4	Cristóbal	20	17	13	31
5	CE Manresa	20	21	16	29
6	Castelldefel	20	19	20	28
7	Pobla	20	27	25	26
8	Santfeliuenc	20	16	24	22
9	UE Valls	20	12	24	17
10	Igualada	20	14	32	13
11	Montañesa	20	10	29	12
12	Cerdanyola	20	31	15	40
13	Girona FC B	20	29	12	37
14	Granollers	20	32	22	33
15	Sant Andreu	20	24	21	31
16	Vilassar	20	21	21	30
17	FE Grama	20	22	28	27
18	CF Peralada	20	16	18	25
19	UE Sants	20	17	25	24
20	UE Figueres	20	19	32	21
21	UA Horta	20	20	26	18
22	Banyoles	20	13	24	15

TEMPORADA 2019/2020

TERCERA DIVISIÓN GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	L´Hospitale	27	59	28	59
2	Terrassa FC	27	42	19	53
3	CE Europa	27	59	31	50
4	Sant Andreu	27	45	28	50
5	CF Peralada	27	38	26	46
6	Pobla	27	37	26	45
7	Vilafranca	27	38	27	44
8	Vilassar	27	44	34	44
9	Granollers	27	50	34	43
10	CE Manresa	27	37	28	39
11	Castelldefel	27	37	37	38
12	UA Horta	27	39	48	36
13	Cerdanyola	27	37	38	35
14	UE Figueres	27	43	48	31
15	Cristóbal	27	31	38	31
16	Santfeliuenc	27	31	44	29
17	Banyoles	27	22	35	28
18	Igualada	27	28	46	25
19	UE Sants	27	29	50	22
20	Reus	27	0	81	0

TEMPORADA 2018/2019

TERCERA DIVISIÓN GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Badalona	40	75	31	83
2	L´Hospitale	40	71	31	80
3	UA Horta	40	57	32	79
4	AE Prat	40	51	22	75
5	Sant Andreu	40	65	34	71
6	CE Europa	40	53	41	63
7	Reus	40	58	41	63
8	Terrassa FC	40	52	45	63
9	Vilafranca	40	53	42	62
10	Granollers	40	54	42	61
11	Cerdanyola	40	40	46	50
12	UE Figueres	40	36	46	49
13	Santfeliuenc	40	56	58	49
14	Pobla	40	44	46	48
15	Cristóbal	40	52	70	48
16	Castelldefel	40	39	56	43
17	UE Sants	40	37	56	43
18	FE Grama	40	30	57	33
19	Santboià	40	24	66	31
20	Ascó	40	31	65	30
21	Martinenc	40	34	85	26

TEMPORADA 2017/2018

TERCERA DIVISIÓN GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Espanyol B	38	74	25	90
2	Sant Andreu	38	61	24	71
3	L´Hospitale	38	61	31	71
4	Terrassa FC	38	60	38	64
5	AE Prat	38	57	35	63
6	Pobla	38	40	25	63
7	Ascó	38	47	41	60
8	CE Europa	38	48	46	58
9	Vilafranca	38	48	42	54
10	UE Figueres	38	47	43	53
11	UA Horta	38	47	52	50
12	Cerdanyola	38	35	43	48
13	Santboià	38	35	37	48
14	Reus	38	40	50	47
15	Santfeliuenc	38	43	42	46
16	Castelldefel	38	40	46	44
17	Granollers	38	32	54	38
18	Palamós	38	38	64	31
19	CF Gavá	38	28	87	21
20	Vilassar	38	24	80	18

TEMPORADA 2016/2017

TERCERA DIVISIÓN GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Olot	38	73	38	80
2	CF Peralada	38	68	27	77
3	Terrassa FC	38	48	26	66
4	Vilafranca	38	60	37	64
5	Sant Andreu	38	51	40	60
6	Ascó	38	44	37	57
7	Pobla	38	43	36	55
8	Granollers	38	47	54	50
9	UE Figueres	38	39	41	50
10	Vilassar	38	40	44	50
11	Palamós	38	49	55	49
12	CE Europa	38	28	32	47
13	Santfeliuenc	38	39	44	45
14	Cerdanyola	38	43	51	45
15	Castelldefel	38	34	51	42
16	Jonquera	38	19	29	42
17	Montañesa	38	32	48	42
18	Manlleu	38	41	59	40
19	Júpiter	38	32	52	35
20	Sabadell B	38	34	63	31

TEMPORADA 2015/2016

SEGUNDA DIVISIÓN B GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Reus	38	52	31	73
2	Villarreal	38	62	32	71
3	Hércules	38	51	28	71
4	Lleida	38	49	22	67
5	Cornellà	38	46	36	63
6	Alcoyano	38	47	34	61
7	CE Sabadell	38	49	40	55
8	Valencia	38	45	39	53
9	Atlético	38	48	47	53
10	Eldense	38	48	63	51
11	Barça	38	40	40	51
12	Espanyol B	38	50	45	48
13	Badalona	38	32	39	46
14	At. Levante	38	38	48	45
15	L´Hospitale	38	31	49	43
16	Olimpic	38	29	46	42
17	Pobla	38	34	47	38
18	Olot	38	37	53	37
19	Llosetense	38	26	54	35
20	Huracán	38	17	38	0

TEMPORADA 2014/2015

TERCERA DIVISIÓN GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Ascó	38	61	34	72
2	Pobla	38	54	30	69
3	CE Europa	38	53	32	68
4	UE Figueres	38	46	44	59
5	Vilafranca	38	57	56	59
6	AE Prat	38	49	34	59
7	Terrassa FC	38	56	42	59
8	Rubí	38	47	40	54
9	Masnou	38	40	48	51
10	Cerdanyola	38	44	49	49
11	Palamós	38	52	53	49
12	CF Peralada	38	41	50	49
13	Montañesa	38	41	40	48
14	CF Gavá	38	42	54	48
15	Sabadell B	38	46	49	47
16	Santfeliuenc	38	41	48	47
17	Manlleu	38	51	54	45
18	Castelldefel	38	39	47	41
19	Martinenc	38	49	70	37
20	Vilassar	38	28	63	28

TEMPORADA 2013/2014

TERCERA DIVISIÓN GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Cornellà	38	58	40	73
2	Montañesa	38	61	31	73
3	CE Europa	38	52	29	69
4	Terrassa FC	38	55	35	69
5	Rubí	38	58	37	69
6	Ascó	38	53	40	68
7	Palamós	38	62	53	61
8	Pobla	38	45	37	57
9	Santfeliuenc	38	46	41	57
10	Manlleu	38	39	39	50
11	UE Figueres	38	51	52	47
12	Cerdanyola	38	52	58	46
13	Vilafranca	38	41	50	44
14	Masnou	38	36	46	44
15	CF Gavá	38	43	52	42
16	Castelldefel	38	47	50	42
17	Vilassar	38	35	49	42
18	Santboià	38	47	54	40
19	Rapitenca	38	31	67	31
20	Gramanet	38	25	77	18

TEMPORADA 2012/2013

TERCERA DIVISIÓN GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Cornellà	36	67	30	76
2	Olot	36	62	28	73
3	CE Europa	36	51	25	69
4	Manlleu	36	43	27	61
5	UE Figueres	36	49	42	56
6	Pobla	36	48	48	51
7	Rapitenca	36	46	39	50
8	Gramanet	36	32	30	48
9	Palamós	36	46	51	45
10	Castelldefel	36	31	39	45
11	Rubí	36	56	50	44
12	CF Gavá	36	36	41	44
13	Vilassar	36	42	43	43
14	Santboià	36	40	46	39
15	Vilafranca	36	34	52	39
16	Montañesa	36	32	49	38
17	Júpiter	36	39	54	37
18	UE Vic	36	38	58	35
19	Balaguer	36	33	73	23

TEMPORADA 2011/2012

TERCERA DIVISIÓN GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	AE Prat	38	57	27	75
2	Espanyol B	38	68	30	70
3	Manlleu	38	72	48	65
4	Pobla	38	52	27	64
5	Cornellà	38	52	34	62
6	Santboià	38	47	42	58
7	Terrassa FC	38	57	55	58
8	Vilafranca	38	50	59	54
9	CF Gavá	38	49	50	53
10	Olot	38	53	54	51
11	Rubí	38	60	54	50
12	Balaguer	38	36	52	49
13	Castelldefel	38	43	47	49
14	UE Vic	38	44	49	47
15	Montañesa	38	42	54	47
16	CE Europa	38	37	46	44
17	Gramanet	38	45	52	43
18	Vilanova	38	42	52	42
19	Amposta	38	47	84	29
20	Masnou	38	31	68	24

TEMPORADA 2010/2011

TERCERA DIVISIÓN GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Badalona	38	65	36	73
2	Montañesa	38	40	33	67
3	Pobla	38	60	36	67
4	Reus	38	52	26	65
5	Espanyol B	38	65	38	64
6	Manlleu	38	58	40	61
7	CE Europa	38	54	42	58
8	Cornellà	38	58	44	55
9	AE Prat	38	49	42	53
10	CF Gavá	38	42	45	52
11	Vilafranca	38	48	55	49
12	Terrassa FC	38	58	53	47
13	Castelldefel	38	37	45	47
14	Amposta	38	45	65	45
15	Balaguer	38	42	60	43
16	Masnou	38	51	60	41
17	Vilanova	38	42	51	41
18	Palamós	38	35	45	41
19	Ascó	38	29	72	29
20	Premià	38	24	66	27

TEMPORADA 2009/2010

TERCERA DIVISIÓN GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	L´Hospitale	38	75	16	86
2	Reus	38	69	23	83
3	Santboià	38	68	46	70
4	AE Prat	38	60	33	67
5	Cornellà	38	43	41	61
6	Manlleu	38	53	39	60
7	Badalona	38	58	42	56
8	CE Europa	38	56	51	54
9	Balaguer	38	55	48	52
10	Amposta	38	56	59	50
11	Castelldefel	38	52	60	48
12	Pobla	38	46	52	47
13	Vilanova	38	50	54	46
14	Palamós	38	42	55	46
15	Ascó	38	48	69	43
16	Cassà	38	48	61	42
17	Premià	38	35	53	36
18	Rapitenca	38	46	71	34
19	Blanes	38	43	85	27
20	Olesa	38	30	75	26

TEMPORADA 2008/2009

TERCERA DIVISIÓN GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Espanyol B	38	84	26	83
2	Reus	38	76	37	79
3	L´Hospitale	38	63	28	76
4	Santboià	38	58	39	66
5	Manlleu	38	61	41	64
6	Premià	38	70	53	64
7	Vilanova	38	64	49	55
8	AE Prat	38	46	45	55
9	Pobla	38	55	62	52
10	Amposta	38	62	66	49
11	CE Europa	38	52	55	48
12	Cornellà	38	47	59	48
13	Cassà	38	47	52	46
14	Rapitenca	38	44	55	43
15	Blanes	38	58	73	42
16	Balaguer	38	49	58	39
17	Palamós	38	45	69	38
18	Mataró	38	44	68	36
19	Miapuesta	38	42	80	31
20	Banyoles	38	30	82	18

TEMPORADA 2007/2008

TERCERA DIVISIÓN GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Barça	38	70	41	83
2	Sant Andreu	38	74	25	82
3	Reus	38	63	37	65
4	Santboià	38	45	32	60
5	Rapitenca	38	51	43	59
6	Palamós	38	46	41	58
7	Premià	38	65	52	55
8	Pobla	38	52	45	52
9	Banyoles	38	39	48	51
10	Balaguer	38	46	45	50
11	CE Europa	38	51	49	50
12	Vilanova	38	58	53	49
13	Manlleu	38	52	62	48
14	Cassà	38	49	58	48
15	Blanes	38	52	61	48
16	Mataró	38	42	48	48
17	Castelldefel	38	40	54	45
18	Igualada	38	45	68	37
19	CE Manresa	38	37	58	35
20	Masnou	38	27	84	21

Competiciones que juega

Tercera Federación Grupo 5

Pos	Equipos		Pts
1		Olot	73
2		L´Hospitalet	63
3		UE Vilassar de Mar	57
4		Badalona	51
5		Tona	47
6		AE Prat	45
7		L'Escala	45
8		Reus FC Reddis	44
9		Montañesa	43
10		CFJ Mollerussa	42
11		FE Grama	41
12		CF Peralada	41
13		Girona FC B	40
14		CP San Cristóbal	40
15		CF Pobla de Mafumet	35
16		FC Vilafranca	33
17		Castelldefels	30
18		Rapitenca	30

	Ascenso : Olot
	Playoff Ascenso : L´Hospitalet, UE Vilassar de Mar, Badalona, Tona
	Descenso : FC Vilafranca, Castelldefels, Rapitenca

RIVALES EN Tercera Federaci.

USO DE MEMORIA

7,581,256 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1370
Total Execution Time	0.1382

CADENA URL

/historico/Pobla-Mafumet

GET DATOS

$_GET['/historico/Pobla-Mafumet']

POST DATOS

No hay datos POST existentes

CONSULTAS (34)

0.0042	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 = 72264
0.0019	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1980 AND type_rel = 2
0.0024	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1980 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0025	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 (2832,3193,3314,26595,34888) ORDER BY n.cover_points DESC, update_date DESC
0.0026	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 = '1980' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021	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 = 72264 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025	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=1980 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 (72264) 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.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 72264 AND teamId = 1980
0.0022	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 = '1980' 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 = '1980' 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 = '1980' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0019	SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '1980' and rp.type = 4
0.0047	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 = 72264 WHERE rp.league_id = 72264 AND rp.teamId = 1980 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.0035	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 = 72264 WHERE rp.league_id = 72264 AND rp.teamId = 1980 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029	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 = 72264 WHERE rp.league_id = 72264 AND rp.teamId = 1980 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027	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 = 1980 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 72264 AND t.round = 33 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* `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 = 67979 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.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 = 62389 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.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 = 58583 AND t.round = 22 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* `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 = 50273 AND t.round = 27 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 = 44393 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* `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 = 39029 AND t.round = 38 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* `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 = 33355 AND t.round = 38 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* `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 = 15377 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* `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 = 3915 AND t.round = 38 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 = 2555 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* `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 = 1945 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* `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 = 1402 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* `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 = 1105 AND t.round = 38 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 = 836 AND t.round = 38 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* `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 = 135 AND t.round = 38 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* `tables2008` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 12 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

CF Pobla de Mafumet

CF Pobla de Mafumet

Selecciona un equipo

Competiciones que juega

Tercera Federación Grupo 5

RIVALES EN Tercera Federaci.