4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Leones Negros II
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
LIGA PREMIER SERIE B - CLAUSURA
Equipo PJ GF GC Puntos
1 Leones Negros II Leones 13 23 7 33
2 Mineros de Zacatecas II Mineros 13 30 16 32
3 Celaya Premier Celaya 13 25 19 23
4 UA Tamaulipas Tamaulipas 13 22 18 23
5 Internacional SM Internaciona 13 23 14 22
6 Deportivo Cafessa Deportivo 13 17 15 19
7 Sahuayo F.C. Sahuayo F.C. 13 13 15 17
8 Dorados Premier Dorados 13 16 15 15
9 Constructores Constructore 13 22 26 14
10 UA Zacatecas Zacatecas 13 18 23 14
11 Cimarrones II Cimarrones 13 14 22 12
12 Mineros de Fresnillo Mineros 13 15 23 10
13 Club Calor Club Calor 13 9 22 10
14 Saltillo FC Saltillo FC 13 14 26 7
15 Yalmakan Yalmakan 13 30 8 30
16 Orizaba Orizaba 13 29 6 29
17 Chapulineros de Oaxaca Chapulineros 13 30 12 26
18 Ciervos Ciervos 13 23 20 24
19 Zitacuaro Zitacuaro 13 18 13 22
20 Coyotes de Tlaxcala Coyotes 13 27 12 20
21 Nuevo Chimalhuacán Nuevo 13 13 13 19
22 Teca UTN Teca UTN 13 14 13 16
23 Cuautla Cuautla 13 16 14 14
24 Ocelotes de la UNACH Ocelotes 13 16 16 14
25 Isleños del Carmen Isleños 13 11 17 14
26 Deportivo Gladiadores F.C. Deportivo 13 13 22 14
27 F.C. Satélites F.C. 13 12 33 6
28 Cuatetes de Acapulco Cuatetes 13 0 53 0
TEMPORADA 2016/2017
LIGA PREMIER SERIE A - CLAUSURA GRUPO 1
Equipo PJ GF GC Puntos
1 Guadalajara Premier Guadalajara 15 26 15 31
2 Tigres UANL Premier Tigres UANL 15 23 13 29
3 Mineros de Fresnillo Mineros 15 25 18 29
4 Santos Laguna Premier Santos 15 23 15 27
5 Rayados de Monterrey Premie Rayados 15 30 22 24
6 Murciélagos F.C. Murciélagos 15 21 20 21
7 Leones Negros II Leones 15 25 26 21
8 Reynosa F.C. Reynosa F.C. 15 22 21 20
9 UA Chihuahua Chihuahua 15 18 21 20
10 Mineros de Zacatecas II Mineros 15 23 18 18
11 Atlas Premier Atlas 15 18 21 18
12 Cimarrones II Cimarrones 15 22 26 18
13 Cuervos J.A.P. Cuervos 15 12 15 14
14 Club Tijuana Premier Club Tijuana 15 25 27 13
15 Durango Durango 15 10 19 13
16 Titanes de Saltillo Titanes 15 17 43 9

  USO DE MEMORIA  
5,587,928 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1047
Total Execution Time  0.1059
  CADENA URL  
/historico/Leones-Negros-Ii/2020
  GET DATOS  
$_GET['/historico/Leones-Negros-Ii/2020']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0028  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 = 'Leones-Negros-Ii' AND l.year = 2020 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.0020  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=100452 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=100452 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0042  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.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=100452 AND type_rel = 2
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 = '100452' AND l.year = 2020 ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '100452' 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 = 51046 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024  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=100452 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 (58750,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.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 58750 AND teamId = 100452
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 44592 AND teamId = 100452
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 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.0020  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 = '100452' 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 = '100452' 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 = '100452' 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 = 100452 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.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 = 100452 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 = 100452 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 = 100452 AND l.year <= 2020 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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.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 = 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.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 = 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.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 = 33796 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 = 37691 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC