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

J. Sanluqueña

Temporada 2023/2024

TEMPORADA 2023/2024

2ª ANDALUZA CÁDIZ
Equipo		PJ	GF	GC	Puntos
1	Taraguilla	27	63	27	59
2	Barbate	27	51	25	57
3	Chipiona CF	27	50	29	53
4	Linense	27	49	33	53
5	Vejer	27	41	38	43
6	Sanluqueño	27	44	49	41
7	CD Jédula	27	27	29	39
8	Athletic	27	34	33	38
9	Tarifa UD	27	30	31	35
10	CD Ubrique	27	33	37	34
11	Olvera	27	42	41	33
12	Villamartín	27	45	44	33
13	Chiclana	27	44	44	33
14	Jose	27	24	43	25
15	Sanluqueña	27	32	61	22
16	Recreativo	27	26	71	12

TEMPORADA 2022/2023

2ª ANDALUZA CÁDIZ
Equipo		PJ	GF	GC	Puntos
1	Cádiz C	30	68	29	60
2	Rayo	30	48	29	58
3	Bernardo	30	56	43	49
4	Ciudad Cadiz	30	51	43	48
5	Roque	30	43	41	47
6	Chiclana	30	42	34	42
7	Chipiona CF	30	42	48	42
8	Vejer	30	46	46	41
9	Sanluqueña	30	57	66	38
10	Linense	30	44	41	37
11	Jose	30	32	57	37
12	Ubrique	30	48	56	36
13	Aficion	30	38	44	34
14	Torno 2009	30	48	60	31
15	Castellar	30	53	68	30
16	Tesorillo	30	25	36	30

TEMPORADA 2021/2022

2ª ANDALUZA CÁDIZ
Equipo		PJ	GF	GC	Puntos
1	Grupo	33	92	36	74
2	Barbate	34	81	30	71
3	Castellar	34	73	43	67
4	Linense	33	80	40	65
5	Chipiona CF	33	55	43	57
6	Torno 2009	34	66	51	54
7	Ciudad Cadiz	34	55	58	51
8	Aficion	33	52	49	49
9	Vejer	34	37	40	47
10	Sanluqueña	33	51	62	47
11	Tarifa UD	33	49	61	44
12	Federico	33	49	61	40
13	Nextstars	33	53	55	38
14	Divina	33	50	80	34
15	Sherry	33	42	71	30
16	Jose Obrero	33	50	70	27
17	Alcalá	22	16	47	18
18	Novo	33	21	75	11

TEMPORADA 2020/2021

2ª ANDALUZA CÁDIZ GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Rayo	16	37	12	36
2	CD Jédula	15	31	13	28
3	Castellar	16	29	22	28
4	Aficion	16	24	20	24
5	Jose Obrero	16	20	22	20
6	Ud Bornense	16	24	26	19
7	Divina	16	28	34	18
8	Sanluqueña	15	21	27	18
9	Alma África	16	17	55	7

TEMPORADA 2019/2020

2ª ANDALUZA CÁDIZ
Equipo		PJ	GF	GC	Puntos
1	Guadiaro	25	79	17	69
2	Cortijillos	25	53	20	55
3	UD Algaida	25	56	24	48
4	Xerez	25	65	34	47
5	CD Jédula	25	45	33	41
6	Fernando	25	42	34	41
7	CD Rivera	25	36	30	40
8	Portuense	25	42	32	39
9	Divina	25	28	41	31
10	Amigos Cruz	25	39	45	28
11	Sanluqueña	25	39	46	28
12	Medina	25	36	41	27
13	Estrella	25	23	39	25
14	Rayo	25	21	40	25
15	Alcalá	25	27	53	24
16	Espera C.F.	25	22	54	23
17	Cañorrera	25	18	65	21
18	Jose Obrero	25	30	53	20

TEMPORADA 2018/2019

PRIMERA ANDALUZA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Chiclana CF	34	57	29	72
2	Trebujena	34	68	34	71
3	Grupo	34	62	27	67
4	Balón	34	68	35	67
5	Villamartín	34	59	34	67
6	Ubrique UD	34	66	47	60
7	Jerez	34	54	47	49
8	Algeciras	34	72	67	48
9	Vejer	34	49	51	45
10	Recreativo	34	48	50	45
11	Tarifa UD	34	44	52	44
12	Chiclana	34	50	59	43
13	Tesorillo	34	56	52	41
14	Torno 2009	34	52	61	40
15	Guadiaro	34	47	58	38
16	Fernando	33	35	66	26
17	Alcalá	33	31	79	20
18	Sanluqueña	34	24	94	12

TEMPORADA 2017/2018

PRIMERA ANDALUZA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Grupo	34	68	26	69
2	Roteña	34	55	33	64
3	Trebujena	34	59	37	62
4	Jerez	33	63	39	59
5	Villamartín	34	58	45	59
6	Balón	34	58	37	54
7	Chiclana CF	33	56	37	54
8	Vejer	34	52	46	52
9	Torno 2009	33	61	66	48
10	Fernando	34	56	53	46
11	Guadiaro	34	53	54	46
12	Tesorillo	33	51	63	41
13	Sanluqueña	33	50	68	40
14	Recreativo	33	39	49	39
15	Jose Obrero	34	40	60	37
16	Rayo	34	47	64	35
17	CD Jédula	33	29	70	27
18	Chipiona CF	33	25	73	18

TEMPORADA 2016/2017

