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

Guijuelo

Entrenador: Mario Sánchez

Temporada 2023/2024

TEMPORADA 2023/2024

SEGUNDA FEDERACIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Ourense CF	33	52	19	70
2	Pontevedra	33	68	31	65
3	Zamora	33	38	20	60
4	Guijuelo	33	36	32	51
5	Rayo	33	47	40	48
6	Langreo	33	30	39	47
7	Compostela	33	34	35	47
8	Real	33	45	52	44
9	Coruxo	33	35	47	42
10	Deportivo	33	46	46	41
11	Real Avilés	33	40	36	41
12	Gimnástica	33	40	49	40
13	Marino	33	26	24	39
14	Villalbés	33	23	31	37
15	Arandina	33	36	44	34
16	Real Oviedo	33	26	41	30
17	Cayón	33	36	50	30
18	Covadonga	33	35	57	29

TEMPORADA 2022/2023

SEGUNDA FEDERACIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Arenteiro	34	44	19	73
2	Real Avilés	34	45	30	59
3	Real	34	49	41	56
4	Compostela	34	42	27	54
5	Zamora	34	38	33	54
6	Guijuelo	34	35	29	54
7	Real Oviedo	34	44	42	51
8	Gimnástica	34	32	31	51
9	Marino	34	33	34	49
10	Rayo	34	41	41	48
11	Coruxo	34	36	29	46
12	Langreo	34	36	38	45
13	Ourense CF	34	36	36	43
14	Palencia	34	25	32	41
15	CD Laredo	34	20	31	35
16	Burgos CF B	34	29	54	27
17	CD Lugo B	34	30	47	26
18	Bergantiños	34	33	54	22

TEMPORADA 2021/2022

TERCERA FEDERACIÓN GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	Guijuelo	32	61	16	75
2	SD Almazán	32	51	28	64
3	Real Ávila	32	45	25	58
4	Mirandés B	32	36	24	55
5	Atlético	32	37	28	54
6	Júpiter	32	55	37	54
7	Arandina	32	39	22	53
8	Palencia CF	32	45	36	47
9	Atl. Astorga	32	33	37	42
10	Atl.	32	32	40	40
11	Virgen	32	28	34	39
12	Numancia B	32	40	48	36
13	Santa Marta	32	37	49	35
14	Ribert	32	34	49	32
15	Salamanca	32	22	51	30
16	Ciudad	32	29	65	20
17	DiocesÁvila	32	21	56	19

TEMPORADA 2020/2021

SEGUNDA DIVISIÓN B GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Celta	18	22	20	30
2	Unionistas	18	17	10	30
3	Zamora	18	18	17	30
4	Deportivo	18	14	10	29
5	Racing	18	22	17	27
6	Compostela	18	20	16	25
7	Pontevedra	18	19	19	21
8	Coruxo	18	16	23	20
9	Salamanca	18	17	23	19
10	Guijuelo	18	12	22	12
11	Burgos	18	24	12	39
12	Cultural	18	27	15	31
13	Real	18	24	17	30
14	Numancia	18	23	14	25
15	Langreo	18	21	20	25
16	Marino	18	18	22	22
17	Real Oviedo	18	17	27	21
18	Lealtad	18	11	14	20
19	Sporting	18	16	24	16
20	Covadonga	18	21	37	14

TEMPORADA 2019/2020

SEGUNDA DIVISIÓN B GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Logroñés	28	49	19	62
2	Cultural	28	45	28	49
3	Bilbao Ath.	28	55	35	49
4	Real	28	43	28	47
5	Real	28	47	35	44
6	Amorebieta	28	38	38	42
7	Osasuna	28	35	35	40
8	Burgos	28	31	37	39
9	Guijuelo	28	30	26	37
10	Haro	28	29	33	36
11	Deportivo	28	28	31	34
12	Calahorra	28	28	32	34
13	Salamanca	28	30	39	34
14	Barakaldo	28	33	42	32
15	Leioa	28	35	38	31
16	Unionistas	28	39	43	31
17	Real Unión	28	29	33	29
18	Arenas Getxo	28	27	43	28
19	Izarra	28	29	47	28
20	Tudelano	28	26	44	24

