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

CD La Almunia

Temporada 2023/2024

TEMPORADA 2023/2024

PREFERENTE ARAGÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Andorra	31	66	21	77
2	Almunia	31	82	34	64
3	Calatayud	31	80	30	64
4	Alcañiz	31	68	31	61
5	José	31	41	29	53
6	Casetas	31	51	33	52
7	Quinto	31	38	26	48
8	Mores CD	31	37	37	44
9	AD Magallon	31	25	25	43
10	Cariñena	31	47	56	41
11	Atlético	31	38	50	37
12	Mallén	31	35	51	34
13	Atlético	31	30	40	32
14	Cella	31	29	49	30
15	Chiprana	31	30	51	27
16	Mequinenza	31	26	64	24
17	Fleta CD	31	34	59	22
18	Villa	31	24	95	14

TEMPORADA 2022/2023

TERCERA FEDERACIÓN GRUPO 17
Equipo		PJ	GF	GC	Puntos
1	Robres	30	48	29	60
2	Barbastro	30	45	25	53
3	Huesca B	30	54	33	51
4	Ejea	30	47	33	48
5	Tamarite	30	44	41	48
6	Almudévar	30	36	28	47
7	Illueca	30	37	38	47
8	CF Epila	30	35	29	41
9	CD Utrillas	30	33	38	39
10	Calamocha	30	23	26	38
11	CD Binéfar	30	42	38	37
12	Caspe	30	30	39	36
13	CD Cuarte	30	27	34	35
14	Atlético	30	24	33	28
15	Cariñena	30	34	65	24
16	Almunia	30	34	64	22

TEMPORADA 2021/2022

PREFERENTE ARAGÓN GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	CD Utrillas	32	81	22	80
2	Almunia	32	77	24	71
3	Mores CD	32	70	30	69
4	Actur Pablo	32	69	42	54
5	Alcorisa	32	53	49	53
6	Andorra	32	54	41	52
7	Herrera	32	54	50	50
8	Cella	32	63	47	47
9	Calatayud	32	44	35	47
10	Alcañiz	32	48	45	47
11	CD Delicias	32	49	49	42
12	Calatorao	32	47	48	42
13	Morata CD	32	35	38	35
14	Cariñena	32	46	89	26
15	Maella C.D.	32	34	75	23
16	CD Calanda	31	30	82	16
17	Atlético	31	21	109	8

TEMPORADA 2020/2021

PREFERENTE ARAGÓN GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Giner	16	33	11	39
2	Actur Pablo	16	27	16	32
3	Almunia	16	29	20	31
4	Casetas	16	30	20	27
5	Calatayud	16	18	24	21
6	Herrera	16	25	35	15
7	Calatorao	16	18	28	14
8	Morata CD	16	19	32	13
9	Zaragoza	16	17	30	11

TEMPORADA 2019/2020

PREFERENTE ARAGÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	CF Epila	24	53	22	58
2	Cariñena	23	47	16	50
3	Fuentes	24	47	22	48
4	Alcañiz	24	38	17	47
5	Caspe	24	31	15	47
6	CD Utrillas	22	33	19	36
7	Calatorao	24	31	38	31
8	Herrera	24	31	51	31
9	José	22	35	23	30
10	Almunia	23	35	37	30
11	Montecarlo	24	39	44	26
12	Morata CD	24	23	35	26
13	Quinto	24	18	28	25
14	Calatayud	23	25	34	24
15	Alfindén	24	28	43	23
16	Cella	24	28	45	23
17	Alcorisa	24	18	40	21
18	Andorra	23	16	47	11

TEMPORADA 2018/2019

TERCERA DIVISIÓN GRUPO 17
Equipo		PJ	GF	GC	Puntos
1	SD Tarazona	38	72	17	80
2	Illueca	38	60	34	72
3	Deportivo	38	58	19	72
4	Sariñena	38	51	30	71
5	SD Borja	38	54	30	70
6	Utebo	38	50	31	67
7	Brea	38	48	34	61
8	AD San Juan	38	44	30	58
9	Atlético	38	41	35	57
10	Almudévar	38	42	42	50
11	CD Binéfar	38	45	50	47
12	Calamocha	38	41	55	46
13	Villanueva	38	37	56	44
14	Robres	38	38	46	43
15	Tamarite	38	36	59	43
16	Belchite	38	32	42	38
17	Lorenzo	38	32	69	33
18	Sabiñánigo	38	33	55	32
19	Almunia	38	38	71	31
20	Casetas	38	20	67	23

TEMPORADA 2017/2018

TERCERA DIVISIÓN GRUPO 17
Equipo		PJ	GF	GC	Puntos
1	CD Teruel	38	81	30	82
2	SD Borja	38	62	28	78
3	Ejea	38	89	41	75
4	SD Tarazona	38	85	39	73
5	Robres	38	51	34	68
6	Tamarite	38	57	48	60
7	Illueca	38	53	44	59
8	Almudévar	38	62	59	54
9	Utebo	38	53	49	53
10	Brea	38	47	53	50
11	Sabiñánigo	38	43	48	50
12	Sariñena	38	49	49	46
13	Atlético	38	43	58	43
14	Almunia	38	50	73	43
15	CD Binéfar	38	40	62	41
16	Belchite	38	38	66	41
17	Fraga	38	42	56	40
18	Valdefierro	38	31	60	35
19	Cariñena	38	36	77	29
20	Caspe	38	25	63	23

TEMPORADA 2016/2017

PREFERENTE ARAGÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Almunia	34	74	29	75
2	Valdefierro	34	78	31	73
3	CD Utrillas	34	61	36	56
4	Calatayud	34	64	41	56
5	Villa	34	46	33	54
6	Calamocha	34	51	34	53
7	Fuentes	34	54	45	53
8	Casetas	34	65	46	49
9	Mallén	34	51	55	48
10	Morata CD	34	56	58	43
11	Cella	34	32	40	43
12	Gallur CD	34	34	42	42
13	Hernán	34	43	55	41
14	Zaragoza	34	58	74	41
15	Quinto	34	30	38	40
16	Fuensport	34	37	67	35
17	Sadabense	34	33	85	23
18	Alcorisa	34	35	93	17

TEMPORADA 2015/2016

PREFERENTE ARAGÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	CF Epila	34	78	28	75
2	Brea	34	73	33	74
3	José	34	62	41	59
4	Casetas	34	51	35	58
5	Fuentes	34	54	44	58
6	Montecarlo	34	58	36	55
7	Cella	34	50	37	55
8	CD Utrillas	34	57	43	55
9	Calamocha	34	53	38	55
10	Morata CD	34	48	37	50
11	Mallén	34	57	47	50
12	Almunia	34	53	48	45
13	Gallur CD	34	43	58	41
14	Quinto	34	38	43	39
15	Tauste CD	34	37	71	28
16	Villanueva	34	40	88	20
17	Pedrola	34	20	93	16
18	Gregorio	34	44	96	12

TEMPORADA 2014/2015

PREFERENTE ARAGÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Cariñena	34	82	33	73
2	Belchite	34	57	22	71
3	Almunia	34	61	32	67
4	Brea	34	59	44	56
5	Cella	34	50	33	55
6	CD Utrillas	34	53	46	55
7	CF Epila	34	51	42	50
8	Casetas	34	56	45	48
9	Calamocha	34	42	48	46
10	Giner	34	49	48	44
11	Alcañiz	34	51	53	43
12	Morata CD	34	43	56	43
13	Fuentes	34	51	47	42
14	Calatayud	34	48	50	41
15	Actur Pablo	34	45	55	41
16	AD Magallon	34	43	77	30
17	Atlético	34	32	71	21
18	CD Calanda	34	28	99	19

TEMPORADA 2013/2014

PREFERENTE ARAGÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Santa Isabel	34	69	16	74
2	Caspe	34	75	22	72
3	Almunia	34	53	27	72
4	Cella	34	54	32	61
5	Belchite	34	52	27	61
6	Calamocha	34	52	44	58
7	CD Utrillas	34	53	35	52
8	Fuentes	34	48	45	50
9	José	34	51	49	47
10	Casetas	34	50	44	47
11	Cariñena	34	50	44	45
12	Alcañiz	34	43	49	44
13	Giner	34	38	47	40
14	Atlético	34	36	49	38
15	Quinto	34	37	54	32
16	Mesa Puesta	34	41	76	31
17	Lécera 2022	34	27	92	14
18	Calatorao	34	19	96	6

TEMPORADA 2012/2013

TERCERA DIVISIÓN GRUPO 17
Equipo		PJ	GF	GC	Puntos
1	Sariñena	38	70	20	84
2	Andorra	38	73	25	84
3	CD Ebro	38	66	40	73
4	Utebo	38	56	26	72
5	Atlético	38	70	50	70
6	Ejea	38	58	40	60
7	SD Borja	38	46	39	57
8	SD Tarazona	38	45	45	53
9	CD Cuarte	38	51	47	53
10	Villanueva	38	47	48	52
11	Oliver	38	45	49	48
12	Atlético	38	35	51	46
13	Barbastro	38	47	57	46
14	Almudévar	38	46	48	45
15	Sabiñánigo	38	51	55	44
16	Calatayud	38	37	52	44
17	Almunia	38	39	58	40
18	Valdefierro	38	38	50	39
19	Robres	38	41	63	30
20	CD Binéfar	38	19	117	15

TEMPORADA 2011/2012

