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

El Palo FC

Entrenador: Juanma Gómez

Temporada 2023/2024

TEMPORADA 2023/2024

SEGUNDA FEDERACIÓN GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Sevilla At.	33	51	19	65
2	Yeclano	33	43	28	60
3	Marbella FC	33	40	31	55
4	Betis	33	43	27	52
5	Orihuela CF	33	36	35	51
6	CD Estepona	33	33	26	48
7	RB Linense	33	35	31	47
8	Águilas FC	33	26	19	47
9	UCAM Murcia	33	33	35	44
10	Unión Atl.	33	35	34	43
11	Atlético	33	30	40	43
12	Racing	33	20	26	40
13	Cádiz	33	39	42	39
14	Manchego	33	28	36	38
15	Roque Lepe	33	32	36	36
16	El Palo FC	33	25	35	35
17	Vélez CF	33	31	52	29
18	Cartagena	33	23	51	20

TEMPORADA 2022/2023

TERCERA FEDERACIÓN GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	Marbella FC	30	67	17	72
2	Real Jaén	30	59	12	68
3	El Palo FC	30	43	20	63
4	Torre	30	53	31	55
5	Malagueño	30	45	27	45
6	Huétor Vega	30	42	35	45
7	CF Motril	30	37	41	41
8	Torredonjime	30	45	42	41
9	Almería B	30	40	34	41
10	Arenas	30	36	36	39
11	Torreperogil	30	40	45	38
12	Huétor	30	52	44	37
13	Maracena	30	34	48	33
14	Málaga City	30	22	48	25
15	Atletico	30	30	54	21
16	Huracán	30	8	119	5

TEMPORADA 2021/2022

TERCERA FEDERACIÓN GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	Torremolinos	32	45	21	63
2	Huétor	32	56	30	58
3	Marbella FC	32	53	26	58
4	Almería B	32	59	31	57
5	Malagueño	32	51	38	57
6	CF Motril	32	59	37	56
7	Torredonjime	32	55	35	55
8	Torre	32	52	40	49
9	Atletico	32	42	47	42
10	El Palo FC	32	40	40	41
11	Huétor Vega	32	33	38	39
12	Torreperogil	32	28	36	38
13	Real Jaén	32	31	43	36
14	Alhaurín	32	28	49	34
15	Pedro	32	26	48	28
16	Alhaurino	32	40	53	27
17	Intergym	32	13	99	4

TEMPORADA 2020/2021

TERCERA DIVISIÓN GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	Mancha Real	20	35	12	36
2	Almería B	20	32	25	33
3	Torredonjime	20	35	25	33
4	Torreperogil	20	16	17	28
5	Huétor	20	28	25	28
6	Huétor Vega	20	25	27	25
7	Real Jaén	20	24	27	25
8	Poli	20	15	25	23
9	Loja	20	15	32	21
10	Atletico	20	22	23	21
11	Maracena	20	19	28	20
12	Vélez CF	18	22	15	37
13	Antequera	18	29	11	30
14	El Palo FC	18	18	17	28
15	Torremolinos	18	23	18	28
16	Malagueño	18	28	19	28
17	Alhaurín	18	17	27	20
18	CD Estepona	18	18	25	20
19	CF Motril	18	21	26	20
20	Melilla CD	18	17	29	17
21	Alhaurino	18	22	28	17

TEMPORADA 2019/2020

TERCERA DIVISIÓN GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	Linares	29	60	16	75
2	Pvo. Ejido	29	48	28	57
3	CF Motril	29	50	24	56
4	Real Jaén	29	54	25	56
5	Almería B	29	60	28	53
6	Torredonjime	29	53	33	50
7	Antequera	29	42	32	49
8	El Palo FC	29	44	37	48
9	Malagueño	29	41	37	39
10	Loja	29	49	55	37
11	Mancha Real	29	25	29	35
12	Huétor	29	42	48	35
13	Torreperogil	29	30	35	34
14	Maracena	29	33	41	30
15	Poli	29	35	49	29
16	Vélez CF	29	37	56	28
17	Huétor Vega	29	33	48	27
18	Melilla CD	29	21	64	23
19	Atletico	29	21	48	20
20	Alhaurín	29	29	74	13

TEMPORADA 2018/2019

TERCERA DIVISIÓN GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	Real Jaén	42	99	32	101
2	Linares	42	80	31	90
3	Antequera	42	90	35	82
4	El Palo FC	42	65	34	81
5	Vélez CF	42	56	40	68
6	CF Motril	42	79	59	68
7	Loja	42	68	64	62
8	Mancha Real	42	59	52	60
9	Torredonjime	42	74	59	58
10	Torreperogil	42	43	52	58
11	Huétor	42	65	55	57
12	Huétor Vega	42	56	65	57
13	Poli	42	53	57	57
14	Alhaurín	42	72	70	56
15	Alhaurino	42	72	66	56
16	Torremolinos	42	57	65	53
17	CD Rincón	42	45	63	52
18	Martos CD	42	41	70	44
19	Atarfe	42	49	79	42
20	Pedro	42	48	75	41
21	Guadix CF	42	44	95	35
22	River	42	28	125	4

TEMPORADA 2017/2018

TERCERA DIVISIÓN GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	Malagueño	42	95	31	96
2	Almería B	42	97	35	86
3	Real Jaén	42	58	29	82
4	Antequera	42	78	37	82
5	Huétor	42	77	49	82
6	CF Motril	42	85	56	81
7	Linares	42	68	47	74
8	Mancha Real	42	66	46	72
9	Loja	42	87	63	69
10	El Palo FC	42	66	50	67
11	Torredonjime	42	79	65	67
12	Vélez CF	42	60	65	56
13	CD Rincón	42	53	61	52
14	Torremolinos	42	64	76	50
15	Martos CD	42	58	85	47
16	Atarfe	42	46	69	43
17	Pedro	42	43	80	43
18	Huétor Vega	42	47	74	38
19	Guadix CF	42	40	77	37
20	Maracena	42	44	73	35
21	Villacarrill	42	44	79	28
22	Melistar	42	24	132	12

TEMPORADA 2016/2017

TERCERA DIVISIÓN GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	Malagueño	38	107	34	90
2	Antequera	38	70	38	75
3	Almería B	38	61	36	71
4	Huétor	38	73	48	71
5	CF Motril	38	71	43	70
6	Loja	38	63	41	66
7	CD Rincón	38	49	52	57
8	El Palo FC	38	64	57	56
9	Martos CD	38	57	54	53
10	Guadix CF	38	47	51	51
11	Pedro	38	44	49	48
12	Torredonjime	38	41	51	48
13	Maracena	38	50	54	46
14	Atarfe	38	42	61	45
15	Vélez CF	38	44	64	44
16	Huétor Vega	38	45	55	44
17	River	38	47	67	40
18	Alhaurino	38	37	67	31
19	D.H. Andrés	38	48	88	28
20	Alhaurín	38	39	89	19

TEMPORADA 2015/2016

TERCERA DIVISIÓN GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	Mancha Real	38	73	25	86
2	Malagueño	38	96	34	86
3	Loja	38	68	26	81
4	Pvo. Ejido	38	77	32	79
5	El Palo FC	38	69	24	76
6	Antequera	38	67	33	71
7	Guadix CF	38	68	46	70
8	Vélez CF	38	55	33	65
9	Huétor	38	60	37	59
10	Martos CD	38	58	55	56
11	Pedro	38	55	67	48
12	Villares	38	46	57	44
13	CD Rincón	38	48	59	41
14	Alhaurín	38	42	67	40
15	Atarfe	38	45	71	36
16	Maracena	38	48	69	36
17	River	38	44	88	32
18	Comarca	38	30	62	31
19	CD Ronda	38	32	97	24
20	Español	38	11	110	4

TEMPORADA 2014/2015

SEGUNDA DIVISIÓN B GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Cádiz	38	66	24	76
2	UCAM Murcia	38	46	29	65
3	Almería B	38	47	30	62
4	Villanovense	38	46	30	61
5	RB Linense	38	56	52	58
6	Recreativo	38	50	39	58
7	UD Melilla	38	47	47	54
8	Betis	38	43	43	52
9	Roque Lepe	38	52	56	51
10	Marbella FC	38	42	48	51
11	Real Jaén	38	45	36	49
12	Cacereño	38	49	52	47
13	Lorca FC	38	42	44	45
14	Sevilla At.	38	33	34	44
15	Cartagena	38	36	46	43
16	La Roda CF	38	33	43	43
17	Arroyo	38	30	50	43
18	Córdoba	38	33	60	43
19	El Palo FC	38	42	43	41
20	Lucena	38	32	64	39

TEMPORADA 2013/2014

SEGUNDA DIVISIÓN B GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Albacete	38	62	30	82
2	Lorca FC	38	62	22	79
3	Cartagena	38	59	35	73
4	Cádiz	38	75	38	71
5	Guadalajara	38	57	33	69
6	Recreativo	38	65	47	58
7	RB Linense	38	51	42	56
8	UD Melilla	38	47	45	55
9	Lucena	38	42	45	55
10	Cacereño	38	43	49	53
11	Córdoba	38	42	50	45
12	El Palo FC	38	35	47	45
13	Almería B	38	42	49	43
14	Sevilla At.	38	33	44	43
15	Arroyo	38	38	47	43
16	Algeciras	38	39	45	43
17	La Roda CF	38	39	46	40
18	Fernando	38	36	60	39
19	Sanluqueño	38	34	68	34
20	Écija	38	28	87	23

TEMPORADA 2012/2013

TERCERA DIVISIÓN GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	El Palo FC	38	72	36	74
2	Mancha Real	38	50	27	72
3	Recreativo	38	73	35	72
4	Malagueño	38	71	27	71
5	Linares	38	52	30	70
6	Villacarrill	38	66	41	65
7	Martos CD	38	52	44	64
8	Vélez CF	38	51	47	56
9	Atarfe	38	58	48	53
10	Maracena	38	47	49	51
11	Marbella FC	38	52	53	49
12	Casino Real	38	43	44	48
13	Pedro	38	50	45	47
14	CD Ronda	38	53	56	45
15	Unión	38	45	55	45
16	Huétor	38	44	67	41
17	CD Huercal	38	33	73	31
18	Torremolinos	38	32	67	30
19	Alhaurín	38	29	79	23
20	Comarca	38	24	74	23

TEMPORADA 2011/2012

TERCERA DIVISIÓN GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	Loja	40	87	33	86
2	Unión	40	76	37	85
3	Marbella FC	40	66	28	78
4	Malagueño	39	77	34	76
5	Maracena	39	62	40	73
6	Comarca	40	57	34	70
7	Mancha Real	40	53	34	70
8	Pedro	40	67	46	67
9	El Palo FC	40	63	57	65
10	Martos CD	40	49	45	59
11	Casino Real	39	44	49	54
12	CD Ronda	40	49	60	51
13	Alhaurín	40	59	63	50
14	Huétor	39	50	56	49
15	Motril CF	40	51	45	48
16	Nerja	39	42	57	45
17	Vélez CF	39	36	60	39
18	Arenas	40	35	51	37
19	Antequera	40	47	70	37
20	Ciudad	40	22	80	18
21	Carboneras	40	6	119	4

TEMPORADA 2010/2011

TERCERA DIVISIÓN GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	Comarca	38	57	29	79
2	Alhaurín	38	61	25	78
3	Loja	38	60	35	74
4	Malagueño	38	62	35	70
5	CD Ronda	38	68	37	68
6	Maracena	38	51	36	63
7	Antequera	38	72	47	62
8	Motril CF	38	50	33	58
9	Martos CD	38	38	39	53
10	Marbella FC	38	52	50	50
11	Mancha Real	38	49	42	49
12	Huétor	38	37	54	46
13	El Palo FC	38	57	65	46
14	Ciudad	38	46	54	45
15	Vélez CF	38	56	57	44
16	Carboneras	38	57	71	40
17	Casino Real	38	44	65	40
18	Baza	38	30	60	34
19	Alhaurino	38	38	58	30
20	Adra	38	13	106	6

TEMPORADA 2009/2010

