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

AD San Juan

Entrenador: Julen Foncillas

Temporada 2023/2024

TEMPORADA 2023/2024

SEGUNDA FEDERACIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Bilbao Ath.	34	68	17	82
2	Barakaldo	34	61	19	76
3	Logroñés	34	70	17	71
4	Utebo	34	40	31	61
5	Deportivo	34	51	40	56
6	Deportivo	34	57	42	52
7	Tudelano	34	45	32	48
8	Barbastro	34	28	28	47
9	Real	34	35	37	47
10	Calahorra	34	36	38	46
11	SD Gernika	34	37	48	43
12	Arenas Getxo	34	35	37	41
13	Izarra	34	32	51	36
14	AD San Juan	34	29	47	33
15	Mutilvera	34	21	50	33
16	Náxara	34	23	59	24
17	Valle	34	24	58	21
18	Brea	34	15	56	21

TEMPORADA 2022/2023

SEGUNDA FEDERACIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Sestao River	34	55	17	72
2	Deportivo	34	40	23	59
3	SD Tarazona	34	60	37	56
4	Utebo	34	39	32	53
5	SD Gernika	34	41	31	53
6	Tudelano	34	39	32	52
7	Real	34	46	42	52
8	AD San Juan	34	33	27	51
9	Arenas Getxo	34	39	42	48
10	Izarra	34	39	31	48
11	Mutilvera	34	44	37	46
12	Brea	34	27	33	44
13	Beasain KE	34	40	40	41
14	Cirbonero	34	35	40	40
15	CD Alfaro	34	35	54	34
16	Logroñés	34	27	54	32
17	Racing Rioja	34	27	57	32
18	Arnedo	34	28	65	24

TEMPORADA 2021/2022

SEGUNDA FEDERACIÓN GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Osasuna	34	72	29	72
2	Sestao River	34	53	22	70
3	Real	34	55	30	59
4	Rayo	34	42	29	56
5	Arenas Getxo	34	42	25	56
6	AD San Juan	34	47	39	51
7	Racing Rioja	34	43	39	50
8	SD Gernika	34	50	42	49
9	Burgos CF B	34	42	33	48
10	Izarra	34	33	34	45
11	Mutilvera	34	42	45	45
12	Logroñés	34	45	39	45
13	CD Laredo	34	41	36	45
14	Cayón	34	26	60	33
15	Tropezón	34	40	68	27
16	Náxara	34	27	53	26
17	CF Ardoi	34	29	61	25
18	Peña Sport	34	31	76	18

TEMPORADA 2020/2021

TERCERA DIVISIÓN GRUPO 15
Equipo		PJ	GF	GC	Puntos
1	AD San Juan	20	21	9	35
2	Beti Kozkor	20	23	18	33
3	Valle	20	31	23	32
4	Itaroa	20	29	23	30
5	CD Pamplona	20	28	18	30
6	Burladés	20	22	30	26
7	Beti Onak	20	26	25	24
8	Corellano	20	24	29	24
9	Txantrea	20	23	29	23
10	Subiza	20	25	28	21
11	River Ega	20	23	43	14
12	Peña Sport	20	32	14	47
13	Cirbonero	20	35	21	32
14	CF Ardoi	20	26	15	32
15	Cantolagua	20	28	19	31
16	CD Cortes	20	18	21	28
17	Murchante	20	19	19	24
18	Peña	20	24	33	24
19	Baztan	20	19	27	20
20	Fontellas	20	18	37	20
21	Lourdes	20	18	26	19
22	Bidezarra	20	18	23	19

TEMPORADA 2019/2020

TERCERA DIVISIÓN GRUPO 15
Equipo		PJ	GF	GC	Puntos
1	Mutilvera	27	57	27	58
2	AD San Juan	27	49	23	55
3	Beti Kozkor	27	42	27	52
4	CD Pamplona	27	36	18	50
5	Itaroa	27	40	26	47
6	Peña Sport	27	44	35	45
7	Cirbonero	27	52	38	44
8	Txantrea	27	45	34	41
9	Burladés	27	31	34	37
10	Valle	27	45	41	35
11	Beti Onak	27	32	38	35
12	CD Cortes	27	27	23	32
13	Corellano	27	29	42	32
14	Murchante	27	27	30	31
15	Lourdes	27	28	37	30
16	CF Ardoi	27	29	39	30
17	Peña	27	39	53	25
18	Subiza	27	34	49	24
19	Baztan	27	30	57	19
20	Fontellas	27	16	61	13

