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.

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

Gurrea

Temporada 2023/2024

TEMPORADA 2023/2024

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

TEMPORADA 2022/2023

1ª REGIONAL ARAGÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Atletico	32	62	20	69
2	Gurrea	31	58	34	67
3	Mequinenza	31	62	31	63
4	Juventud	32	69	42	60
5	Peña	32	68	46	60
6	Almunia Juan	32	54	47	55
7	Peña	32	64	40	54
8	Lorenzo	32	58	51	52
9	Peñas	32	55	47	50
10	Lanaja	32	62	67	45
11	Esplus CD	32	51	61	37
12	Graus	32	49	79	32
13	Binaced	32	46	61	31
14	Peñas	32	47	67	30
15	Estadilla	32	45	67	29
16	Zaidin CD	32	44	75	19
17	U.D.	32	22	81	10

TEMPORADA 2021/2022

PREFERENTE ARAGÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Almudévar	32	89	20	83
2	Fuentes	32	88	31	71
3	José	32	57	30	70
4	Tardienta	32	61	35	56
5	Villanueva	32	52	31	54
6	Quinto	32	41	22	54
7	Zuera	32	47	35	47
8	Villa	32	42	54	45
9	AD Magallon	32	43	40	41
10	Ajax	32	39	49	36
11	Gancho	32	51	67	36
12	Alfindén	32	39	63	35
13	Mallén	32	31	53	30
14	Tauste CD	32	37	54	29
15	Gurrea	32	30	71	28
16	Santa Isabel	32	29	65	26
17	Gallur CD	32	28	84	21

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

1ª REGIONAL ARAGÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Altorricón	33	84	33	76
2	Peña	34	77	44	71
3	Bujaraloz	34	79	55	67
4	Jacetano	34	71	25	66
5	Gurrea	34	95	44	58
6	Pueyo Hinaco	33	62	53	57
7	Monzón	34	61	41	51
8	Benabarre	34	66	48	50
9	Lanaja	34	66	60	50
10	Internaciona	34	65	70	48
11	Atletico	34	55	47	46
12	Peñas	34	45	51	45
13	Zaidin CD	34	54	46	44
14	Estadilla	34	59	73	43
15	Belver	34	51	67	41
16	La Fueva	34	55	58	38
17	Juventud	34	28	141	9
18	Lalueza	34	10	127	1

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

2ª REGIONAL ARAGÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Gurrea	22	79	25	59
2	Lanaja	21	74	28	49
3	Ayerbe	22	47	30	39
4	Peñas	22	69	35	39
5	Sodeto	22	52	49	31
6	Alcala	22	47	61	31
7	Bolea	22	43	63	27
8	San Jorge	21	31	42	24
9	Montesusin	22	32	47	21
10	Almudevar	22	31	54	20
11	Alto Ara	22	29	69	17
12	El Temple	22	33	64	16

TEMPORADA 2014/2015

2ª REGIONAL ARAGÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Juventud	28	93	20	73
2	Internaciona	28	81	37	57
3	Lanaja	28	66	41	55
4	Gurrea	28	66	49	50
5	Peñas	28	64	53	47
6	Bolea	28	63	61	46
7	Ayerbe	28	53	42	45
8	El Temple	28	59	50	44
9	Almudevar	28	46	50	38
10	Montesusin	28	46	46	34
11	Alto Cinca	28	34	68	25
12	San Jorge	28	36	50	23
13	Alcala	28	49	89	19
14	Alto Ara	28	34	81	18
15	Sodeto	28	31	84	18

Competiciones que juega

Grupo 1

Preferente Aragón Grupo 1

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

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

RIVALES EN Preferente Aragó.

USO DE MEMORIA

5,967,016 bytes

BENCHMARKS

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.5650
Total Execution Time	0.5670

CADENA URL

/historico/Gurrea

GET DATOS

$_GET['/historico/Gurrea']

POST DATOS

No hay datos POST existentes

CONSULTAS (29)

0.0155	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 = 'Gurrea' 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.0145	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=29020 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=29020 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0294	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 = 73510
0.0145	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=29020 AND type_rel = 2
0.0148	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 = '29020' ORDER BY l.year DESC,cat.coefficient DESC
0.0147	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 = '29020' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0147	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 = '29020' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0147	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.0148	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=29020 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 (73510,69388) 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 = 73510 AND teamId = 29020
0.0145	SELECT count(id) as num_players from rel_players WHERE league_id = 69388 AND teamId = 29020
0.0146	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 = '29020' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0146	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '29020' 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 = '29020' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0159	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 = 29020 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 = 73510 WHERE rp.league_id = 73510 AND rp.teamId = 29020 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 = 73510 WHERE rp.league_id = 73510 AND rp.teamId = 29020 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0148	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 = 29020 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 73510 AND t.round = 32 ORDER BY team.conference ASC,t.position 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* `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 = 69388 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.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* `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 = 63839 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.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* `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.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* `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.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 = 39765 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* `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.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* `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 = 16811 AND t.round = 22 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* `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 = 5125 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Gurrea

Gurrea

Selecciona un equipo

Competiciones que juega

Preferente Aragón Grupo 1

RIVALES EN Preferente Aragó.