TERCERA DIVISIÓN GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	Mancha Real	36	53	26	68
2	Motril CF	36	54	24	66
3	El Palo FC	36	59	44	63
4	Almería B	36	62	37	61
5	CD Ronda	36	64	51	60
6	Malagueño	36	56	44	59
7	Comarca	36	52	34	57
8	Ciudad	36	52	48	53
9	Loja	36	42	40	49
10	Antequera	36	43	38	47
11	Vélez CF	36	50	52	47
12	Alhaurino	36	53	54	45
13	Adra	36	47	59	45
14	CD Santa Fe	36	40	55	41
15	Carboneras	36	43	63	38
16	Huétor	36	44	67	38
17	Baza	36	36	54	37
18	Arenas	36	33	63	35
19	Polideportiv	19	21	22	24
20	CD Vera	19	17	46	10

TEMPORADA 2008/2009

PRIMERA ANDALUZA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Mancha Real	32	93	16	91
2	El Palo FC	32	86	34	70
3	Martos CD	31	64	32	53
4	Nerja	31	43	29	51
5	Alhaurín	31	43	31	45
6	Torremolinos	31	52	40	44
7	Benamiel	31	42	32	44
8	Vilches	32	53	47	41
9	Baeza CF	30	38	37	41
10	Real Jaén	32	45	53	38
11	Fuengirola	30	44	53	34
12	Barrio NSR	32	45	67	34
13	La Puerta	31	36	60	32
14	CD Mijas	31	42	52	29
15	Torre	30	31	73	21
16	D.H. Andrés	2	3	2	4
17	Alcalá CF	23	4	113	0

TEMPORADA 2007/2008

2ª ANDALUZA MÁLAGA
Equipo		PJ	GF	GC	Puntos
1	El Palo FC	30	75	33	68
2	DosHermanas	30	62	21	67
3	Atlco.	30	85	38	66
4	Pedro	30	46	30	48
5	CD Torrox	30	53	50	46
6	CD Rincón	30	42	42	45
7	Atco. Lauro	30	46	53	45
8	CD Cártama	30	45	44	41
9	Campillos	30	38	46	41
10	Marbella B	30	51	52	38
11	Cala Míjas	30	52	64	37
12	CF Alameda	30	49	64	37
13	Mijas	30	48	53	32
14	Sierra	30	33	75	23
15	Cdad Jardin	30	31	59	22
16	Pto. Torre.	30	40	72	18

TEMPORADA 2006/2007

2ª ANDALUZA MÁLAGA
Equipo		PJ	GF	GC	Puntos
1	Torre	30	54	25	64
2	CD Mijas	30	50	19	62
3	Barrio	30	47	29	59
4	El Palo FC	30	55	28	54
5	Mijas	30	61	33	53
6	Marbella B	30	48	33	47
7	Pto. Torre.	30	50	40	46
8	CD Torrox	30	48	47	41
9	CD Rincón	30	45	40	40
10	Pedro	30	41	54	36
11	CD Cártama	30	33	36	35
12	Cdad Jardin	30	32	47	34
13	Sierra	30	25	49	30
14	CD La Cala	30	39	66	26
15	Benagalbón	30	38	85	21
16	CD Trabuco	30	32	67	18

TEMPORADA 2005/2006

2ª ANDALUZA MÁLAGA
Equipo		PJ	GF	GC	Puntos
1	Benamiel	30	74	30	64
2	Campillos	30	68	30	60
3	Mijas	30	61	32	59
4	CD Trabuco	30	49	26	57
5	El Palo FC	30	61	43	51
6	CD La Cala	30	70	56	48
7	CD Mijas	30	54	39	45
8	Barrio	30	44	36	45
9	CD Cártama	30	53	52	41
10	Marbella B	30	50	43	38
11	Sierra	30	40	65	38
12	Benagalbón	30	59	73	37
13	Archidona	30	48	62	33
14	Cala Míjas	30	38	64	29
15	Casabermeja	30	40	88	27
16	Pizarra CF	30	34	104	8

TEMPORADA 2004/2005

