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

UA Zacatecas

Temporada 2023/2024

TEMPORADA 2023/2024

LIGA PREMIER SERIE A GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Los Cabos	33	55	28	65
2	Durango	33	54	25	62
3	Chihuahua	24	38	6	58
4	Gavilanes	33	46	34	56
5	Tamaulipas	34	48	54	52
6	Tecos	34	54	39	51
7	Orgullo	33	33	29	49
8	Leones	34	47	49	49
9	Cimarrones	33	32	31	48
10	Saltillo FC	33	31	31	48
11	Tritones	34	33	30	44
12	Zacatecas	33	46	38	43
13	Real Apodaca	33	42	41	42
14	Mineros	34	38	44	40
15	Club Calor	33	31	51	35
16	Mexicali FC	34	23	61	29
17	Colima	34	31	68	24
18	Coras	33	26	49	22

TEMPORADA 2022/2023

LIGA PREMIER SERIE A - CLAUSURA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Chihuahua	10	21	10	25
2	Tecos	10	14	4	25
3	Tritones	10	17	5	24
4	Los Cabos	10	14	8	18
5	Cimarrones	10	16	11	18
6	Zacatecas	10	14	12	17
7	Coras	10	9	13	13
8	Mineros	10	7	16	10
9	Mexicali FC	10	10	18	8
10	Halcones	10	6	17	6
11	Leones	10	4	18	1

TEMPORADA 2021/2022

LIGA PREMIER SERIE A - CLAUSURA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Mazorqueros	13	30	10	33
2	Tritones	13	23	12	29
3	Durango	13	32	11	27
4	Coras	13	20	12	26
5	Saltillo FC	13	24	18	25
6	Cimarrones	13	19	15	19
7	Gavilanes	13	14	9	17
8	Zacatecas	13	22	20	16
9	Tecos	13	13	19	16
10	Leones	13	13	22	13
11	Colima	13	11	21	10
12	Mineros	13	17	29	9
13	Tamaulipas	13	10	29	8
14	Catedrático	13	9	30	5

TEMPORADA 2020/2021

LIGA PREMIER SERIE A GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Durango	22	44	15	52
2	Reboceros	22	44	25	46
3	Colima	22	36	19	46
4	Gavilanes	22	22	14	46
5	Mineros	22	35	29	34
6	Atlético	22	22	24	32
7	Zacatecas	22	25	28	32
8	Tecos	22	23	29	25
9	Mazorqueros	22	23	36	24
10	Saltillo FC	22	23	40	22
11	Leones	22	25	42	19
12	Cimarrones	22	13	34	11

TEMPORADA 2019/2020

LIGA PREMIER SERIE A GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Tepatitlán	23	55	14	62
2	Zacatecas	24	47	24	56
3	Reynosa F.C.	23	51	22	53
4	Gavilanes	23	41	24	48
5	Durango	23	48	25	46
6	Coras	22	36	25	44
7	Murciélagos	24	45	36	39
8	Chihuahua	23	34	30	38
9	Saltillo FC	24	28	23	37
10	Tecos	22	30	41	25
11	Tamaulipas	23	26	41	21
12	Leones	23	29	49	17
13	Atlético	24	18	65	15
14	Mineros	24	17	51	13
15	Cimarrones	23	15	50	12
16	Coyotes	20	30	14	43
17	Irapuato	20	42	28	40
18	Pioneros	20	37	25	34
19	Pumas UNAM.	21	38	31	33
20	Cafessa	20	28	22	33
21	Cruz Azul	20	31	19	31
22	Inter Playa	20	32	26	27
23	Reboceros	21	26	33	27
24	Yalmakan	21	35	42	25
25	Cafetaleros	20	26	33	24
26	Cañoneros	20	19	33	23
27	Sporting	20	15	33	11
28	Atlético	21	18	38	11
29	Orizaba	0	0	0	0

TEMPORADA 2018/2019