TEMPORADA 2018/2019

TERCERA DIVISIÓN GRUPO 15
Equipo		PJ	GF	GC	Puntos
1	Osasuna	38	89	20	92
2	Peña Sport	38	99	35	88
3	Mutilvera	38	69	31	81
4	Beti Kozkor	38	58	32	71
5	CD Cortes	38	49	43	62
6	AD San Juan	38	55	36	56
7	Cirbonero	38	49	38	52
8	Txantrea	38	56	64	46
9	Baztan	38	65	77	46
10	Burladés	38	36	47	46
11	Itaroa	38	40	57	44
12	Beti Onak	38	41	65	43
13	CF Ardoi	38	38	48	43
14	Subiza	38	51	63	43
15	Corellano	38	35	64	41
16	Valle	38	45	55	40
17	CD Pamplona	38	44	54	39
18	Avance	38	43	59	37
19	Cantolagua	38	39	61	37
20	CD Alesves	38	39	91	28

TEMPORADA 2017/2018

TERCERA DIVISIÓN GRUPO 15
Equipo		PJ	GF	GC	Puntos
1	Mutilvera	38	77	25	90
2	AD San Juan	38	52	22	74
3	CD Iruña	38	59	28	73
4	Burladés	38	51	28	65
5	Cirbonero	38	58	39	63
6	CD Pamplona	38	44	41	54
7	Txantrea	38	50	41	53
8	CF Ardoi	38	51	57	51
9	CD Cortes	38	36	39	50
10	Beti Kozkor	38	40	45	49
11	Valle	38	48	48	48
12	Baztan	38	50	68	47
13	Subiza	38	53	57	46
14	Cantolagua	38	41	56	46
15	Itaroa	38	39	47	45
16	Corellano	38	36	53	43
17	Oberena	38	37	56	43
18	Idoya	38	37	61	32
19	River Ega	38	45	67	32
20	Gares	38	28	54	31

TEMPORADA 2016/2017

TERCERA DIVISIÓN GRUPO 15
Equipo		PJ	GF	GC	Puntos
1	Peña Sport	38	73	35	82
2	CD Iruña	38	66	32	79
3	Cirbonero	38	65	30	77
4	CD Cortes	38	51	35	64
5	Oberena	38	54	45	63
6	AD San Juan	38	60	42	62
7	Burladés	38	51	50	59
8	Idoya	38	51	47	57
9	Itaroa	38	39	36	52
10	Txantrea	38	63	56	52
11	Subiza	38	65	62	50
12	Cantolagua	38	44	47	49
13	Valle	38	51	49	45
14	River Ega	38	52	77	45
15	CD Pamplona	38	47	52	44
16	Corellano	38	49	56	44
17	CF Ardoi	38	39	46	44
18	Lourdes	38	37	56	40
19	Erriberri	38	27	69	29
20	Valtierrano	38	30	92	14

TEMPORADA 2015/2016

TERCERA DIVISIÓN GRUPO 15
Equipo		PJ	GF	GC	Puntos
1	Osasuna	38	81	24	84
2	Cirbonero	38	67	32	80
3	AD San Juan	38	65	31	77
4	Mutilvera	38	80	35	76
5	CD Cortes	38	48	30	73
6	CF Ardoi	38	68	40	65
7	Valle	38	55	52	55
8	Burladés	38	47	43	50
9	River Ega	38	48	58	50
10	Subiza	38	57	62	49
11	Txantrea	38	70	66	48
12	CD Pamplona	38	50	49	47
13	Cantolagua	38	40	54	44
14	CD Iruña	38	51	57	44
15	Erriberri	38	23	53	42
16	Itaroa	38	39	52	39
17	Oberena	38	38	66	37
18	Baztan	38	53	97	32
19	Beti Onak	38	42	82	28
20	Mendi	38	34	73	24

TEMPORADA 2014/2015

TERCERA DIVISIÓN GRUPO 15
Equipo		PJ	GF	GC	Puntos
1	Peña Sport	36	68	29	85
2	AD San Juan	36	49	15	75
3	Osasuna	38	64	31	72
4	Izarra	36	65	31	70
5	Mutilvera	36	62	38	63
6	CD Cortes	36	47	42	57
7	Oberena	36	50	41	56
8	Burladés	36	43	33	56
9	Itaroa	36	49	43	53
10	Txantrea	36	56	52	50
11	Cirbonero	36	42	43	46
12	Valle	36	63	62	45
13	CF Ardoi	36	38	49	41
14	Subiza	36	49	73	38
15	CD Pamplona	36	39	55	37
16	Beti Onak	36	38	57	37
17	Idoya	36	33	68	33
18	Valtierrano	36	31	73	23
19	Corellano	36	25	74	17
20	CD Iruña	2	2	4	0

TEMPORADA 2013/2014

TERCERA DIVISIÓN GRUPO 15
Equipo		PJ	GF	GC	Puntos
1	Izarra	38	59	16	85
2	AD San Juan	38	57	14	85
3	Mutilvera	38	57	26	75
4	Osasuna	38	76	32	75
5	Txantrea	38	56	36	66
6	Valle	38	60	49	62
7	CD Cortes	38	44	43	52
8	Oberena	38	45	49	50
9	CD Iruña	38	44	48	48
10	Cirbonero	38	47	50	46
11	Itaroa	38	41	44	46
12	Burladés	38	37	41	46
13	CD Pamplona	38	51	57	46
14	Corellano	38	47	57	42
15	Beti Onak	38	50	59	42
16	Valtierrano	38	42	64	42
17	Lagun Artea	38	48	62	41
18	Murchante	38	34	62	36
19	Erriberri	38	31	64	32
20	Artajonés	38	25	78	23

TEMPORADA 2012/2013

TERCERA DIVISIÓN GRUPO 15
Equipo		PJ	GF	GC	Puntos
1	AD San Juan	38	53	16	80
2	Mutilvera	38	77	28	78
3	CD Iruña	38	67	44	69
4	CD Cortes	38	50	41	66
5	Cirbonero	38	70	39	65
6	Txantrea	38	51	31	65
7	Cd Huarte	38	58	49	58
8	Burladés	38	47	38	55
9	Murchante	38	39	39	55
10	Cd Oberena	38	48	51	53
11	Cd Pamplona	38	45	48	48
12	Valle	38	47	50	47
13	Erriberri	38	42	52	45
14	Lagun Artea	38	32	48	43
15	Valtierrano	38	41	52	42
16	Idoya	38	34	55	41
17	Subiza	38	51	75	40
18	Aoiz	38	40	62	39
19	Peña	38	39	66	31
20	Lagunak	38	19	66	21

TEMPORADA 2011/2012

TERCERA DIVISIÓN GRUPO 15
Equipo		PJ	GF	GC	Puntos
1	Peña Sport	38	88	35	92
2	Izarra	38	104	33	90
3	Tudelano	38	97	26	88
4	Mutilvera	38	71	32	80
5	AD San Juan	38	50	36	66
6	Txantrea	38	54	38	60
7	Murchante	38	61	64	54
8	Cirbonero	38	57	53	53
9	CD Iruña	38	53	53	52
10	CD Pamplona	38	47	65	43
11	Oberena	38	48	61	42
12	Itaroa	38	54	60	41
13	Valle	38	43	60	41
14	Idoya	38	36	61	39
15	Burladés	38	40	48	38
16	Aoiz	38	49	74	38
17	CD Cortes	38	33	63	37
18	Lourdes	38	39	77	33
19	Azkoyen	38	34	65	32
20	Aluvión	38	33	87	21

TEMPORADA 2010/2011

TERCERA DIVISIÓN GRUPO 15
Equipo		PJ	GF	GC	Puntos
1	Tudelano	38	87	24	90
2	Nivel	38	78	24	83
3	Valle	38	57	45	67
4	Mutilvera	38	60	34	66
5	Txantrea	38	57	35	65
6	CD Iruña	38	52	36	59
7	AD San Juan	38	38	30	56
8	Cirbonero	38	51	46	53
9	Lourdes	38	52	57	53
10	Oberena	38	40	39	52
11	CD Pamplona	38	51	49	49
12	Murchante	38	50	57	45
13	Itaroa	38	45	48	44
14	Aoiz	38	37	49	42
15	Aluvión	38	34	44	41
16	Idoya	38	51	77	41
17	CF Ardoi	38	29	57	38
18	Lagun Artea	38	38	80	37
19	River Ega	38	26	73	27
20	Peña	38	34	63	25

TEMPORADA 2009/2010

TERCERA DIVISIÓN GRUPO 15
Equipo		PJ	GF	GC	Puntos
1	Tudelano	38	87	29	89
2	Peña Sport	38	87	27	82
3	Cirbonero	38	57	38	71
4	CD Iruña	38	58	35	69
5	Mutilvera	38	69	46	65
6	AD San Juan	38	50	36	58
7	Valle	38	51	43	57
8	Txantrea	38	40	38	52
9	Lourdes	38	67	64	52
10	Oberena	38	62	49	49
11	CD Pamplona	38	33	45	48
12	Aoiz	38	36	39	48
13	Aluvión	38	44	61	44
14	River Ega	38	33	38	41
15	Peña	38	44	61	41
16	Murchante	38	29	50	40
17	Itaroa	38	38	59	39
18	Valtierrano	38	34	91	36
19	Zarramonza	38	28	58	34
20	CD Cortes	38	25	65	23

TEMPORADA 2008/2009

TERCERA DIVISIÓN GRUPO 15
Equipo		PJ	GF	GC	Puntos
1	Izarra	36	75	27	82
2	Peña Sport	36	72	31	79
3	Tudelano	36	65	32	69
4	Mutilvera	37	61	36	67
5	AD San Juan	36	61	39	63
6	CD Iruña	36	55	39	60
7	Cirbonero	37	44	40	54
8	Valle	36	50	46	51
9	Itaroa	36	44	37	48
10	River Ega	36	41	54	46
11	Lourdes	36	42	52	46
12	Aoiz	37	42	47	45
13	Oberena	36	48	58	44
14	Txantrea	36	42	46	43
15	Aluvión	36	48	67	41
16	Murchante	36	34	52	39
17	Idoya	36	38	53	39
18	Peña	37	46	72	38
19	CF Ardoi	36	44	54	36
20	Lagunak	36	32	63	31
21	Mendi	36	29	68	23

TEMPORADA 2007/2008

TERCERA DIVISIÓN GRUPO 15
Equipo		PJ	GF	GC	Puntos
1	Izarra	38	63	32	81
2	Mutilvera	38	57	42	74
3	CD Iruña	38	70	34	74
4	Tudelano	38	64	35	70
5	AD San Juan	38	58	33	69
6	Valle	38	53	33	67
7	Aluvión	38	55	35	65
8	Murchante	38	44	37	55
9	Txantrea	38	43	45	55
10	Lourdes	38	58	51	54
11	Aoiz	38	40	34	52
12	Oberena	38	42	57	46
13	River Ega	38	48	56	46
14	Cirbonero	38	43	50	46
15	CF Ardoi	38	46	66	40
16	Itaroa	38	40	60	34
17	Idoya	38	42	62	31
18	Artajonés	38	44	66	30
19	Zarramonza	38	34	78	29
20	Burladés	38	26	64	29

TEMPORADA 2005/2006

TERCERA DIVISIÓN GRUPO 15
Equipo		PJ	GF	GC	Puntos
1	Peña Sport	36	72	35	78
2	Valle	36	70	31	71
3	Itaroa	36	59	35	69
4	CD Iruña	36	75	49	69
5	Oberena	36	57	29	66
6	Mutilvera	36	43	33	56
7	Aluvión	36	44	48	49
8	Tudelano	36	39	39	49
9	Burladés	36	47	51	46
10	Txantrea	36	38	41	45
11	Aoiz	36	44	49	44
12	Murchante	36	34	42	43
13	Cirbonero	36	52	64	41
14	Lourdes	36	39	59	39
15	River Ega	36	44	57	38
16	Lagun Artea	36	43	61	38
17	Artajonés	36	36	60	36
18	Beti Onak	36	51	73	33
19	AD San Juan	36	25	56	26

