4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Hebar Pazardzhik

Hebar Pazardzhik

Entrenador: Lyuboslav Penev

Temporada 2023/2024
TEMPORADA 2023/2024
LIGA BULGARIA GRUPO 3
Equipo PJ GF GC Puntos
1 Beroe Beroe 31 27 42 36
2 Lokomotiv Sofia Lokomotiv 31 24 56 31
3 Hebar Pazardzhik Hebar 31 32 46 30
4 Pirin Blagoevgrad Pirin 31 24 43 30
5 Botev Vratsa Botev Vratsa 31 24 54 25
6 Etar Etar 31 17 59 14
TEMPORADA 2022/2023
LIGA BULGARIA GRUPO 3
Equipo PJ GF GC Puntos
1 Pirin Blagoevgrad Pirin 35 28 43 34
2 Hebar Pazardzhik Hebar 35 30 59 32
3 Botev Vratsa Botev Vratsa 35 29 64 32
4 Beroe Beroe 35 31 54 32
5 Septemvri Sofia Septemvri 35 31 52 28
6 Spartak Varna Spartak 35 32 65 25
TEMPORADA 2021/2022
SEGUNDA BULGARIA B PFG
Equipo PJ GF GC Puntos
1 Septemvri Sofia Septemvri 36 77 35 70
2 Spartak Varna Spartak 36 64 39 70
3 Hebar Pazardzhik Hebar 36 54 33 70
4 Etar Etar 36 69 42 68
5 FK Minyor Pernik Minyor 36 50 35 63
6 Ludogorets II Ludogorets 36 70 48 61
7 Montana Montana 36 39 31 58
8 Strumska Slava Strumska 36 40 37 54
9 Maritsa Plovdiv Maritsa 36 51 48 50
10 Sportist Svoge Sportist 36 38 46 48
11 CSKA 1948 Sofia II CSKA 1948 S. 36 53 50 45
12 Dobrudzha Dobrich Dobrudzha 36 39 45 45
13 Litex Lovech Litex Lovech 36 41 42 45
14 Yantra Gabrovo Yantra 36 30 46 40
15 Sozopol Sozopol 36 40 56 39
16 Botev Plovdiv II Botev 36 34 47 38
17 Marek Marek 36 29 46 36
18 Septemvri Simitli Septemvri 36 41 68 33
19 Levski 2020 Lom Levski 2020 36 12 77 8
20 Neftochimik Neftochimik 0 0 0 0
TEMPORADA 2020/2021
SEGUNDA BULGARIA B PFG
Equipo PJ GF GC Puntos
1 Pirin Blagoevgrad Pirin 29 63 26 62
2 Lokomotiv Sofia Lokomotiv 30 65 30 62
3 Septemvri Sofia Septemvri 29 51 29 53
4 Ludogorets II Ludogorets 30 56 38 50
5 Sportist Svoge Sportist 30 43 36 49
6 Hebar Pazardzhik Hebar 30 50 36 48
7 Sozopol Sozopol 30 35 40 39
8 Litex Lovech Litex Lovech 29 33 31 36
9 FK Minyor Pernik Minyor 29 27 37 36
10 Strumska Slava Strumska 30 31 37 34
11 Yantra Gabrovo Yantra 30 30 47 34
12 Septemvri Simitli Septemvri 30 34 42 33
13 Kariana Erden Kariana 25 29 44 31
14 Dobrudzha Dobrich Dobrudzha 29 25 46 27
15 Neftochimik Neftochimik 30 27 61 27
16 Gorna Lokomotiv Oryahovitsa Gorna 30 24 43 25
17 Vitosha Bistritsa Vitosha 0 0 0 0
TEMPORADA 2019/2020
SEGUNDA BULGARIA B PFG
Equipo PJ GF GC Puntos
1 CSKA 1948 Sofia CSKA 1948 S. 21 59 18 55
2 Septemvri Sofia Septemvri 20 47 19 52
3 Montana Montana 22 43 17 45
4 Lokomotiv Sofia Lokomotiv 22 37 18 42
5 Neftochimik Neftochimik 21 35 29 33
6 Hebar Pazardzhik Hebar 21 35 30 33
7 Litex Lovech Litex Lovech 20 29 15 32
8 Kariana Erden Kariana 20 30 24 32
9 Gorna Lokomotiv Oryahovitsa Gorna 21 32 30 29
10 Botev Galabovo Botev 22 26 32 28
11 Ludogorets II Ludogorets 22 23 25 27
12 Pirin Blagoevgrad Pirin 20 24 29 25
13 Strumska Slava Strumska 21 21 34 22
14 Chernomorets Balchik Chernomorets 20 15 27 22
15 Spartak Varna Spartak 22 9 42 13
16 Spartak Pleven Spartak 22 13 41 10
17 Pomorie Pomorie 27 15 63 6
TEMPORADA 2018/2019
TERCERA BULGARIA V AFG GRUPO 2
Equipo PJ GF GC Puntos
1 Hebar Pazardzhik Hebar 34 73 19 90
2 Oborishte Oborishte 34 60 27 75
3 Vihren Vihren 34 52 35 62
4 Slivnishki Geroy Slivnishki 34 60 35 58
5 FK Minyor Pernik Minyor 34 57 37 58
6 Bansko Bansko 34 56 37 57
7 Pirin Razlog Pirin Razlog 34 47 35 51
8 Rilski Sportist Rilski 34 47 42 49
9 Belasitsa Belasitsa 34 43 37 46
10 Marek Marek 34 35 37 41
11 Chavdar Etropole Chavdar 34 54 47 40
12 Septemvri Simitli Septemvri 34 34 36 40
13 Balkan Botevgrad Balkan 34 41 57 38
14 Sportist Svoge Sportist 34 45 61 37
15 Nadezhda Dobroslavtsi Nadezhda 34 40 61 37
16 Botev Ihtiman Botev 34 35 75 32
17 Germaneya Germaneya 34 36 70 30
18 Velbazhd Velbazhd 34 22 89 8
TEMPORADA 2017/2018
TERCERA BULGARIA V AFG GRUPO 3
Equipo PJ GF GC Puntos
1 CSKA 1948 Sofia CSKA 1948 S. 34 95 16 92
2 Hebar Pazardzhik Hebar 34 72 24 84
3 Vihren Vihren 34 70 49 62
4 FK Minyor Pernik Minyor 34 53 42 54
5 Bansko Bansko 34 48 34 53
6 Chavdar Etropole Chavdar 34 63 49 52
7 Septemvri Simitli Septemvri 34 46 37 50
8 Slivnishki Geroy Slivnishki 34 50 41 46
9 Belasitsa Belasitsa 34 40 46 42
10 Balkan Botevgrad Balkan 34 49 60 41
11 Botev Ihtiman Botev 34 41 64 40
12 Pirin Razlog Pirin Razlog 34 40 40 38
13 Svoboda Svoboda 34 37 59 38
14 Marek Marek 34 35 48 37
15 Rilski Sportist Rilski 34 40 51 36
16 Germaneya Germaneya 34 38 63 35
17 Pirin Gotse Delchev Pirin Gotse 34 27 66 32
18 OFK Elin Pelin Elin Pelin 34 34 89 21
TEMPORADA 2016/2017
TERCERA BULGARIA V AFG GRUPO 4
Equipo PJ GF GC Puntos
1 Strumska Slava Strumska 34 76 20 78
2 Septemvri Simitli Septemvri 34 62 28 72
3 FK Minyor Pernik Minyor 34 58 37 68
4 Slivnishki Geroy Slivnishki 34 69 39 59
5 Belasitsa Belasitsa 34 52 34 59
6 Hebar Pazardzhik Hebar 34 68 41 58
7 Chavdar Etropole Chavdar 34 60 46 53
8 Marek Marek 34 51 50 52
9 Rilski Sportist Rilski 34 53 61 43
10 Pirin Gotse Delchev Pirin Gotse 34 45 41 42
11 Pirin Razlog Pirin Razlog 34 36 55 41
12 Balkan Botevgrad Balkan 34 54 55 40
13 Germaneya Germaneya 34 52 52 38
14 Botev Ihtiman Botev 34 49 72 38
15 Svoboda Svoboda 34 36 75 37
16 Vihren Vihren 34 36 46 37
17 Velbazhd Kyustendil Velbazhd 34 44 63 32
18 Chepinets Chepinets 34 33 119 18
TEMPORADA 2011/2012
TERCERA BULGARIA V AFG GRUPO 4
Equipo PJ GF GC Puntos
1 Pirin Razlog Pirin Razlog 36 93 20 93
2 Perun Perun 36 83 20 89
3 Rilski Sportist Rilski 36 66 29 68
4 Oborishte Oborishte 36 76 35 67
5 Marek Marek 36 62 31 63
6 Vitosha Bistritsa Vitosha 36 53 36 61
7 Velbazhd Velbazhd 36 57 54 57
8 Germaneya Germaneya 36 50 51 52
9 Chepinets Chepinets 36 68 50 49
10 Belasitsa Belasitsa 36 54 47 48
11 Mesta Mesta 36 51 51 46
12 Kostinbrod Kostinbrod 36 42 50 46
13 Septemvri Sofia Septemvri 36 38 49 44
14 Hebar 2011 Hebar 2011 71 61 218 43
15 Minyor Bobov dol Minyor Bobov 36 45 62 42
16 Vitosha Dolna Dikanya Vitosha 36 48 68 42
17 Strumska Slava Strumska 36 44 63 36
18 Levski Elin Pelin Levski Elin 35 28 85 20
19 Balkan Botevgrad Balkan 0 0 0 0
TEMPORADA 2010/2011
TERCERA BULGARIA V AFG GRUPO 1
Equipo PJ GF GC Puntos
1 Slivnishki Geroy Slivnishki 38 108 24 93
2 Pirin Razlog Pirin Razlog 38 89 28 85
3 Vitosha Bistritsa Vitosha 38 70 24 85
4 Perun Perun 38 89 31 79
5 Mesta Mesta 38 71 38 69
6 Kostinbrod Kostinbrod 38 82 47 61
7 Lokomotiv Septemvri Lokomotiv 38 75 55 59
8 Balkan Botevgrad Balkan 38 61 51 56
9 Septemvri Sofia Septemvri 38 59 54 56
10 Velbazhd Velbazhd 38 73 59 54
11 Minyor Bobov dol Minyor Bobov 38 62 58 54
12 Vitosha Dolna Dikanya Vitosha 38 58 53 53
13 Benkovski Pazardzhik Benkovski 38 57 57 48
14 Strumska Slava Strumska 38 57 78 47
15 Chepinets Chepinets 38 49 75 42
16 Germaneya Germaneya 38 39 58 39
17 Levski Elin Pelin Levski Elin 38 52 100 36
18 Hebar Pazardzhik Hebar 38 54 93 32
19 Botev Ihtiman Botev 37 20 133 16
20 Avangard Avangard 37 37 146 14
TEMPORADA 2009/2010
TERCERA BULGARIA V AFG GRUPO 4
Equipo PJ GF GC Puntos
1 Malesh Malesh 36 96 27 91
2 Minyor Bobov dol Minyor Bobov 36 60 15 78
3 Slivnishki Geroy Slivnishki 36 79 34 75
4 Pirin Razlog Pirin Razlog 36 59 25 68
5 Benkovski Pazardzhik Benkovski 36 53 38 59
6 Vitosha Bistritsa Vitosha 36 49 50 55
7 Perun Perun 36 46 44 53
8 Strumska Slava Strumska 36 55 43 51
9 Germaneya Germaneya 36 37 47 45
10 Belasitsa Belasitsa 36 40 51 45
11 Mesta Mesta 36 55 67 42
12 Vitosha Dolna Dikanya Vitosha 36 39 61 42
13 Botev Ihtiman Botev 36 42 77 39
14 Chepinets Chepinets 36 62 88 37
15 Levski Elin Pelin Levski Elin 36 52 72 36
16 Kostinbrod Kostinbrod 36 45 67 36
17 Hebar Pazardzhik Hebar 36 50 75 36
18 Velbazhd Velbazhd 36 44 61 35
19 Novi Iskar Novi Iskar 36 30 51 35
TEMPORADA 2008/2009
TERCERA BULGARIA V AFG GRUPO 1
Equipo PJ GF GC Puntos
1 Septemvri Simitli Septemvri 38 75 28 90
2 Malesh Malesh 38 83 30 88
3 Minyor Bobov dol Minyor Bobov 38 83 32 86
4 Levski Elin Pelin Levski Elin 38 70 44 66
5 Hebar Pazardzhik Hebar 38 55 42 66
6 FK Bansko 1951 Bansko 1951 38 60 30 62
7 Strumska Slava Strumska 38 64 43 57
8 Vitosha Bistritsa Vitosha 38 58 52 53
9 Mesta Mesta 38 57 63 48
10 Germaneya Germaneya 38 40 62 48
11 Slivnishki Geroy Slivnishki 38 40 48 47
12 Velbazhd Velbazhd 38 49 48 46
13 Velbazhd Kyustendil Velbazhd 38 40 56 44
14 Minyor 1919 Minyor 1919 38 49 59 43
15 Pirin Razlog Pirin Razlog 38 49 63 42
16 Chepinets Chepinets 38 42 70 41
17 Pirin 2001 Blagoevgrad Pirin 2001. 38 38 57 40
18 Botev Ihtiman Botev 38 41 78 39
19 FK Ljulin Sofia Ljulin Sofia 38 44 71 36
20 FK Levski Dolna Banja Levski Dolna 38 32 93 29
TEMPORADA 2006/2007
SEGUNDA BULGARIA B PFG GRUPO 2
Equipo PJ GF GC Puntos
1 Pirin Blagoevgrad Pirin 26 41 11 60
2 Vidima-Rakovski Vidima-Rakov 26 50 24 53
3 Pirin Gotse Delchev Pirin Gotse 26 38 30 42
4 Vikhar Gorublyane Vikhar 26 33 27 40
5 Spartak Pleven Spartak 26 32 27 38
6 Etar Etar 26 36 34 35
7 FK Minyor Pernik Minyor 26 30 32 32
8 Montana Montana 26 30 33 32
9 Chavdar Byala Chavdar 26 28 32 32
10 Velbazhd Velbazhd 26 37 44 32
11 Belite Orli Belite Orli 26 27 30 31
12 Lokomotiv Mezdra Lokomotiv 26 27 42 29
13 Hebar Pazardzhik Hebar 26 22 41 25
14 Minyor Bobov dol Minyor Bobov 26 18 42 21
TEMPORADA 2005/2006
SEGUNDA BULGARIA B PFG GRUPO 1
Equipo PJ GF GC Puntos
1 Chernomoretz Burgas Chernomoretz 26 54 15 62
2 Rilski Sportist Rilski 26 53 25 61
3 Spartak Pleven Spartak 26 58 18 59
4 Vidima-Rakovski Vidima-Rakov 26 39 26 43
5 Belite Orli Belite Orli 26 34 32 38
6 Pirin Gotse Delchev Pirin Gotse 26 39 26 37
7 Hebar Pazardzhik Hebar 26 35 35 33
8 Etar Etar 26 31 39 30
9 Minyor Bobov dol Minyor Bobov 26 34 37 29
10 Lokomotiv Mezdra Lokomotiv 26 25 46 27
11 Montana Montana 26 23 47 26
12 FK Minyor Pernik Minyor 26 25 43 24
13 Yantra Gabrovo Yantra 26 23 52 22
14 Balkan Botevgrad Balkan 26 11 43 19
TEMPORADA 2000/2001
LIGA BULGARIA
Equipo PJ GF GC Puntos
1 Levski Sofia Levski Sofia 26 63 13 69
2 CSKA Sofia CSKA Sofia 26 65 16 62
3 Velbazhd Velbazhd 26 48 29 57
4 Litex Lovech Litex Lovech 26 70 23 55
5 Neftochimik Neftochimik 26 47 34 42
6 Slavia Sofia Slavia Sofia 26 35 35 35
7 Spartak Varna Spartak 26 38 40 34
8 Lokomotiv Sofia Lokomotiv 26 37 37 33
9 Hebar Pazardzhik Hebar 26 39 55 26
10 Cherno More Varna Cherno More 26 20 49 26
11 Chernomoretz Burgas Chernomoretz 26 22 48 22
12 Beroe Beroe 26 21 47 22
13 Botev Plovdiv Botev 26 28 55 20
14 FK Minyor Pernik Minyor 26 19 71 13
TEMPORADA 1991/1992
LIGA BULGARIA
Equipo PJ GF GC Puntos
1 CSKA Sofia CSKA Sofia 30 74 26 67
2 Levski Sofia Levski Sofia 30 54 18 64
3 Lokomotiv Plovdiv Lokomotiv 30 42 22 51
4 Botev Plovdiv Botev 30 46 27 50
5 Etar Etar 30 35 18 49
6 Sliven Sliven 30 37 39 44
7 Beroe Beroe 30 32 41 40
8 Lokomotiv Sofia Lokomotiv 30 38 40 39
9 Yantra Gabrovo Yantra 30 24 33 35
10 Gorna Lokomotiv Oryahovitsa Gorna 30 23 39 35
11 Slavia Sofia Slavia Sofia 30 33 31 34
12 Chernomoretz Burgas Chernomoretz 30 28 43 33
13 Dobrudzha Dobrich Dobrudzha 30 29 48 31
14 Pirin Blagoevgrad Pirin 30 22 34 30
15 FK Minyor Pernik Minyor 30 19 51 24
16 Hebar Pazardzhik Hebar 30 17 43 20
TEMPORADA 1989/1990
LIGA BULGARIA
Equipo PJ GF GC Puntos
1 CSKA Sofia CSKA Sofia 30 85 30 63
2 Lokomotiv Sofia Lokomotiv 30 53 40 50
3 Etar Etar 30 51 32 49
4 Slavia Sofia Slavia Sofia 30 37 29 49
5 Botev Plovdiv Botev 30 43 39 48
6 Levski Sofia Levski Sofia 30 57 39 47
7 Pirin Blagoevgrad Pirin 30 46 32 47
8 Sliven Sliven 30 41 44 41
9 Gorna Lokomotiv Oryahovitsa Gorna 30 28 32 41
10 Chernomoretz Burgas Chernomoretz 30 36 41 40
11 Beroe Beroe 30 43 48 39
12 Dunav Ruse Dunav Ruse 30 30 38 36
13 Lokomotiv Plovdiv Lokomotiv 30 30 47 36
14 Hebar Pazardzhik Hebar 30 29 43 35
15 Cherno More Varna Cherno More 30 28 63 22
16 Botev Vratsa Botev Vratsa 30 25 65 20

  USO DE MEMORIA  
7,205,056 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1610
Total Execution Time  0.1622
  CADENA URL  
/historico/Hebar
  GET DATOS  
$_GET['/historico/Hebar']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (49)  
0.0032  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 = 'Hebar' 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=59507 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=59507 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=59507 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=59507 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0017  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=59507 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0039  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 = 75897
0.0025  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 = 72087
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=59507 AND type_rel = 2
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=205 AND type_rel = 3
0.0022  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 205 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0021  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 (1296295,1294106,1220390,1193443,1177533) ORDER BY n.cover_points DESC, update_date DESC
0.0026  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 = '59507' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0028  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 = '59507' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  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 = 75897 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 = 73790 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0027  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=59507 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (75897,73790,71432) 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.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 75897 AND teamId = 59507
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 73790 AND teamId = 59507
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 59507
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 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 = 75897 AND t.round = 2 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0023  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 = '59507' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '59507' and rp.type = 4
0.0021  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 = '59507' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0038  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 = 75897 WHERE rp.league_id = 75897 AND rp.teamId = 59507 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.0026  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 = 75897 WHERE rp.league_id = 75897 AND rp.teamId = 59507 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 = 75897 WHERE rp.league_id = 75897 AND rp.teamId = 59507 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027  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 = 59507 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 75897 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.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 `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 = 71635 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.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 = 63160 AND t.round = 38 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 = 57213 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 `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 = 50137 AND t.round = 28 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 `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 = 44690 AND t.round = 34 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 `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 = 39352 AND t.round = 34 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 `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 = 34149 AND t.round = 34 ORDER BY team.conference 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 `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 = 24584 AND t.round = 38 ORDER BY team.conference 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 `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 = 24587 AND t.round = 38 ORDER BY team.conference 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 `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 = 24624 AND t.round = 38 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 `tables2009` 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 = 24626 AND t.round = 38 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 `tables2007` 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 = 14029 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 `tables2006` 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 = 14021 AND t.round = 26 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 = 8780 AND t.round = 26 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 `tables1992` 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 = 26185 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 `tables1990` 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 = 26190 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  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 = 75897 ORDER BY nameShow LIMIT 100