4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2023/2024
LIGA BULGARIA GRUPO 4
Equipo PJ GF GC Puntos
1 CSKA 1948 Sofia CSKA 1948 S. 31 31 27 44
2 Botev Plovdiv Botev 31 47 34 44
3 Arda Kardzhali Arda 31 33 33 40
4 Slavia Sofia Slavia Sofia 31 29 45 36
TEMPORADA 2022/2023
LIGA BULGARIA GRUPO 4
Equipo PJ GF GC Puntos
1 Arda Kardzhali Arda 36 47 36 58
2 Slavia Sofia Slavia Sofia 36 37 31 58
3 Lokomotiv Sofia Lokomotiv 36 37 49 42
4 Botev Plovdiv Botev 36 41 49 36
TEMPORADA 2021/2022
LIGA BULGARIA GRUPO 2
Equipo PJ GF GC Puntos
1 Ludogorets Ludogorets 31 77 25 79
2 CSKA Sofia CSKA Sofia 31 42 31 58
3 Botev Plovdiv Botev 31 38 33 53
4 Levski Sofia Levski Sofia 31 38 27 52
5 Cherno More Varna Cherno More 31 36 22 47
6 Slavia Sofia Slavia Sofia 31 35 38 37
TEMPORADA 2020/2021
LIGA BULGARIA GRUPO 4
Equipo PJ GF GC Puntos
1 Cherno More Varna Cherno More 32 37 34 45
2 Levski Sofia Levski Sofia 32 34 32 41
3 Tsarsko Selo Tsarsko Selo 32 33 39 37
4 Botev Plovdiv Botev 32 34 52 32
TEMPORADA 2019/2020
LIGA BULGARIA GRUPO 3
Equipo PJ GF GC Puntos
1 Cherno More Varna Cherno More 3 7 3 47
2 Etar Etar 3 3 3 31
3 Tsarsko Selo Tsarsko Selo 3 3 4 31
4 Vitosha Bistritsa Vitosha 3 0 3 6
5 Botev Plovdiv Botev 3 6 4 36
6 Arda Kardzhali Arda 3 1 2 35
7 Botev Vratsa Botev Vratsa 3 5 4 26
8 Dunav Ruse Dunav Ruse 3 4 6 22
TEMPORADA 2018/2019
LIGA BULGARIA GRUPO 3
Equipo PJ GF GC Puntos
1 Ludogorets Ludogorets 10 14 5 79
2 CSKA Sofia CSKA Sofia 10 10 3 78
3 Levski Sofia Levski Sofia 10 13 13 66
4 Beroe Beroe 10 10 7 58
5 Cherno More Varna Cherno More 10 8 17 52
6 Botev Plovdiv Botev 10 5 15 50
TEMPORADA 2017/2018
LIGA BULGARIA GRUPO 3
Equipo PJ GF GC Puntos
1 Ludogorets Ludogorets 10 28 9 88
2 CSKA Sofia CSKA Sofia 10 21 12 81
3 Levski Sofia Levski Sofia 10 18 13 64
4 Beroe Beroe 10 12 19 59
5 Botev Plovdiv Botev 10 18 20 56
6 Vereya Vereya 10 3 27 36
TEMPORADA 2016/2017
LIGA BULGARIA GRUPO 2
Equipo PJ GF GC Puntos
1 Vereya Vereya 6 9 4 45
2 Botev Plovdiv Botev 6 15 8 44
3 Slavia Sofia Slavia Sofia 6 7 10 37
4 Montana Montana 6 8 17 15
5 Beroe Beroe 6 8 5 44
6 Pirin Blagoevgrad Pirin 6 11 8 43
7 Neftochimik Neftochimik 6 6 10 31
8 Gorna Lokomotiv Oryahovitsa Gorna 6 10 12 30
TEMPORADA 2015/2016
LIGA BULGARIA GRUPO 1
Equipo PJ GF GC Puntos
1 Ludogorets Ludogorets 32 55 21 70
2 Levski Sofia Levski Sofia 32 36 18 56
3 Beroe Beroe 32 37 27 53
4 Slavia Sofia Slavia Sofia 32 36 29 49
5 Lokomotiv Plovdiv Lokomotiv 32 40 45 49
6 Cherno More Varna Cherno More 32 36 45 38
7 Botev Plovdiv Botev 32 27 44 33
8 Pirin Blagoevgrad Pirin 32 27 45 26
9 Montana Montana 32 23 43 21
10 Litex Lovech Litex Lovech 0 0 0 0
TEMPORADA 2014/2015
LIGA BULGARIA GRUPO 1
Equipo PJ GF GC Puntos
1 Ludogorets Ludogorets 22 46 14 47
2 CSKA Sofia CSKA Sofia 22 39 15 44
3 Litex Lovech Litex Lovech 22 37 24 39
4 Lokomotiv Sofia Lokomotiv 22 29 24 39
5 Beroe Beroe 22 34 21 38
6 Botev Plovdiv Botev 22 32 26 36
7 Levski Sofia Levski Sofia 22 36 25 34
8 Cherno More Varna Cherno More 22 26 24 31
9 Slavia Sofia Slavia Sofia 22 24 30 23
10 Lokomotiv Plovdiv Lokomotiv 22 13 36 20
11 Marek Marek 22 8 45 14
12 FK Haskovo 2009 Haskovo 2009 22 12 52 7
TEMPORADA 2013/2014
LIGA BULGARIA GRUPO 2
Equipo PJ GF GC Puntos
1 Ludogorets Ludogorets 12 17 6 84
2 CSKA Sofia CSKA Sofia 12 12 6 72
3 Litex Lovech Litex Lovech 12 15 11 72
4 Botev Plovdiv Botev 12 12 11 65
5 Levski Sofia Levski Sofia 12 14 15 62
6 Cherno More Varna Cherno More 12 9 12 54
7 Lokomotiv Plovdiv Lokomotiv 12 6 24 50

  USO DE MEMORIA  
5,603,456 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.1203
Total Execution Time  0.1217
  CADENA URL  
/historico/Botev-Plovdiv
  GET DATOS  
$_GET['/historico/Botev-Plovdiv']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (25)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6371 AND type_rel = 2
0.0019  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 6371 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0022  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 (231358,256722,625578,729501,1145240) ORDER BY n.cover_points DESC, update_date DESC
0.0035  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 = '6371' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0029  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 = 6371 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72087 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.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 `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 = 75898 AND t.round = 2 ORDER BY team.conference ASC,t.position 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 `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 = 67855 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.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 `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 = 71636 AND t.round = 6 ORDER BY team.conference ASC,t.position 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 `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 = 63159 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.0033  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 = 67306 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.0035  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 = 57193 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.0031  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 = 62414 AND t.round = 6 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0043  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 = 49907 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.0063  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 = 56790 AND t.round = 3 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0052  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 = 43917 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0043  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 = 49314 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0066  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 = 38727 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0058  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 = 43226 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0070  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 = 33678 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0037  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 = 38256 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 15434 AND t.round = 36 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 `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 = 11703 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 3815 AND t.round = 22 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 `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 = 10191 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC