4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Bdin
TEMPORADA 2023/2024
SEGUNDA BULGARIA B PFG
Equipo PJ GF GC Puntos
1 Spartak Varna Spartak 30 51 22 63
2 Septemvri Sofia Septemvri 30 41 24 58
3 Marek Marek 30 31 21 54
4 Montana Montana 30 38 28 50
5 Dobrudzha Dobrich Dobrudzha 30 42 28 49
6 Yantra Gabrovo Yantra 30 35 32 44
7 Ludogorets II Ludogorets 30 35 30 42
8 Spartak Pleven Spartak 30 27 27 42
9 Dunav Ruse Dunav Ruse 30 27 31 42
10 Strumska Slava Strumska 30 28 28 41
11 Litex Lovech Litex Lovech 30 25 29 41
12 CSKA 1948 Sofia II CSKA 1948 S. 30 32 34 40
13 Belasitsa Belasitsa 30 33 29 37
14 Chernomorets 1919 Burgas Chernomorets 30 28 35 34
15 Sportist Svoge Sportist 30 28 39 33
16 Maritsa Plovdiv Maritsa 30 28 46 28
17 Chernomorets Balchik Chernomorets 30 28 45 27
18 Bdin Bdin 30 12 41 18
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
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
TEMPORADA 2016/2017
TERCERA BULGARIA V AFG GRUPO 3
Equipo PJ GF GC Puntos
1 Litex Lovech Litex Lovech 28 114 9 77
2 Kariana Erden Kariana 28 90 18 67
3 FC Sevlievo FC Sevlievo 28 69 33 58
4 OFK Levski OFK Levski 28 50 26 55
5 Bdin Bdin 28 82 33 52
6 Vihar Slavyanovo Vihar 28 70 29 50
7 Akademik Svishtov Akademik 28 43 41 38
8 Parva Atomna Parva Atomna 28 43 56 35
9 Pavlikeni Pavlikeni 28 42 49 34
10 Yantra Gabrovo Yantra 28 49 61 34
11 Tryavna Tryavna 28 35 50 31
12 Mizia 2005 Mizia 2005 28 38 59 31
13 Partizan Partizan 28 23 72 23
14 Kom Berkovitsa Berkovitsa 28 20 140 7
15 Juventus Malchika Juventus 28 18 110 5
TEMPORADA 2015/2016
TERCERA BULGARIA V AFG GRUPO 4
Equipo PJ GF GC Puntos
1 Etar Etar 30 100 16 82
2 Botev Vratsa Botev Vratsa 30 101 17 81
3 Akademik Svishtov Akademik 30 58 34 59
4 OFK Levski OFK Levski 30 49 33 48
5 Kariana Erden Kariana 30 49 44 47
6 Vihar Slavyanovo Vihar 30 44 38 46
7 Pavlikeni Pavlikeni 30 39 52 46
8 Partizan Partizan 30 47 40 44
9 FC Sevlievo FC Sevlievo 30 49 56 42
10 Botev Lukovit Botev 30 47 56 41
11 Tryavna Tryavna 30 36 42 36
12 Bdin Bdin 30 48 75 34
13 Juventus Malchika Juventus 30 32 62 31
14 Yantra Gabrovo Yantra 30 29 50 29
15 Parva Atomna Parva Atomna 30 23 65 15
16 Gigant Belene Gigant 30 21 92 11
TEMPORADA 2014/2015
TERCERA BULGARIA V AFG GRUPO 4
Equipo PJ GF GC Puntos
1 Spartak Pleven Spartak 26 92 8 71
2 Etar Etar 26 68 20 62
3 Akademik Svishtov Akademik 26 56 19 54
4 Bdin Bdin 26 61 35 52
5 OFK Levski OFK Levski 26 43 24 47
6 Botev Lukovit Botev 26 46 53 37
7 Yantra Gabrovo Yantra 26 43 54 32
8 Pavlikeni Pavlikeni 26 40 54 30
9 Juventus Malchika Juventus 26 37 56 30
10 Kom Berkovitsa Berkovitsa 26 43 64 30
11 Partizan Partizan 26 39 62 29
12 Vidima-Rakovski Vidima-Rakov 26 23 57 24
13 Parva Atomna Parva Atomna 26 31 45 21
14 Sitomir Sitomir 26 12 83 4
TEMPORADA 2013/2014
TERCERA BULGARIA V AFG GRUPO 3
Equipo PJ GF GC Puntos
1 Lokomotiv Mezdra Lokomotiv 23 72 19 55
2 Etar Etar 23 50 13 53
3 Botev Lukovit Botev 23 45 23 53
4 Gorna Lokomotiv Oryahovitsa Gorna 23 80 23 52
5 Spartak Pleven Spartak 23 52 22 51
6 Partizan Partizan 23 34 35 40
7 Bdin Bdin 23 36 29 32
8 Vidima-Rakovski Vidima-Rakov 23 43 31 31
9 Parva Atomna Parva Atomna 23 35 34 29
10 Gigant Belene Gigant 22 20 39 21
11 Sitomir Sitomir 23 24 46 20
12 Yantra Gabrovo Yantra 22 14 53 18
13 OFK Levski OFK Levski 23 26 50 17
14 Pavlikeni Pavlikeni 23 22 69 16
15 Kom Berkovitsa Berkovitsa 23 28 48 15
16 Tryavna Tryavna 23 14 61 14
TEMPORADA 2011/2012
SEGUNDA BULGARIA B PFG GRUPO 2
Equipo PJ GF GC Puntos
1 Pirin Gotse Delchev Pirin Gotse 27 41 12 62
2 Sportist Svoge Sportist 27 44 23 56
3 Bdin Bdin 27 42 20 51
4 Bansko Bansko 27 36 24 40
5 Chavdar Etropole Chavdar 27 36 33 39
6 Septemvri Simitli Septemvri 27 35 33 34
7 Akademik Sofia Akademik 27 25 33 31
8 Slivnishki Geroy Slivnishki 27 28 48 25
9 Malesh Malesh 27 19 38 22
10 Chavdar Byala Chavdar 27 14 56 12
TEMPORADA 2010/2011
TERCERA BULGARIA V AFG GRUPO 3
Equipo PJ GF GC Puntos
1 Bdin Bdin 30 82 17 74
2 Parva Atomna Parva Atomna 30 57 16 61
3 Lokomotiv Mezdra Lokomotiv 30 53 24 58
4 Yantra Gabrovo Yantra 30 57 34 53
5 Spartak Pleven Spartak 30 49 27 51
6 Samovodene Samovodene 30 57 25 50
7 Akademik Svishtov Akademik 30 52 29 48
8 Tryavna Tryavna 30 42 37 45
9 Sitomir Sitomir 30 39 53 41
10 Torpedo Torpedo 30 39 35 35
11 Botev Dimovo Botev Dimovo 30 25 58 32
12 Balkan Belogradchik Balkan 30 40 65 31
13 Gorna Lokomotiv Oryahovitsa Gorna 30 28 42 29
14 Gigant Belene Gigant 30 25 70 26
15 Lokomotiv Dryanovo Lokomotiv 30 17 76 23
16 OFK Levski OFK Levski 30 24 78 22
TEMPORADA 2009/2010
SEGUNDA BULGARIA B PFG GRUPO 2
Equipo PJ GF GC Puntos
1 Vidima-Rakovski Vidima-Rakov 30 53 32 60
2 Bansko Bansko 30 50 22 59
3 Akademik Sofia Akademik 30 49 37 59
4 Vihren Vihren 30 45 24 56
5 Etar Etar 30 47 38 47
6 Botev Vratsa Botev Vratsa 30 39 26 45
7 Septemvri Simitli Septemvri 30 40 34 43
8 Chavdar Etropole Chavdar 30 34 32 43
9 Balkan Botevgrad Balkan 30 35 28 41
10 Marek Marek 30 36 36 41
11 Pirin Gotse Delchev Pirin Gotse 30 35 38 40
12 Kom-Minyor Kom-Minyor 30 36 43 38
13 Botev Krivodol Botev 30 21 40 31
14 Rilski Sportist Rilski 30 32 49 30
15 Bdin Bdin 30 26 48 20
16 Belite Orli Belite Orli 30 20 71 10
TEMPORADA 2008/2009
TERCERA BULGARIA V AFG GRUPO 2
Equipo PJ GF GC Puntos
1 Botev Vratsa Botev Vratsa 29 91 12 76
2 Bdin Bdin 30 80 22 72
3 Lokomotiv Dryanovo Lokomotiv 30 65 33 59
4 Yantra Gabrovo Yantra 30 52 41 57
5 Gorna Lokomotiv Oryahovitsa Gorna 29 46 18 54
6 Gigant Belene Gigant 30 42 40 42
7 FK Marija Luiza Marija Luiza 30 45 51 39
8 Pavlikeni Pavlikeni 30 31 43 36
9 OFK Levski OFK Levski 30 36 55 36
10 Tryavna Tryavna 30 30 38 35
11 Akademik Svishtov Akademik 30 46 60 35
12 FK Storgozija Pleven Storgozija 30 38 47 32
13 Botev Dimovo Botev Dimovo 30 38 59 32
14 Sitomir Sitomir 30 33 70 30
15 FK Bali 2000 Debelec Bali 2000 D. 30 47 68 29
16 FK Chumerna Elena Chumerna 30 14 77 10
TEMPORADA 2000/2001
SEGUNDA BULGARIA B PFG
Equipo PJ GF GC Puntos
1 Spartak Pleven Spartak 32 92 25 81
2 Marek Marek 32 54 17 68
3 Pirin Blagoevgrad Pirin 32 48 21 61
4 Lokomotiv Plovdiv Lokomotiv 32 55 39 58
5 Dobrudzha Dobrich Dobrudzha 32 52 37 57
6 Nesebar Nesebar 32 51 36 54
7 Svetkavitsa Svetkavitsa 32 47 36 54
8 Vidima-Rakovski Vidima-Rakov 32 53 36 52
9 Botev Vratsa Botev Vratsa 32 56 57 46
10 Belasitsa Belasitsa 32 37 31 44
11 Dunav Ruse Dunav Ruse 32 35 38 41
12 Akademik Svishtov Akademik 32 37 37 38
13 Septemvri Sofia Septemvri 32 39 47 37
14 Metalurg Pernik Metalurg 32 36 51 36
15 FK Haskovo 2009 Haskovo 2009 32 32 60 33
16 Bdin Bdin 31 18 96 10
17 Dorostol Dorostol 31 10 88 1
18 Panayot Volov Panayot 0 0 0 0
TEMPORADA 1947/1948
LIGA BULGARIA
Equipo PJ GF GC Puntos
1 CSKA Sofia CSKA Sofia 8 20 7 21
2 Levski Sofia Levski Sofia 8 18 10 17
3 Marek Marek 6 18 12 10
4 Spartak Varna Spartak 6 12 10 10
5 Spartak Sofia Spartak 4 3 2 7
6 Lokomotiv Plovdiv Lokomotiv 4 7 8 7
7 Bdin Bdin 4 5 6 6
8 Cherno More Varna Cherno More 4 9 9 5
9 Levski Burgas Levski 2 0 2 1
10 Lokomotiv Stara Zagora Lokomotiv 2 3 7 1
11 Botev Plovdiv Botev 2 2 4 0
12 Spartak Pleven Spartak 2 1 4 0
13 Yantra Gabrovo Yantra 2 1 4 0
14 Belasitsa Belasitsa 2 0 3 0
15 Lokomotiv Ruse Lokomotiv 2 0 4 0
16 Montana Montana 2 6 13 0

  USO DE MEMORIA  