TEMPORADA 2018/2019

SEGUNDA DIVISIÓN B GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Fuenlabrada	38	49	21	71
2	Ponferradina	38	55	27	69
3	Atlético B	38	57	32	68
4	RM Castilla	38	62	45	65
5	Cultural	38	56	34	65
6	Pontevedra	38	45	38	62
7	Guijuelo	38	35	33	59
8	UD Sanse	38	54	45	56
9	Unionistas	38	39	37	52
10	Coruxo	38	38	41	50
11	Real	38	33	40	49
12	Salamanca	38	40	42	49
13	Burgos	38	28	32	48
14	Internaciona	38	47	54	48
15	Palmas	38	26	33	48
16	Celta	38	45	48	46
17	Rápido	38	28	55	38
18	Unión	38	42	62	36
19	Navalcarnero	38	37	70	25
20	Deportivo	38	28	55	24

TEMPORADA 2017/2018

SEGUNDA DIVISIÓN B GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Rayo	38	60	35	70
2	Deportivo	38	46	28	69
3	Fuenlabrada	38	56	31	65
4	Celta	38	44	32	63
5	Rápido	38	39	28	61
6	Navalcarnero	38	44	40	61
7	CF Talavera	38	40	46	56
8	RM Castilla	38	53	37	55
9	Atlético B	38	43	46	51
10	UD Sanse	38	45	46	51
11	Unión	38	43	46	51
12	Ponferradina	38	53	50	48
13	Guijuelo	38	34	34	45
14	Pontevedra	38	45	46	45
15	Real	38	41	48	44
16	Coruxo	38	37	57	43
17	CD Toledo	38	45	50	41
18	Racing	38	38	53	40
19	Gimnástica	38	33	50	39
20	CCD Cerceda	38	26	62	25

TEMPORADA 2016/2017

SEGUNDA DIVISIÓN B GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Cultural	38	86	28	86
2	Racing	38	64	20	86
3	Celta	38	76	31	84
4	Pontevedra	38	48	36	60
5	Ponferradina	38	35	40	55
6	Real	38	40	42	54
7	Racing	38	50	38	54
8	Coruxo	38	43	58	49
9	Tudelano	38	32	34	49
10	Lealtad	38	38	39	48
11	Osasuna	38	48	53	47
12	Guijuelo	38	57	49	47
13	Izarra	38	37	45	46
14	Boiro	38	39	45	45
15	Caudal	38	47	56	45
16	Burgos	38	43	54	45
17	Mutilvera	38	32	46	43
18	Palencia	38	26	60	38
19	Arandina	38	39	64	32
20	Somozas	38	23	65	24

TEMPORADA 2015/2016

SEGUNDA DIVISIÓN B GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Racing	38	56	28	74
2	Racing	38	60	28	73
3	Tudelano	38	48	23	72
4	Logroñés	38	50	28	66
5	Burgos	38	47	39	58
6	Guijuelo	38	35	35	57
7	Cultural	38	39	32	56
8	Somozas	38	41	38	55
9	Pontevedra	38	38	37	54
10	Lealtad	38	50	44	50
11	Celta	38	47	55	50
12	Izarra	38	35	37	50
13	Real	38	42	49	48
14	Coruxo	38	49	51	46
15	Arandina	38	43	61	45
16	Cacereño	38	33	45	43
17	Sporting	38	34	52	42
18	Atl. Astorga	38	44	55	40
19	Compostela	38	29	42	38
20	Peña Sport	38	29	70	26

TEMPORADA 2014/2015

SEGUNDA DIVISIÓN B GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Real Oviedo	38	77	31	80
2	Real Murcia	38	47	26	72
3	Racing	38	65	41	69
4	Logroñés	38	49	37	66
5	Guijuelo	38	58	48	61
6	Compostela	38	45	39	61
7	Cultural	38	52	43	59
8	Coruxo	38	44	47	53
9	Real	38	54	54	52
10	Somozas	38	44	43	52
11	Sporting	38	49	50	50
12	Burgos	38	37	40	49
13	Celta	38	49	58	48
14	Atl. Astorga	38	50	56	45
15	Lealtad	38	38	49	44
16	Real Avilés	38	36	53	43
17	Langreo	38	37	49	43
18	Zamora	38	38	51	39
19	Tropezón	38	38	62	36
20	Marino	38	26	56	21

TEMPORADA 2013/2014

SEGUNDA DIVISIÓN B GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Racing	36	55	27	66
2	Racing	36	58	35	63
3	Real Avilés	36	53	31	63
4	Guijuelo	36	49	31	60
5	Real Oviedo	36	52	42	57
6	Marino	36	50	34	54
7	Zamora	36	43	40	54
8	Sporting	36	52	50	50
9	CD Ourense	36	36	34	50
10	Burgos	36	38	44	46
11	Logroñés	36	33	45	46
12	Tropezón	36	38	55	44
13	Compostela	36	53	46	44
14	Cultural	36	39	43	44
15	Coruxo	36	38	47	44
16	Caudal	36	41	50	39
17	Logroñés	36	36	52	38
18	Celta	36	37	61	34
19	Noja	36	36	70	24

TEMPORADA 2012/2013

SEGUNDA DIVISIÓN B GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Tenerife	38	62	28	73
2	Leganés	38	57	35	70
3	Real Oviedo	38	53	33	66
4	Caudal	38	49	37	60
5	Real Madrid	38	59	42	57
6	Fuenlabrada	38	55	45	56
7	Atlético B	38	56	49	54
8	Salamanca	38	59	48	53
9	Coruxo	38	38	45	52
10	Getafe B	38	39	37	48
11	Marino	38	40	51	47
12	CD Ourense	38	42	46	47
13	Sporting	38	44	47	47
14	Real Avilés	38	43	54	46
15	Guijuelo	38	34	50	45
16	Zamora	38	42	50	43
17	UD Sanse	38	35	48	43
18	RSD Alcalá	38	27	44	41
19	Rayo	38	38	57	36
20	Marino	38	36	62	35

TEMPORADA 2011/2012

SEGUNDA DIVISIÓN B GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Mirandés	38	55	22	82
2	Ponferradina	38	65	34	74
3	Eibar	38	46	35	66
4	Amorebieta	38	50	35	62
5	Logroñés	38	52	38	60
6	Deportivo	38	64	39	59
7	Guijuelo	38	45	44	58
8	Bilbao Ath.	38	47	39	55
9	Salamanca	38	50	48	52
10	Sestao River	38	52	52	51
11	Zamora	38	41	37	49
12	Real	38	50	52	48
13	Osasuna	38	49	56	48
14	Real Unión	38	45	43	48
15	Gimnástica	38	39	50	46
16	Palencia	38	32	46	46
17	Arandina	38	38	52	39
18	Gimnástica	38	40	70	30
19	Lemona	38	26	60	29
20	Burgos	38	29	63	28

TEMPORADA 2010/2011

SEGUNDA DIVISIÓN B GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Eibar	38	58	32	73
2	Mirandés	38	52	24	72
3	Deportivo	38	63	43	66
4	Real Unión	38	51	35	65
5	Palencia	38	44	28	63
6	Logroñés	38	44	32	63
7	Osasuna	38	49	39	58
8	Real Oviedo	38	45	34	58
9	Lemona	38	42	38	53
10	Gimnástica	38	34	41	52
11	Real	38	34	37	51
12	Bilbao Ath.	38	29	37	46
13	Zamora	38	46	56	43
14	Cultural	38	42	48	43
15	Guijuelo	38	39	44	39
16	Caudal	38	29	38	38
17	La Muela	38	36	56	38
18	Peña Sport	38	30	56	36
19	Sporting	38	26	54	34
20	Barakaldo	38	27	48	24

TEMPORADA 2009/2010

SEGUNDA DIVISIÓN B GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Ponferradina	38	44	21	75
2	Eibar	38	45	34	66
3	Palencia	38	46	27	65
4	Pontevedra	38	48	37	63
5	Deportivo	38	45	31	62
6	Lemona	38	51	42	53
7	CD Lugo	38	49	41	53
8	Osasuna	38	38	43	52
9	Celta	38	53	61	51
10	Cultural	38	46	49	49
11	Barakaldo	38	40	43	49
12	Mirandés	38	44	42	48
13	Montañeros	38	46	51	47
14	Zamora	38	39	51	46
15	Bilbao Ath.	38	35	42	46
16	Guijuelo	38	38	36	45
17	Sestao River	38	32	40	44
18	Izarra	38	41	50	39
19	Racing	38	31	43	37
20	Compostela	38	38	65	30

TEMPORADA 2008/2009

SEGUNDA DIVISIÓN B GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Real Unión	38	57	25	75
2	Cultural	38	45	23	70
3	Ponferradina	38	54	41	63
4	Zamora	38	47	34	61
5	Celta	38	42	26	58
6	Lemona	38	31	31	58
7	Racing	38	43	44	56
8	CD Lugo	38	57	48	55
9	Guijuelo	38	45	37	53
10	Barakaldo	38	35	39	53
11	Bilbao Ath.	38	48	43	52
12	Pontevedra	38	50	49	51
13	Ciudad	38	42	42	50
14	Rayo	38	38	47	47
15	Sestao River	38	37	41	46
16	Sporting	38	46	55	45
17	Deportivo	38	40	53	39
18	Real	38	29	43	39
19	Real	38	32	61	36
20	Marino	38	22	58	33

TEMPORADA 2007/2008

SEGUNDA DIVISIÓN B GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Ponferradina	38	52	28	67
2	Huesca	38	45	27	67
3	Barakaldo	38	45	34	63
4	Zamora	38	43	38	63
5	Real Unión	38	48	34	62
6	Conquense	38	54	44	61
7	Lemona	38	42	34	60
8	Guadalajara	38	45	49	58
9	Guijuelo	38	42	41	57
10	Sestao River	38	34	26	55
11	Cultural	38	49	44	52
12	Real	38	40	38	50
13	Logroñés	38	40	46	47
14	Real	38	37	48	44
15	Bilbao Ath.	38	40	50	42
16	Logroñes	38	37	40	40
17	Burgos	38	30	39	40
18	Osasuna	38	25	37	40
19	Palencia	38	30	46	39
20	Peña Sport	38	31	66	23

TEMPORADA 2006/2007

SEGUNDA DIVISIÓN B GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Eibar	38	51	26	71
2	Burgos	38	51	24	69
3	Palencia	38	38	29	65
4	Real Unión	38	43	26	65
5	Sestao River	38	42	29	65
6	Barakaldo	38	45	26	63
7	Real	38	54	39	61
8	Lemona	38	40	28	60
9	Zamora	38	44	36	52
10	Logroñes	38	36	38	51
11	Cultural	38	37	40	51
12	Guijuelo	38	41	33	50
13	Marino	38	31	31	49
14	Logroñés	38	36	49	46
15	Bilbao Ath.	38	39	49	45
16	Real	38	31	47	43
17	CD Alfaro	38	41	55	41
18	Universidad	38	34	68	36
19	Real Oviedo	38	27	47	32
20	Amurrio	38	19	60	19

TEMPORADA 2005/2006

TERCERA DIVISIÓN GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	Gimnástica	38	89	16	97
2	Mirandés	38	76	20	89
3	Guijuelo	38	76	33	83
4	Huracán	38	66	31	78
5	Atl.	38	68	38	69
6	Norma	38	52	42	63
7	Real Ávila	38	52	46	61
8	Júpiter	38	49	48	54
9	Arandina	38	52	38	53
10	Salamanca B	38	53	51	51
11	Numancia B	38	53	63	49
12	Hullera	38	44	61	48
13	Iscar	38	37	40	45
14	Universidad	38	39	63	39
15	Becerril	38	47	65	38
16	La Bañeza	38	30	54	37
17	Benavente	38	39	66	35
18	Atlético	38	42	83	31
19	Cebrereña	38	32	75	20
20	SD Almazán	38	25	88	18

TEMPORADA 2004/2005

SEGUNDA DIVISIÓN B GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Ponferradina	38	43	28	69
2	Real Unión	38	47	27	68
3	Burgos	38	44	24	63
4	Zamora	38	39	30	62
5	Real	38	38	30	61
6	Logroñes	38	35	37	61
7	Barakaldo	38	41	32	59
8	Cultural	38	53	37	58
9	Lemona	38	34	26	58
10	Bilbao Ath.	38	53	43	57
11	Amurrio	38	33	25	51
12	Deportivo	38	39	34	49
13	Palencia	38	40	41	45
14	CD Alfaro	38	42	53	43
15	Marino	38	39	48	42
16	Mirandés	38	26	35	42
17	Guijuelo	38	37	48	39
18	Sestao River	38	34	54	32
19	Gimnástica	38	29	58	32
20	Haro	38	18	54	22

Competiciones que juega

Segunda Federación Grupo 1

Pos	Equipos		Pts
1		Ourense CF	70
2		Pontevedra	65
3		Zamora	60
4		Guijuelo	51
5		Rayo Cantabria	48
6		Langreo	47
7		SD Compostela	47
8		Real Valladolid Promesas	44
9		Coruxo	42
10		Deportivo Fabril	41
11		Real Avilés Industrial	41
12		Gimnástica Torrelavega	40
13		Marino de Luanco	39
14		RC Villalbés	37
15		Arandina	34
16		Real Oviedo Vetusta	30
17		Cayón	30
18		CD Covadonga	29

	Ascenso : Ourense CF
	Playoff Ascenso : Pontevedra, Zamora, Guijuelo, Rayo Cantabria
	Playoff Descenso : Marino de Luanco
	Descenso : RC Villalbés, Arandina, Real Oviedo Vetusta, Cayón, CD Covadonga

RIVALES EN Copa del Rey

RIVALES EN Segunda Federaci.

USO DE MEMORIA

8,705,168 bytes

BENCHMARKS

Loading Time Base Classes	0.0013
Controller Execution Time ( Home / Category )	7.7953
Total Execution Time	7.7966

CADENA URL

/historico/Guijuelo

GET DATOS

$_GET['/historico/Guijuelo']

POST DATOS

No hay datos POST existentes

CONSULTAS (30)

0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1271 AND type_rel = 2
0.2656	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1271 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.1893	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 (1090,2598,2826,3254,3963) ORDER BY n.cover_points DESC, update_date DESC
0.6088	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 = '1271' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.4125	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=1271 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0220	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 (75887,72362,71759,71432) 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.4073	SELECT count(id) as num_players from rel_players WHERE league_id = 72362 AND teamId = 1271
1.2372	SELECT count(id) as num_players from rel_players WHERE league_id = 71759 AND teamId = 1271
0.1263	SELECT count(id) as num_players from rel_players WHERE league_id = 75887 AND teamId = 1271
0.4351	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 1271
0.4318	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 = 72362 WHERE rp.league_id = 72362 AND rp.teamId = 1271 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.4598	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 = 72362 WHERE rp.league_id = 72362 AND rp.teamId = 1271 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.3424	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 = 72362 WHERE rp.league_id = 72362 AND rp.teamId = 1271 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.2854	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 = 1271 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.1101	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 = 67965 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.1738	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 = 58608 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.1455	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 = 50266 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.1513	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 = 44080 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.1724	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 = 38806 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.1550	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 = 33378 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0970	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 = 15375 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.2155	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 = 3865 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.1610	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 = 2466 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.2084	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 = 1102 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.1683	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 = 826 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.1342	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 = 127 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.2448	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 = 5 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.1644	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 = 83 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0866	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 = 22120 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.1150	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 = 173 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Guijuelo

Guijuelo

Selecciona un equipo

Competiciones que juega

Segunda Federación Grupo 1

RIVALES EN Copa del Rey

RIVALES EN Segunda Federaci.

RIVALES EN Segunda Federaci.