4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del ZSKA Dushanbe
TEMPORADA 2023/2024
LIGA TAYIKISTÁN
Equipo PJ GF GC Puntos
1 Istiklol Dushanbe Istiklol 1 3 1 3
2 ZSKA Dushanbe ZSKA 1 3 1 3
3 Khosilot Farkhor Khosilot 1 2 0 3
4 Regar-TadAZ Regar-TadAZ 1 2 0 3
5 FK Khujand FK Khujand 1 2 1 3
6 Barqchi Hisor Barqchi 1 3 3 1
7 Ravshan Kulob Ravshan 1 3 3 1
8 FK Eskhata FK Eskhata 1 1 2 0
9 FK Istaravshan Istaravshan 1 1 3 0
10 Panjsher Balkh Panjsher 1 1 3 0
11 Vakhsh Bokhtar Vakhsh 1 0 2 0
12 FK Kuktosh FK Kuktosh 1 0 2 0
TEMPORADA 2022/2023
LIGA TAYIKISTÁN GRUPO 3
Equipo PJ GF GC Puntos
1 ZSKA Dushanbe ZSKA 4 2 1 26
2 FK Khujand FK Khujand 4 1 1 26
3 Khosilot Farkhor Khosilot 4 3 2 25
4 Regar-TadAZ Regar-TadAZ 4 4 2 24
5 Vakhsh Bokhtar Vakhsh 4 1 5 17
TEMPORADA 2021/2022
LIGA TAYIKISTÁN GRUPO 2
Equipo PJ GF GC Puntos
1 Istiklol Dushanbe Istiklol 22 46 13 48
2 Ravshan Kulob Ravshan 22 26 23 35
3 FK Khujand FK Khujand 22 29 18 34
4 Vakhsh Bokhtar Vakhsh 22 23 17 34
5 ZSKA Dushanbe ZSKA 22 26 38 25
TEMPORADA 2020/2021
LIGA TAYIKISTÁN
Equipo PJ GF GC Puntos
1 Istiklol Dushanbe Istiklol 27 78 9 68
2 FK Khujand FK Khujand 27 52 26 55
3 ZSKA Dushanbe ZSKA 27 37 29 44
4 FK Istaravshan Istaravshan 27 30 25 42
5 Vakhsh Bokhtar Vakhsh 27 30 33 36
6 Ravshan Kulob Ravshan 26 27 34 29
7 Fayzkand Fayzkand 27 20 37 29
8 FK Eskhata FK Eskhata 26 32 49 27
9 FK Kuktosh FK Kuktosh 27 38 58 26
10 Dushanbe-83 Dushanbe-83 27 23 67 18
TEMPORADA 2019/2020
LIGA TAYIKISTÁN
Equipo PJ GF GC Puntos
1 Istiklol Dushanbe Istiklol 18 61 11 45
2 FK Khujand FK Khujand 18 30 23 35
3 ZSKA Dushanbe ZSKA 18 29 25 29
4 FK Kuktosh FK Kuktosh 18 30 24 28
5 Vakhsh Bokhtar Vakhsh 18 27 24 26
6 Dushanbe-83 Dushanbe-83 18 20 29 20
7 Fayzkand Fayzkand 18 17 31 19
8 FK Istaravshan Istaravshan 18 29 38 17
9 Lokomotive Pamir Lokomotive 18 14 26 14
10 Regar-TadAZ Regar-TadAZ 18 21 47 12
TEMPORADA 2018/2019
LIGA TAYIKISTÁN
Equipo PJ GF GC Puntos
1 Istiklol Dushanbe Istiklol 21 60 20 51
2 FK Khujand FK Khujand 21 37 21 36
3 Regar-TadAZ Regar-TadAZ 21 31 30 30
4 ZSKA Dushanbe ZSKA 21 24 27 29
5 FK Istaravshan Istaravshan 21 24 32 27
6 FK Kuktosh FK Kuktosh 21 31 36 27
7 Vakhsh Bokhtar Vakhsh 21 26 28 24
8 Panjsher Balkh Panjsher 21 18 57 11
TEMPORADA 2017/2018
LIGA TAYIKISTÁN
Equipo PJ GF GC Puntos
1 Istiklol Dushanbe Istiklol 21 36 16 51
2 FK Khujand FK Khujand 21 42 20 46
3 FK Kuktosh FK Kuktosh 21 31 32 30
4 Regar-TadAZ Regar-TadAZ 21 27 26 28
5 Vakhsh Bokhtar Vakhsh 21 27 29 25
6 ZSKA Dushanbe ZSKA 21 24 33 24
7 Panjsher Balkh Panjsher 21 16 29 18
8 Barqchi Hisor Barqchi 21 16 34 13
TEMPORADA 2016/2017
LIGA TAYIKISTÁN
Equipo PJ GF GC Puntos
1 Istiklol Dushanbe Istiklol 21 64 14 55
2 FK Khujand FK Khujand 21 44 22 37
3 ZSKA Dushanbe ZSKA 21 19 13 34
4 Regar-TadAZ Regar-TadAZ 21 22 23 24
5 Barqchi Hisor Barqchi 21 20 27 24
6 Vakhsh Bokhtar Vakhsh 21 17 28 22
7 Panjsher Balkh Panjsher 21 25 48 19
8 Khosilot Farkhor Khosilot 21 16 52 15
TEMPORADA 2015/2016
LIGA TAYIKISTÁN
Equipo PJ GF GC Puntos
1 Istiklol Dushanbe Istiklol 18 67 20 45
2 Khosilot Farkhor Khosilot 18 40 16 37
3 Regar-TadAZ Regar-TadAZ 18 36 23 32
4 Barqchi Hisor Barqchi 18 32 25 29
5 Xayr Xayr 18 29 25 29
6 ZSKA Dushanbe ZSKA 18 23 16 27
7 FK Khujand FK Khujand 18 22 37 25
8 Vakhsh Bokhtar Vakhsh 18 21 39 18
9 Ravshan Kulob Ravshan 18 17 50 9
10 Parvoz Parvoz 18 14 50 5
TEMPORADA 2014/2015
LIGA TAYIKISTÁN
Equipo PJ GF GC Puntos
1 Istiklol Dushanbe Istiklol 18 69 5 50
2 FK Khujand FK Khujand 18 34 21 39
3 Ravshan Kulob Ravshan 18 37 26 34
4 Regar-TadAZ Regar-TadAZ 18 31 14 33
5 Xayr Xayr 18 21 26 29
6 ZSKA Dushanbe ZSKA 18 18 22 26
7 Barqchi Hisor Barqchi 18 17 32 14
8 Vakhsh Bokhtar Vakhsh 18 11 34 13
9 FK Istaravshan Istaravshan 18 16 36 12
10 Parvoz Parvoz 18 6 44 4
TEMPORADA 2013/2014
LIGA TAYIKISTÁN
Equipo PJ GF GC Puntos
1 Istiklol Dushanbe Istiklol 18 65 10 50
2 Xayr Xayr 18 27 17 35
3 FK Istaravshan Istaravshan 18 20 11 33
4 FK Khujand FK Khujand 18 24 17 32
5 Parvoz Parvoz 18 28 35 25
6 Regar-TadAZ Regar-TadAZ 18 25 27 20
7 Energetik Energetik 18 17 30 19
8 ZSKA Dushanbe ZSKA 18 14 27 15
9 Vakhsh Bokhtar Vakhsh 18 12 32 14
10 Ravshan Kulob Ravshan 18 18 44 9
TEMPORADA 2012/2013
LIGA TAYIKISTÁN
Equipo PJ GF GC Puntos
1 Ravshan Kulob Ravshan 18 26 5 46
2 Istiklol Dushanbe Istiklol 18 47 8 43
3 Xayr Xayr 18 26 14 34
4 Regar-TadAZ Regar-TadAZ 18 26 18 33
5 FK Khujand FK Khujand 18 17 21 23
6 Parvoz Parvoz 18 14 29 19
7 Vakhsh Bokhtar Vakhsh 18 11 17 16
8 Energetik Energetik 18 13 23 16
9 ZSKA Dushanbe ZSKA 18 10 26 11
10 FK Istaravshan Istaravshan 18 13 42 8
11 Panjsher Balkh Panjsher 0 0 0 0
TEMPORADA 2011/2012
LIGA TAYIKISTÁN
Equipo PJ GF GC Puntos
1 Ravshan Kulob Ravshan 24 51 10 62
2 Regar-TadAZ Regar-TadAZ 24 77 16 61
3 Istiklol Dushanbe Istiklol 24 76 13 53
4 Xayr Xayr 24 45 27 52
5 Parvoz Parvoz 24 47 36 34
6 Vakhsh Bokhtar Vakhsh 24 31 24 31
7 ZSKA Dushanbe ZSKA 24 26 25 30
8 FK Khujand FK Khujand 24 29 44 30
9 FK Istaravshan Istaravshan 24 33 44 29
10 Energetik Energetik 24 35 34 28
11 Khosilot Farkhor Khosilot 24 18 64 14
12 Guardia Dushanbe Guardia 24 18 72 12
13 Zarafshon Panjakent Zarafshon 24 21 98 6
TEMPORADA 2010/2011
LIGA TAYIKISTÁN
Equipo PJ GF GC Puntos
1 Istiklol Dushanbe Istiklol 40 130 16 108
2 Regar-TadAZ Regar-TadAZ 40 108 29 95
3 Ravshan Kulob Ravshan 40 78 38 89
4 Barqchi Hisor Barqchi 40 78 64 66
5 Xayr Xayr 40 61 59 54
6 ZSKA Dushanbe ZSKA 40 65 69 52
7 FK Khujand FK Khujand 40 56 72 51
8 Vakhsh Bokhtar Vakhsh 40 43 51 50
9 Parvoz Parvoz 40 45 76 40
10 Shodmon Gissar Shodmon 40 44 115 23
11 Guardia Dushanbe Guardia 40 32 151 12
TEMPORADA 2009/2010
LIGA TAYIKISTÁN
Equipo PJ GF GC Puntos
1 Istiklol Dushanbe Istiklol 32 76 17 84
2 Regar-TadAZ Regar-TadAZ 32 81 24 71
3 Vakhsh Bokhtar Vakhsh 32 42 27 56
4 Xayr Xayr 32 59 42 54
5 Barqchi Hisor Barqchi 32 41 44 40
6 ZSKA Dushanbe ZSKA 32 35 51 37
7 FK Khujand FK Khujand 32 42 58 32
8 Parvoz Parvoz 32 35 71 24
9 Ravshan Kulob Ravshan 32 18 95 6

  USO DE MEMORIA  
5,752,288 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6081
Total Execution Time  0.6093
  CADENA URL  
/historico/Cska-Pomir
  GET DATOS  
$_GET['/historico/Cska-Pomir']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0309  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 = 75579
0.0149  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=57364 AND type_rel = 2
0.0166  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 = '57364' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0157  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 = 75579 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0166  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=57364 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0151  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 (75579) 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.0157  SELECT count(id) as num_players from rel_players WHERE league_id = 75579 AND teamId = 57364
0.0162  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 = 75579 AND t.round = 1 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0156  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 = '57364' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0148  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '57364' and rp.type = 4
0.0156  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 = '57364' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0170  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 = 75579 WHERE rp.league_id = 75579 AND rp.teamId = 57364 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.0149  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 = 75579 WHERE rp.league_id = 75579 AND rp.teamId = 57364 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0149  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 = 75579 WHERE rp.league_id = 75579 AND rp.teamId = 57364 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0155  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 = 57364 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0161  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 `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 = 75579 AND t.round = 1 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0159  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 = 71255 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0156  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 = 74194 AND t.round = 5 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 67183 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 70372 AND t.round = 5 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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 = 61997 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.0158  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 = 49258 AND t.round = 21 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0158  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 = 43092 AND t.round = 21 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163  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 = 38059 AND t.round = 21 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0166  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 = 23347 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163  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 = 11767 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0161  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 = 9552 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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 = 23790 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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 `tables2012` 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 = 23791 AND t.round = 26 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 `tables2011` 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 = 43723 AND t.round = 44 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 `tables2010` 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 = 43724 AND t.round = 35 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC