4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Volyn Lutsk
TEMPORADA 2021/2022
SEGUNDA UCRANIA
Equipo PJ GF GC Puntos
1 Metalist Kharkiv Metalist 20 52 9 53
2 FC Kryvbas FC Kryvbas 20 38 17 42
3 Alians Lypova Dolyna Alians 19 33 24 33
4 Obolon Obolon 19 24 16 33
5 Nyva Ternopil Nyva 20 22 22 29
6 Hirnyk-Sport Hirnyk-Sport 20 15 17 29
7 FC Prykarpattia Prykarpattia 20 27 26 28
8 Podillya Khmelnytskyi Podillya 20 19 18 26
9 Polissya Zhytomyr Polissya 18 21 17 25
10 Volyn Lutsk Volyn Lutsk 19 17 20 25
11 Olimpik Donetsk Olimpik 19 19 23 23
12 Avanhard Kramatorsk Avanhard 18 16 24 22
13 Ahrobiznes Volochysk Ahrobiznes 20 16 23 21
14 VPK-Ahro Shevchenkivka VPK-Ahro 20 16 28 18
15 Uzhhorod Uzhhorod 20 16 40 16
16 Kremin Kremin 20 16 43 13
TEMPORADA 2020/2021
SEGUNDA UCRANIA
Equipo PJ GF GC Puntos
1 Veres Rivne Veres Rivne 30 56 21 68
2 Chornomorets Odessa Chornomorets 30 45 23 61
3 Metalist 1925 Kharkiv Metalist 30 36 22 56
4 MFK Mykolaiv Mykolaiv 30 49 23 53
5 Ahrobiznes Volochysk Ahrobiznes 30 46 27 52
6 Alians Lypova Dolyna Alians 30 46 31 51
7 Volyn Lutsk Volyn Lutsk 30 39 28 46
8 Obolon Obolon 30 44 35 43
9 Hirnyk-Sport Hirnyk-Sport 30 43 45 38
10 VPK-Ahro Shevchenkivka VPK-Ahro 30 30 48 37
11 Polissya Zhytomyr Polissya 30 32 37 35
12 Avanhard Kramatorsk Avanhard 30 32 51 32
13 Nyva Ternopil Nyva 30 30 50 31
14 FC Prykarpattia Prykarpattia 30 25 45 30
15 Kremin Kremin 30 23 50 24
16 Krystal Krystal 30 21 61 13
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
LIGA UCRANIANA GRUPO 3
Equipo PJ GF GC Puntos
1 Vorskla Poltava Vorskla 32 32 32 42
2 Stal Dniprodzerzhynsk Stal 32 27 31 41
3 Zirka Kirovohrad Zirka 32 29 43 34
4 Karpaty Lviv Karpaty Lviv 32 35 41 30
5 Dnipro Dnipropetrovsk Dnipro 32 31 40 13
6 Volyn Lutsk Volyn Lutsk 32 17 51 10
TEMPORADA 2015/2016
LIGA UCRANIANA
Equipo PJ GF GC Puntos
1 Dynamo Kyiv Dynamo Kyiv 25 54 11 70
2 Shakhtar Donetsk Shakhtar 25 76 25 63
3 Dnipro Dnipropetrovsk Dnipro 25 50 22 53
4 Zorya Luhansk Zorya 26 51 26 48
5 Vorskla Poltava Vorskla 25 32 26 42
6 Oleksandriya Oleksandriya 26 30 29 38
7 Karpaty Lviv Karpaty Lviv 25 26 37 30
8 Stal Dniprodzerzhynsk Stal 25 22 31 29
9 Olimpik Donetsk Olimpik 25 22 35 25
10 Metalist Kharkiv Metalist 25 19 46 24
11 Chornomorets Odessa Chornomorets 25 20 39 22
12 Volyn Lutsk Volyn Lutsk 26 36 36 20
13 Hoverla Uzhhorod Hoverla 25 13 45 7
14 Metalurh Zaporizhya Metalurh 16 7 50 3
TEMPORADA 2014/2015
LIGA UCRANIANA
Equipo PJ GF GC Puntos
1 Dynamo Kyiv Dynamo Kyiv 26 65 12 66
2 Shakhtar Donetsk Shakhtar 26 71 21 56
3 Dnipro Dnipropetrovsk Dnipro 26 47 17 54
4 Zorya Luhansk Zorya 26 40 31 45
5 Vorskla Poltava Vorskla 26 35 22 42
6 Metalist Kharkiv Metalist 25 34 32 35
7 Metalurh Zaporizhya Metalurh 26 20 40 26
8 Olimpik Donetsk Olimpik 26 24 64 26
9 Volyn Lutsk Volyn Lutsk 26 38 44 25
10 Metalurh Donetsk Metalurh 26 27 38 22
11 Chornomorets Odessa Chornomorets 25 15 31 20
12 Hoverla Uzhhorod Hoverla 26 22 47 19
13 Karpaty Lviv Karpaty Lviv 26 22 31 15
14 FC Mariupol FC Mariupol 26 25 55 14
TEMPORADA 2013/2014
LIGA UCRANIANA
Equipo PJ GF GC Puntos
1 Shakhtar Donetsk Shakhtar 28 62 23 65
2 Dnipro Dnipropetrovsk Dnipro 28 56 28 59
3 Metalist Kharkiv Metalist 28 54 29 57
4 Dynamo Kyiv Dynamo Kyiv 28 55 33 53
5 Chornomorets Odessa Chornomorets 28 30 22 46
6 Metalurh Donetsk Metalurh 28 45 42 43
7 Zorya Luhansk Zorya 28 35 30 42
8 Vorskla Poltava Vorskla 28 36 38 40
9 Sevastopol Sevastopol 28 32 43 35
10 FC Mariupol FC Mariupol 28 27 33 34
11 Karpaty Lviv Karpaty Lviv 28 33 39 32
12 Hoverla Uzhhorod Hoverla 28 26 39 26
13 Volyn Lutsk Volyn Lutsk 28 25 51 24
14 Metalurh Zaporizhya Metalurh 28 19 54 12
15 Tavriya Simferopol Tavriya 28 15 46 10
16 Arsenal Kyiv Arsenal Kyiv 0 0 0 0
TEMPORADA 2012/2013
LIGA UCRANIANA
Equipo PJ GF GC Puntos
1 Shakhtar Donetsk Shakhtar 30 82 18 79
2 Metalist Kharkiv Metalist 30 59 25 66
3 Dynamo Kyiv Dynamo Kyiv 30 55 23 62
4 Dnipro Dnipropetrovsk Dnipro 30 54 27 56
5 Metalurh Donetsk Metalurh 30 45 35 49
6 Chornomorets Odessa Chornomorets 30 32 36 43
7 Kryvbas Kryvbas 30 36 41 43
8 Arsenal Kyiv Arsenal Kyiv 30 34 41 39
9 FC Mariupol FC Mariupol 30 30 32 38
10 Zorya Luhansk Zorya 30 32 43 37
11 Tavriya Simferopol Tavriya 30 27 46 32
12 Vorskla Poltava Vorskla 30 31 36 31
13 Volyn Lutsk Volyn Lutsk 30 26 45 29
14 Karpaty Lviv Karpaty Lviv 30 37 52 27
15 Hoverla Uzhhorod Hoverla 30 29 57 22
16 Metalurh Zaporizhya Metalurh 30 12 64 11
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
SEGUNDA UCRANIA
Equipo PJ GF GC Puntos
1 Sevastopol Sevastopol 34 68 27 76
2 Volyn Lutsk Volyn Lutsk 34 71 30 74
3 Stal Alchevsk Stal 34 55 35 65
4 FC Lviv FC Lviv 34 49 22 63
5 Oleksandriya Oleksandriya 34 58 34 63
6 Krymteplytsia Krymteplytsi 34 53 28 59
7 Naftovyk-Ukrnafta Okhtyrka Naftovyk-Ukr 34 45 35 57
8 Desna Chernihiv Desna 34 38 29 48
9 Arsenal Bila Tserkva Arsenal Bila 34 48 44 46
10 Zirka Kirovohrad Zirka 34 38 40 46
11 Helios Kharkiv Helios 34 42 47 46
12 FK Odessa FK Odessa 34 44 47 44
13 Dynamo Kyiv II Dynamo Kyiv 34 35 46 41
14 Feniks-Illichovets Feniks-Illic 34 39 52 37
15 Enerhetyk Burshtyn Enerhetyk 34 32 49 35
16 FC Prykarpattia Prykarpattia 34 26 68 22
17 FC Kharkiv FC Kharkiv 34 22 76 14
18 Nyva Ternopil Nyva 34 18 72 13
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
LIGA UCRANIANA
Equipo PJ GF GC Puntos
1 Shakhtar Donetsk Shakhtar 30 64 14 75
2 Dynamo Kyiv Dynamo Kyiv 30 68 20 75
3 Chornomorets Odessa Chornomorets 30 36 31 45
4 FC Mariupol FC Mariupol 30 30 34 43
5 Metalist Kharkiv Metalist 30 35 42 43
6 Dnipro Dnipropetrovsk Dnipro 30 33 23 43
7 Tavriya Simferopol Tavriya 30 29 31 39
8 Metalurh Zaporizhya Metalurh 30 32 40 39
9 Metalurh Donetsk Metalurh 30 35 35 39
10 Vorskla Poltava Vorskla 30 28 34 37
11 Stal Alchevsk Stal 30 26 39 36
12 Arsenal Kyiv Arsenal Kyiv 30 31 39 35
13 FC Kharkiv FC Kharkiv 30 29 36 33
14 Kryvbas Kryvbas 30 27 35 33
15 Volyn Lutsk Volyn Lutsk 30 31 45 33
16 Hoverla Uzhhorod Hoverla 30 17 53 15
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

  USO DE MEMORIA  
7,578,928 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0017
Controller Execution Time ( Home / Category )  1.8694
Total Execution Time  1.8712
  CADENA URL  
/historico/Volyn
  GET DATOS  
$_GET['/historico/Volyn']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (113)  
0.0191  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 = 'Volyn' 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.0407  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 = 'Volyn' 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.0147  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0147  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0149  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0149  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0148  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0149  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0147  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0147  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0149  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0147  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0147  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0148  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0149  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0149  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0149  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0149  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0149  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0149  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0151  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0149  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0151  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0152  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0149  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0151  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0147  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0147  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0144  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0144  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0144  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0148  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0152  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0144  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0144  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0144  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0149  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0149  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0147  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0149  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0144  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=5618 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0154  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 = 63374
0.0151  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 = 63722
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=5618 AND type_rel = 2
0.0146  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 5618 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0149  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 (23743,59220,113830) ORDER BY n.cover_points DESC, update_date DESC
0.0165  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 = '5618' ORDER BY l.year DESC,cat.coefficient DESC
0.0171  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 = '5618' AND l.year = 2022 ORDER BY l.year DESC,cat.coefficient DESC
0.0179  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 = '5618' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0181  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 = '5618' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0159  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 = 63722 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0147  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 = 63374 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0154  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=5618 AND l.year in (2021,2022,2023) ORDER BY l.id DESC, l.year DESC ;
0.0146  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 (63722,63374,62807) 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.0158  SELECT count(id) as num_players from rel_players WHERE league_id = 63374 AND teamId = 5618
0.0150  SELECT count(id) as num_players from rel_players WHERE league_id = 63722 AND teamId = 5618
0.0229  SELECT count(id) as num_players from rel_players WHERE league_id = 62807 AND teamId = 5618
0.0150  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 63374 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0147  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 = '5618' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0144  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '5618' and rp.type = 4
0.0148  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 = '5618' 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 events2022 e ON e.player_id = p.id AND e.league_id = 63374 WHERE rp.league_id = 63374 AND rp.teamId = 5618 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.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 events2022 e ON e.player_id = p.id AND e.league_id = 63374 WHERE rp.league_id = 63374 AND rp.teamId = 5618 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0155  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 events2022 e ON e.player_id = p.id AND e.league_id = 63374 WHERE rp.league_id = 63374 AND rp.teamId = 5618 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0155  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 = 5618 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0152  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 = 63374 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.0150  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 = 58693 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.0148  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.0149  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.0150  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.0149  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 = 33416 AND t.round = 22 ORDER BY team.conference 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 `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 = 38211 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 15437 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 3827 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 2486 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 1929 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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.0153  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 = 1304 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 14293 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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.0154  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.0158  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.0159  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 = 5824 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 `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.0159  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.0157  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 = 63374 ORDER BY nameShow LIMIT 100