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

Águilas FC

Entrenador: Sergio Yúfera

Temporada 2023/2024

TEMPORADA 2023/2024

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

TEMPORADA 2022/2023

TERCERA FEDERACIÓN GRUPO 13
Equipo		PJ	GF	GC	Puntos
1	Águilas FC	30	55	15	69
2	Lorca	30	54	28	58
3	Unión Atl.	30	39	23	56
4	Racing	30	42	30	53
5	Pulpileño	30	45	33	51
6	Unión	30	44	31	50
7	Real Murcia	30	39	32	44
8	UCAM Murcia	30	35	37	41
9	Cieza	30	43	39	40
10	El Palmar	30	44	51	37
11	Ciudad	30	26	31	35
12	Caravaca	30	33	43	34
13	Deportiva	30	34	47	30
14	Alcantarilla	30	20	38	25
15	Muleño CF	30	33	63	21
16	CD Bullense	30	22	67	18

TEMPORADA 2021/2022

SEGUNDA FEDERACIÓN GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Intercity	34	46	16	66
2	Nucía	34	41	18	64
3	Real Murcia	34	42	27	58
4	Eldense	34	47	37	56
5	Hércules	34	41	31	56
6	Racing	34	34	29	55
7	UD Alzira	34	42	36	51
8	Recreativo	34	34	32	46
9	UD Melilla	34	36	39	45
10	Mancha Real	34	32	36	43
11	Pvo. Ejido	34	30	35	43
12	Yugo	34	29	34	43
13	Águilas FC	34	32	36	41
14	At. Levante	34	33	33	38
15	Pulpileño	34	23	48	34
16	Marchamalo	34	33	59	32
17	Puertollano	34	38	50	29
18	CD Toledo	34	27	44	28

TEMPORADA 2020/2021

TERCERA DIVISIÓN GRUPO 13
Equipo		PJ	GF	GC	Puntos
1	Real Murcia	20	36	14	44
2	Águilas FC	20	43	8	44
3	Pulpileño	20	30	11	43
4	Garres	20	22	21	27
5	CD Bullense	20	23	25	27
6	UCAM Murcia	20	28	23	26
7	Olímpico	20	17	23	23
8	El Palmar	20	26	28	22
9	Minerva	20	24	36	20
10	EDMF Churra	20	17	36	16
11	Plus Ultra	20	11	52	9
12	Racing	20	27	12	43
13	Cartagena	20	38	10	40
14	Racing	20	25	9	37
15	Unión Atl.	20	33	19	36
16	Cartagena	20	30	27	32
17	Mazarrón	20	21	19	26
18	Deportiva	20	18	20	24
19	Huércal-Ove	20	17	27	22
20	Ciudad	20	13	18	21
21	Muleño CF	20	18	31	16
22	Lorca FC	20	9	57	4

TEMPORADA 2019/2020

TERCERA DIVISIÓN GRUPO 13
Equipo		PJ	GF	GC	Puntos
1	Lorca	28	63	23	60
2	Pulpileño	28	52	19	57
3	Racing	28	52	19	56
4	Real Murcia	28	51	28	54
5	Mazarrón	28	44	32	54
6	UCAM Murcia	28	45	30	47
7	Lorca FC	28	37	28	46
8	Minerva	28	46	38	42
9	Muleño CF	28	39	39	40
10	Garres	28	34	30	35
11	Deportiva	28	39	47	33
12	EDMF Churra	28	31	42	33
13	Cartagena	28	35	36	33
14	El Palmar	28	26	51	31
15	Huércal-Ove	28	29	34	30
16	Águilas FC	28	30	38	27
17	Cartagena	28	28	49	26
18	Olímpico	28	25	49	24
19	Ciudad	28	21	51	19
20	Plus Ultra	28	18	62	15

TEMPORADA 2018/2019

TERCERA DIVISIÓN GRUPO 13
Equipo		PJ	GF	GC	Puntos
1	Yeclano	42	88	30	89
2	Lorca	42	69	28	89
3	Lorca FC	42	73	28	80
4	EDMF Churra	42	63	50	77
5	Pulpileño	42	65	41	76
6	Águilas FC	42	56	33	74
7	Racing	42	55	49	65
8	UCAM Murcia	42	52	42	63
9	Deportiva	42	45	55	55
10	Mazarrón	42	48	56	54
11	Olímpico	42	54	64	54
12	Garres	42	36	48	53
13	Real Murcia	42	56	64	51
14	Muleño CF	42	44	59	49
15	Minerva	42	42	55	48
16	Huércal-Ove	42	56	68	48
17	Cartagena	42	51	53	48
18	Ciudad	42	43	70	44
19	Unión Atl.	42	42	55	43
20	Estudiantes	42	37	55	42
21	CD Algar	42	29	71	35
22	Cieza	42	36	66	32

TEMPORADA 2017/2018

