4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Murciélagos
TEMPORADA 2019/2020
LIGA PREMIER SERIE A GRUPO 1
Equipo PJ GF GC Puntos
1 Tepatitlán FC Tepatitlán 23 55 14 62
2 UA Zacatecas Zacatecas 24 47 24 56
3 Reynosa F.C. Reynosa F.C. 23 51 22 53
4 Gavilanes FC Gavilanes 23 41 24 48
5 Durango Durango 23 48 25 46
6 Coras de Nayarit Coras 22 36 25 44
7 Murciélagos Murciélagos 24 45 36 39
8 UA Chihuahua Chihuahua 23 34 30 38
9 Saltillo FC Saltillo FC 24 28 23 37
10 Tecos Tecos 22 30 41 25
11 UA Tamaulipas Tamaulipas 23 26 41 21
12 Leones Negros II Leones 23 29 49 17
13 Atlético Bahía Atlético 24 18 65 15
14 Mineros de Fresnillo Mineros 24 17 51 13
15 Cimarrones II Cimarrones 23 15 50 12
16 Coyotes de Tlaxcala Coyotes 20 30 14 43
17 Irapuato Irapuato 20 42 28 40
18 Pioneros de Cancún Pioneros 20 37 25 34
19 Pumas UNAM Premier Pumas UNAM. 21 38 31 33
20 Cafessa Jalisco Cafessa 20 28 22 33
21 Cruz Azul Cruz Azul 20 31 19 31
22 Inter Playa del Carmen Inter Playa 20 32 26 27
23 Reboceros de la Piedad Reboceros 21 26 33 27
24 Yalmakan Yalmakan 21 35 42 25
25 Cafetaleros de Chiapas II Cafetaleros 20 26 33 24
26 Cañoneros Marina Cañoneros 20 19 33 23
27 Sporting Canamy Sporting 20 15 33 11
28 Atlético San Luis II Atlético 21 18 38 11
29 Orizaba Orizaba 0 0 0 0
TEMPORADA 2018/2019
LIGA PREMIER SERIE A - APERTURA GRUPO 1
Equipo PJ GF GC Puntos
1 Guadalajara Premier Guadalajara 30 46 28 61
2 Loros Universidad Loros 30 72 33 58
3 Tepatitlán FC Tepatitlán 30 52 40 54
4 Reynosa F.C. Reynosa F.C. 30 42 23 52
5 Murciélagos Murciélagos 30 56 39 52
6 Necaxa Premier Necaxa 30 38 33 52
7 UA Chihuahua Chihuahua 30 47 30 51
8 Coras de Nayarit Coras 30 42 31 51
9 Gavilanes FC Gavilanes 30 41 33 48
10 UA Tamaulipas Tamaulipas 31 41 50 38
11 Monarcas Morelia Premier Monarcas 30 50 41 37
12 Leones Negros II Leones 30 35 49 34
13 Tecos Tecos 31 43 52 31
14 Durango Durango 30 25 45 23
15 Pacific Pacific 30 32 71 22
16 Cimarrones II Cimarrones 30 18 82 9
17 Irapuato Irapuato 30 57 19 70
18 UA Zacatecas Zacatecas 30 46 34 52
19 Tuxtla FC Tuxtla FC 30 45 28 50
20 Pumas UNAM Premier Pumas UNAM. 30 47 34 49
21 Cruz Azul Cruz Azul 30 38 30 47
22 Real Zamora Real Zamora 30 44 38 47
23 Inter Playa del Carmen Inter Playa 30 35 30 47
24 Toluca Premier Toluca 30 41 40 42
25 Coyotes de Tlaxcala Coyotes 30 39 34 40
26 Reboceros de la Piedad Reboceros 30 39 39 39
27 Pioneros de Cancún Pioneros 30 30 37 33
28 Orizaba Orizaba 30 25 40 33
29 Sporting Canamy Sporting 30 31 57 28
30 América Premier América 30 30 47 27
31 Cocodrilos de Tabasco Cocodrilos 30 23 41 26
32 Yalmakan Yalmakan 30 28 50 22
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
ASCENSO MX - CLAUSURA
Equipo PJ GF GC Puntos
1 Leones Negros Leones 15 22 15 29
2 Necaxa Necaxa 15 21 12 28
3 Cafetaleros Cafetaleros 15 14 8 27
4 Celaya Celaya 15 20 13 26
5 Atlante FC Atlante FC 15 22 12 25
6 Mineros de Zacatecas Mineros 15 17 13 22
7 Correcaminos UAT Correcaminos 15 13 17 22
8 Alebrijes de Oaxaca Alebrijes 15 19 19 21
9 Venados FC Venados FC 15 17 14 20
10 FC Juárez FC Juárez 15 13 12 20
11 Deportivo Tepic Deportivo 15 20 19 19
12 Lobos BUAP Lobos BUAP 15 17 22 18
13 Murciélagos Murciélagos 15 18 30 16
14 Zacatepec Zacatepec 15 15 23 13
15 Atl. San Luis Atl. Luis 15 11 20 11
16 Cimarrones de Sonora Cimarrones 15 12 22 10
TEMPORADA 2014/2015
LIGA PREMIER SERIE A - CLAUSURA GRUPO 1
Equipo PJ GF GC Puntos
1 Reynosa F.C. Reynosa F.C. 12 23 10 26
2 Tampico Madero Tampico 12 22 14 24
3 Cimarrones de Sonora Cimarrones 12 19 9 23
4 Loros Universidad Loros 12 24 14 22
5 Gallos Blancos de Querétaro Gallos 12 22 16 18
6 UA Chihuahua Chihuahua 12 16 18 17
7 Tecos Tecos 12 15 17 15
8 Ua Ciudad Juárez Ciudad 12 11 16 14
9 Murciélagos Murciélagos 12 12 19 13
10 Deportivo Tepic JAP Deportivo 12 12 21 12
11 Santos de Soledad F.C. Santos 12 19 22 11
12 UA Zacatecas Zacatecas 12 12 20 10
13 Durango Durango 12 9 20 10
TEMPORADA 2013/2014
LIGA PREMIER SERIE A - CLAUSURA GRUPO 1
Equipo PJ GF GC Puntos
1 Loros Universidad Loros 15 36 11 36
2 De los altos altos 15 20 9 32
3 Deportivo Tepic Deportivo 15 17 5 29
4 Unión de Curtidores Unión 15 30 14 27
5 Estudiantes Tecos II Estudiantes 15 16 16 25
6 Ua Ciudad Juárez Ciudad 15 23 24 22
7 Durango Durango 15 15 17 21
8 Cimarrones de Sonora Cimarrones 15 16 19 20
9 Murciélagos Murciélagos 15 18 21 19
10 Águilas Reales Águilas 15 10 19 17
11 Vaqueros Ameca Vaqueros 15 10 20 17
12 UA Tamaulipas Tamaulipas 15 18 21 16
13 UA Chihuahua Chihuahua 15 16 24 14
14 Cachorros Guadalajara Cachorros 15 12 20 13
15 Bravos Nuevo Laredo Bravos Nuevo 15 13 23 13
16 Reynosa F.C. Reynosa F.C. 15 13 20 12
TEMPORADA 2012/2013
LIGA PREMIER SERIE A - APERTURA GRUPO 1
Equipo PJ GF GC Puntos
1 Loros Universidad Loros 15 42 19 34
2 Deportivo Tepic JAP Deportivo 15 27 15 28
3 Murciélagos Murciélagos 15 24 13 26
4 Unión de Curtidores Unión 15 19 14 26
5 Águilas Reales Águilas 15 21 17 25
6 UA Chihuahua Chihuahua 15 22 18 23
7 De los altos altos 15 24 18 21
8 Durango Durango 15 27 22 21
9 Ua Ciudad Juárez Ciudad 15 21 19 21
10 Cimarrones de Sonora Cimarrones 15 16 21 20
11 Vaqueros Ameca Vaqueros 15 20 23 18
12 Bravos Nuevo Laredo Bravos Nuevo 15 16 24 16
13 Estudiantes Tecos II Estudiantes 15 17 21 15
14 Reynosa F.C. Reynosa F.C. 15 18 32 15
15 Cachorros Guadalajara Cachorros 15 15 24 13
16 UA Tamaulipas Tamaulipas 15 6 35 5

  USO DE MEMORIA  
6,031,776 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.1144
Total Execution Time  0.1155
  CADENA URL  
/historico/Murcielagos
  GET DATOS  
$_GET['/historico/Murcielagos']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (32)  
0.0041  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.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=59692 AND type_rel = 2
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 59692 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 (21277,109829,135124,135137,200665) ORDER BY n.cover_points DESC, update_date DESC
0.0025  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 = '59692' ORDER BY l.year DESC,cat.coefficient DESC
0.0023  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 = '59692' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = '59692' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021  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.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=59692 AND l.year in (2019,2020,2021) ORDER BY l.id DESC, l.year DESC ;
0.0019  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,44592) 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 = 51046 AND teamId = 59692
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 44592 AND teamId = 59692
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 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.0024  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 = '59692' 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 = '59692' and rp.type = 4
0.0022  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 = '59692' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0020  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 = 59692 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.0021  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 = 59692 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0020  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 = 59692 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  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 = 59692 AND l.year <= 2020 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 `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.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 = 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.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 = 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.0021  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.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 `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.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 = 37587 AND t.round = 17 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 `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 = 15285 AND t.round = 15 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 = 20081 AND t.round = 15 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 = 9258 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 = 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.0034  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 = 16465 AND t.round = 15 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 `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 = 16463 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC