Has elegido rechazar las cookies basadas en consentimiento que utilizamos principalmente para gestionar la publicidad y las recomendaciones de contenido.

En adelante, para aceder a nuestra web tienes que elegir alguna de las siguientes opciones.

Has cambiado de idea y quieres
NAVEGAR GRATIS Y CON PUBLICIDAD...

Navega por besoccer.com y resultados-futbol.com con publicidad personalizada, seguimiento y cookies de forma gratuita.

Optar por esta opción te permitirá mantener tu experiencia de navegación como hasta ahora. Al aceptar las cookies y tecnologías similares, estás dando tu consentimiento para que recopilemos y utilicemos tu información de navegación con el propósito de adaptar la publicidad y la personalización según tus intereses. La presencia de esta publicidad es crucial para continuar proporcionando contenido de calidad, sevicios eficientes a los usuarios y mejorar la experiencia general de uso.

Nosotros y nuestros socios hacemos el siguiente tratamiento de datos: almacenamiento y acceso a información de geolocalización con propósitos de publicidad dirigida, almacenamiento y acceso a información de geolocalización para realizar estudios de mercado, almacenar o acceder a información en un dispositivo, analizar activamente las características del dispositivo para su identificación, compartir tus análisis de navegación y grupos de interés con terceros, crear un perfil para la personalización de contenidos, crear un perfil publicitario personalizado, desarrollar y mejorar productos, enriquecer el perfil con información de terceros, medir el rendimiento de los anuncios, medir el rendimiento del contenido, seleccionar anuncios básicos, seleccionar anuncios personalizados, seleccionar contenido personalizado, utilizar datos de localización geográfica precisa, utilizar estudios de mercado a fin de generar información sobre el público.

Aceptar y continuar gratis

...O sigues prefiriendo rechazar las cookies y entonces
CONTINÚA REGISTRÁNDOTE Y SUSCRIBIÉNDOTE

Navega por besoccer.com y resultados-futbol.com sin publicidad ni seguimiento suscribiéndote a nuestra web por 0,50 € al día.

Además de abonar la suscripción, es necesario realizar un registro previo para acceder. El mismo perfil de usuario es compartido entre los sitios besoccer.com y resultados-futbol.com

Accede por 0,50 € al día

Para saber más, consulta nuestra Política de Cookies.

Sitios
- Twitter
Notificaciones 0
Amigos 0
Actividad

No hay actividad de la comunidad para mostrarte.

4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

Resultados de Fútbol

AD San Juan FS

Temporada 2023/2024

TEMPORADA 2023/2024

SEGUNDA DIVISIÓN B FUTSAL GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Tauste FS	28	116	72	62
2	Otxartabe	28	122	81	61
3	Lauburu	28	120	89	53
4	CD Tafa FS	28	123	96	53
5	Zierbena	28	103	101	50
6	Pinseque AD	28	118	103	46
7	Alcorcón	28	115	108	41
8	Colo Colo	28	97	99	40
9	Anaitasuna	28	95	93	39
10	Cristóbal	28	128	120	38
11	Juv. Circulo	28	94	106	37
12	Juan	28	90	101	35
13	AD Quel	28	109	119	30
14	Ribera	28	109	154	19
15	Laskorain	28	81	115	16
16	Villa	28	73	136	11

TEMPORADA 2022/2023

SEGUNDA DIVISIÓN B FUTSAL GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Anaitasuna	30	141	84	72
2	Otxartabe	30	155	97	68
3	Pinseque AD	30	165	112	67
4	Lauburu	30	102	64	59
5	Zierbena	30	118	105	56
6	Juan	30	119	96	48
7	CD Tafa FS	30	101	106	46
8	Colo Colo	30	117	116	41
9	Futsala	30	124	122	38
10	AD Quel	30	122	153	36
11	Ribera	30	115	130	35
12	ED Brunete	30	97	134	33
13	Almonacid	30	119	144	28
14	FS Albelda	30	77	120	28
15	Ibararte FS	30	75	118	21
16	AF Antxo	30	108	154	13

TEMPORADA 2021/2022

SEGUNDA DIVISIÓN B FUTSAL GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	CD Tafa FS	30	137	57	79
2	Pinseque AD	30	143	100	66
3	Otxartabe	30	132	87	53
4	Juan	30	111	81	53
5	Zierbena	30	100	86	51
6	Sala 2012	30	108	92	47
7	Dehesa	30	116	138	43
8	Anaitasuna	30	93	103	41
9	Lauburu	30	98	100	37
10	Colo Colo	30	105	121	37
11	Ibararte FS	30	80	97	37
12	Juv. Circulo	30	93	108	36
13	AD Quel	30	108	115	34
14	Mahastiak	30	85	148	23
15	Ciudad	30	74	118	21
16	Tauste FS	30	82	114	19