TERCERA DIVISIÓN GRUPO 13
Equipo		PJ	GF	GC	Puntos
1	Yeclano	38	81	37	75
2	Racing	38	59	39	68
3	Pulpileño	38	58	34	67
4	EDMF Churra	38	57	40	63
5	Minerva	38	63	46	62
6	FC Pinatar	38	52	47	58
7	Águilas FC	38	48	44	56
8	Cartagena	38	49	51	55
9	Estudiantes	38	53	54	54
10	UCAM Murcia	38	50	50	53
11	Muleño CF	38	43	46	52
12	Deportiva	38	48	50	47
13	Lorca FC B	38	51	48	47
14	Huércal-Ove	38	53	57	46
15	Cieza	38	41	53	46
16	Real Murcia	38	50	57	45
17	Garres	38	55	60	44
18	Unión Atl.	38	43	53	42
19	El Palmar	38	52	65	40
20	Bala Azul	38	30	105	15

TEMPORADA 2016/2017

TERCERA DIVISIÓN GRUPO 13
Equipo		PJ	GF	GC	Puntos
1	Lorca	38	96	38	85
2	Lorca FC B	38	87	34	85
3	Águilas FC	38	78	30	81
4	Racing	38	54	27	67
5	Yeclano	38	61	38	65
6	Real Murcia	38	67	44	59
7	El Palmar	38	54	48	58
8	UCAM Murcia	38	71	51	55
9	Estudiantes	38	58	52	53
10	Unión Atl.	38	47	54	52
11	Cieza	38	58	66	52
12	Pulpileño	38	50	55	49
13	Huércal-Ove	38	40	59	43
14	EDMF Churra	38	53	57	42
15	Muleño CF	38	44	60	42
16	Deportiva	38	40	56	41
17	Pinatar	38	39	47	39
18	Ciudad	38	41	63	37
19	CD Algar	38	39	68	33
20	Olímpico	38	27	157	17

TEMPORADA 2015/2016

TERCERA DIVISIÓN GRUPO 13
Equipo		PJ	GF	GC	Puntos
1	Lorca	34	64	16	78
2	Águilas FC	34	62	29	77
3	El Palmar	34	71	30	66
4	Racing	34	58	39	63
5	Yeclano	34	52	27	62
6	Unión Atl.	34	51	38	59
7	Huércal-Ove	34	42	41	50
8	Real Murcia	34	45	39	49
9	Deportiva	34	56	61	46
10	Muleño CF	34	40	48	45
11	Estudiantes	34	50	42	41
12	EDMF Churra	34	37	45	41
13	Ciudad	34	45	56	36
14	Pulpileño	34	33	43	35
15	Pinatar	34	41	59	31
16	Plus Ultra	34	35	55	31
17	EF Alhama	34	39	69	26
18	Caravaca	34	29	113	16

TEMPORADA 2014/2015

TERCERA DIVISIÓN GRUPO 13
Equipo		PJ	GF	GC	Puntos
1	Jumilla	34	57	26	72
2	Real Murcia	34	56	20	69
3	Huércal-Ove	34	57	32	68
4	Águilas FC	34	66	30	64
5	Racing	34	47	32	60
6	Yeclano	34	56	43	56
7	Deportiva	34	43	41	50
8	Unión Atl.	34	44	46	47
9	Pinatar	34	42	44	45
10	Plus Ultra	34	50	59	43
11	Muleño CF	34	43	41	39
12	El Palmar	34	41	48	39
13	Caravaca	34	37	48	38
14	Club Fortuna	34	48	61	38
15	EF Alhama	34	39	56	35
16	Cartagena	34	36	58	35
17	Unión	34	32	55	29
18	Cieza	34	23	77	17

TEMPORADA 2013/2014

TERCERA DIVISIÓN GRUPO 13
Equipo		PJ	GF	GC	Puntos
1	UCAM Murcia	36	71	15	88
2	Yeclano	36	78	34	75
3	Águilas FC	36	71	33	73
4	Racing	36	75	38	70
5	Unión Atl.	36	80	32	69
6	Jumilla	36	69	56	64
7	Huércal-Ove	36	50	40	56
8	Deportiva	36	59	49	56
9	Real Murcia	36	57	54	48
10	Plus Ultra	36	48	57	47
11	Cieza	36	54	64	45
12	El Palmar	36	49	55	43
13	Muleño CF	36	44	75	35
14	Unión	36	37	64	35
15	Pulpileño	36	35	60	32
16	CD Bullense	36	31	80	27
17	Olímpico	36	38	94	21

TEMPORADA 2012/2013

TERCERA DIVISIÓN GRUPO 13
Equipo		PJ	GF	GC	Puntos
1	Lorca FC	34	86	25	79
2	Cieza	34	55	27	70
3	Racing	34	64	30	69
4	Jumilla	34	66	35	67
5	Deportiva	34	41	31	57
6	Plus Ultra	34	43	29	54
7	Real Murcia	34	32	35	50
8	Unión	34	40	42	47
9	Pulpileño	34	39	42	44
10	El Palmar	34	46	48	43
11	Águilas FC	34	42	39	42
12	CD Bullense	34	36	38	42
13	Olímpico	34	46	60	40
14	Huércal-Ove	34	39	46	39
15	Club Fortuna	34	30	53	34
16	Bala Azul	34	34	66	31
17	CD Beniel	34	30	81	19
18	Pinatar	34	26	68	14

TEMPORADA 2011/2012

TERCERA DIVISIÓN GRUPO 13
Equipo		PJ	GF	GC	Puntos
1	Yeclano	36	73	24	86
2	Águilas FC	36	77	34	81
3	Lorca FC	36	77	24	79
4	Racing	36	81	34	79
5	Cieza	36	79	42	69
6	UCAM Murcia	36	70	45	58
7	Real Murcia	36	45	36	56
8	Jumilla	36	54	52	50
9	Bala Azul	36	47	54	50
10	Pulpileño	36	54	46	45
11	Plus Ultra	36	47	58	42
12	Pinatar	36	31	43	41
13	Deportiva	36	33	56	41
14	Club Fortuna	36	40	66	36
15	Unión	36	45	81	34
16	Santomera	36	39	61	30
17	Cartagena	36	28	61	28
18	Base Abarán	36	39	77	26
19	Esperanza	36	20	85	24

TEMPORADA 2010/2011

PREFERENTE MURCIA
Equipo		PJ	GF	GC	Puntos
1	Águilas FC	38	69	18	96
2	Esperanza	38	84	41	75
3	Deportiva	38	79	41	75
4	Torre	38	73	56	67
5	Ceuti At.	38	70	54	63
6	Thader	38	63	42	59
7	Pozo	38	65	67	56
8	Cuarto	38	54	55	53
9	Muleño CF	38	65	60	52
10	CD Bullense	38	57	52	52
11	El Palmar	38	46	48	52
12	Garres	38	65	72	52
13	Yeclano B	38	43	42	51
14	Mazarrón	38	43	54	44
15	Ciudad Cieza	38	45	62	43
16	Guadalupe	38	50	63	38
17	Lumbreras	38	45	60	37
18	Montecasilla	38	64	86	35
19	Javalí-Ñor	38	38	93	26
20	Cotillas	38	35	87	23

Competiciones que juega

Segunda Federación Grupo 4

Pos	Equipos		Pts
1		Sevilla At.	64
2		Yeclano Deportivo	59
3		Marbella FC	52
4		Betis Deportivo	51
5		Orihuela CF	50
6		CD Estepona	48
7		Águilas FC	46
8		RB Linense	44
9		UCAM Murcia	43
10		Atlético Antoniano	42
11		FC La Unión Atl.	40
12		Racing Cartagena Mar Menor	39
13		Cádiz CF Mirandilla	38
14		CD Manchego Ciudad Real	37
15		San Roque de Lepe	35
16		El Palo FC	34
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 del Rey

RIVALES EN Segunda Federaci.

USO DE MEMORIA

7,355,672 bytes

BENCHMARKS

Loading Time Base Classes	0.0014
Controller Execution Time ( Home / Category )	0.6029
Total Execution Time	0.6043

CADENA URL

/historico/Aguilas-Cf

GET DATOS

$_GET['/historico/Aguilas-Cf']

POST DATOS

No hay datos POST existentes

CONSULTAS (31)

0.0149	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=90 AND type_rel = 2
0.0154	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 90 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0150	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 (70823,75296,79747,79873,94469) ORDER BY n.cover_points DESC, update_date DESC
0.0152	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 = '90' ORDER BY l.year DESC,cat.coefficient DESC
0.0151	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 = '90' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0152	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=90 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0146	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 (72365,71759,71432,67987) 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.0154	SELECT count(id) as num_players from rel_players WHERE league_id = 72365 AND teamId = 90
0.0147	SELECT count(id) as num_players from rel_players WHERE league_id = 67987 AND teamId = 90
0.0152	SELECT count(id) as num_players from rel_players WHERE league_id = 71759 AND teamId = 90
0.0148	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 90
0.0147	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 = '90' 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 = '90' and rp.type = 4
0.0148	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 = '90' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 72365 WHERE rp.league_id = 72365 AND rp.teamId = 90 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.0157	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 = 90 AND (e.action = 4 or e.action = 5) 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 = 72365 WHERE rp.league_id = 72365 AND rp.teamId = 90 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0156	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 = 90 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 67987 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.0163	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 = 62384 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.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* `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 = 58592 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.0179	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 = 50281 AND t.round = 28 ORDER BY team.conference ASC,t.position 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* `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 = 44401 AND t.round = 42 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* `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 = 39037 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152	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 = 33363 AND t.round = 38 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* `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 = 15455 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149	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 = 3922 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149	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 = 2562 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150	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 = 1955 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* `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 = 1447 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149	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 = 1233 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Águilas FC

Águilas FC

Selecciona un equipo

Competiciones que juega

Segunda Federación Grupo 4

RIVALES EN Copa del Rey

RIVALES EN Segunda Federaci.