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

Pumas UNAM Premier

Temporada 2019/2020

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 A - CLAUSURA
Equipo		PJ	GF	GC	Puntos
1	Loros	17	36	14	36
2	Necaxa	17	22	18	31
3	Tigres UANL	17	22	12	29
4	Durango	17	23	19	27
5	Atlas	17	23	23	26
6	Reynosa F.C.	17	24	12	25
7	Tepatitlán	17	25	19	25
8	Pacific	17	24	19	25
9	Guadalajara	17	15	15	23
10	Monarcas	17	20	20	22
11	Tecos	17	16	17	22
12	Gavilanes	17	18	24	21
13	Santos	17	20	24	20
14	Club Leon P.	17	16	23	20
15	Deportivo	17	11	25	20
16	Chihuahua	17	16	30	16
17	Club Tijuana	17	25	30	15
18	Rayados	17	14	26	13
19	Tuxtla FC	17	31	12	38
20	Irapuato	17	32	23	32
21	Reboceros	17	28	19	32
22	Pioneros	17	18	13	32
23	Inter Playa	17	23	14	31
24	América	17	26	20	27
25	Puebla F.C.	17	22	22	23
26	Real Zamora	17	21	21	23
27	Gallos	17	22	18	22
28	Cruz Azul	17	20	19	20
29	Halcones	17	15	18	20
30	Sporting	17	20	29	20
31	Tiburones	17	16	17	19
32	Lobos BUAP.	17	19	26	18
33	Toluca	17	18	24	17
34	Cruz Azul P.	17	20	28	17
35	Pachuca	17	14	30	13
36	Pumas UNAM.	17	21	33	12

TEMPORADA 2016/2017

LIGA DE NUEVOS TALENTOS - CLAUSURA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	América	6	11	6	11
2	Monarcas	6	10	5	11
3	Guadalajara	6	10	11	7
4	Santos	6	4	13	4
5	Club Leon P.	6	10	4	13
6	Gallos	6	10	9	11
7	Tigres UANL	6	6	7	6
8	Pumas UNAM.	6	7	13	4

TEMPORADA 2015/2016

LIGA PREMIER SERIE A - CLAUSURA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Tlaxcala FC	15	40	12	31
2	Tampico	15	23	8	30
3	Pumas UNAM.	15	21	14	30
4	Pioneros	15	33	12	28
5	Inter Playa	15	24	17	27
6	Chapulineros	15	14	10	22
7	Cuervos	15	19	21	22
8	Orizaba	15	17	14	20
9	Cruz Azul P.	15	21	25	20
10	Athletic	15	26	31	18
11	Ocelotes	15	17	22	16
12	Tuxtla FC	15	15	34	16
13	Tiburones	15	15	17	15
14	América	15	17	24	11
15	Puebla F.C.	15	15	30	11
16	Petroleros	15	13	39	7

TEMPORADA 2014/2015

LIGA PREMIER SERIE A - APERTURA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Tlaxcala FC	15	33	7	36
2	Tampico	15	29	11	34
3	América	15	32	11	31
4	Pioneros	15	25	17	27
5	Puebla F.C.	15	25	20	27
6	Chapulineros	15	21	15	24
7	Pumas UNAM.	15	24	18	23
8	Tuxtla FC	15	22	20	23
9	Inter Playa	15	16	16	19
10	Athletic	15	22	29	17
11	Ocelotes	15	16	20	15
12	Cruz Azul P.	15	21	22	14
13	Tiburones	15	17	26	13
14	Orizaba	15	11	25	11
15	Petroleros	15	13	49	9
16	Cuervos	15	13	34	8

Competiciones que juega

Liga Premier Serie A Grupo 1

Pos	Equipos		Pts
1		Tepatitlán FC	62
2		UA Zacatecas	56
3		Reynosa F.C.	53
4		Gavilanes FC	48
5		Durango	46
6		Coras de Nayarit	44
7		Coyotes de Tlaxcala	43
8		Irapuato	40
9		Murciélagos	39
10		UA Chihuahua	38
11		Saltillo FC	37
12		Pioneros de Cancún	34
13		Pumas UNAM Premier	33
14		Cafessa Jalisco	33
15		Cruz Azul	31
16		Inter Playa del Carmen	27
17		Reboceros de la Piedad	27
18		Yalmakan	25
19		Tecos	25
20		Cafetaleros de Chiapas II	24
21		Cañoneros Marina	23
22		UA Tamaulipas	21
23		Leones Negros II	17
24		Atlético Bahía	15
25		Mineros de Fresnillo	13
26		Cimarrones II	12
27		Sporting Canamy	11
28		Atlético San Luis II	11
29		Orizaba	0

	Series Finales : Tepatitlán FC, UA Zacatecas, Reynosa F.C., Gavilanes FC

RIVALES EN Liga Premier Ser.

USO DE MEMORIA

5,815,664 bytes

BENCHMARKS

Loading Time Base Classes	0.0018
Controller Execution Time ( Home / Category )	0.7203
Total Execution Time	0.7221

CADENA URL

/historico/Pumas-Unam-Ii

GET DATOS

$_GET['/historico/Pumas-Unam-Ii']

POST DATOS

No hay datos POST existentes

CONSULTAS (47)

0.0131	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 = 'Pumas-Unam-Ii' 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.0141	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 = 'Pumas-Unam-Ii' 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.0125	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=65983 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=65983 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=65983 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=65983 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	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=65983 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128	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=65983 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129	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=65983 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128	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=65983 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128	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=65983 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	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=65983 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129	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=65983 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128	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=65983 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0133	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=65983 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0133	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=65983 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0158	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 = 51046
0.0129	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=65983 AND type_rel = 2
0.0138	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 65983 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0131	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 (712817) ORDER BY n.cover_points DESC, update_date DESC
0.0151	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 = '65983' ORDER BY l.year DESC,cat.coefficient DESC
0.0140	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 = '65983' AND l.year = 2020 ORDER BY l.year DESC,cat.coefficient DESC
0.0144	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 = '65983' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0144	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 = '65983' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0140	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 = 51046 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0131	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=65983 AND l.year in (2019,2020,2021) 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 (51046,49546) 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.0126	SELECT count(id) as num_players from rel_players WHERE league_id = 51046 AND teamId = 65983
0.0125	SELECT count(id) as num_players from rel_players WHERE league_id = 49546 AND teamId = 65983
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 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0126	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 = '65983' 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 = '65983' 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 = '65983' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0126	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 events2020 e ON e.player_id = p.id AND e.league_id = 51046 WHERE rp.league_id = 51046 AND rp.teamId = 65983 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.0126	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 events2020 e ON e.player_id = p.id AND e.league_id = 51046 WHERE rp.league_id = 51046 AND rp.teamId = 65983 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0126	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 events2020 e ON e.player_id = p.id AND e.league_id = 51046 WHERE rp.league_id = 51046 AND rp.teamId = 65983 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0128	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 = 65983 AND l.year <= 2020 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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.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 = 39021 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149	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 = 41348 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143	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 = 33798 AND t.round = 15 ORDER BY team.conference 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* `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 = 37693 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127	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 = 38296 AND t.round = 6 ORDER BY team.conference 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* `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 = 20215 AND t.round = 15 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* `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 = 16636 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127	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 = 51046 ORDER BY nameShow LIMIT 100

Pumas UNAM Premier

Pumas UNAM Premier

Selecciona un equipo

Competiciones que juega

Liga Premier Serie A Grupo 1

RIVALES EN Liga Premier Ser.