4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del FK Minyor Pernik
TEMPORADA 2023/2024
TERCERA BULGARIA V AFG GRUPO 2
Equipo PJ GF GC Puntos
1 FK Minyor Pernik Minyor 29 60 19 75
2 CSKA Sofia II CSKA Sofia 29 54 25 66
3 Vihren Vihren 30 48 38 51
4 Slivnishki Geroy Slivnishki 30 44 34 50
5 Botev Ihtiman Botev 30 49 42 49
6 Balkan Botevgrad Balkan 29 50 45 45
7 Rilski Sportist Rilski 30 43 45 42
8 Chavdar Etropole Chavdar 29 46 47 41
9 Levski Sofia II Levski Sofia 29 47 38 40
10 Kyustendil Kyustendil 29 47 39 40
11 Vitosha Bistritsa Vitosha 30 22 25 37
12 Septemvri Sofia II Septemvri 30 39 37 37
13 Septemvri Simitli Septemvri 30 40 43 36
14 CSKA 1948 Sofia III CSKA 1948 S. 30 40 43 35
15 Kostinbrod Kostinbrod 30 34 51 35
16 Bansko Bansko 30 33 42 35
17 Oborishte Oborishte 30 37 64 33
18 Slavia Sofia II Slavia Sofia 29 37 51 31
19 Pirin Razlog Pirin Razlog 29 22 47 26
20 Hebar II Hebar II 30 27 44 26
TEMPORADA 2022/2023
SEGUNDA BULGARIA B PFG
Equipo PJ GF GC Puntos
1 CSKA 1948 Sofia II CSKA 1948 S. 34 60 17 74
2 Etar Etar 34 47 22 63
3 Levski Krumovgrad Levski 34 43 33 60
4 Ludogorets II Ludogorets 34 42 35 57
5 Sportist Svoge Sportist 34 41 40 52
6 Dunav Ruse Dunav Ruse 34 47 38 50
7 Maritsa Plovdiv Maritsa 34 36 46 47
8 Litex Lovech Litex Lovech 34 32 28 44
9 Montana Montana 34 37 39 44
10 Yantra Gabrovo Yantra 34 31 34 44
11 Spartak Pleven Spartak 34 44 44 42
12 Belasitsa Belasitsa 34 33 41 41
13 Dobrudzha Dobrich Dobrudzha 34 38 40 39
14 Strumska Slava Strumska 34 35 44 39
15 FK Minyor Pernik Minyor 34 33 35 38
16 Sozopol Sozopol 34 32 52 38
17 Vitosha Bistritsa Vitosha 34 34 50 36
18 Botev Plovdiv II Botev 34 25 52 28
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
TERCERA BULGARIA V AFG GRUPO 2
Equipo PJ GF GC Puntos
1 FK Minyor Pernik Minyor 18 34 6 42
2 Septemvri Simitli Septemvri 17 31 11 41
3 Sportist Svoge Sportist 18 31 21 37
4 Vihren Vihren 18 29 14 37
5 Oborishte Oborishte 18 30 10 34
6 Kyustendil Kyustendil 18 27 17 32
7 Slivnishki Geroy Slivnishki 18 27 22 27
8 Bansko Bansko 17 26 18 26
9 Chavdar Etropole Chavdar 18 30 26 23
10 Belasitsa Belasitsa 18 21 26 22
11 Botev Ihtiman Botev 18 14 24 22
12 Nadezhda Dobroslavtsi Nadezhda 18 28 35 18
13 Pirin Razlog Pirin Razlog 18 12 22 17
14 Marek Marek 18 19 39 16
15 Balkan Botevgrad Balkan 18 16 33 15
16 Rilski Sportist Rilski 18 13 33 11
17 Perun Perun 18 9 40 7
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 2015/2016
TERCERA BULGARIA V AFG GRUPO 3
Equipo PJ GF GC Puntos
1 CSKA Sofia CSKA Sofia 32 146 10 94
2 Vitosha Bistritsa Vitosha 32 72 16 74
3 Slivnishki Geroy Slivnishki 32 80 35 69
4 Strumska Slava Strumska 32 58 36 60
5 FK Minyor Pernik Minyor 32 55 35 59
6 Vihren Vihren 32 48 36 55
7 Chiko Byaga Chiko Byaga 32 57 67 43
8 Septemvri Sofia Septemvri 32 67 62 42
9 Belasitsa Belasitsa 32 41 52 39
10 Botev Ihtiman Botev 32 52 66 37
11 Rilski Sportist Rilski 32 41 43 35
12 Velbazhd Velbazhd 32 42 56 34
13 Sofia 2010 Sofia 2010 32 51 72 34
14 Chepinets Chepinets 32 35 72 32
15 Pirin Gotse Delchev Pirin Gotse 32 33 63 28
16 Germaneya Germaneya 32 20 122 19
17 Balkan Varvara Balkan 32 25 80 17
18 Lokomotiv Sofia Lokomotiv 0 0 0 0
TEMPORADA 2014/2015
TERCERA BULGARIA V AFG GRUPO 3
Equipo PJ GF GC Puntos
1 Oborishte Oborishte 30 91 21 70
2 FK Minyor Pernik Minyor 30 56 21 65
3 Pirin Gotse Delchev Pirin Gotse 30 53 18 62
4 Vitosha Bistritsa Vitosha 30 57 22 60
5 Slivnishki Geroy Slivnishki 30 69 38 58
6 Belasitsa Belasitsa 30 48 33 51
7 Strumska Slava Strumska 30 38 36 42
8 Vihren Vihren 30 37 40 39
9 Velbazhd Velbazhd 30 38 42 37
10 Koneliano German Koneliano 30 46 80 37
11 Balkan Varvara Balkan 30 47 69 34
12 Germaneya Germaneya 30 32 55 33
13 Chepinets Chepinets 30 35 58 32
14 Rilski Sportist Rilski 30 26 46 27
15 Sportist Svoge Sportist 30 26 69 20
16 Mesta Mesta 30 15 66 15
TEMPORADA 2013/2014
TERCERA BULGARIA V AFG GRUPO 4
Equipo PJ GF GC Puntos
1 Septemvri Simitli Septemvri 15 24 7 35
2 Pirin Blagoevgrad Pirin 15 32 6 34
3 Slivnishki Geroy Slivnishki 15 32 9 33
4 FK Minyor Pernik Minyor 15 29 7 32
5 Oborishte Oborishte 15 25 16 29
6 Vihren Vihren 15 17 17 22
7 Belasitsa Belasitsa 15 19 15 20
8 Velbazhd Velbazhd 15 19 21 20
9 Mesta Mesta 15 14 25 20
10 Balkan Varvara Balkan 15 18 20 19
11 Strumska Slava Strumska 15 11 14 16
12 Sportist Svoge Sportist 15 15 21 15
13 Germaneya Germaneya 15 11 19 15
14 Chepinets Chepinets 15 17 27 14
15 Botev Ihtiman Botev 15 10 30 9
16 Septemvri Sofia Septemvri 15 9 48 6
TEMPORADA 2012/2013
LIGA BULGARIA
Equipo PJ GF GC Puntos
1 Ludogorets Ludogorets 30 58 13 72
2 Levski Sofia Levski Sofia 30 59 20 71
3 CSKA Sofia CSKA Sofia 30 54 20 63
4 Botev Plovdiv Botev 30 51 21 60
5 Litex Lovech Litex Lovech 30 56 24 50
6 Chernomoretz Burgas Chernomoretz 30 32 29 47
7 Beroe Beroe 30 36 38 45
8 Slavia Sofia Slavia Sofia 30 40 35 42
9 Lokomotiv Plovdiv Lokomotiv 30 37 34 39
10 Cherno More Varna Cherno More 30 33 39 35
11 Pirin Gotse Delchev Pirin Gotse 30 27 57 34
12 Lokomotiv Sofia Lokomotiv 30 27 38 31
13 Botev Vratsa Botev Vratsa 30 23 51 31
14 FK Minyor Pernik Minyor 30 20 49 20
15 Montana Montana 30 27 57 16
16 Etar Etar 30 20 75 13
TEMPORADA 2011/2012
LIGA BULGARIA
Equipo PJ GF GC Puntos
1 Ludogorets Ludogorets 30 73 16 70
2 CSKA Sofia CSKA Sofia 30 60 19 69
3 Levski Sofia Levski Sofia 30 61 28 62
4 Chernomoretz Burgas Chernomoretz 30 57 23 60
5 Litex Lovech Litex Lovech 30 57 28 59
6 Lokomotiv Plovdiv Lokomotiv 30 44 39 57
7 Cherno More Varna Cherno More 30 46 25 52
8 Slavia Sofia Slavia Sofia 30 42 36 51
9 FK Minyor Pernik Minyor 30 35 40 36
10 Beroe Beroe 30 30 37 35
11 Montana Montana 30 29 51 31
12 Botev Vratsa Botev Vratsa 30 30 44 29
13 Lokomotiv Sofia Lokomotiv 30 26 50 24
14 Vidima-Rakovski Vidima-Rakov 30 19 59 15
15 Kaliakra Kaliakra 30 26 77 11
16 Svetkavitsa Svetkavitsa 30 8 71 8
TEMPORADA 2010/2011
LIGA BULGARIA
Equipo PJ GF GC Puntos
1 Litex Lovech Litex Lovech 30 56 13 75
2 Levski Sofia Levski Sofia 30 67 24 72
3 CSKA Sofia CSKA Sofia 30 53 26 61
4 Lokomotiv Plovdiv Lokomotiv 30 54 28 52
5 Lokomotiv Sofia Lokomotiv 30 47 33 52
6 Cherno More Varna Cherno More 30 36 28 51
7 Beroe Beroe 30 33 34 46
8 Chernomoretz Burgas Chernomoretz 30 19 28 37
9 FK Minyor Pernik Minyor 30 33 45 36
10 Slavia Sofia Slavia Sofia 30 34 38 32
11 Montana Montana 30 30 46 32
12 Kaliakra Kaliakra 30 19 40 30
13 Pirin Blagoevgrad Pirin 30 32 39 27
14 Vidima-Rakovski Vidima-Rakov 30 26 52 25
15 Akademik Sofia Akademik 30 16 51 20
16 OFC Sliven 2000 Sliven 2000 30 22 52 19
TEMPORADA 2009/2010
LIGA BULGARIA
Equipo PJ GF GC Puntos
1 Litex Lovech Litex Lovech 30 59 17 70
2 CSKA Sofia CSKA Sofia 30 51 22 58
3 Levski Sofia Levski Sofia 30 57 26 57
4 Lokomotiv Sofia Lokomotiv 30 47 33 52
5 Chernomoretz Burgas Chernomoretz 30 44 29 51
6 Slavia Sofia Slavia Sofia 30 34 28 50
7 Cherno More Varna Cherno More 30 40 28 48
8 FK Minyor Pernik Minyor 30 38 26 45
9 Pirin Blagoevgrad Pirin 30 34 32 43
10 Beroe Beroe 30 30 36 38
11 Montana Montana 30 30 37 36
12 Lokomotiv Plovdiv Lokomotiv 30 36 52 33
13 OFC Sliven 2000 Sliven 2000 30 29 40 32
14 Lokomotiv Mezdra Lokomotiv 30 27 48 27
15 Sportist Svoge Sportist 30 23 59 19
16 Botev Plovdiv Botev 30 12 78 1
TEMPORADA 2008/2009
LIGA BULGARIA
Equipo PJ GF GC Puntos
1 Levski Sofia Levski Sofia 30 57 18 69
2 CSKA Sofia CSKA Sofia 30 54 22 68
3 Cherno More Varna Cherno More 30 48 19 60
4 Litex Lovech Litex Lovech 30 53 26 58
5 Lokomotiv Sofia Lokomotiv 30 52 29 54
6 Chernomoretz Burgas Chernomoretz 30 41 37 43
7 Lokomotiv Plovdiv Lokomotiv 30 40 43 43
8 Slavia Sofia Slavia Sofia 30 41 38 37
9 Lokomotiv Mezdra Lokomotiv 30 39 41 37
10 Pirin Blagoevgrad Pirin 30 35 50 35
11 FK Minyor Pernik Minyor 30 24 39 35
12 OFC Sliven 2000 Sliven 2000 30 32 40 32
13 Botev Plovdiv Botev 30 31 50 30
14 Vihren Vihren 30 29 50 26
15 Spartak Varna Spartak 30 19 46 25
16 Belasitsa Belasitsa 30 24 71 17
TEMPORADA 2007/2008
SEGUNDA BULGARIA B PFG GRUPO 2
Equipo PJ GF GC Puntos
1 Lokomotiv Mezdra Lokomotiv 26 56 12 63
2 FK Minyor Pernik Minyor 26 45 31 47
3 Chavdar Etropole Chavdar 26 39 23 46
4 Rilski Sportist Rilski 26 44 33 45
5 Belite Orli Belite Orli 26 33 31 38
6 Sportist Svoge Sportist 26 35 30 36
7 Montana Montana 26 29 29 34
8 Etar Etar 26 33 39 34
9 Akademik Sofia Akademik 26 41 43 32
10 Spartak Pleven Spartak 26 29 40 32
11 Pirin Gotse Delchev Pirin Gotse 26 28 33 31
12 Chavdar Byala Chavdar 26 19 34 25
13 Yantra Gabrovo Yantra 26 31 48 24
14 Velbazhd Velbazhd 26 20 56 18
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 2004/2005
SEGUNDA BULGARIA B PFG
Equipo PJ GF GC Puntos
1 Vihren Vihren 30 57 21 69
2 Botev Plovdiv Botev 30 64 21 68
3 Pirin 1992 Pirin 1992 30 63 18 67
4 Spartak Pleven Spartak 30 60 27 61
5 Rilski Sportist Rilski 30 47 35 51
6 Svetkavitsa Svetkavitsa 30 48 45 48
7 FK Minyor Pernik Minyor 30 46 42 41
8 Pomorie Pomorie 30 38 39 40
9 Panayot Volov Panayot 30 43 45 40
10 Chernomoretz Burgas Chernomoretz 30 31 40 39
11 Etar Etar 30 38 46 36
12 Dobrudzha Dobrich Dobrudzha 30 34 53 35
13 Dorostol Dorostol 30 24 43 25
14 Akademik Svishtov Akademik 30 21 52 24
15 Chernomorets Sofia Chernomorets 30 29 64 19
16 Gorna Lokomotiv Oryahovitsa Gorna 30 17 69 13

  USO DE MEMORIA  