PREFERENTE ARAGÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	SD Borja	34	76	22	84
2	Almunia	34	70	31	74
3	Mallén	34	60	34	71
4	Cella	34	60	40	56
5	Illueca	34	62	39	54
6	Villa	34	61	41	53
7	Brea	34	55	57	52
8	Belchite	34	57	45	50
9	Calamocha	34	35	50	42
10	Gregorio	34	45	65	39
11	Hernán	34	46	53	38
12	CD Utrillas	34	46	57	38
13	Morata CD	34	33	50	38
14	Valdefuentes	34	51	46	37
15	Actur Pablo	34	37	62	36
16	La Muela	34	50	69	32
17	Cd Daroca	34	33	79	26
18	Cd Azuara	34	31	68	21

TEMPORADA 2010/2011

PREFERENTE ARAGÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	CD Cuarte	34	91	41	76
2	José	34	74	40	64
3	Atlético	34	63	40	64
4	Quinto	34	56	31	63
5	Belchite	34	59	49	57
6	Illueca	34	49	39	57
7	Almunia	34	44	32	56
8	Brea	34	48	51	56
9	Alcañiz	34	61	53	52
10	Cd Daroca	34	43	46	44
11	Fuentes	34	49	55	43
12	CD Utrillas	34	49	53	42
13	Peñas	34	37	51	35
14	Calamocha	34	52	71	35
15	Teruel B	34	30	44	34
16	Cd Movera	34	34	69	28
17	Alcorisa	34	36	73	27
18	Monzalbarba	34	33	70	19

TEMPORADA 2009/2010

PREFERENTE ARAGÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	CD Ebro	34	78	22	84
2	Universidad	34	83	17	81
3	SD Tarazona	34	72	35	72
4	Oliver	34	49	49	57
5	Brea	33	60	50	56
6	José	34	45	41	52
7	Calamocha	34	56	55	51
8	Pedrola	34	53	45	48
9	Teruel B	34	42	52	46
10	Casetas	33	47	52	44
11	Illueca	34	45	56	44
12	Almunia	34	42	50	43
13	Monzalbarba	34	49	59	36
14	Alfindén	34	51	69	35
15	Montecarlo	34	41	57	32
16	Garrapinillo	34	42	64	31
17	Cella	34	38	82	24
18	Santa	34	47	85	21

TEMPORADA 2008/2009

PREFERENTE ARAGÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Tauste CD	34	70	30	77
2	Mallén	34	55	29	64
3	Fuentes	34	62	36	62
4	SD Tarazona	34	63	38	59
5	Illueca	34	70	49	56
6	Quinto	34	38	34	53
7	Casetas	34	47	45	49
8	Almunia	34	55	44	48
9	Alfindén	34	48	43	48
10	José	34	50	47	47
11	Teruel B	34	57	50	46
12	Cella	34	62	79	45
13	Belchite	34	51	63	44
14	Santa	34	55	61	43
15	Ateca	34	57	65	41
16	Ágreda	34	43	67	26
17	Molinos	34	40	72	25
18	Gregorio	34	33	104	14

TEMPORADA 2005/2006

TERCERA DIVISIÓN GRUPO 17
Equipo		PJ	GF	GC	Puntos
1	Universidad	38	63	34	67
2	Barbastro	38	52	38	66
3	Andorra	38	59	38	64
4	Utebo	38	55	41	62
5	Atlético	38	69	37	61
6	Sariñena	38	46	37	60
7	Sabiñánigo	38	49	39	60
8	Jacetano	38	38	38	52
9	Alcañiz	38	51	55	51
10	CD Binéfar	38	33	30	50
11	Calatayud	38	51	52	50
12	Casetas	38	41	49	50
13	Almunia	38	49	54	49
14	Villanueva	38	48	50	49
15	CD Ebro	38	36	44	49
16	Zuera	38	43	50	48
17	CD Teruel	38	53	45	48
18	Mallén	38	24	49	42
19	Fuentes	38	41	64	36
20	Lalueza	38	26	83	19

TEMPORADA 2002/2003

TERCERA DIVISIÓN GRUPO 16
Equipo		PJ	GF	GC	Puntos
1	Fraga	40	72	36	82
2	Huesca	40	68	34	81
3	Casetas	40	73	29	81
4	Barbastro	40	64	28	76
5	CD Teruel	40	61	35	74
6	Utebo	40	54	46	64
7	Fuentes	40	53	61	58
8	Atlético	40	53	50	58
9	Sariñena	40	40	37	56
10	Universidad	40	77	66	52
11	CD Ebro	40	36	49	52
12	Andorra	40	44	54	49
13	Zuera	40	58	56	47
14	Sabiñánigo	40	53	72	47
15	Monzalbarba	40	45	65	46
16	Jacetano	40	49	65	44
17	Villa	40	51	86	43
18	Villanueva	40	37	61	42
19	Alcañiz	40	48	52	41
20	Almunia	40	40	73	36
21	Figueruelas	40	31	52	33