TEMPORADA 1999/2000

TERCERA DIVISIÓN GRUPO 15
Equipo		PJ	GF	GC	Puntos
1	Peña Sport	38	65	27	74
2	Txantrea	38	58	32	67
3	Mirandés	38	52	43	64
4	Logroñés	38	61	44	63
5	Burladés	38	53	40	59
6	Aoiz	38	51	45	59
7	Valle	38	59	50	58
8	Tudelano	38	56	41	56
9	Azkoyen	38	45	40	52
10	Haro	38	47	55	52
11	CD Alfaro	38	53	56	50
12	River Ebro	38	50	60	49
13	Oberena	38	40	37	48
14	Agoncillo	38	41	49	48
15	Beti Onak	38	42	60	47
16	Idoya	38	65	87	47
17	Artajonés	38	37	49	44
18	AD San Juan	38	49	53	43
19	Itaroa	38	40	61	40
20	Baztan	38	32	67	21

TEMPORADA 1998/1999

TERCERA DIVISIÓN GRUPO 15
Equipo		PJ	GF	GC	Puntos
1	Peña Sport	38	78	28	83
2	Azkoyen	38	67	38	74
3	Izarra	38	54	26	68
4	Logroñés	38	55	34	66
5	Tudelano	38	53	44	59
6	Mirandés	38	54	47	58
7	Txantrea	38	45	39	56
8	Oberena	38	53	58	52
9	Burladés	38	51	51	49
10	Valle	38	47	49	49
11	Beti Onak	38	42	54	48
12	CD Alfaro	38	33	41	45
13	Aoiz	38	33	37	43
14	Haro	38	44	52	43
15	Itaroa	38	50	61	43
16	AD San Juan	38	35	36	41
17	Artajonés	38	35	53	41
18	CD Berceo	38	44	66	41
19	Murchante	38	36	57	35
20	Rápido	38	26	64	27

Competiciones que juega

Segunda Federación Grupo 2

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

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

RIVALES EN Copa Federación

RIVALES EN Segunda Federaci.

USO DE MEMORIA

8,401,856 bytes

BENCHMARKS

Loading Time Base Classes	0.0013
Controller Execution Time ( Home / Category )	0.5789
Total Execution Time	0.5802

CADENA URL

/historico/San-Juan

GET DATOS

$_GET['/historico/San-Juan']

POST DATOS

No hay datos POST existentes

CONSULTAS (38)

0.0225	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.0109	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2232 AND type_rel = 2
0.0118	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2232 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0122	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,427710,428153,428205,822157) ORDER BY n.cover_points DESC, update_date DESC
0.0135	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 = '2232' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0118	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.0134	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=2232 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0112	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 (74091,72363,71432,69563) 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.0112	SELECT count(id) as num_players from rel_players WHERE league_id = 72363 AND teamId = 2232
0.0118	SELECT count(id) as num_players from rel_players WHERE league_id = 69563 AND teamId = 2232
0.0125	SELECT count(id) as num_players from rel_players WHERE league_id = 74091 AND teamId = 2232
0.0125	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 2232
0.0116	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 = '2232' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0109	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '2232' and rp.type = 4
0.0111	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 = '2232' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0137	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 = 2232 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.0141	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 = 2232 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0136	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 = 2232 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0118	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 = 2232 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0122	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 = 67966 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.0119	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 = 62381 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.0123	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 = 58594 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.0118	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 = 50283 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.0119	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 = 44403 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132	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 = 39039 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 33365 AND t.round = 38 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* `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 = 15457 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112	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 = 3924 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113	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 = 2564 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0115	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 = 1956 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113	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 = 1449 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111	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 = 1135 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111	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 = 842 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112	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 = 145 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112	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 = 22 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0114	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 = 22127 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0119	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* `tables2000` 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 = 22028 AND t.round = 38 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* `tables1999` 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 = 22012 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

AD San Juan

AD San Juan

Selecciona un equipo

Competiciones que juega

Segunda Federación Grupo 2

RIVALES EN Copa Federación

RIVALES EN Segunda Federaci.