2ª ANDALUZA MÁLAGA
Equipo		PJ	GF	GC	Puntos
1	Nerja	30	69	30	65
2	Marbella B	30	82	36	62
3	Torre	30	55	26	60
4	CD Cártama	30	65	25	58
5	CD Mijas	30	64	31	58
6	Benamiel	30	54	29	56
7	Coín	30	77	45	52
8	Campillos	30	40	39	49
9	Mijas	30	55	53	43
10	El Palo FC	30	36	35	41
11	Archidona	30	41	57	34
12	CD Trabuco	30	35	70	34
13	Julian	30	35	62	29
14	Benagalbón	30	38	66	29
15	Cala Míjas	30	34	59	27
16	Nueva	30	35	60	26
17	CD Álora	30	52	83	22
18	CF Alameda	30	27	88	20

Competiciones que juega

Segunda Federación Grupo 4

Pos	Equipos		Pts
1		Sevilla At.	65
2		Yeclano Deportivo	60
3		Marbella FC	55
4		Betis Deportivo	52
5		Orihuela CF	51
6		CD Estepona	48
7		RB Linense	47
8		Águilas FC	47
9		UCAM Murcia	44
10		FC La Unión Atl.	43
11		Atlético Antoniano	43
12		Racing Cartagena Mar Menor	40
13		Cádiz CF Mirandilla	39
14		CD Manchego Ciudad Real	38
15		San Roque de Lepe	36
16		El Palo FC	35
17		Vélez CF	29
18		FC Cartagena B	20

	Ascenso : Sevilla At.
	Playoff Ascenso : Yeclano Deportivo, Marbella FC, Betis Deportivo, Orihuela CF
	Playoff Descenso : Cádiz CF Mirandilla
	Descenso : CD Manchego Ciudad Real, San Roque de Lepe, El Palo FC, Vélez CF, FC Cartagena B

RIVALES EN Copa Federación

RIVALES EN Segunda Federaci.

USO DE MEMORIA

8,564,696 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.6697
Total Execution Time	0.6709

CADENA URL

/historico/Palo

GET DATOS

$_GET['/historico/Palo']

POST DATOS

No hay datos POST existentes

CONSULTAS (41)

0.0253	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 = 72365
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=971 AND type_rel = 2
0.0131	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 971 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0129	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 (1312985,35435,53002,53102,53138) ORDER BY n.cover_points DESC, update_date DESC
0.0132	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 = '971' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0131	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=971 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0127	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 (74091,72960,72365,71489,71432,67983) 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.0128	SELECT count(id) as num_players from rel_players WHERE league_id = 72365 AND teamId = 971
0.0127	SELECT count(id) as num_players from rel_players WHERE league_id = 67983 AND teamId = 971
0.0129	SELECT count(id) as num_players from rel_players WHERE league_id = 71489 AND teamId = 971
0.0128	SELECT count(id) as num_players from rel_players WHERE league_id = 74091 AND teamId = 971
0.0130	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 971
0.0127	SELECT count(id) as num_players from rel_players WHERE league_id = 72960 AND teamId = 971
0.0129	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 = '971' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '971' and rp.type = 4
0.0132	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 = '971' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0125	SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '971' and rp.type = 4
0.0150	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 = 72365 WHERE rp.league_id = 72365 AND rp.teamId = 971 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.0139	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 = 72365 WHERE rp.league_id = 72365 AND rp.teamId = 971 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0135	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 = 72365 WHERE rp.league_id = 72365 AND rp.teamId = 971 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0132	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 = 971 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0130	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 = 72365 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.0130	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 = 67983 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.0130	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 = 62393 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.0131	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 = 58588 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.0135	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 = 50277 AND t.round = 29 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0137	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 = 44397 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 39033 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143	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 = 33359 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147	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 = 15450 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132	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 = 3866 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135	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 = 2467 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133	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 = 1953 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133	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 = 1405 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 1122 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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 = 839 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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 = 322 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132	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 = 2977 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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* `tables2007` 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 = 2976 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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* `tables2006` 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 = 2975 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128	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* `tables2005` 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 = 2974 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

El Palo FC

El Palo FC

Selecciona un equipo

Competiciones que juega

Segunda Federación Grupo 4

RIVALES EN Copa Federación

RIVALES EN Segunda Federaci.