TEMPORADA 2020/2021

SEGUNDA DIVISIÓN B FUTSAL GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	CD Tafa FS	16	75	21	42
2	Juan	16	55	46	32
3	Ciudad	16	38	45	24
4	Pinseque AD	16	53	51	23
5	Sala 2012	16	43	45	23
6	Tauste FS	16	49	58	17
7	AD Quel	16	54	61	17
8	Ibararte FS	16	56	63	16
9	Union	16	52	85	10

TEMPORADA 2019/2020

SEGUNDA DIVISIÓN B FUTSAL GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Otxartabe	23	120	75	56
2	CD Tafa FS	23	96	56	49
3	Guardo	23	92	59	49
4	Juan	23	95	68	47
5	Ibararte FS	23	78	62	45
6	Zierbena	23	82	65	41
7	Lauburu	23	84	66	40
8	Juv. Circulo	23	90	87	33
9	Cuellar	23	96	84	25
10	Ciudad	23	87	97	25
11	Laskorain	23	63	78	23
12	Pinseque AD	23	68	100	23
13	Tauste FS	22	64	92	20
14	Kukuyaga	23	64	120	18
15	Sala 2012	23	50	68	17
16	Castro	22	53	105	11

TEMPORADA 2018/2019

SEGUNDA DIVISIÓN B FUTSAL GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Alzira FS	30	131	61	66
2	Lauburu	30	135	87	64
3	Juan	30	122	80	60
4	CD Tafa FS	30	121	79	57
5	CFS Ibi	30	143	114	55
6	Otxartabe	30	143	119	55
7	Pinseque AD	30	134	106	53
8	Zierbena	30	120	107	43
9	Ciudad	30	130	136	41
10	Juv. Circulo	30	85	113	35
11	Cuellar	30	99	111	32
12	Laskorain	30	83	115	30
13	Sala 2012	30	85	109	28
14	Sala Quinto	30	108	149	27
15	Santurtzi	30	105	177	18
16	Peña Union	30	80	161	12

TEMPORADA 2017/2018

SEGUNDA DIVISIÓN B FUTSAL GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Full	30	164	73	70
2	Juan	30	129	88	64
3	Lauburu	30	116	53	61
4	Zierbena	30	118	94	57
5	Segorbe	30	144	112	56
6	CD Tafa FS	29	108	75	51
7	Ciudad	30	128	114	47
8	Cons Jose L.	30	130	126	47
9	Santurtzi	30	145	142	43
10	Sala Quinto	30	113	121	37
11	Pinseque AD	30	149	143	36
12	Peña Union	29	107	134	32
13	Juv. Circulo	30	89	108	30
14	Nuestra	30	65	119	23
15	Elorrioko	30	90	165	22
16	Nalda	30	53	181	8

TEMPORADA 2016/2017

SEGUNDA DIVISIÓN B FUTSAL GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Full	30	170	94	68
2	Pinseque AD	30	171	95	64
3	Zierbena	30	116	70	61
4	Segor FS	30	130	109	59
5	Alza	30	115	89	50
6	Juan	30	99	100	48
7	Debabarrena	30	106	100	42
8	Lauburu	30	93	83	38
9	Sala Quinto	30	116	128	38
10	Juventud	30	95	102	37
11	CD Tafa FS	30	98	115	37
12	Nuestra	30	93	118	33
13	Santurtzi	30	108	142	32
14	Graccurris	30	100	129	26
15	Aurrera	30	89	141	24
16	Internaciona	30	62	146	15

TEMPORADA 2015/2016

SEGUNDA DIVISIÓN B FUTSAL GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Zierbena	30	152	79	77
2	Full	30	180	93	66
3	Juan	30	117	76	64
4	Pinseque AD	30	170	110	62
5	Debabarrena	30	99	93	51
6	Ebrosala	30	98	94	48
7	Lauburu	30	97	81	43
8	Sala Quinto	30	111	105	40
9	Aurrera	30	93	97	38
10	Santurtzi	30	108	132	38
11	Segor FS	30	105	106	37
12	Fuenmayor	30	107	133	37
13	CD Xota FS	30	97	111	37
14	Mahastiak	30	101	132	36
15	Villa	30	61	127	15
16	Sala Cadrete	30	53	180	5

