4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Yantra Polski Trambesh
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 2018/2019
TERCERA BULGARIA V AFG GRUPO 3
Equipo PJ GF GC Puntos
1 Spartak Pleven Spartak 30 75 11 79
2 Yantra Gabrovo Yantra 30 90 30 70
3 FC Sevlievo FC Sevlievo 30 50 27 59
4 Vihar Slavyanovo Vihar 30 44 25 54
5 Pavlikeni Pavlikeni 30 46 44 48
6 Bdin Bdin 30 55 43 42
7 Partizan Partizan 30 48 44 41
8 Akademik Svishtov Akademik 30 47 51 41
9 Parva Atomna Parva Atomna 30 53 52 38
10 Botev Lukovit Botev 30 40 42 38
11 Kom Berkovitsa Berkovitsa 30 36 42 38
12 Lokomotiv Mezdra Lokomotiv 30 49 67 37
13 Tryavna Tryavna 30 27 57 27
14 Lokomotiv Dryanovo Lokomotiv 30 34 65 24
15 OFK Levski OFK Levski 30 34 80 24
16 Yantra Polski Trambesh Yantra 30 29 77 24
TEMPORADA 2017/2018
TERCERA BULGARIA V AFG GRUPO 4
Equipo PJ GF GC Puntos
1 Kariana Erden Kariana 30 100 19 80
2 FC Sevlievo FC Sevlievo 30 60 27 64
3 Vihar Slavyanovo Vihar 30 68 32 58
4 Bdin Bdin 30 57 33 53
5 Parva Atomna Parva Atomna 30 45 29 52
6 OFK Levski OFK Levski 30 42 40 46
7 Yantra Gabrovo Yantra 30 60 39 43
8 Spartak Pleven Spartak 30 39 46 39
9 Akademik Svishtov Akademik 30 45 46 37
10 Partizan Partizan 30 34 50 37
11 Tryavna Tryavna 30 33 47 36
12 Pavlikeni Pavlikeni 30 34 62 32
13 Botev Lukovit Botev 30 37 64 30
14 Yantra Polski Trambesh Yantra 30 37 61 26
15 Yantra Gabrovo Yantra 30 26 71 23
16 Mizia 2005 Mizia 2005 30 24 75 22

  USO DE MEMORIA  
5,374,832 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.0945
Total Execution Time  0.0964
  CADENA URL  
/historico/Yantra-Polski-Trambesh
  GET DATOS  
$_GET['/historico/Yantra-Polski-Trambesh']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0029  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 = 'Yantra-Polski-Trambesh' 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.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=102468 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=102468 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0040  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 = 73008
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=102468 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=238 AND type_rel = 3
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 238 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0023  SELECT /*53 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 (77796,59747,55420,15539) ORDER BY n.cover_points DESC, update_date DESC
0.0022  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 = '102468' ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '102468' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0020  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 = '102468' 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 = 73008 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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=102468 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018  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.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 73008 AND teamId = 102468
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 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.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 = '102468' 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 = '102468' 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 = '102468' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 73008 WHERE rp.league_id = 73008 AND rp.teamId = 102468 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 events2024 e ON e.player_id = p.id AND e.league_id = 73008 WHERE rp.league_id = 73008 AND rp.teamId = 102468 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 events2024 e ON e.player_id = p.id AND e.league_id = 73008 WHERE rp.league_id = 73008 AND rp.teamId = 102468 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022  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 = 102468 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 team.conference ASC,t.position 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 `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.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 `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.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 `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.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 = 44691 AND t.round = 30 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 = 39353 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 73008 ORDER BY nameShow LIMIT 100