7,280,344 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.1543
Total Execution Time  0.1556
  CADENA URL  
/historico/Bdin
  GET DATOS  
$_GET['/historico/Bdin']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (43)  
0.0031  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 = 'Bdin' 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=7480 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=7480 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=7480 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=7480 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 = 72088
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=7480 AND type_rel = 2
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=237 AND type_rel = 3
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 237 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0024  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 (856187,808709,15539) ORDER BY n.cover_points DESC, update_date DESC
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 = '7480' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '7480' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0024  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 = 73790 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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 = 72088 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  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=7480 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 (73790,72088,71432,68507) 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.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 72088 AND teamId = 7480
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 68507 AND teamId = 7480
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 73790 AND teamId = 7480
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 7480
0.0021  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 = '7480' 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 = '7480' 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 = '7480' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0031  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 = 72088 WHERE rp.league_id = 72088 AND rp.teamId = 7480 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.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 = 72088 WHERE rp.league_id = 72088 AND rp.teamId = 7480 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  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 = 72088 WHERE rp.league_id = 72088 AND rp.teamId = 7480 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  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 = 7480 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 = 72088 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 = 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.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 `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.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 `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.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 `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
0.0028  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.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 `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.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 `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 = 34148 AND t.round = 30 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 `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 = 15845 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 `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 = 4372 AND t.round = 26 ORDER BY team.conference 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 `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 = 3576 AND t.round = 30 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 `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 = 1738 AND t.round = 27 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 `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 = 24592 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 `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 = 14032 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 `tables2001` 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 = 14039 AND t.round = 32 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 `tables1948` 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 = 26311 AND t.round = 4 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC