4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Maritsa Plovdiv
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
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
TERCERA BULGARIA V AFG GRUPO 1
Equipo PJ GF GC Puntos
1 Zagorets Zagorets 34 87 22 83
2 Maritsa Plovdiv Maritsa 34 79 26 83
3 Chernomorets 1919 Burgas Chernomorets 34 78 22 81
4 Rozova dolina Rozova 34 66 47 62
5 Gigant Saedinenie Gigant 34 53 30 56
6 Atletik Kuklen Atletik 34 41 35 52
7 Dimitrovgrad Dimitrovgrad 34 38 40 47
8 Levski Karlovo Levski 34 47 55 47
9 Rodopa Smolyan Rodopa 34 58 43 46
10 Izvor Gorski izvor Izvor Gorski 34 43 35 45
11 Borislav 2009 Borislav 34 50 45 43
12 Haskovo 1957 Haskovo 1957 34 31 41 40
13 Sokol Markovo Sokol 34 44 69 38
14 Karnobat Karnobat 34 35 58 37
15 Yambol 1915 Yambol 1915 34 29 52 33
16 Nesebar Nesebar 34 41 68 33
17 Spartak Plovdiv Spartak 34 35 58 30
18 Vereya Vereya 34 22 131 3
TEMPORADA 2019/2020
TERCERA BULGARIA V AFG GRUPO 1
Equipo PJ GF GC Puntos
1 Sozopol Sozopol 19 36 8 45
2 Zagorets Zagorets 19 52 15 43
3 Maritsa Plovdiv Maritsa 19 43 15 41
4 Chernomorets 1919 Burgas Chernomorets 19 30 19 36
5 Gigant Saedinenie Gigant 19 27 19 34
6 Minyor Radnevo Minyor 19 26 13 30
7 Rozova dolina Rozova 19 38 30 30
8 Svilengrad Svilengrad 19 27 19 30
9 Nesebar Nesebar 19 22 25 26
10 Borislav 2009 Borislav 19 28 33 23
11 Haskovo 1957 Haskovo 1957 19 23 29 22
12 Levski Karlovo Levski 19 18 22 21
13 Rodopa Smolyan Rodopa 19 23 33 21
14 Atletik Kuklen Atletik 19 19 30 20
15 Yambol 1915 Yambol 1915 19 17 38 16
16 Sokol Markovo Sokol 19 18 47 15
17 Karnobat Karnobat 19 17 33 14
18 Dimitrovgrad Dimitrovgrad 19 13 49 12
TEMPORADA 2018/2019
TERCERA BULGARIA V AFG GRUPO 1
Equipo PJ GF GC Puntos
1 Neftochimik Neftochimik 34 88 21 90
2 Sozopol Sozopol 34 74 27 85
3 Zagorets Zagorets 34 81 22 77
4 Chernomorets 1919 Burgas Chernomorets 34 76 35 68
5 Maritsa Plovdiv Maritsa 34 44 29 58
6 Minyor Radnevo Minyor 34 46 30 56
7 Haskovo 1957 Haskovo 1957 34 54 47 50
8 Rozova dolina Rozova 34 58 50 48
9 Atletik Kuklen Atletik 34 48 46 46
10 Sokol Markovo Sokol 34 46 58 42
11 Gigant Saedinenie Gigant 34 32 36 41
12 Borislav 2009 Borislav 34 44 47 39
13 Karnobat Karnobat 34 41 67 37
14 Levski Karlovo Levski 34 25 52 36
15 Dimitrovgrad Dimitrovgrad 34 30 54 31
16 Svilengrad Svilengrad 34 30 69 29
17 Sadovo Sadovo 34 18 90 19
18 Asenovets Asenovets 34 36 91 14
TEMPORADA 2017/2018
SEGUNDA BULGARIA B PFG
Equipo PJ GF GC Puntos
1 Botev Vratsa Botev Vratsa 30 46 20 64
2 Lokomotiv Sofia Lokomotiv 30 51 27 63
3 Tsarsko Selo Tsarsko Selo 30 56 28 63
4 Montana Montana 30 50 20 56
5 Nesebar Nesebar 30 42 43 44
6 Pomorie Pomorie 30 36 32 41
7 Botev Galabovo Botev 30 37 40 41
8 Gorna Lokomotiv Oryahovitsa Gorna 30 42 39 40
9 Ludogorets II Ludogorets 30 40 50 40
10 Litex Lovech Litex Lovech 30 26 26 39
11 Chernomorets Balchik Chernomorets 30 37 40 39
12 Strumska Slava Strumska 30 31 43 36
13 Oborishte Oborishte 30 26 32 33
14 Maritsa Plovdiv Maritsa 30 34 45 33
15 Sozopol Sozopol 30 25 47 24
16 Neftochimik Neftochimik 30 15 62 9
TEMPORADA 2016/2017
TERCERA BULGARIA V AFG GRUPO 2
Equipo PJ GF GC Puntos
1 Zagorets Zagorets 34 77 13 84
2 Maritsa Plovdiv Maritsa 34 95 25 78
3 Karnobat Karnobat 34 79 35 73
4 Rozova dolina Rozova 34 69 38 64
5 Atletik Kuklen Atletik 34 58 44 53
6 Borislav 2009 Borislav 34 60 48 50
7 Evrokolezh Evrokolezh 34 64 65 46
8 Uragan Boyadzhik Uragan 34 55 66 45
9 Asenovets Asenovets 34 50 56 44
10 Dimitrovgrad Dimitrovgrad 34 35 39 43
11 Vereya II Vereya II 34 66 76 41
12 Svilengrad Svilengrad 34 41 52 41
13 Gigant Saedinenie Gigant 34 51 71 41
14 Rakovski 2011 Rakovski 34 52 81 40
15 Minyor Radnevo Minyor 34 39 58 39
16 Arda Kardzhali Arda 34 49 69 39
17 Lyubimets Lyubimets 34 38 79 33
18 Elhovo Elhovo 34 27 90 15
TEMPORADA 2015/2016
TERCERA BULGARIA V AFG GRUPO 1
Equipo PJ GF GC Puntos
1 Nesebar Nesebar 34 88 20 90
2 Rozova dolina Rozova 34 81 30 76
3 Zagorets Zagorets 33 64 20 72
4 Uragan Boyadzhik Uragan 34 93 45 64
5 Dimitrovgrad Dimitrovgrad 34 62 38 62
6 Gigant Saedinenie Gigant 34 67 58 58
7 Svilengrad Svilengrad 33 72 53 56
8 Asenovets Asenovets 34 57 46 53
9 Maritsa Plovdiv Maritsa 34 45 29 51
10 Evrokolezh Evrokolezh 34 69 74 46
11 Karnobat Karnobat 34 56 56 43
12 Spartak Plovdiv Spartak 34 36 38 42
13 Levski Karlovo Levski 34 43 75 35
14 Rakovski 2011 Rakovski 34 45 68 34
15 Borislav 2009 Borislav 34 34 59 29
16 Minyor Radnevo Minyor 34 32 84 27
17 Chernomoretz Burgas Chernomoretz 34 42 101 22
18 Sliven Sliven 34 20 112 10
TEMPORADA 2014/2015
TERCERA BULGARIA V AFG GRUPO 1
Equipo PJ GF GC Puntos
1 Pomorie Pomorie 30 66 16 73
2 Gigant Saedinenie Gigant 30 63 25 61
3 Dimitrovgrad Dimitrovgrad 30 51 23 58
4 Rozova dolina Rozova 30 47 30 51
5 Minyor Radnevo Minyor 30 48 38 50
6 Evrokolezh Evrokolezh 30 43 33 50
7 Asenovets Asenovets 30 58 35 46
8 Zagorets Zagorets 30 50 31 46
9 Svilengrad Svilengrad 30 50 39 45
10 Nesebar Nesebar 30 47 36 43
11 Maritsa Plovdiv Maritsa 30 38 53 39
12 Tundzha Yambol Tundzha 30 34 45 35
13 Spartak Plovdiv Spartak 30 27 49 32
14 Levski Karlovo Levski 30 23 48 28
15 OFC Sliven 2000 Sliven 2000 30 26 95 15
16 FK Stara Zagora Stara Zagora 30 17 92 4
17 Elhovo Elhovo 0 0 0 0
18 Rodopa Smolyan Rodopa 0 0 0 0
TEMPORADA 2010/2011
TERCERA BULGARIA V AFG GRUPO 4
Equipo PJ GF GC Puntos
1 Botev Plovdiv Botev 38 127 15 112
2 Neftochimik Neftochimik 38 100 31 81
3 Zagorets Zagorets 38 69 37 78
4 Sozopol Sozopol 38 89 31 71
5 Gigant Saedinenie Gigant 38 66 45 70
6 Botev Galabovo Botev 38 68 39 66
7 Dimitrovgrad Dimitrovgrad 38 67 42 61
8 Svilengrad Svilengrad 38 70 66 61
9 Maritsa Plovdiv Maritsa 38 77 55 58
10 Arda Kardzhali Arda 38 71 59 54
11 Hebros Hebros 38 61 49 54
12 Tundzha Yagoda Tundzha 38 67 86 53
13 Asenovets Asenovets 38 58 63 49
14 Rodopa Smolyan Rodopa 38 63 72 47
15 Rozova dolina Rozova 38 49 58 45
16 Levski Karlovo Levski 38 39 71 43
17 Chirpan Chirpan 38 36 90 32
18 Tundzha Yambol Tundzha 38 43 106 30
19 Gabrovnitsa Gabrovnitsa 38 19 136 11
20 Stambolovo Stambolovo 38 16 104 10
TEMPORADA 2009/2010
TERCERA BULGARIA V AFG GRUPO 3
Equipo PJ GF GC Puntos
1 Ravda 1954 Ravda 1954 36 111 20 96
2 Maritsa Plovdiv Maritsa 36 101 25 96
3 Neftochimik Neftochimik 36 89 28 77
4 Botev Galabovo Botev 36 58 28 64
5 Levski Karlovo Levski 36 54 28 62
6 Sozopol Sozopol 36 58 33 62
7 Stambolovo Stambolovo 36 47 35 56
8 Arda Kardzhali Arda 36 42 38 56
9 Hebros Hebros 36 52 41 55
10 Tundzha Yagoda Tundzha 36 75 67 54
11 Gigant Saedinenie Gigant 36 51 43 54
12 Zagorets Zagorets 36 50 60 43
13 Rozova dolina Rozova 36 54 76 40
14 Dimitrovgrad Dimitrovgrad 36 43 57 38
15 Strandzha-Metalurg Strandzha-Me 36 39 71 37
16 Metalik Metalik 36 46 90 37
17 Gabrovnitsa Gabrovnitsa 36 33 98 24
18 Tundzha Yambol Tundzha 36 20 105 17
19 FK Haskovo 2009 Haskovo 2009 36 10 90 14
TEMPORADA 2008/2009
SEGUNDA BULGARIA B PFG GRUPO 1
Equipo PJ GF GC Puntos
1 Beroe Beroe 28 48 19 66
2 Chernomorets Pomorie Chernomorets 28 59 21 61
3 Kaliakra Kaliakra 28 39 28 48
4 Spartak Plovdiv Spartak 28 30 33 41
5 Dunav Ruse Dunav Ruse 28 35 34 39
6 Nesebar Nesebar 28 36 32 38
7 Lyubimets Lyubimets 28 30 29 38
8 Svetkavitsa Svetkavitsa 28 37 40 35
9 Svilengrad Svilengrad 28 32 40 34
10 Minyor Radnevo Minyor 28 35 47 33
11 Lokomotiv Stara Zagora Lokomotiv 28 31 36 32
12 Chernomorets Balchik Chernomorets 28 30 39 31
13 Rodopa Smolyan Rodopa 28 33 48 31
14 Panayot Volov Panayot 28 22 34 30
15 Maritsa Plovdiv Maritsa 28 21 38 29
TEMPORADA 2007/2008
SEGUNDA BULGARIA B PFG GRUPO 1
Equipo PJ GF GC Puntos
1 Sliven Sliven 26 63 23 60
2 Kaliakra Kaliakra 26 49 17 54
3 Rodopa Smolyan Rodopa 26 44 18 53
4 Nesebar Nesebar 26 43 29 50
5 Dunav Ruse Dunav Ruse 26 35 28 42
6 Spartak Plovdiv Spartak 26 28 34 35
7 Maritsa Plovdiv Maritsa 26 34 41 35
8 Chernomorets Pomorie Chernomorets 26 40 35 34
9 Panayot Volov Panayot 26 23 35 31
10 Svetkavitsa Svetkavitsa 26 26 46 28
11 Minyor Radnevo Minyor 26 32 50 26
12 Svilengrad Svilengrad 26 30 43 25
13 Benkovski Byala Benkovski 26 26 41 22
14 FK Haskovo 2009 Haskovo 2009 26 24 57 21
TEMPORADA 2006/2007
SEGUNDA BULGARIA B PFG GRUPO 1
Equipo PJ GF GC Puntos
1 Chernomoretz Burgas Chernomoretz 26 57 20 63
2 Chernomorets Pomorie Chernomorets 26 51 10 60
3 FK Haskovo 2009 Haskovo 2009 26 38 27 43
4 Nesebar Nesebar 26 40 32 40
5 Dunav Ruse Dunav Ruse 26 46 35 39
6 Spartak Plovdiv Spartak 26 32 28 38
7 Panayot Volov Panayot 26 29 36 37
8 Kaliakra Kaliakra 26 25 31 36
9 Svetkavitsa Svetkavitsa 26 36 41 34
10 Maritsa Plovdiv Maritsa 26 35 36 32
11 Minyor Radnevo Minyor 26 34 45 25
12 Sliven Sliven 26 32 52 23
13 Dobrudzha Dobrich Dobrudzha 26 25 51 20
14 Lokomotiv Stara Zagora Lokomotiv 26 22 58 13
TEMPORADA 2005/2006
SEGUNDA BULGARIA B PFG GRUPO 2
Equipo PJ GF GC Puntos
1 Spartak Varna Spartak 26 34 12 56
2 Maritsa Plovdiv Maritsa 26 41 21 49
3 FK Haskovo 2009 Haskovo 2009 26 37 19 48
4 Spartak Plovdiv Spartak 26 32 26 43
5 AKB Minyor AKB Minyor 26 30 32 39
6 Dunav Ruse Dunav Ruse 26 27 35 36
7 Dobrudzha Dobrich Dobrudzha 26 27 26 34
8 Nesebar Nesebar 26 37 37 34
9 Panayot Volov Panayot 26 32 33 34
10 Svetkavitsa Svetkavitsa 26 27 26 33
11 Kaliakra Kaliakra 26 27 36 32
12 Sliven Sliven 26 22 30 31
13 Pomorie Pomorie 26 22 38 24
14 Zagorets Zagorets 26 21 45 16
TEMPORADA 1996/1997
LIGA BULGARIA
Equipo PJ GF GC Puntos
1 CSKA Sofia CSKA Sofia 30 62 18 71
2 Neftochimik Neftochimik 30 70 20 67
3 Slavia Sofia Slavia Sofia 30 60 22 57
4 Levski Sofia Levski Sofia 30 57 29 53
5 Botev Plovdiv Botev 30 41 41 45
6 FK Minyor Pernik Minyor 30 28 35 44
7 Lokomotiv Sofia Lokomotiv 30 59 47 43
8 Levski Kyustendil Levski 30 51 52 42
9 Spartak Varna Spartak 30 40 41 42
10 Lokomotiv Plovdiv Lokomotiv 30 37 38 41
11 Dobrudzha Dobrich Dobrudzha 30 44 49 39
12 Spartak Pleven Spartak 30 35 45 39
13 Etar Etar 30 37 53 35
14 Maritsa Plovdiv Maritsa 30 38 45 32
15 Montana Montana 30 32 54 28
16 Vidima-Rakovski Vidima-Rakov 30 8 110 1
TEMPORADA 1970/1971
LIGA BULGARIA
Equipo PJ GF GC Puntos
1 CSKA Sofia CSKA Sofia 30 74 21 69
2 Levski Sofia Levski Sofia 30 59 22 69
3 Botev Plovdiv Botev 30 51 31 55
4 Lokomotiv Plovdiv Lokomotiv 30 55 42 49
5 Botev Vratsa Botev Vratsa 30 53 50 45
6 Slavia Sofia Slavia Sofia 30 53 41 43
7 Cherno More Varna Cherno More 30 37 42 39
8 Yantra Gabrovo Yantra 30 42 52 39
9 Spartak Pleven Spartak 30 46 47 37
10 Dunav Ruse Dunav Ruse 30 32 45 37
11 Etar Etar 30 33 49 37
12 Marek Marek 30 37 41 36
13 Tundzha Yambol Tundzha 30 26 47 33
14 Akademik Sofia Akademik 30 33 41 29
15 Chernomoretz Burgas Chernomoretz 30 33 66 25
16 Maritsa Plovdiv Maritsa 30 28 55 21
TEMPORADA 1969/1970
LIGA BULGARIA
Equipo PJ GF GC Puntos
1 Levski Sofia Levski Sofia 30 67 17 73
2 CSKA Sofia CSKA Sofia 30 73 29 68
3 Slavia Sofia Slavia Sofia 30 41 31 53
4 Botev Vratsa Botev Vratsa 30 48 34 49
5 Lokomotiv Plovdiv Lokomotiv 30 53 45 47
6 Etar Etar 30 42 36 44
7 Cherno More Varna Cherno More 30 47 34 40
8 Marek Marek 30 41 49 39
9 Chernomoretz Burgas Chernomoretz 30 33 41 39
10 Akademik Sofia Akademik 30 34 32 37
11 Spartak Pleven Spartak 30 29 53 37
12 Dunav Ruse Dunav Ruse 30 28 34 36
13 Botev Plovdiv Botev 30 34 38 34
14 Maritsa Plovdiv Maritsa 30 34 51 33
15 Beroe Beroe 30 19 64 22
16 FK Minyor Pernik Minyor 30 24 59 20
TEMPORADA 1967/1968
LIGA BULGARIA
Equipo PJ GF GC Puntos
1 Levski Sofia Levski Sofia 30 61 29 63
2 CSKA Sofia CSKA Sofia 30 63 27 60
3 Lokomotiv Sofia Lokomotiv 30 65 40 58
4 Spartak Sofia Spartak 30 49 38 54
5 Slavia Sofia Slavia Sofia 30 49 41 47
6 Botev Plovdiv Botev 30 52 49 40
7 Beroe Beroe 30 56 57 39
8 FK Minyor Pernik Minyor 30 39 59 39
9 Botev Vratsa Botev Vratsa 30 55 40 38
10 Lokomotiv Plovdiv Lokomotiv 30 47 42 38
11 Cherno More Varna Cherno More 30 43 43 36
12 Spartak Pleven Spartak 30 43 61 34
13 Chernomoretz Burgas Chernomoretz 30 35 53 34
14 Dobrudzha Dobrich Dobrudzha 30 36 50 33
15 OFC Sliven 2000 Sliven 2000 30 38 57 33
16 Maritsa Plovdiv Maritsa 30 29 74 23

  USO DE MEMORIA  
7,906,584 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.5943
Total Execution Time  0.5956
  CADENA URL  
/historico/Maritsa-Plovdiv
  GET DATOS  
$_GET['/historico/Maritsa-Plovdiv']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=20020 AND type_rel = 2
0.0134  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 = '20020' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0129  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.0139  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=20020 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0133  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) 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.0149  SELECT count(id) as num_players from rel_players WHERE league_id = 72088 AND teamId = 20020
0.0143  SELECT count(id) as num_players from rel_players WHERE league_id = 73790 AND teamId = 20020
0.0139  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 20020
0.0147  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 = 72088 AND t.round = 31 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0134  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 = '20020' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0128  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '20020' and rp.type = 4
0.0133  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 = '20020' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0159  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 = 20020 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.0160  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 = 20020 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0154  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 = 20020 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0147  SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 20020 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0145  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 = 31 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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.0146  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.0130  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 = 57215 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.0129  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 = 50571 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.0131  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 = 44689 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 38793 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 = 15842 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 4371 AND t.round = 34 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 `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 = 24594 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0140  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 = 24623 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 14024 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 14023 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 14022 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 14028 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 `tables1997` 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 = 8773 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155  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 `tables1971` 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 = 26279 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 `tables1970` 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 = 26280 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 `tables1968` 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 = 26288 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC