4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Drenovets
TEMPORADA 2023/2024
TERCERA BULGARIA V AFG GRUPO 4
Equipo PJ GF GC Puntos
1 Gorna Lokomotiv Oryahovitsa Gorna 23 78 13 67
2 Akademik Svishtov Akademik 22 45 10 53
3 FC Sevlievo FC Sevlievo 22 55 20 48
4 Yantra Polski Trambesh Yantra 24 52 40 44
5 Lokomotiv Mezdra Lokomotiv 23 47 27 43
6 Etar II Etar II 24 45 36 41
7 Dunav Lom Dunav Lom 23 28 39 31
8 Boruna Tsareva livada Boruna 23 35 50 26
9 Vihar Slavyanovo Vihar 23 36 39 25
10 Juventus Malchika Juventus 23 34 65 22
11 Pavlikeni Pavlikeni 22 31 56 21
12 Drenovets Drenovets 24 31 61 21
13 OFK Levski OFK Levski 23 25 42 20
14 Partizan Partizan 22 26 56 16
15 Botev Vratsa II Botev Vratsa 23 29 43 16
TEMPORADA 2022/2023
TERCERA BULGARIA V AFG GRUPO 1
Equipo PJ GF GC Puntos
1 Bdin Bdin 30 89 29 76
2 Gorna Lokomotiv Oryahovitsa Gorna 30 90 21 72
3 Vihar Slavyanovo Vihar 30 63 25 66
4 Lokomotiv Mezdra Lokomotiv 30 63 27 63
5 Pavlikeni Pavlikeni 29 54 48 52
6 FC Sevlievo FC Sevlievo 30 65 30 51
7 Yantra Polski Trambesh Yantra 30 64 44 43
8 Akademik Svishtov Akademik 30 47 46 39
9 Partizan Partizan 30 36 54 33
10 Botev Vratsa II Botev Vratsa 30 41 64 33
11 Juventus Malchika Juventus 30 35 74 33
12 Drenovets Drenovets 30 41 76 31
13 OFK Levski OFK Levski 29 30 66 28
14 Etar II Etar II 30 38 68 25
15 Boruna Tsareva livada Boruna 30 33 72 23
16 Lokomotiv Dryanovo Lokomotiv 30 23 68 21
TEMPORADA 2021/2022
TERCERA BULGARIA V AFG GRUPO 1
Equipo PJ GF GC Puntos
1 Spartak Pleven Spartak 32 89 19 81
2 FC Sevlievo FC Sevlievo 32 64 22 73
3 Gorna Lokomotiv Oryahovitsa Gorna 32 70 31 69
4 Bdin Bdin 32 65 26 59
5 Vihar Slavyanovo Vihar 32 56 31 59
6 Yantra Polski Trambesh Yantra 32 47 41 52
7 Partizan Partizan 32 49 50 52
8 Pavlikeni Pavlikeni 32 48 33 51
9 OFK Levski OFK Levski 32 41 47 40
10 Botev Vratsa II Botev Vratsa 32 30 47 36
11 Drenovets Drenovets 32 39 66 35
12 Akademik Svishtov Akademik 32 43 56 33
13 Lokomotiv Mezdra Lokomotiv 32 35 47 32
14 Juventus Malchika Juventus 32 30 64 28
15 Lokomotiv Dryanovo Lokomotiv 32 33 63 27
16 Etar II Etar II 32 46 90 24
17 Peshtera Galata Peshtera 32 26 78 23
TEMPORADA 2020/2021
TERCERA BULGARIA V AFG GRUPO 4
Equipo PJ GF GC Puntos
1 Levski 2020 Lom Levski 2020 34 86 11 90
2 Vihar Slavyanovo Vihar 34 67 29 72
3 Yantra Polski Trambesh Yantra 33 63 38 63
4 FC Sevlievo FC Sevlievo 34 55 30 61
5 Spartak Pleven Spartak 34 76 34 60
6 Botev Vratsa II Botev Vratsa 34 67 44 60
7 Partizan Partizan 33 46 40 53
8 Pavlikeni Pavlikeni 33 41 31 50
9 Drenovets Drenovets 34 55 55 49
10 Lokomotiv Dryanovo Lokomotiv 34 59 58 49
11 Lokomotiv Mezdra Lokomotiv 33 44 47 43
12 Akademik Svishtov Akademik 34 41 60 35
13 OFK Levski OFK Levski 34 36 45 34
14 Parva Atomna Parva Atomna 33 38 60 33
15 Bdin Bdin 34 35 84 33
16 Peshtera Galata Peshtera 34 48 82 32
17 Etar II Etar II 33 42 62 29
18 Tryavna Tryavna 34 21 110 8
TEMPORADA 2019/2020
TERCERA BULGARIA V AFG GRUPO 4
Equipo PJ GF GC Puntos
1 Yantra Gabrovo Yantra 13 33 8 33
2 FC Sevlievo FC Sevlievo 13 33 13 29
3 Vihar Slavyanovo Vihar 13 28 15 28
4 Partizan Partizan 13 34 13 25
5 Pavlikeni Pavlikeni 13 22 16 22
6 Drenovets Drenovets 13 19 22 20
7 Lokomotiv Dryanovo Lokomotiv 13 23 19 17
8 Akademik Svishtov Akademik 13 29 23 16
9 Lokomotiv Mezdra Lokomotiv 13 15 20 15
10 Kom Berkovitsa Berkovitsa 13 25 26 13
11 Tryavna Tryavna 13 16 24 11
12 Parva Atomna Parva Atomna 13 13 28 11
13 Bdin Bdin 13 9 37 7
14 Juventus Malchika Juventus 13 14 49 3

  USO DE MEMORIA  
5,230,112 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0015
Controller Execution Time ( Home / Category )  0.3791
Total Execution Time  0.3806
  CADENA URL  
/historico/Fk-Drenovets
  GET DATOS  
$_GET['/historico/Fk-Drenovets']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=121959 AND type_rel = 2
0.0161  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 = '121959' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0156  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 = 73008 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0150  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=121959 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0146  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 (73008) 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.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 73008 AND teamId = 121959
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 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 = 73008 AND t.round = 25 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0146  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 = '121959' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '121959' and rp.type = 4
0.0146  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 = '121959' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0147  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 = 73008 WHERE rp.league_id = 73008 AND rp.teamId = 121959 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.0147  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 = 73008 WHERE rp.league_id = 73008 AND rp.teamId = 121959 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0146  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 = 73008 WHERE rp.league_id = 73008 AND rp.teamId = 121959 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0147  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 = 121959 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 68507 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.0165  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 = 63578 AND t.round = 34 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 `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 = 57816 AND t.round = 34 ORDER BY team.conference ASC,t.position 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 `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 = 51129 AND t.round = 13 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC