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

Barbastro

Entrenador: Daniel Martínez

Temporada 2023/2024

TEMPORADA 2023/2024

SEGUNDA FEDERACIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Bilbao Ath.	33	63	17	79
2	Barakaldo	33	58	19	73
3	Logroñés	33	67	17	68
4	Utebo	33	40	28	61
5	Deportivo	33	48	36	56
6	Deportivo	33	57	40	52
7	Tudelano	33	43	32	45
8	Barbastro	33	27	28	44
9	Real	33	33	36	44
10	SD Gernika	33	37	47	43
11	Calahorra	33	32	35	43
12	Arenas Getxo	33	34	36	40
13	Izarra	33	31	49	36
14	Mutilvera	33	21	47	33
15	AD San Juan	33	28	46	32
16	Valle	33	23	55	21
17	Brea	33	15	51	21
18	Náxara	33	20	58	21

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

TERCERA FEDERACIÓN GRUPO 17
Equipo		PJ	GF	GC	Puntos
1	Deportivo	32	65	29	67
2	Utebo	32	63	28	66
3	Illueca	32	47	31	65
4	CD Binéfar	32	54	30	56
5	Robres	32	45	32	53
6	CD Cuarte	32	46	27	52
7	Atlético	32	40	23	49
8	Barbastro	32	36	29	48
9	Caspe	32	46	37	48
10	CF Epila	32	39	37	48
11	Cariñena	32	36	45	45
12	Calamocha	32	36	40	36
13	Belchite	32	35	43	33
14	Santa	32	31	40	33
15	SD Borja	32	31	48	29
16	Giner	32	23	97	18
17	Biescas	32	10	67	10

TEMPORADA 2020/2021

TERCERA DIVISIÓN GRUPO 17
Equipo		PJ	GF	GC	Puntos
1	CD Teruel	22	34	11	49
2	Huesca B	22	36	18	45
3	Belchite	22	22	9	35
4	Deportivo	22	32	14	34
5	Illueca	22	23	16	34
6	CD Binéfar	22	29	17	32
7	Atlético	22	26	19	31
8	Cariñena	22	21	23	27
9	Tamarite	22	19	29	25
10	Valdefierro	22	20	36	22
11	Fraga	22	17	21	22
12	AD San Juan	22	0	66	0
13	Brea	22	34	12	42
14	CD Cuarte	22	32	21	39
15	Utebo	22	21	15	37
16	Barbastro	22	27	18	36
17	SD Borja	22	29	23	31
18	Calamocha	22	24	19	30
19	Sariñena	22	36	36	29
20	CF Epila	22	23	23	26
21	Robres	22	23	31	26
22	Almudévar	22	17	32	22
23	Villanueva	22	16	39	18
24	Sabiñánigo	22	24	37	14

TEMPORADA 2019/2020

TERCERA DIVISIÓN GRUPO 17
Equipo		PJ	GF	GC	Puntos
1	SD Tarazona	28	58	20	65
2	CD Teruel	29	53	19	63
3	Brea	29	41	23	54
4	Deportivo	28	51	23	51
5	CD Cuarte	28	39	32	50
6	AD San Juan	28	38	30	46
7	SD Borja	28	37	29	45
8	Illueca	28	42	37	43
9	Sariñena	29	36	32	43
10	CD Binéfar	29	34	30	41
11	Barbastro	29	35	33	39
12	Fraga	29	35	33	37
13	Utebo	29	37	41	32
14	Atlético	29	24	34	32
15	Robres	29	31	39	28
16	Tamarite	29	27	45	28
17	Calamocha	28	32	48	27
18	Belchite	29	21	35	26
19	Villanueva	29	23	48	24
20	Valdefierro	28	22	56	22
21	Almudévar	28	18	47	19

TEMPORADA 2018/2019