LIGA PREMIER SERIE A - APERTURA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Guadalajara	30	46	28	61
2	Loros	30	72	33	58
3	Tepatitlán	30	52	40	54
4	Reynosa F.C.	30	42	23	52
5	Murciélagos	30	56	39	52
6	Necaxa	30	38	33	52
7	Chihuahua	30	47	30	51
8	Coras	30	42	31	51
9	Gavilanes	30	41	33	48
10	Tamaulipas	31	41	50	38
11	Monarcas	30	50	41	37
12	Leones	30	35	49	34
13	Tecos	31	43	52	31
14	Durango	30	25	45	23
15	Pacific	30	32	71	22
16	Cimarrones	30	18	82	9
17	Irapuato	30	57	19	70
18	Zacatecas	30	46	34	52
19	Tuxtla FC	30	45	28	50
20	Pumas UNAM.	30	47	34	49
21	Cruz Azul	30	38	30	47
22	Real Zamora	30	44	38	47
23	Inter Playa	30	35	30	47
24	Toluca	30	41	40	42
25	Coyotes	30	39	34	40
26	Reboceros	30	39	39	39
27	Pioneros	30	30	37	33
28	Orizaba	30	25	40	33
29	Sporting	30	31	57	28
30	América	30	30	47	27
31	Cocodrilos	30	23	41	26
32	Yalmakan	30	28	50	22

TEMPORADA 2017/2018

LIGA PREMIER SERIE B - CLAUSURA
Equipo		PJ	GF	GC	Puntos
1	Leones	13	23	7	33
2	Mineros	13	30	16	32
3	Celaya	13	25	19	23
4	Tamaulipas	13	22	18	23
5	Internaciona	13	23	14	22
6	Deportivo	13	17	15	19
7	Sahuayo F.C.	13	13	15	17
8	Dorados	13	16	15	15
9	Constructore	13	22	26	14
10	Zacatecas	13	18	23	14
11	Cimarrones	13	14	22	12
12	Mineros	13	15	23	10
13	Club Calor	13	9	22	10
14	Saltillo FC	13	14	26	7
15	Yalmakan	13	30	8	30
16	Orizaba	13	29	6	29
17	Chapulineros	13	30	12	26
18	Ciervos	13	23	20	24
19	Zitacuaro	13	18	13	22
20	Coyotes	13	27	12	20
21	Nuevo	13	13	13	19
22	Teca UTN	13	14	13	16
23	Cuautla	13	16	14	14
24	Ocelotes	13	16	16	14
25	Isleños	13	11	17	14
26	Deportivo	13	13	22	14
27	F.C.	13	12	33	6
28	Cuatetes	13	0	53	0

TEMPORADA 2016/2017

LIGA PREMIER SERIE A - CLAUSURA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Irapuato	14	31	17	28
2	Reboceros	14	20	11	28
3	Monarcas	14	32	15	26
4	Gallos	14	18	11	25
5	Cruz Azul	14	21	16	24
6	Club Leon P.	14	21	23	21
7	Atlético	14	18	15	19
8	Toluca	14	9	9	18
9	Zacatecas	14	16	21	17
10	Tepatitlán	14	14	20	17
11	Pachuca	14	15	19	16
12	Necaxa	14	20	28	15
13	Real Zamora	14	16	19	12
14	Cachorros	14	14	25	10
15	Santos	14	14	30	9
16	Deportivo	0	0	0	0

TEMPORADA 2015/2016

LIGA PREMIER SERIE A - CLAUSURA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Murciélagos	14	27	17	26
2	Reynosa F.C.	14	21	15	25
3	Mineros	14	20	13	23
4	Rayados	14	15	17	23
5	Santos	13	23	11	22
6	Ciudad	14	23	21	22
7	Club Tijuana	14	25	20	21
8	Cimarrones	13	31	16	20
9	Tigres UANL	14	19	17	20
10	Santos	14	19	29	16
11	Durango	14	20	25	15
12	Deportivo	14	12	21	13
13	Zacatecas	14	16	22	12
14	Chihuahua	14	17	27	12
15	Dorados	14	16	33	12

TEMPORADA 2014/2015

LIGA PREMIER SERIE A - APERTURA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Mineros	14	27	12	30
2	Tigres UANL	14	24	14	26
3	Zacatecas	14	19	12	25
4	Cimarrones	14	21	19	22
5	Reynosa F.C.	14	17	16	21
6	Rayados	14	14	12	20
7	Santos	14	19	20	20
8	Club Tijuana	14	16	19	18
9	Chihuahua	14	17	20	17
10	Murciélagos	14	11	14	16
11	Santos	14	16	19	15
12	Dorados	14	25	29	15
13	Durango	14	21	26	15
14	Ciudad	14	18	21	14
15	Deportivo	14	10	22	11

TEMPORADA 2013/2014

LIGA PREMIER SERIE A - CLAUSURA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Irapuato	14	21	10	27
2	Cruz Azul P.	14	19	12	26
3	Real	14	22	19	23
4	Orizaba	14	14	12	23
5	Atl.	14	19	12	22
6	Delfines II	14	18	20	21
7	Tiburones	14	11	15	21
8	UAEM Potros	14	17	15	20
9	Linces	14	25	19	18
10	Inter Playa	14	16	19	18
11	Ocelotes	14	16	18	14
12	Tampico	14	11	19	14
13	Zacatecas	14	12	18	13
14	Teca UTN	14	13	19	12
15	Patriotas	14	17	24	12

TEMPORADA 2012/2013

LIGA PREMIER SERIE A - APERTURA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Linces	14	26	13	32
2	Ocelotes	14	20	11	32
3	Teca UTN	14	25	13	24
4	UAEM Potros	14	24	16	24
5	Cruz Azul P.	14	20	16	21
6	Irapuato	14	18	14	21
7	Atl.	13	15	12	21
8	Real	14	24	22	19
9	Inter Playa	14	10	8	19
10	Tiburones	14	19	24	15
11	Tampico	14	18	26	15
12	Orizaba	14	14	19	13
13	Delfines	14	16	23	10
14	Zacatecas	13	11	24	8
15	Patriotas	14	10	29	7

Competiciones que juega

Liga Premier Serie A Grupo 1

Pos	Equipos		Pts
1		Los Cabos	65
2		Durango	62
3		Chihuahua FC	58
4		Gavilanes FC	56
5		UA Tamaulipas	52
6		Tecos	51
7		Orgullo de Reynosa	49
8		Leones Negros II	49
9		Cimarrones II	48
10		Saltillo FC	48
11		Tritones Vallarta	44
12		UA Zacatecas	43
13		Real Apodaca	42
14		Mineros de Fresnillo	40
15		Club Calor	35
16		Mexicali FC	29
17		Colima	24
18		Coras de Nayarit	22

	Series Finales : Los Cabos
	Playoffs : Durango, Chihuahua FC, Gavilanes FC, UA Tamaulipas, Tecos, Orgullo de Reynosa

RIVALES EN Liga Premier Ser.

USO DE MEMORIA

6,536,944 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.5617
Total Execution Time	0.5629

CADENA URL

/historico/Ua-Zacatecas

GET DATOS

$_GET['/historico/Ua-Zacatecas']

POST DATOS

No hay datos POST existentes

CONSULTAS (32)

0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=56899 AND type_rel = 2
0.0130	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 = '56899' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126	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 = 73350 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0129	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=56899 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126	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 (73350,71573,70229,68375) 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.0127	SELECT count(id) as num_players from rel_players WHERE league_id = 73350 AND teamId = 56899
0.0126	SELECT count(id) as num_players from rel_players WHERE league_id = 70229 AND teamId = 56899
0.0138	SELECT count(id) as num_players from rel_players WHERE league_id = 71573 AND teamId = 56899
0.0138	SELECT count(id) as num_players from rel_players WHERE league_id = 68375 AND teamId = 56899
0.0276	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 = 73350 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0128	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 = '56899' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '56899' and rp.type = 4
0.0127	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 = '56899' 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 = 73350 WHERE rp.league_id = 73350 AND rp.teamId = 56899 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.0135	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 = 73350 WHERE rp.league_id = 73350 AND rp.teamId = 56899 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0132	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 = 73350 WHERE rp.league_id = 73350 AND rp.teamId = 56899 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0130	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 = 56899 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 68370 AND t.round = 11 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128	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 = 68375 AND t.round = 11 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0137	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 = 64143 AND t.round = 13 ORDER BY team.conference ASC,t.position 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* `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 = 66329 AND t.round = 13 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128	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 = 58750 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.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* `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 = 51046 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.0131	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 = 44592 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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 = 39022 AND t.round = 13 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 41349 AND t.round = 13 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 = 33797 AND t.round = 15 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 = 37692 AND t.round = 15 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* `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 = 20213 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0137	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 = 16634 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0142	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 = 8620 AND t.round = 13 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145	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 = 16464 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

UA Zacatecas

UA Zacatecas

Selecciona un equipo

Competiciones que juega

Liga Premier Serie A Grupo 1

RIVALES EN Liga Premier Ser.