7,745,576 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.8789
Total Execution Time  0.8800
  CADENA URL  
/historico/Fk-Minyor-Pernik
  GET DATOS  
$_GET['/historico/Fk-Minyor-Pernik']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.3234  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 = 73001
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17417 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=238 AND type_rel = 3
0.0321  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.0131  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.0604  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 = '17417' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0042  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 = 73001 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0621  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=17417 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0101  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 (73546,73001,68483,68063,67320) 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.0323  SELECT count(id) as num_players from rel_players WHERE league_id = 68063 AND teamId = 17417
0.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 73001 AND teamId = 17417
0.0179  SELECT count(id) as num_players from rel_players WHERE league_id = 68483 AND teamId = 17417
0.0080  SELECT count(id) as num_players from rel_players WHERE league_id = 73546 AND teamId = 17417
0.0169  SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 17417
0.0132  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 = 73001 AND t.round = 31 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0049  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 = '17417' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0024  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '17417' and rp.type = 4
0.0028  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 = '17417' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0124  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 = 73001 WHERE rp.league_id = 73001 AND rp.teamId = 17417 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.0112  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 = 73001 WHERE rp.league_id = 73001 AND rp.teamId = 17417 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0069  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 = 73001 WHERE rp.league_id = 73001 AND rp.teamId = 17417 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0444  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 = 17417 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0084  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 = 73001 AND t.round = 31 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0069  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 = 68063 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.0062  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 = 51127 AND t.round = 19 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0086  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.0125  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.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 `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.0101  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 = 15844 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0098  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 = 4373 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0120  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 = 3577 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135  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 `tables2013` 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 = 1934 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0092  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 = 1621 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 = 8796 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0089  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 = 8795 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0081  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 `tables2008` 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 = 14030 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0069  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