TEMPORADA 2014/2015

SEGUNDA DIVISIÓN B FUTSAL GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Full	30	169	97	71
2	Zierbena	30	130	77	67
3	Pinseque AD	30	180	127	62
4	Debabarrena	30	115	90	61
5	Ebrosala	30	126	105	54
6	CD Xota FS	30	104	94	42
7	Juan	30	103	89	40
8	Sala Quinto	30	110	115	39
9	Lauburu	30	91	103	39
10	Fuenmayor	30	100	115	36
11	Segor FS	30	91	116	34
12	Santurtzi	30	107	125	33
13	Aurrera	30	93	132	32
14	Mahastiak	30	100	119	31
15	Ibararte FS	30	87	124	26
16	Agoncillo	30	51	129	12

TEMPORADA 2012/2013

SEGUNDA DIVISIÓN B FUTSAL GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Debabarrena	24	131	52	62
2	Zierbena	24	108	57	53
3	Zalatambor	24	97	55	52
4	Pinseque AD	24	119	79	51
5	Full	24	111	72	42
6	Juan	24	84	82	41
7	Kirol Sport	24	79	87	32
8	Atenea	24	73	89	30
9	Sala Quinto	24	69	75	26
10	Sigüenza	24	73	111	23
11	Arnedo	24	56	109	17
12	Sala	24	40	103	11
13	Maderas Alto	24	34	103	11

TEMPORADA 2011/2012

TERCERA DIVISIÓN FUTSAL GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Burlades	14	69	39	36
2	Juan	14	70	32	34
3	CD Tafa FS	14	56	39	30
4	CD Xota FS	13	42	37	18
5	Gazte	14	43	53	16
6	Jarama	14	34	46	14
7	Universidad	14	50	65	10
8	Kirol Sport	13	30	83	3

Competiciones que juega

Grupo 2

Segunda División B Futsal Grupo 2

Pos	Equipos		Pts
1		Tauste FS	62
2		Otxartabe CD	61
3		Lauburu Ke Ibarra	53
4		CD Tafa FS	53
5		Zierbena CDF	50
6		Pinseque AD	46
7		AD Alcorcón FS	41
8		Colo Colo	40
9		CD Anaitasuna	39
10		CD San Cristóbal Nuñez	38
11		Juv. del Circulo Católico	37
12		AD San Juan FS	35
13		AD Quel	30
14		Ribera de Navarra	19
15		Laskorain Ke Futsal	16
16		Villa de Ribafrecha	11

RIVALES EN Segunda División.

USO DE MEMORIA

6,075,520 bytes

BENCHMARKS

Loading Time Base Classes	0.0013
Controller Execution Time ( Home / Category )	0.1221
Total Execution Time	0.1235

CADENA URL

/historico/Ad-San-Juan-Futsal

GET DATOS

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

POST DATOS

No hay datos POST existentes

CONSULTAS (31)

0.0062	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 = 'Ad-San-Juan-Futsal' 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.0023	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=8162 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022	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=8162 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=8162 AND type_rel = 2
0.0047	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 = '8162' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0041	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 = '8162' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0030	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 = 74082 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0047	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=8162 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0023	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 (74082) 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.0024	SELECT count(id) as num_players from rel_players WHERE league_id = 74082 AND teamId = 8162
0.0035	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 74082 AND t.round = 28 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0026	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 = '8162' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0020	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '8162' and rp.type = 4
0.0025	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 = '8162' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0024	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 = 74082 WHERE rp.league_id = 74082 AND rp.teamId = 8162 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.0024	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 = 74082 WHERE rp.league_id = 74082 AND rp.teamId = 8162 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022	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 = 74082 WHERE rp.league_id = 74082 AND rp.teamId = 8162 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028	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 = 8162 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 = 74082 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.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* `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 = 68838 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.0023	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 = 63773 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.0022	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 = 58895 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.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* `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 = 50544 AND t.round = 23 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* `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 = 44513 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	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 = 40225 AND t.round = 30 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* `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 = 35139 AND t.round = 30 ORDER BY team.conference 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* `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 = 16954 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	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 = 4610 AND t.round = 30 ORDER BY team.conference 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* `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 = 2202 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	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 = 1801 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021	SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 74082 ORDER BY nameShow LIMIT 100


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

Resultados de Fútbol

AD San Juan FS

AD San Juan FS

Selecciona un equipo

Competiciones que juega

Segunda División B Futsal Grupo 2

RIVALES EN Segunda División.