2ª ANDALUZA CÁDIZ
Equipo		PJ	GF	GC	Puntos
1	Fernando	31	83	40	64
2	Rayo	32	72	33	62
3	Sanluqueña	32	60	37	60
4	Puerto Real	31	63	34	59
5	Vejer	32	43	23	59
6	Ubrique UD	32	72	47	57
7	C.D. Salle	31	55	37	53
8	Bernardo	32	63	50	47
9	C.D. Union.	31	55	49	47
10	Barbate	32	47	60	46
11	Prado	31	38	48	44
12	Tarifa UD	32	63	74	40
13	Federico	31	52	70	36
14	Conil B	32	31	61	23
15	Espera C.F.	30	40	63	22
16	Unión	31	41	89	21
17	Cañorrera	31	26	89	11

TEMPORADA 2015/2016

3ª ANDALUZA CÁDIZ
Equipo		PJ	GF	GC	Puntos
1	Fernando	28	73	35	57
2	C.D. Salle	29	83	37	55
3	Tarifa UD	29	63	46	53
4	Vejer	29	48	35	51
5	Sanluqueña	28	63	52	51
6	Federico	29	56	41	49
7	Ubrique UD	29	55	35	48
8	Rayo	29	39	35	47
9	Prado	28	56	73	33
10	Unión	28	36	63	31
11	Pueblo Nuevo	29	48	59	31
12	Cañorrera	29	42	61	30
13	Atletico	27	44	66	29
14	San Benito	25	34	59	28
15	C.D. Union.	29	36	58	24
16	Puerto Real	15	15	36	13
17	Novo Gazul.	0	0	0	0

TEMPORADA 2014/2015

3ª ANDALUZA CÁDIZ
Equipo		PJ	GF	GC	Puntos
1	Xerez	28	126	12	77
2	Guadiaro	28	65	25	63
3	Florida	28	55	49	52
4	Torno 2009	28	65	41	51
5	Ubrique UD	28	63	41	49
6	Sanluqueña	28	56	51	48
7	Fernando	28	56	49	41
8	Vejer	28	48	46	38
9	Tarifa UD	28	44	48	38
10	San Benito	28	50	60	33
11	Prado	28	39	61	28
12	Federico	28	35	60	28
13	Atletico	28	37	71	25
14	Espera C.F.	28	41	69	23
15	Español	28	17	114	4
16	Puerto	0	0	0	0

TEMPORADA 2010/2011

3ª ANDALUZA CÁDIZ
Equipo		PJ	GF	GC	Puntos
1	Alcalá	28	90	25	63
2	Balona	28	67	23	60
3	Portuense	28	64	20	60
4	Sanluqueña	28	63	38	60
5	Jose Obrero	28	65	36	56
6	Sindicales	28	39	53	43
7	Federico	28	46	45	42
8	Juventud	28	48	57	37
9	Novo	28	47	62	34
10	Torno 2009	28	49	53	32
11	Atlético	28	37	50	29
12	Pueblo Nuevo	28	40	61	26
13	El Bosque	28	37	67	21
14	Alcalá	28	33	80	16
15	Algodonales	28	29	84	16

Competiciones que juega

2ª Andaluza Cádiz

Pos	Equipos		Pts
1		AD Taraguilla	59
2		Barbate	57
3		Chipiona CF	53
4		RB Linense B	53
5		CD Vejer Balompié	43
6		At. Sanluqueño B	41
7		CD Jédula	39
8		Athletic Nueva Jarilla	38
9		Tarifa UD	35
10		CD Ubrique	34
11		Olvera	33
12		CD UD Villamartín	33
13		Chiclana Industrial	33
14		San Jose Atletico	25
15		J. Sanluqueña	22
16		Recreativo Portuense	12

	Ascenso : AD Taraguilla, Barbate, Chipiona CF, RB Linense B
	Descenso : Chiclana Industrial, San Jose Atletico, J. Sanluqueña, Recreativo Portuense

RIVALES EN 2ª Andaluza Cádi.

USO DE MEMORIA

6,080,264 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1499
Total Execution Time	0.1511

CADENA URL

/historico/J-Sanluquena

GET DATOS

$_GET['/historico/J-Sanluquena']

POST DATOS

No hay datos POST existentes

CONSULTAS (32)

0.0038	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 = 'J-Sanluquena' 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.0019	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=14096 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	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=14096 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0045	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 = 73678
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=14096 AND type_rel = 2
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=279 AND type_rel = 3
0.0023	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 279 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0024	SELECT /53 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 (1242683,1162357,687224,674140,635729) ORDER BY n.cover_points DESC, update_date DESC
0.0023	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 = '14096' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0022	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 = '14096' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020	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 = 73678 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023	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=14096 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018	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 (73678) 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.0018	SELECT count(id) as num_players from rel_players WHERE league_id = 73678 AND teamId = 14096
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 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 = 73678 AND t.round = 27 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0023	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 = '14096' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '14096' and rp.type = 4
0.0020	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 = '14096' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0019	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 = 73678 WHERE rp.league_id = 73678 AND rp.teamId = 14096 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.0019	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 = 73678 WHERE rp.league_id = 73678 AND rp.teamId = 14096 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019	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 = 73678 WHERE rp.league_id = 73678 AND rp.teamId = 14096 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021	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 = 14096 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 73678 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.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* `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 = 68925 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.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* `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 = 64158 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.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* `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 = 59425 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.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* `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 = 51363 AND t.round = 25 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 = 44621 AND t.round = 34 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* `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 = 39325 AND t.round = 34 ORDER BY team.conference 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* `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 = 16926 AND t.round = 34 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* `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 = 4112 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* `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 = 2993 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

J. Sanluqueña

J. Sanluqueña

Selecciona un equipo

Competiciones que juega

2ª Andaluza Cádiz

RIVALES EN 2ª Andaluza Cádi.