PREFERENTE ARAGÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	CD Cuarte	34	69	28	72
2	Barbastro	34	54	27	71
3	CF Epila	34	52	39	59
4	Santa	34	55	47	59
5	Zuera	34	60	58	50
6	José	34	53	51	47
7	Biescas	34	39	44	47
8	Villa	34	48	49	46
9	Zaragoza	34	49	48	45
10	Mallén	34	37	45	45
11	Peña	34	48	41	43
12	Tardienta	34	43	46	43
13	AD Magallon	34	43	47	43
14	Actur Pablo	34	40	45	43
15	Gallur CD	34	40	52	42
16	Jacetano	34	42	51	41
17	Grañén	34	40	64	29
18	Altorricón	34	35	65	25

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

PREFERENTE ARAGÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Caspe	34	56	29	66
2	Fraga	34	62	30	61
3	Atlético	34	47	25	61
4	José	34	53	46	56
5	Actur Pablo	34	45	44	51
6	Mequinenza	34	44	32	50
7	Barbastro	34	47	45	50
8	Peña	34	56	55	50
9	Lorenzo	34	51	64	49
10	Montecarlo	34	53	51	48
11	Peñas	34	44	49	47
12	Villanueva	34	48	41	44
13	Grañén	34	55	52	44
14	Giner	34	47	59	40
15	Benabarre	34	46	55	39
16	Santa Isabel	34	40	55	36
17	Altorricón	34	48	69	36
18	Lalueza	34	31	72	19

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

TERCERA DIVISIÓN GRUPO 17
Equipo		PJ	GF	GC	Puntos
1	CD Ebro	38	84	27	86
2	CD Teruel	38	72	36	84
3	Sariñena	38	72	26	78
4	SD Tarazona	38	76	36	77
5	Andorra	38	54	24	76
6	SD Borja	38	54	34	61
7	CD Cuarte	38	46	40	60
8	Almudévar	38	49	39	59
9	Utebo	38	49	60	55
10	Ejea	38	51	45	52
11	Illueca	38	48	58	50
12	Villa	38	40	61	47
13	Atlético	38	51	62	43
14	Sabiñánigo	38	53	65	42
15	CD Binéfar	38	37	56	40
16	Villanueva	38	35	50	40
17	Tamarite	38	34	63	35
18	Caspe	38	30	48	35
19	Santa Isabel	38	29	52	29
20	Barbastro	38	26	108	6

TEMPORADA 2013/2014

TERCERA DIVISIÓN GRUPO 17
Equipo		PJ	GF	GC	Puntos
1	Deportivo	40	95	30	95
2	CD Teruel	40	56	41	78
3	Ejea	40	58	29	72
4	Almudévar	40	78	37	71
5	Atlético	40	65	48	71
6	SD Tarazona	40	67	52	70
7	Utebo	40	57	51	69
8	SD Borja	40	52	34	64
9	Barbastro	40	56	49	59
10	Andorra	40	44	42	57
11	Villanueva	40	57	47	57
12	Tamarite	40	54	64	56
13	CD Ebro	40	67	54	51
14	Sabiñánigo	40	52	59	51
15	Illueca	40	40	51	49
16	CD Cuarte	40	47	53	48
17	Brea	40	39	76	39
18	Calatayud	40	46	79	38
19	Atlético	40	36	77	28
20	Altorricón	40	36	83	24
21	Oliver	40	35	81	21

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

TERCERA DIVISIÓN GRUPO 17
Equipo		PJ	GF	GC	Puntos
1	Sariñena	36	64	23	76
2	Ejea	36	66	34	69
3	CD Cuarte	36	61	35	66
4	Utebo	36	52	31	63
5	Valdefierro	36	48	34	62
6	Villanueva	36	59	48	54
7	Sabiñánigo	36	54	48	54
8	Calatayud	36	44	34	53
9	CD Binéfar	36	42	39	51
10	Oliver	36	50	53	48
11	CD Ebro	36	42	47	47
12	Barbastro	36	54	59	47
13	Atlético	36	38	45	44
14	Robres	36	41	50	43
15	SD Tarazona	36	41	49	42
16	Tauste CD	36	50	59	37
17	Giner	36	41	68	31
18	Quinto	36	24	64	29
19	José	36	31	82	20

TEMPORADA 2010/2011

TERCERA DIVISIÓN GRUPO 17
Equipo		PJ	GF	GC	Puntos
1	Andorra	38	84	31	84
2	Deportivo	38	76	29	79
3	Utebo	38	74	30	79
4	CD Binéfar	38	66	48	71
5	Ejea	38	75	37	70
6	Villanueva	38	60	36	62
7	Sabiñánigo	38	60	42	61
8	Barbastro	38	55	48	61
9	Atlético	38	48	35	58
10	Calatayud	38	58	47	58
11	Valdefierro	38	55	54	54
12	SD Tarazona	38	52	62	50
13	River Ebro	38	58	67	42
14	Tauste CD	38	39	56	41
15	Sariñena	38	35	55	39
16	Giner	38	39	75	38
17	Altorricón	38	31	66	35
18	Pomar	38	34	72	35
19	Sta. Isabel	38	42	84	28
20	Mallén	38	29	96	17

TEMPORADA 2009/2010

TERCERA DIVISIÓN GRUPO 17
Equipo		PJ	GF	GC	Puntos
1	CD Teruel	38	88	29	94
2	La Muela	38	73	24	90
3	Deportivo	38	96	33	84
4	Ejea	38	104	35	84
5	Atlético	38	77	42	81
6	Andorra	38	78	38	79
7	Sabiñánigo	38	53	60	52
8	Villanueva	38	60	62	46
9	Utebo	38	53	62	46
10	Valdefierro	38	46	63	46
11	Giner	38	40	74	43
12	Sariñena	38	36	61	43
13	Tauste CD	38	43	61	39
14	Barbastro	38	40	72	39
15	Calatayud	38	46	56	38
16	Mallén	38	37	57	36
17	CD Cuarte	38	40	73	36
18	Fraga	38	46	84	35
19	Alcañiz	38	55	86	34
20	Jacetano	38	34	73	30

TEMPORADA 2008/2009

TERCERA DIVISIÓN GRUPO 17
Equipo		PJ	GF	GC	Puntos
1	Atlético	38	87	28	88
2	Deportivo	38	91	30	86
3	CD Teruel	38	78	22	82
4	La Muela	38	86	32	80
5	Ejea	38	74	38	71
6	Andorra	38	76	44	67
7	Utebo	38	61	58	57
8	Sariñena	38	51	58	57
9	Barbastro	38	51	58	50
10	Calatayud	38	52	56	47
11	Alcañiz	38	64	68	46
12	Villanueva	38	62	65	45
13	Sabiñánigo	38	35	60	43
14	CD Cuarte	38	45	59	42
15	Giner	38	40	67	41
16	Fraga	38	48	71	40
17	Lorenzo	38	36	76	38
18	CD Binéfar	38	50	82	38
19	Zuera	38	33	76	21
20	Brea	38	35	107	21

TEMPORADA 2007/2008

TERCERA DIVISIÓN GRUPO 17
Equipo		PJ	GF	GC	Puntos
1	Ejea	40	95	37	93
2	Barbastro	40	102	24	88
3	CD Teruel	40	73	29	84
4	Atlético	40	76	34	81
5	Andorra	40	74	45	81
6	Deportivo	40	84	38	80
7	Villanueva	40	65	46	71
8	Sariñena	40	59	52	58
9	Calatayud	40	40	39	53
10	Sabiñánigo	40	51	57	52
11	Utebo	40	56	65	51
12	Lorenzo	40	48	74	43
13	CD Binéfar	40	42	71	43
14	CD Cuarte	40	52	81	43
15	Brea	40	52	91	43
16	Fraga	40	41	66	40
17	CD Ebro	40	40	65	40
18	Figueruelas	40	38	64	37
19	Illueca	40	43	78	33
20	Peñas	40	36	74	29
21	Jacetano	40	47	84	28

TEMPORADA 2006/2007

SEGUNDA DIVISIÓN B GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Alicante	38	51	36	65
2	Huesca	38	44	33	62
3	Alcoyano	38	45	34	62
4	L´Hospitale	38	43	36	61
5	Badalona	38	47	28	60
6	Terrassa FC	38	46	34	59
7	Orihuela CF	38	46	33	56
8	Villajoyosa	38	39	40	54
9	Benidorm	38	51	53	52
10	At. Levante	38	33	35	52
11	Gramanet	38	39	41	52
12	UE Figueres	38	37	43	49
13	Espanyol B	38	45	47	49
14	Lleida	38	44	38	49
15	Osasuna	38	34	43	45
16	Valencia	38	32	46	45
17	Sant Andreu	38	35	43	45
18	Eldense	38	32	44	42
19	Barça	38	33	47	37
20	Barbastro	38	31	53	33

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 2004/2005

TERCERA DIVISIÓN GRUPO 17
Equipo		PJ	GF	GC	Puntos
1	Barbastro	38	62	35	72
2	Utebo	38	70	30	71
3	Universidad	38	71	40	69
4	Sariñena	38	57	37	66
5	Sabiñánigo	38	61	40	62
6	Villanueva	38	58	52	61
7	Casetas	38	69	57	60
8	Andorra	38	61	49	59
9	Jacetano	38	65	48	58
10	Alcañiz	38	52	43	58
11	Atlético	38	51	42	55
12	CD Teruel	38	43	46	51
13	Calatayud	38	36	42	49
14	CD Ebro	38	39	49	48
15	CD Binéfar	38	30	44	43
16	Zuera	38	48	60	43
17	Fraga	38	38	55	40
18	Villa	38	42	65	35
19	Ejea	38	24	72	24
20	La Fueva	38	37	108	18

Competiciones que juega

Segunda Federación Grupo 2

Pos	Equipos		Pts
1		Bilbao Ath.	79
2		Barakaldo	73
3		UD Logroñés	68
4		Utebo	61
5		Deportivo Aragón	56
6		Deportivo Alavés B	52
7		Tudelano	45
8		Barbastro	44
9		Real Sociedad C	44
10		SD Gernika	43
11		CD Calahorra	43
12		Arenas de Getxo	40
13		Izarra	36
14		Mutilvera	33
15		AD San Juan	32
16		CD Valle de Egüés	21
17		Brea	21
18		Náxara	21

	Ascenso : Bilbao Ath.
	Playoff Ascenso : Barakaldo, UD Logroñés, Utebo, Deportivo Aragón
	Playoff Descenso : Izarra
	Descenso : Mutilvera, AD San Juan, CD Valle de Egüés, Brea, Náxara

RIVALES EN Copa del Rey

RIVALES EN Segunda Federaci.

USO DE MEMORIA

8,423,656 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1616
Total Execution Time	0.1629

CADENA URL

/historico/Barbastro

GET DATOS

$_GET['/historico/Barbastro']

POST DATOS

No hay datos POST existentes

CONSULTAS (37)

0.0039	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 = 72363
0.0019	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=427 AND type_rel = 2
0.0021	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 427 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0024	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 (750356,822157,886617,981218,990175) ORDER BY n.cover_points DESC, update_date DESC
0.0031	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 = '427' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021	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 = 72363 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0033	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=427 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019	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 (72363,71759,71432,68447,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.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 72363 AND teamId = 427
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 67991 AND teamId = 427
0.0025	SELECT count(id) as num_players from rel_players WHERE league_id = 71759 AND teamId = 427
0.0019	SELECT count(id) as num_players from rel_players WHERE league_id = 68447 AND teamId = 427
0.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 427
0.0039	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 = 72363 WHERE rp.league_id = 72363 AND rp.teamId = 427 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.0033	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 = 72363 WHERE rp.league_id = 72363 AND rp.teamId = 427 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0030	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 = 72363 WHERE rp.league_id = 72363 AND rp.teamId = 427 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0040	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 = 427 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0026	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 = 72363 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.0024	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.0027	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 = 62401 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.0028	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 = 58596 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.0028	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 = 50285 AND t.round = 31 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025	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 = 44662 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026	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.0029	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 = 33993 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033	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.0030	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 = 3926 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025	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 = 2567 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027	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.0028	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 = 1411 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025	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 = 1106 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027	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 = 843 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033	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 = 147 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026	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 = 24 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025	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 = 84 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0039	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.0027	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 = 22110 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Barbastro

Barbastro

Selecciona un equipo

Competiciones que juega

Segunda Federación Grupo 2

RIVALES EN Copa del Rey

RIVALES EN Segunda Federaci.