4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del UAEM Potros
TEMPORADA 2019/2020
ASCENSO MX - APERTURA
Equipo PJ GF GC Puntos
1 Alebrijes de Oaxaca Alebrijes 13 18 15 27
2 Atlante FC Atlante FC 13 15 9 26
3 Tampico Madero Tampico 13 18 13 23
4 Leones Negros Leones 13 17 17 22
5 Zacatepec Zacatepec 13 18 18 21
6 Celaya Celaya 13 14 11 19
7 Mineros de Zacatecas Mineros 13 13 11 19
8 Cafetaleros Cafetaleros 13 17 16 18
9 Dorados Dorados 13 13 12 17
10 Cimarrones de Sonora Cimarrones 13 10 11 17
11 Loros Universidad Loros 13 16 18 16
12 UAEM Potros UAEM Potros 13 18 21 15
13 Venados FC Venados FC 13 12 20 14
14 Correcaminos UAT Correcaminos 13 12 19 11
TEMPORADA 2018/2019
ASCENSO MX - APERTURA
Equipo PJ GF GC Puntos
1 FC Juárez FC Juárez 14 26 10 35
2 Mineros de Zacatecas Mineros 14 27 15 32
3 Atlante FC Atlante FC 14 27 19 30
4 Cimarrones de Sonora Cimarrones 14 21 18 25
5 Atl. San Luis Atl. Luis 14 17 10 23
6 Alebrijes de Oaxaca Alebrijes 14 17 13 22
7 Dorados Dorados 14 16 13 22
8 Leones Negros Leones 14 22 20 18
9 UAEM Potros UAEM Potros 14 9 10 17
10 Correcaminos UAT Correcaminos 14 14 19 15
11 Zacatepec Zacatepec 14 15 20 13
12 Cafetaleros Cafetaleros 14 18 28 12
13 Tampico Madero Tampico 14 11 20 9
14 Venados FC Venados FC 14 12 23 9
15 Celaya Celaya 14 11 25 8
TEMPORADA 2017/2018
ASCENSO MX - CLAUSURA
Equipo PJ GF GC Puntos
1 Mineros de Zacatecas Mineros 15 24 17 28
2 Dorados Dorados 15 20 13 26
3 Leones Negros Leones 15 21 18 25
4 Zacatepec Zacatepec 15 17 19 24
5 Alebrijes de Oaxaca Alebrijes 15 25 17 23
6 Atlante FC Atlante FC 15 16 12 23
7 Celaya Celaya 15 17 14 23
8 Cafetaleros Cafetaleros 15 24 21 22
9 Tampico Madero Tampico 15 14 11 22
10 Atl. San Luis Atl. Luis 15 18 22 20
11 Venados FC Venados FC 15 15 17 19
12 Correcaminos UAT Correcaminos 15 15 20 18
13 FC Juárez FC Juárez 15 12 16 15
14 Murciélagos Murciélagos 15 12 21 15
15 Cimarrones de Sonora Cimarrones 15 16 22 14
16 UAEM Potros UAEM Potros 15 11 17 11
TEMPORADA 2016/2017
ASCENSO MX - CLAUSURA
Equipo PJ GF GC Puntos
1 Mineros de Zacatecas Mineros 17 21 11 32
2 Dorados Dorados 17 29 22 31
3 Alebrijes de Oaxaca Alebrijes 17 27 19 30
4 FC Juárez FC Juárez 17 23 17 28
5 UAEM Potros UAEM Potros 17 21 15 28
6 Lobos BUAP Lobos BUAP 17 30 26 27
7 Zacatepec Zacatepec 17 23 22 27
8 Cimarrones de Sonora Cimarrones 17 20 19 27
9 Deportivo Tepic Deportivo 17 24 20 26
10 Tampico Madero Tampico 17 15 14 23
11 Leones Negros Leones 17 16 18 22
12 Cafetaleros Cafetaleros 17 20 21 21
13 Atlante FC Atlante FC 17 17 18 21
14 Celaya Celaya 17 26 27 19
15 Correcaminos UAT Correcaminos 17 24 31 16
16 Venados FC Venados FC 17 17 34 15
17 Loros Universidad Loros 17 18 27 14
18 Murciélagos Murciélagos 17 13 23 14
TEMPORADA 2015/2016
LIGA PREMIER SERIE A - CLAUSURA GRUPO 4
Equipo PJ GF GC Puntos
1 Real Zamora Real Zamora 2 7 1 6
2 UAEM Potros UAEM Potros 2 1 0 4
3 Tampico Madero Tampico 2 0 1 1
4 UA Tamaulipas Tamaulipas 2 1 7 0
TEMPORADA 2014/2015
LIGA PREMIER SERIE A - APERTURA GRUPO 2
Equipo PJ GF GC Puntos
1 Atlético Estado de México Atlético 14 29 10 32
2 Loros Universidad Loros 14 26 8 30
3 Cruz Azul Cruz Azul 14 23 12 30
4 Tepatitlán FC Tepatitlán 14 30 16 26
5 Atlas Premier Atlas 14 17 14 22
6 Cachorros U. De G. Cachorros 14 25 22 20
7 Monarcas Morelia Premier Monarcas 14 22 20 20
8 Gallos Blancos de Querétaro Gallos 14 15 16 20
9 Irapuato Irapuato 14 22 21 18
10 UAEM Potros UAEM Potros 14 21 27 15
11 Pachuca Premier Pachuca 14 15 25 14
12 Club Leon Premier Club Leon P. 14 16 22 13
13 Guadalajara Premier Guadalajara 14 17 24 13
14 Toluca Premier Toluca 14 16 27 13
15 Real Cuautitlán Real 14 8 38 5
TEMPORADA 2013/2014
LIGA PREMIER SERIE A - CLAUSURA GRUPO 2
Equipo PJ GF GC Puntos
1 Irapuato Irapuato 14 21 10 27
2 Cruz Azul Premier Cruz Azul P. 14 19 12 26
3 Real Cuautitlán Real 14 22 19 23
4 Orizaba Orizaba 14 14 12 23
5 Atl. Coatzacoalcos Atl. 14 19 12 22
6 Delfines II Delfines II 14 18 20 21
7 Tiburones Rojos de Veracruz Tiburones 14 11 15 21
8 UAEM Potros UAEM Potros 14 17 15 20
9 Linces de Tlaxcala Linces 14 25 19 18
10 Inter Playa del Carmen Inter Playa 14 16 19 18
11 Ocelotes de la UNACH Ocelotes 14 16 18 14
12 Tampico Madero Tampico 14 11 19 14
13 UA Zacatecas Zacatecas 14 12 18 13
14 Teca UTN Teca UTN 14 13 19 12
15 Patriotas de Córdoba Patriotas 14 17 24 12
TEMPORADA 2012/2013
LIGA PREMIER SERIE A - APERTURA GRUPO 2
Equipo PJ GF GC Puntos
1 Linces de Tlaxcala Linces 14 26 13 32
2 Ocelotes de la UNACH Ocelotes 14 20 11 32
3 Teca UTN Teca UTN 14 25 13 24
4 UAEM Potros UAEM Potros 14 24 16 24
5 Cruz Azul Premier Cruz Azul P. 14 20 16 21
6 Irapuato Irapuato 14 18 14 21
7 Atl. Coatzacoalcos Atl. 13 15 12 21
8 Real Cuautitlán Real 14 24 22 19
9 Inter Playa del Carmen Inter Playa 14 10 8 19
10 Tiburones Rojos de Veracruz Tiburones 14 19 24 15
11 Tampico Madero Tampico 14 18 26 15
12 Orizaba Orizaba 14 14 19 13
13 Delfines Delfines 14 16 23 10
14 UA Zacatecas Zacatecas 13 11 24 8
15 Patriotas de Córdoba Patriotas 14 10 29 7

  USO DE MEMORIA  
5,764,736 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.1423
Total Execution Time  0.1436
  CADENA URL  
/historico/Uaem-Potros
  GET DATOS  
$_GET['/historico/Uaem-Potros']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0044  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 = 50025
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=59338 AND type_rel = 2
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 59338 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0023  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 (70775,133088,133998,134443,181904) ORDER BY n.cover_points DESC, update_date DESC
0.0027  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 = '59338' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0024  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 = '59338' 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 = 49960 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 50025 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025  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=59338 AND l.year in (2019,2020,2021) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (50025,49960,49506,48518,48497) 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.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 49960 AND teamId = 59338
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 48497 AND teamId = 59338
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 50025 AND teamId = 59338
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 48518 AND teamId = 59338
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 49506 AND teamId = 59338
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 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 = 49960 AND t.round = 13 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0065  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 = 49960 WHERE rp.league_id = 49960 AND rp.teamId = 59338 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.0060  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 = 49960 WHERE rp.league_id = 49960 AND rp.teamId = 59338 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0058  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 = 49960 WHERE rp.league_id = 49960 AND rp.teamId = 59338 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0044  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 = 59338 AND l.year <= 2020 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0036  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 = 49960 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.0045  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 = 48497 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0044  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 = 44040 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0048  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 = 38667 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0053  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 = 41854 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0039  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 = 33339 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0039  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 = 20214 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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 = 28242 AND t.round = 1 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032  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 = 9259 AND t.round = 13 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032  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 = 16635 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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 = 8621 AND t.round = 13 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 16466 AND t.round = 15 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 `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