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

Obolon

Entrenador: Valeri Ivashchenko

Temporada 2019/2020
TEMPORADA 2019/2020
SEGUNDA UCRANIA
Equipo PJ GF GC Puntos
1 Minai Minai 30 51 28 62
2 Inhulets Inhulets 30 47 22 60
3 Ahrobiznes Volochysk Ahrobiznes 30 52 30 60
4 Rukh Lviv Rukh Lviv 29 48 21 58
5 Volyn Lutsk Volyn Lutsk 30 57 36 57
6 Obolon Obolon 30 40 31 51
7 Metalist 1925 Kharkiv Metalist 30 44 34 51
8 Avanhard Kramatorsk Avanhard 30 37 40 45
9 Hirnyk-Sport Hirnyk-Sport 30 42 48 39
10 Chornomorets Odessa Chornomorets 30 40 37 39
11 MFK Mykolaiv Mykolaiv 30 45 45 34
12 FC Prykarpattia Prykarpattia 30 44 51 30
13 Kremin Kremin 30 35 57 27
14 Balkany Zorya Balkany 30 27 51 25
15 Metalurh Zaporizhya Metalurh 29 28 55 22
16 Cherkashchyna-Akademiya Cherkashchyn 30 23 74 7
TEMPORADA 2018/2019
SEGUNDA UCRANIA
Equipo PJ GF GC Puntos
1 Dnipro-1 Dnipro-1 28 72 21 67
2 Volyn Lutsk Volyn Lutsk 28 55 30 58
3 Kolos Kovalivka Kolos 28 49 18 54
4 Metalist 1925 Kharkiv Metalist 27 35 20 48
5 Avanhard Kramatorsk Avanhard 27 44 26 45
6 Obolon Obolon 27 35 28 44
7 Inhulets Inhulets 27 35 32 39
8 MFK Mykolaiv Mykolaiv 28 36 32 37
9 Balkany Zorya Balkany 27 28 31 35
10 Rukh Lviv Rukh Lviv 28 37 36 34
11 FC Prykarpattia Prykarpattia 27 41 39 31
12 Hirnyk-Sport Hirnyk-Sport 27 24 43 24
13 Sumy Sumy 27 21 88 16
14 Ahrobiznes Volochysk Ahrobiznes 26 14 36 13
15 Zirka Kirovohrad Zirka 17 10 49 4
16 Helios Kharkiv Helios 3 1 8 0
TEMPORADA 2017/2018
SEGUNDA UCRANIA
Equipo PJ GF GC Puntos
1 Arsenal Kyiv Arsenal Kyiv 34 59 23 75
2 Poltava Poltava 34 56 26 72
3 Desna Chernihiv Desna 34 71 25 71
4 Inhulets Inhulets 34 46 20 69
5 Kolos Kovalivka Kolos 34 39 30 61
6 Avanhard Kramatorsk Avanhard 34 44 42 52
7 Hirnyk-Sport Hirnyk-Sport 34 30 40 50
8 Rukh Lviv Rukh Lviv 33 36 30 48
9 Helios Kharkiv Helios 33 35 43 46
10 MFK Mykolaiv Mykolaiv 34 39 50 44
11 Balkany Zorya Balkany 34 30 35 40
12 Sumy Sumy 33 29 39 37
13 Volyn Lutsk Volyn Lutsk 34 31 44 36
14 Naftovyk-Ukrnafta Okhtyrka Naftovyk-Ukr 34 27 42 33
15 Obolon Obolon 33 24 37 32
16 Cherkashchyna-Akademiya Cherkashchyn 34 29 49 29
17 Kremin Kremin 33 25 54 29
18 Zhemchuzhyna Odesa Zhemchuzhyna 31 33 54 27
TEMPORADA 2016/2017
SEGUNDA UCRANIA
Equipo PJ GF GC Puntos
1 FC Mariupol FC Mariupol 34 61 21 81
2 Desna Chernihiv Desna 34 55 23 74
3 Veres Rivne Veres Rivne 34 62 32 67
4 Helios Kharkiv Helios 34 31 22 58
5 Kolos Kovalivka Kolos 34 52 38 57
6 Naftovyk-Ukrnafta Okhtyrka Naftovyk-Ukr 34 47 29 54
7 Avanhard Kramatorsk Avanhard 34 32 28 52
8 Cherkashchyna-Akademiya Cherkashchyn 34 30 29 48
9 Obolon Obolon 34 37 37 45
10 Arsenal Kyiv Arsenal Kyiv 34 38 39 45
11 Hirnyk-Sport Hirnyk-Sport 34 47 54 43
12 Poltava Poltava 34 33 43 40
13 Inhulets Inhulets 34 33 45 38
14 MFK Mykolaiv Mykolaiv 34 35 44 37
15 Sumy Sumy 34 34 44 36
16 Bukovyna Chernivtsi Bukovyna 34 27 40 33
17 Skala Stryi Skala Stryi 34 25 58 20
18 Ternopil' Ternopil' 34 17 70 15
TEMPORADA 2015/2016
SEGUNDA UCRANIA
Equipo PJ GF GC Puntos
1 Zirka Kirovohrad Zirka 30 52 22 65
2 Cherkashchyna-Akademiya Cherkashchyn 30 45 27 55
3 Obolon Obolon 30 48 35 54
4 FC Mariupol FC Mariupol 30 37 24 53
5 Helios Kharkiv Helios 30 36 24 51
6 Hirnyk Hirnyk 30 42 27 49
7 MFK Mykolaiv Mykolaiv 30 38 27 44
8 Desna Chernihiv Desna 30 33 30 40
9 Naftovyk-Ukrnafta Okhtyrka Naftovyk-Ukr 30 34 33 40
10 Poltava Poltava 30 32 32 38
11 Dynamo Kyiv II Dynamo Kyiv 30 30 34 36
12 Hirnyk-Sport Hirnyk-Sport 30 30 35 33
13 Avanhard Kramatorsk Avanhard 30 32 42 32
14 Sumy Sumy 30 35 54 30
15 Ternopil' Ternopil' 30 21 47 22
16 Nyva Ternopil Nyva 30 10 62 7
TEMPORADA 2014/2015
TERCERA UCRANIA
Equipo PJ GF GC Puntos
1 Cherkashchyna-Akademiya Cherkashchyn 27 53 12 65
2 Obolon Obolon 27 47 19 64
3 Kremin Kremin 27 50 30 48
4 Real Pharma Real Pharma 27 40 29 42
5 Skala Stryi Skala Stryi 27 29 34 38
6 Krystal Krystal 27 39 37 36
7 Shakhtar Donetsk III Shakhtar 27 38 43 30
8 Makiyivvuhillya Makiyivvuhil 27 23 45 21
9 Arsenal Bila Tserkva Arsenal Bila 27 14 40 20
10 Enerhiya Nova Kakhovka Enerhiya 27 25 69 15
TEMPORADA 2013/2014
TERCERA UCRANIA
Equipo PJ GF GC Puntos
1 Hirnyk-Sport Hirnyk-Sport 36 68 31 75
2 Stal Dniprodzerzhynsk Stal 36 81 32 73
3 Ternopil' Ternopil' 36 56 27 67
4 Hirnyk Hirnyk 36 49 36 64
5 Kremin Kremin 36 54 28 62
6 Shakhtar Sverdlovsk Shakhtar 36 48 29 61
7 Obolon Obolon 36 51 34 56
8 Cherkashchyna-Akademiya Cherkashchyn 35 46 33 56
9 Shakhtar Donetsk III Shakhtar 35 47 50 48
10 Myr Myr 35 32 27 47
11 Krystal Krystal 36 51 48 47
12 Enerhiya Mykolajiv Enerhiya 34 24 28 42
13 Karlivka Karlivka 35 31 45 38
14 Real Pharma Real Pharma 35 27 57 38
15 Nikopol Nikopol 35 33 47 36
16 Arsenal Bila Tserkva Arsenal Bila 36 27 57 32
17 Dynamo Khmelnytskyi Dynamo 35 18 52 25
18 Enerhiya Nova Kakhovka Enerhiya 36 38 85 25
19 Skala Stryi Skala Stryi 35 22 57 21
TEMPORADA 2012/2013
SEGUNDA UCRANIA
Equipo PJ GF GC Puntos
1 Sevastopol Sevastopol 34 74 22 74
2 Stal Alchevsk Stal 34 58 35 66
3 Oleksandriya Oleksandriya 34 51 35 60
4 Bukovyna Chernivtsi Bukovyna 34 49 33 58
5 MFK Mykolaiv Mykolaiv 34 48 41 57
6 Naftovyk-Ukrnafta Okhtyrka Naftovyk-Ukr 34 42 31 54
7 Avanhard Kramatorsk Avanhard 34 40 26 53
8 Zirka Kirovohrad Zirka 34 49 37 52
9 Sumy Sumy 34 32 35 50
10 Helios Kharkiv Helios 34 36 21 49
11 Olimpik Donetsk Olimpik 34 37 37 49
12 Tytan Armyansk Tytan 34 44 40 48
13 Poltava Poltava 34 38 35 45
14 Krymteplytsia Krymteplytsi 34 33 45 35
15 Dynamo Kyiv II Dynamo Kyiv 34 34 55 30
16 FK Odessa FK Odessa 34 24 63 24
17 Obolon Obolon 34 19 67 22
18 Arsenal Bila Tserkva Arsenal Bila 34 26 76 20
TEMPORADA 2011/2012
LIGA UCRANIANA
Equipo PJ GF GC Puntos
1 Shakhtar Donetsk Shakhtar 30 80 18 79
2 Dynamo Kyiv Dynamo Kyiv 30 56 12 75
3 Metalist Kharkiv Metalist 30 54 32 59
4 Dnipro Dnipropetrovsk Dnipro 30 52 35 52
5 Arsenal Kyiv Arsenal Kyiv 30 44 27 51
6 Tavriya Simferopol Tavriya 30 43 36 45
7 Metalurh Donetsk Metalurh 30 35 34 42
8 Vorskla Poltava Vorskla 30 38 43 37
9 Chornomorets Odessa Chornomorets 30 32 42 37
10 Kryvbas Kryvbas 30 22 38 33
11 FC Mariupol FC Mariupol 30 28 42 32
12 Volyn Lutsk Volyn Lutsk 30 25 43 27
13 Zorya Luhansk Zorya 30 34 58 26
14 Karpaty Lviv Karpaty Lviv 30 27 51 23
15 Obolon Obolon 30 17 42 21
16 Oleksandriya Oleksandriya 30 24 58 20
TEMPORADA 2010/2011
LIGA UCRANIANA
Equipo PJ GF GC Puntos
1 Shakhtar Donetsk Shakhtar 30 53 16 72
2 Dynamo Kyiv Dynamo Kyiv 30 60 24 65
3 Metalist Kharkiv Metalist 30 58 26 60
4 Dnipro Dnipropetrovsk Dnipro 30 46 20 57
5 Karpaty Lviv Karpaty Lviv 30 41 34 48
6 Vorskla Poltava Vorskla 30 37 32 39
7 Tavriya Simferopol Tavriya 30 44 46 39
8 Metalurh Donetsk Metalurh 30 36 45 38
9 Arsenal Kyiv Arsenal Kyiv 30 36 38 37
10 Obolon Obolon 30 26 38 34
11 Volyn Lutsk Volyn Lutsk 30 27 49 34
12 Zorya Luhansk Zorya 30 28 40 30
13 Kryvbas Kryvbas 30 27 45 29
14 Illychivets Illychivets 30 45 67 29
15 Sevastopol Sevastopol 30 26 48 27
16 Metalurh Zaporizhya Metalurh 30 18 40 24
TEMPORADA 2009/2010
LIGA UCRANIANA
Equipo PJ GF GC Puntos
1 Shakhtar Donetsk Shakhtar 30 62 18 77
2 Dynamo Kyiv Dynamo Kyiv 30 61 16 71
3 Metalist Kharkiv Metalist 30 49 23 62
4 Dnipro Dnipropetrovsk Dnipro 30 48 25 54
5 Karpaty Lviv Karpaty Lviv 30 44 35 50
6 Tavriya Simferopol Tavriya 30 38 38 45
7 Arsenal Kyiv Arsenal Kyiv 30 44 41 42
8 Metalurh Donetsk Metalurh 30 41 33 40
9 Metalurh Zaporizhya Metalurh 30 31 48 35
10 Vorskla Poltava Vorskla 30 29 32 31
11 Obolon Obolon 30 26 50 31
12 FC Mariupol FC Mariupol 30 31 56 29
13 Zorya Luhansk Zorya 30 23 47 28
14 Kryvbas Kryvbas 30 31 47 25
15 Chornomorets Odessa Chornomorets 30 21 44 24
16 Hoverla Uzhhorod Hoverla 30 18 44 19
TEMPORADA 2008/2009
SEGUNDA UCRANIA
Equipo PJ GF GC Puntos
1 Hoverla Uzhhorod Hoverla 30 50 26 63
2 Obolon Obolon 30 70 39 59
3 Oleksandriya Oleksandriya 30 43 28 51
4 Sevastopol Sevastopol 30 44 36 50
5 Volyn Lutsk Volyn Lutsk 31 49 45 47
6 Dynamo Kyiv II Dynamo Kyiv 30 45 39 46
7 Krymteplytsia Krymteplytsi 30 40 36 46
8 Desna Chernihiv Desna 30 32 29 46
9 Ihroservice Simferopol Ihroservice 30 44 42 42
10 FK Odessa FK Odessa 30 39 39 40
11 Stal Alchevsk Stal 30 35 37 40
12 Naftovyk-Ukrnafta Okhtyrka Naftovyk-Ukr 30 41 41 37
13 Feniks-Illichovets Feniks-Illic 30 35 37 37
14 FC Prykarpattia Prykarpattia 30 27 51 27
15 Helios Kharkiv Helios 30 27 42 26
16 Enerhetyk Burshtyn Enerhetyk 30 28 42 25
17 Knyazha Shchaslyve Knyazha 31 22 62 20
TEMPORADA 2007/2008
SEGUNDA UCRANIA
Equipo PJ GF GC Puntos
1 FC Mariupol FC Mariupol 38 65 26 85
2 FC Lviv FC Lviv 38 58 29 74
3 Obolon Obolon 38 67 42 72
4 Desna Chernihiv Desna 38 61 44 67
5 Dynamo Kyiv II Dynamo Kyiv 38 64 52 63
6 Ihroservice Simferopol Ihroservice 38 50 45 60
7 Stal Alchevsk Stal 38 52 44 58
8 Volyn Lutsk Volyn Lutsk 38 61 55 56
9 Oleksandriya Oleksandriya 38 41 32 55
10 MFK Mykolaiv Mykolaiv 38 33 27 52
11 Krymteplytsia Krymteplytsi 38 49 43 50
12 FK Odessa FK Odessa 38 33 39 49
13 Enerhetyk Burshtyn Enerhetyk 38 39 44 48
14 Helios Kharkiv Helios 38 31 41 47
15 Sevastopol Sevastopol 38 38 55 43
16 Cherkashchyna-Akademiya Cherkashchyn 38 43 43 42
17 Feniks-Illichovets Feniks-Illic 38 35 56 41
18 FC Prykarpattia Prykarpattia 38 37 67 39
19 CSKA Kyiv CSKA Kyiv 38 36 74 27
20 Stal Dniprodzerzhynsk Stal 38 23 58 20
TEMPORADA 2006/2007
SEGUNDA UCRANIA
Equipo PJ GF GC Puntos
1 Naftovyk-Ukrnafta Okhtyrka Naftovyk-Ukr 36 61 29 81
2 Hoverla Uzhhorod Hoverla 36 56 22 80
3 Obolon Obolon 36 50 27 73
4 Krymteplytsia Krymteplytsi 36 56 37 70
5 Oleksandriya Oleksandriya 36 41 27 61
6 Dynamo Kyiv II Dynamo Kyiv 36 56 37 59
7 Helios Kharkiv Helios 36 47 35 58
8 Enerhetyk Burshtyn Enerhetyk 36 47 33 56
9 Ihroservice Simferopol Ihroservice 36 49 44 51
10 Stal Dniprodzerzhynsk Stal 36 42 37 51
11 FC Lviv FC Lviv 36 44 44 47
12 MFK Mykolaiv Mykolaiv 36 36 40 46
13 Volyn Lutsk Volyn Lutsk 36 43 48 46
14 Desna Chernihiv Desna 36 54 58 41
15 Cherkashchyna-Akademiya Cherkashchyn 36 34 46 39
16 CSKA Kyiv CSKA Kyiv 36 27 44 38
17 Spartak Ivano-Frankivsk Spartak 36 27 52 33
18 Dynamo Khmelnytskyi Dynamo 36 20 63 10
19 Borysfen Borysfen 36 10 77 2
TEMPORADA 2005/2006
SEGUNDA UCRANIA
Equipo PJ GF GC Puntos
1 Zorya Luhansk Zorya 34 74 13 87
2 Karpaty Lviv Karpaty Lviv 33 53 14 80
3 Obolon Obolon 34 51 19 72
4 Naftovyk-Ukrnafta Okhtyrka Naftovyk-Ukr 33 53 35 55
5 Dynamo Kyiv II Dynamo Kyiv 34 51 36 52
6 Gazovik-Skala Gazovik-Skal 34 35 33 52
7 Dynamo Khmelnytskyi Dynamo 34 42 37 49
8 Stal Dniprodzerzhynsk Stal 34 37 29 48
9 Krymteplytsia Krymteplytsi 34 35 34 47
10 Spartak Ivano-Frankivsk Spartak 33 36 31 45
11 Shakhtar Donetsk II Shakhtar 34 40 42 44
12 Helios Kharkiv Helios 34 27 35 44
13 Ihroservice Simferopol Ihroservice 34 40 51 38
14 Enerhetyk Burshtyn Enerhetyk 34 31 44 36
15 CSKA Kyiv CSKA Kyiv 34 28 52 32
16 Borysfen Borysfen 34 23 46 23
17 Spartak Sumy Spartak Sumy 33 31 69 20
18 Nyva Bershad Nyva Bershad 34 14 81 4
TEMPORADA 2004/2005
LIGA UCRANIANA
Equipo PJ GF GC Puntos
1 Shakhtar Donetsk Shakhtar 30 63 19 80
2 Dynamo Kyiv Dynamo Kyiv 30 58 14 73
3 Metalurh Donetsk Metalurh 30 38 35 49
4 Dnipro Dnipropetrovsk Dnipro 30 38 34 48
5 FC Mariupol FC Mariupol 30 38 34 44
6 Chornomorets Odessa Chornomorets 30 29 29 42
7 Tavriya Simferopol Tavriya 29 34 28 42
8 Volyn Lutsk Volyn Lutsk 30 35 37 40
9 Arsenal Kyiv Arsenal Kyiv 30 30 33 37
10 Metalurh Zaporizhya Metalurh 30 25 32 35
11 Metalist Kharkiv Metalist 30 25 37 34
12 Hoverla Uzhhorod Hoverla 29 21 30 31
13 Kryvbas Kryvbas 30 24 38 31
14 Vorskla Poltava Vorskla 29 18 35 30
15 Obolon Obolon 30 18 43 21
16 Borysfen Borysfen 29 15 31 20
TEMPORADA 2003/2004
LIGA UCRANIANA
Equipo PJ GF GC Puntos
1 Dynamo Kyiv Dynamo Kyiv 30 68 20 73
2 Shakhtar Donetsk Shakhtar 30 62 19 70
3 Dnipro Dnipropetrovsk Dnipro 30 44 23 57
4 Metalurh Donetsk Metalurh 30 51 34 52
5 Chornomorets Odessa Chornomorets 30 38 33 45
6 Obolon Obolon 30 34 35 41
7 Borysfen Borysfen 30 25 29 41
8 FC Mariupol FC Mariupol 30 34 36 40
9 Arsenal Kyiv Arsenal Kyiv 30 38 44 37
10 Kryvbas Kryvbas 30 26 41 36
11 Metalurh Zaporizhya Metalurh 30 26 40 32
12 Tavriya Simferopol Tavriya 30 22 28 32
13 Volyn Lutsk Volyn Lutsk 30 25 44 29
14 Vorskla Poltava Vorskla 30 26 49 27
15 Karpaty Lviv Karpaty Lviv 30 22 39 26
16 Zirka Kirovohrad Zirka 30 16 43 14
TEMPORADA 2002/2003
LIGA UCRANIANA
Equipo PJ GF GC Puntos
1 Dynamo Kyiv Dynamo Kyiv 30 66 20 73
2 Shakhtar Donetsk Shakhtar 30 61 24 70
3 Metalurh Donetsk Metalurh 30 44 26 60
4 Dnipro Dnipropetrovsk Dnipro 30 48 27 59
5 Arsenal Kyiv Arsenal Kyiv 30 49 24 56
6 Volyn Lutsk Volyn Lutsk 30 37 44 41
7 Karpaty Lviv Karpaty Lviv 30 29 37 36
8 Chornomorets Odessa Chornomorets 30 31 45 34
9 Tavriya Simferopol Tavriya 30 36 50 34
10 FC Mariupol FC Mariupol 30 34 38 34
11 Vorskla Poltava Vorskla 30 26 41 32
12 Kryvbas Kryvbas 30 25 37 31
13 Oleksandriya Oleksandriya 30 26 43 30
14 Obolon Obolon 30 32 45 28
15 Metalurh Zaporizhya Metalurh 30 22 41 26
16 Metalist Kharkiv Metalist 30 19 43 23
TEMPORADA 2001/2002
SEGUNDA UCRANIA
Equipo PJ GF GC Puntos
1 Volyn Lutsk Volyn Lutsk 34 56 24 78
2 Chornomorets Odessa Chornomorets 34 48 21 67
3 Obolon Obolon 34 49 26 62
4 MFC Zhytomyr Zhytomyr 33 41 32 58
5 Spartak Ivano-Frankivsk Spartak 34 41 27 53
6 Stal Alchevsk Stal 34 42 34 50
7 Naftovyk-Ukrnafta Okhtyrka Naftovyk-Ukr 34 35 32 49
8 Dynamo Kyiv II Dynamo Kyiv 34 42 32 47
9 Shakhtar Donetsk II Shakhtar 34 50 46 46
10 Zirka Kirovohrad Zirka 34 29 28 46
11 MFK Mykolaiv Mykolaiv 34 37 44 46
12 Karpaty II Karpaty II 34 41 52 42
13 Borisfen Borisfen 33 43 45 40
14 CSKA Kyiv CSKA Kyiv 34 32 39 39
15 FC Nyva Vinnytsya Nyva 34 35 52 38
16 Elektrometalurh Elektrometal 34 30 41 37
17 Dnipro II Dnipro II 34 29 48 31
18 Nyva Ternopil Nyva 34 20 77 13
TEMPORADA 1999/2000
SEGUNDA UCRANIA
Equipo PJ GF GC Puntos
1 Dynamo Kyiv II Dynamo Kyiv 34 76 22 73
2 Stal Alchevsk Stal 34 59 36 70
3 Dnipro Cherkasy Dnipro 34 49 34 59
4 Shakhtar Donetsk II Shakhtar 34 48 38 56
5 CSKA Kyiv CSKA Kyiv 34 40 26 54
6 MFK Mykolaiv Mykolaiv 34 41 38 52
7 FC Lviv FC Lviv 34 35 31 51
8 Oleksandriya Oleksandriya 34 35 34 49
9 Volyn Lutsk Volyn Lutsk 34 44 41 48
10 Spartak Sumy Spartak Sumy 34 43 45 48
11 Elektrometalurh Elektrometal 34 32 34 48
12 FC Nyva Vinnytsya Nyva 34 30 39 48
13 Goverla Goverla 34 37 49 48
14 Naftovyk-Ukrnafta Okhtyrka Naftovyk-Ukr 34 43 51 44
15 MFC Zhytomyr Zhytomyr 34 37 51 40
16 Obolon Obolon 34 24 52 27
17 Chornomorets II Chornomorets 34 27 51 23
18 Torpedo Zaporizhia Torpedo 34 21 49 16

  USO DE MEMORIA  
7,881,504 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.7128
Total Execution Time  0.7140
  CADENA URL  
/historico/Obolon/2020
  GET DATOS  
$_GET['/historico/Obolon/2020']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (43)  
0.0175  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 = 'Obolon' AND l.year = 2020 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.0130  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=5612 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128  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=5612 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128  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=5612 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129  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=5612 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0267  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 = 49999
0.0133  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 = 51075
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=5612 AND type_rel = 2
0.0126  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 5612 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0126  SELECT /*35 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 (219728) ORDER BY n.cover_points DESC, update_date DESC
0.0131  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 = '5612' AND l.year = 2020 ORDER BY l.year DESC,cat.coefficient DESC
0.0132  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 = '5612' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0128  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 = 51075 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126  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 = 49999 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0130  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=5612 AND l.year in (2019,2020,2021) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (58693,58544,56547) 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.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 58693 AND teamId = 5612
0.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 58544 AND teamId = 5612
0.0211  SELECT count(id) as num_players from rel_players WHERE league_id = 56547 AND teamId = 5612
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 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 = 49999 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0147  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 events2020 e ON e.player_id = p.id AND e.league_id = 49999 WHERE rp.league_id = 49999 AND rp.teamId = 5612 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.0139  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 events2020 e ON e.player_id = p.id AND e.league_id = 49999 WHERE rp.league_id = 49999 AND rp.teamId = 5612 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0135  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 events2020 e ON e.player_id = p.id AND e.league_id = 49999 WHERE rp.league_id = 49999 AND rp.teamId = 5612 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0131  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 = 5612 AND l.year <= 2020 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 = 49999 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.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 `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 = 44344 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 `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 = 38758 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 `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 = 33937 AND t.round = 34 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 `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 = 15509 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 `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 = 9214 AND t.round = 27 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 `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 = 14290 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 `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 = 1370 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 `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 = 5828 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 `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 = 14294 AND t.round = 32 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 `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 = 14295 AND t.round = 38 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 `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 = 14296 AND t.round = 38 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 `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 = 14297 AND t.round = 34 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 `tables2005` 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 = 5823 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 `tables2004` 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 = 5822 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 `tables2003` 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 = 5821 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 `tables2002` 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 = 26474 AND t.round = 34 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 `tables2000` 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 = 26476 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  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 = 49999 ORDER BY nameShow LIMIT 100