TEMPORADA 2001/2002

TERCERA DIVISIÓN GRUPO 16
Equipo		PJ	GF	GC	Puntos
1	Fraga	38	56	23	74
2	CD Teruel	38	73	40	71
3	Zuera	38	69	51	71
4	CD Ebro	38	56	27	71
5	Casetas	38	62	35	69
6	Barbastro	38	52	38	63
7	Alcañiz	38	57	46	55
8	Utebo	38	48	50	54
9	Fuentes	38	44	51	53
10	Figueruelas	38	47	44	52
11	Sariñena	38	43	64	51
12	Andorra	38	38	48	49
13	Monzalbarba	38	56	58	49
14	Sabiñánigo	38	49	47	47
15	Villanueva	38	39	54	45
16	Almunia	38	39	50	44
17	Lalueza	38	35	49	44
18	Gregorio	38	43	74	38
19	Alcampell	38	57	66	36
20	Altorricón	38	33	81	22

TEMPORADA 2000/2001

TERCERA DIVISIÓN GRUPO 16
Equipo		PJ	GF	GC	Puntos
1	CD Teruel	40	83	45	83
2	Figueruelas	40	68	32	78
3	Fraga	40	77	35	76
4	Huesca	40	69	35	75
5	Andorra	40	73	43	74
6	Zuera	40	68	42	71
7	Utebo	40	63	39	69
8	Villanueva	40	62	59	67
9	Alcampell	40	58	52	61
10	Barbastro	40	54	56	59
11	Casetas	40	51	40	55
12	CD Ebro	40	52	58	51
13	Gregorio	40	45	58	49
14	Sariñena	40	35	47	45
15	Lalueza	40	38	68	42
16	Almunia	40	53	71	42
17	Fuentes	40	50	71	40
18	Ejea	40	51	77	39
19	Jacetano	40	33	68	37
20	Peralta	40	30	71	31
21	Tamarite	40	31	77	19

Competiciones que juega

Grupo 2

Preferente Aragón Grupo 2

Pos	Equipos		Pts
1		Andorra	77
2		CD La Almunia	64
3		At. Calatayud	64
4		Alcañiz	61
5		UD San José	53
6		Casetas	52
7		Quinto	48
8		Mores CD	44
9		AD Magallon	43
10		Cariñena Atl.	41
11		Atlético Teruel	37
12		Mallén	34
13		Atlético Escalerillas	32
14		Cella	30
15		Chiprana	27
16		CD Mequinenza	24
17		Fleta CD	22
18		CF Villa De Alagón	14

	Ascenso : Andorra
	Descenso : Chiprana, CD Mequinenza, Fleta CD, CF Villa De Alagón

RIVALES EN Preferente Aragó.

USO DE MEMORIA

7,849,976 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.7770
Total Execution Time	0.7782

CADENA URL

/historico/Almunia

GET DATOS

$_GET['/historico/Almunia']

POST DATOS

No hay datos POST existentes

CONSULTAS (40)

0.0197	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 = 'Almunia' 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.0153	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=1481 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150	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=1481 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0151	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=1481 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0316	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 = 73511
0.0145	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1481 AND type_rel = 2
0.0151	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1481 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0152	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 (637063,1223270) ORDER BY n.cover_points DESC, update_date DESC
0.0149	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 = '1481' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0157	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 = 73511 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0169	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=1481 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0154	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 (73511,71432,67991) 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.0147	SELECT count(id) as num_players from rel_players WHERE league_id = 67991 AND teamId = 1481
0.0148	SELECT count(id) as num_players from rel_players WHERE league_id = 73511 AND teamId = 1481
0.0146	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 1481
0.0148	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 = '1481' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '1481' and rp.type = 4
0.0147	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 = '1481' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0164	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 = 73511 WHERE rp.league_id = 73511 AND rp.teamId = 1481 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.0156	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 = 73511 WHERE rp.league_id = 73511 AND rp.teamId = 1481 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0158	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 = 73511 WHERE rp.league_id = 73511 AND rp.teamId = 1481 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0154	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 = 1481 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0166	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 = 67991 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.0168	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 = 63840 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.0159	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 = 59796 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0164	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 = 51282 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.0165	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 = 44405 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0172	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 = 39041 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0171	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 = 16721 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0175	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 = 4083 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0168	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 = 2696 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0174	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 = 1957 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153	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 = 1478 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153	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 = 1142 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155	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 = 861 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151	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 = 298 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0156	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 = 22129 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0157	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* `tables2003` 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 = 22077 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0167	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* `tables2002` 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 = 22061 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0166	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* `tables2001` 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 = 22045 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

CD La Almunia

CD La Almunia

Selecciona un equipo

Competiciones que juega

Preferente Aragón Grupo 2

RIVALES EN Preferente Aragó.