4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Zaqatala
TEMPORADA 2023/2024
SEGUNDA AZERBAIYÁN
Equipo PJ GF GC Puntos
1 FK Qaradag FK Qaradag 23 39 15 49
2 Imisli FK Imisli FK 23 36 16 46
3 Shamakhi Shamakhi 23 49 19 45
4 MOIK MOIK 23 44 23 42
5 Karvan FK Karvan FK 23 30 28 35
6 Zaqatala Zaqatala 23 28 30 26
7 Mingachevir FK Mingachevir 23 17 32 25
8 Iravan Iravan 23 25 48 23
9 Difai Agsu Difai Agsu 23 27 40 17
10 Araz Saatli Araz Saatli 23 24 68 10
TEMPORADA 2022/2023
SEGUNDA AZERBAIYÁN
Equipo PJ GF GC Puntos
1 Araz PFK Araz PFK 28 69 22 69
2 Neftçi II Neftçi II 28 67 32 59
3 Turan-T II Turan-T II 28 49 37 48
4 Qəbələ II Qəbələ 28 45 28 44
5 Səbail II Səbail II 28 46 44 44
6 Zaqatala Zaqatala 28 49 48 44
7 FC Kapaz II FC Kapaz II 28 41 36 43
8 MOIK MOIK 28 43 42 43
9 FK Qaradag FK Qaradag 28 30 23 41
10 Shamakhi FK II Shamakhi 28 40 56 37
11 Qarabag II Qarabag II 28 32 39 31
12 Zirə II Zirə II 28 28 41 28
13 Sumqayıt II Sumqayıt 28 36 60 22
14 Mingachevir FK Mingachevir 28 29 51 20
15 Imisli FK Imisli FK 28 21 66 20
TEMPORADA 2021/2022
SEGUNDA AZERBAIYÁN
Equipo PJ GF GC Puntos
1 FK Qaradag FK Qaradag 24 48 14 55
2 Shamakhi FK II Shamakhi 24 46 23 44
3 Qarabag II Qarabag II 24 39 22 42
4 Sabah II Sabah II 24 37 29 39
5 Neftçi II Neftçi II 24 43 36 38
6 FC Kapaz FC Kapaz 24 35 31 36
7 MOIK MOIK 24 34 34 36
8 Zaqatala Zaqatala 24 35 34 33
9 Qəbələ II Qəbələ 24 36 37 33
10 Turan-T Turan-T 24 37 39 33
11 Sumqayıt II Sumqayıt 24 19 40 20
12 Səbail II Səbail II 24 24 56 15
13 Zirə II Zirə II 24 16 54 12
TEMPORADA 2020/2021
SEGUNDA AZERBAIYÁN
Equipo PJ GF GC Puntos
1 Neftçi II Neftçi II 27 64 17 64
2 Zaqatala Zaqatala 27 54 34 56
3 Turan-T Turan-T 27 41 22 51
4 Sabah II Sabah II 27 47 37 45
5 Qarabag II Qarabag II 27 30 28 34
6 Shamakhi FK II Shamakhi 27 32 54 31
7 FK Qaradag FK Qaradag 27 29 41 29
8 FC Kapaz FC Kapaz 27 30 38 28
9 Sumqayıt II Sumqayıt 27 26 49 22
10 MOIK MOIK 27 30 63 20
TEMPORADA 2019/2020
SEGUNDA AZERBAIYÁN
Equipo PJ GF GC Puntos
1 Turan-T Turan-T 17 29 18 37
2 Səbail II Səbail II 18 30 11 36
3 Zaqatala Zaqatala 17 36 16 35
4 Sabah II Sabah II 18 29 19 32
5 Neftçi II Neftçi II 18 27 15 29
6 FC Kapaz FC Kapaz 18 23 19 28
7 Shamakhi FK II Shamakhi 17 28 22 25
8 Sumqayıt II Sumqayıt 17 19 24 24
9 Qarabag II Qarabag II 17 36 21 24
10 MOIK MOIK 16 19 22 19
11 FC Agsu FC Agsu 18 13 45 13
12 Zirə II Zirə II 17 18 41 11
13 FK Qaradag FK Qaradag 18 10 44 7
TEMPORADA 2018/2019
SEGUNDA AZERBAIYÁN
Equipo PJ GF GC Puntos
1 MOIK MOIK 26 51 21 65
2 Sumqayıt II Sumqayıt 26 68 29 59
3 Neftçi II Neftçi II 26 51 28 52
4 Zaqatala Zaqatala 26 51 30 47
5 Qarabag II Qarabag II 26 51 35 45
6 Shamakhi FK II Shamakhi 26 41 32 40
7 AZAL PFC Baku AZAL Baku 26 31 25 40
8 Sabah II Sabah II 26 27 20 38
9 FK Qaradag FK Qaradag 26 24 39 30
10 Səbail II Səbail II 26 37 57 27
11 FC Kapaz FC Kapaz 26 22 40 24
12 Turan-T Turan-T 26 29 54 20
13 FC Agsu FC Agsu 26 24 62 17
14 Zirə II Zirə II 26 23 58 15
TEMPORADA 2017/2018
SEGUNDA AZERBAIYÁN
Equipo PJ GF GC Puntos
1 Xəzər Xəzər 27 40 18 50
2 FK Qaradag FK Qaradag 27 44 31 46
3 AZAL PFC Baku AZAL Baku 27 30 20 45
4 MOIK MOIK 27 41 30 45
5 Sabah Sabah 27 41 33 40
6 Turan-T Turan-T 27 34 33 39
7 Binə Binə 27 31 37 33
8 FK Mugan FK Mugan 27 32 48 30
9 FC Agsu FC Agsu 27 25 48 28
10 Zaqatala Zaqatala 27 22 42 19
TEMPORADA 2016/2017
SEGUNDA AZERBAIYÁN
Equipo PJ GF GC Puntos
1 Turan-T Turan-T 26 62 11 61
2 FK Sabail FK Sabail 26 80 25 57
3 FC Agsu FC Agsu 26 63 21 53
4 FK Qaradag FK Qaradag 26 64 31 52
5 Zaqatala Zaqatala 26 69 31 49
6 Shamkir Shamkir 26 41 20 48
7 FK Mugan FK Mugan 26 53 33 44
8 MOIK MOIK 26 47 31 36
9 Sahdah Sahdah 26 36 45 30
10 Şərurspor Şərurspor 25 36 51 25
11 Mingachevir FK Mingachevir 26 25 86 20
12 Bakili Bakili 26 30 99 11
13 Ravan Baku Ravan Baku 25 24 67 10
14 Göyazan Qazakh Göyazan 26 20 99 10
TEMPORADA 2015/2016
SEGUNDA AZERBAIYÁN
Equipo PJ GF GC Puntos
1 FK Neftchala Neftchala 26 74 20 62
2 FK Qaradag FK Qaradag 26 59 28 58
3 MOIK MOIK 26 53 24 47
4 FC Agsu FC Agsu 26 46 29 47
5 Shamkir Shamkir 26 30 24 38
6 Zaqatala Zaqatala 26 47 36 36
7 Turan-T Turan-T 26 35 31 36
8 FK Mugan FK Mugan 26 28 26 32
9 FK Baku FK Baku 26 33 42 30
10 Bakili Bakili 26 34 46 30
11 Sahdah Sahdah 26 31 54 30
12 Şərurspor Şərurspor 26 45 44 28
13 Göyazan Qazakh Göyazan 26 17 42 17
14 Mingachevir FK Mingachevir 26 14 100 15

  USO DE MEMORIA  
5,621,976 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1007
Total Execution Time  0.1019
  CADENA URL  
/historico/Zaqatala
  GET DATOS  
$_GET['/historico/Zaqatala']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (32)  
0.0026  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 = 'Zaqatala' 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.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=66431 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=66431 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=66431 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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 = 74494
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=66431 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=516 AND type_rel = 3
0.0023  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 = '66431' ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '66431' AND l.year = 2024 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 = '66431' 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 = 74494 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  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 = 73994 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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=66431 AND l.year in (2023,2024,2025) 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 (74494,73994) 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 = 73994 AND teamId = 66431
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 74494 AND teamId = 66431
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 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 = 73994 AND t.round = 24 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 = '66431' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '66431' 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 = '66431' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0028  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 = 73994 WHERE rp.league_id = 73994 AND rp.teamId = 66431 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.0023  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 = 73994 WHERE rp.league_id = 73994 AND rp.teamId = 66431 AND (e.action = 4 or e.action = 5) 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 events2024 e ON e.player_id = p.id AND e.league_id = 73994 WHERE rp.league_id = 73994 AND rp.teamId = 66431 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023  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 = 66431 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 68775 AND t.round = 30 ORDER BY team.conference ASC,t.position 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 `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 = 64274 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 60163 AND t.round = 27 ORDER BY team.conference ASC,t.position 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 `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 = 51065 AND t.round = 19 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 45097 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 40388 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 35342 AND t.round = 26 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 = 15774 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC