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

Resultados de Fútbol

Alcolea CF

Temporada 2023/2024

TEMPORADA 2023/2024

PREFERENTE ARAGÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Robres	30	73	39	62
2	Zuera	30	61	37	58
3	Ontiñena	30	43	24	57
4	Sadabense	30	53	35	56
5	Internaciona	30	49	23	55
6	Sabiñánigo	30	54	25	54
7	Santa	30	50	31	53
8	Sariñena	30	41	39	45
9	Jacetano	30	32	40	38
10	Montecarlo	30	44	54	37
11	Altorricón	30	40	61	35
12	Los Bancos	30	24	37	35
13	CD Delicias	30	26	51	34
14	Atletico	30	38	54	33
15	Tardienta	30	40	58	27
16	Valdefierro	30	31	57	27
17	Gurrea	30	33	49	25
18	Alcolea CF	30	23	41	24

TEMPORADA 2022/2023

PREFERENTE ARAGÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Fraga	26	70	18	63
2	Internaciona	26	56	22	60
3	Tardienta	26	45	21	50
4	Sabiñánigo	26	45	27	41
5	Jacetano	26	36	38	41
6	Sariñena	26	46	32	39
7	Altorricón	26	50	39	38
8	Zuera	26	34	29	35
9	Ontiñena	26	34	46	34
10	Alcolea CF	26	40	37	33
11	Actur Pablo	26	38	50	29
12	Villanueva	26	32	61	22
13	Ajax	26	28	76	9
14	Biescas	26	24	82	8

TEMPORADA 2021/2022

PREFERENTE ARAGÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Tamarite	32	109	26	83
2	Sariñena	32	79	22	78
3	Internaciona	32	55	21	67
4	Fraga	32	70	32	64
5	Montecarlo	32	61	47	56
6	Valdefierro	32	60	48	50
7	Sabiñánigo	32	57	42	46
8	Atlético	32	31	30	46
9	Casetas	32	53	42	45
10	Jacetano	32	52	49	42
11	Alcolea CF	32	42	58	41
12	Mequinenza	32	36	58	38
13	Peña	32	42	58	33
14	Lorenzo	32	46	80	24
15	Almunia Juan	32	21	89	19
16	Zaragoza	32	22	67	17
17	Peñas	32	22	89	16

TEMPORADA 2020/2021

1ª REGIONAL ARAGÓN GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Alcolea CF	10	26	5	23
2	Jacetano	10	29	13	23
3	Altorricón	10	15	6	21
4	Ontiñena	10	22	14	20
5	Atletico	10	21	6	17
6	Estadilla	10	17	14	16
7	Pueyo Hinaco	10	14	24	12
8	Barbastro	10	16	19	11
9	Esteban	10	13	30	6
10	Bujaraloz	10	13	32	5
11	Boltaña	10	10	33	3

TEMPORADA 2019/2020

1ª REGIONAL ARAGÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Internaciona	25	58	19	60
2	Gurrea	24	74	35	56
3	Jacetano	26	62	25	55
4	Alcolea CF	26	61	29	53
5	Almunia Juan	24	47	20	50
6	Graus	24	59	35	50
7	Esplus CD	25	60	31	41
8	Lanaja	25	59	31	40
9	Altorricón	26	57	42	39
10	San Jorge	24	38	34	33
11	Atletico	26	43	47	32
12	Peñas	25	36	44	32
13	Estadilla	24	37	43	30
14	La Fueva	26	34	44	30
15	Zaidin CD	24	30	37	24
16	Bujaraloz	26	45	63	24
17	Belver	23	17	71	6
18	Esteban	25	19	104	6
19	Grañén	22	17	99	3

TEMPORADA 2018/2019

1ª REGIONAL ARAGÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Peñas	32	94	22	82
2	Huesca B	32	87	24	78
3	Peña	32	73	27	70
4	Gurrea	32	65	33	66
5	Almunia Juan	32	42	43	51
6	Peñas	32	43	40	46
7	Zaidin CD	32	53	59	45
8	Alcolea CF	32	44	51	42
9	Lanaja	32	49	55	41
10	Estadilla	32	55	63	39
11	Atletico	32	40	58	38
12	Esplus	31	38	47	36
13	Esteban	32	42	63	36
14	Belver	32	43	56	34
15	Internaciona	32	38	61	25
16	Ainsa Club.	32	27	84	18
17	Ontiñena	31	30	77	17

TEMPORADA 2017/2018

PREFERENTE ARAGÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Villanueva	34	69	32	71
2	Casetas	34	47	34	70
3	Lorenzo	34	52	33	65
4	Zaragoza	34	57	40	53
5	Grañén	34	42	46	49
6	Barbastro	34	43	42	47
7	Villa	34	38	40	47
8	Gallur CD	34	47	52	47
9	Montecarlo	34	38	39	44
10	Tardienta	34	44	45	43
11	Mallén	34	47	54	43
12	Biescas	34	42	49	43
13	Peña	34	49	46	41
14	AD Magallon	34	43	43	39
15	Alcolea CF	33	45	56	39
16	Giner	34	34	40	38
17	Peñas	33	42	46	32
18	Gregorio	34	29	71	21

TEMPORADA 2016/2017

1ª REGIONAL ARAGÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Tardienta	35	90	25	89
2	Biescas	36	79	32	83
3	Alcolea CF	36	75	42	78
4	Monzón	36	59	55	59
5	Peña	36	67	49	58
6	Jacetano	36	59	48	57
7	Lanaja	35	60	53	53
8	Gurrea	36	70	61	52
9	Belver	36	43	41	50
10	Internaciona	36	73	64	49
11	Peñas	36	46	52	45
12	Pueyo Hinaco	35	54	46	44
13	Alcampell	36	55	75	38
14	Zaidin CD	36	45	67	35
15	Bujaraloz	36	53	81	35
16	Juventud	36	39	76	33
17	Valfonda	36	41	66	32
18	Boltaña	35	45	76	30
19	Graus	36	37	81	25

TEMPORADA 2015/2016

PREFERENTE ARAGÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Robres	34	60	27	71
2	Tamarite	34	71	26	67
3	Santa Isabel	34	42	38	57
4	Peñas	34	54	50	52
5	Caspe	34	49	29	52
6	Actur Pablo	34	59	41	49
7	Hernán	34	43	39	47
8	Grañén	34	43	55	47
9	Peña	34	44	52	47
10	Mequinenza	34	37	38	47
11	Altorricón	34	48	53	46
12	Benabarre	34	49	41	46
13	Barbastro	34	35	45	45
14	Giner	34	44	50	45
15	Alcañiz	34	54	57	45
16	Tardienta	34	43	39	41
17	Alcolea CF	34	34	57	33
18	Belver	34	24	96	10

TEMPORADA 2014/2015

1ª REGIONAL ARAGÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Alcolea CF	32	96	35	75
2	Belver	32	64	29	69
3	Peña	32	61	29	66
4	Lalueza	32	57	32	59
5	Peña	32	59	47	51
6	Laluenga	32	66	45	49
7	Pueyo Hinaco	32	57	55	46
8	Peñas	32	46	49	45
9	La Fueva	32	67	54	44
10	Biescas	32	53	53	44
11	Valfonda	32	39	59	35
12	Alcampell	32	57	68	34
13	Binaced	32	43	68	34
14	Graus	32	36	62	33
15	Ainsa	32	35	61	29
16	Pomar	32	44	74	29
17	Boltaña	32	31	91	16
18	U.D.	0	0	0	0

TEMPORADA 2010/2011

PREFERENTE ARAGÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Universidad	34	71	32	69
2	Oliver	34	64	36	67
3	Tamarite	34	65	35	64
4	Robres	34	67	30	62
5	Fraga	34	69	36	62
6	Zuera	34	62	41	61
7	SD Borja	34	59	45	59
8	Alcampell	34	65	42	58
9	Casetas	34	50	51	46
10	Lorenzo	34	50	52	45
11	Almudévar	34	57	51	39
12	Alfindén	34	40	51	38
13	Peña	34	53	72	38
14	Jacetano	34	45	51	37
15	Gregorio	34	34	61	37
16	Grañén	34	47	70	36
17	Alcolea CF	34	39	69	29
18	Pedrola	34	13	125	8

TEMPORADA 1992/1993

TERCERA DIVISIÓN GRUPO 16
Equipo		PJ	GF	GC	Puntos
1	Huesca	38	84	32	60
2	Utebo	38	62	15	54
3	Barbastro	38	74	34	54
4	Casetas	38	59	35	52
5	Hernán	38	63	41	48
6	CD Teruel	38	50	29	47
7	CD Binéfar	38	48	32	47
8	Fraga	38	53	42	40
9	CD Ebro	38	48	53	37
10	Sabiñánigo	38	49	56	36
11	Tamarite	38	49	55	35
12	Almunia	38	43	61	34
13	Caspe	38	35	47	32
14	Sariñena	38	41	55	32
15	Atlético	38	35	49	30
16	Monzalbarba	38	42	71	30
17	Alcañiz	38	33	46	30
18	Alcolea CF	38	38	51	27
19	Ejea	38	28	71	21
20	Mallén	38	31	90	14

Competiciones que juega

Grupo 1

Preferente Aragón Grupo 1

Pos	Equipos		Pts
1		Robres	62
2		Zuera	58
3		Ontiñena	57
4		Sadabense CD	56
5		Internacional Huesca	55
6		Sabiñánigo	54
7		Santa Anastasia CF	53
8		Sariñena	45
9		Jacetano	38
10		UD Montecarlo	37
11		Altorricón	35
12		Los Bancos	35
13		CD Delicias	34
14		Atletico Binefar	33
15		AD Tardienta	27
16		Valdefierro	27
17		Gurrea	25
18		Alcolea CF	24

	Ascenso : Robres
	Descenso : AD Tardienta, Valdefierro, Gurrea, Alcolea CF

RIVALES EN Preferente Aragó.

USO DE MEMORIA

6,419,768 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.4960
Total Execution Time	0.4973

CADENA URL

/historico/Alcolea-Cf

GET DATOS

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

POST DATOS

No hay datos POST existentes

CONSULTAS (29)

0.0139	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 = 'Alcolea-Cf' 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.0125	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=4729 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=4729 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=4729 AND type_rel = 2
0.0130	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 = '4729' ORDER BY l.year DESC,cat.coefficient DESC
0.0128	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 = '4729' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0128	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 = '4729' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0129	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 = 73510 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0133	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=4729 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0130	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 (73510) 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.0133	SELECT count(id) as num_players from rel_players WHERE league_id = 73510 AND teamId = 4729
0.0127	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 = '4729' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0129	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '4729' and rp.type = 4
0.0128	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 = '4729' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 73510 WHERE rp.league_id = 73510 AND rp.teamId = 4729 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.0143	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 = 73510 WHERE rp.league_id = 73510 AND rp.teamId = 4729 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0138	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 = 73510 WHERE rp.league_id = 73510 AND rp.teamId = 4729 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0131	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 = 4729 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 68792 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0140	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 = 63838 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.0140	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 = 59830 AND t.round = 11 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145	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 = 51300 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.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* `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 = 44665 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148	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 = 39349 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0141	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 = 34098 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0138	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 = 16720 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0140	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 = 5121 AND t.round = 34 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* `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 = 1141 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134	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* `tables1993` 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 = 21895 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC


	¿Has detectado algún error en la web? x Tipo de incidencia ¿Qué ocurre? Deja tu correo si quieres que te contactemos

Resultados de Fútbol

Alcolea CF

Alcolea CF

Selecciona un equipo

Competiciones que juega

Preferente Aragón Grupo 1

RIVALES EN Preferente Aragó.