4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Dolní Benešov
TEMPORADA 2021/2022
3. LIGA CHECA GRUPO 1
Equipo PJ GF GC Puntos
1 Sigma Olomouc II Sigma 32 86 24 80
2 SK Hanácká Hanácká 32 71 34 70
3 Hlučín Hlučín 32 75 31 63
4 Baník Ostrava II Baník 32 71 41 63
5 Slovan Rosice Slovan 32 48 36 57
6 Slovácko II Slovácko 32 67 49 50
7 Uničov Uničov 32 56 52 49
8 Frýdek-Místek Frýdek-Mís 32 53 57 48
9 Velké Meziříčí Velké 32 52 52 45
10 Znojmo Znojmo 32 62 74 38
11 Blansko Blansko 32 51 66 38
12 Uhersky Brod Uhersky Brod 32 40 49 35
13 FC Vratimov FC Vratimov 32 42 74 33
14 FC Zlínsko FC Zlínsko 32 44 70 30
15 Zlín II Zlín II 32 38 55 29
16 Vrchovina Vrchovina 32 28 62 28
17 Vysocina Jihlava II Vysocina 32 29 87 13
18 Dolní Benešov Dolní 0 0 0 0
TEMPORADA 2020/2021
3. LIGA CHECA GRUPO 1
Equipo PJ GF GC Puntos
1 Slovácko II Slovácko 10 23 6 22
2 Vyškov Vyškov 9 19 9 20
3 Frýdek-Místek Frýdek-Mís 10 23 17 19
4 Odra Petřkovice Odra 10 17 15 19
5 FC Zlínsko FC Zlínsko 10 22 20 18
6 Hlučín Hlučín 10 13 10 17
7 Kromeriz Kromeriz 10 14 12 17
8 Uničov Uničov 10 31 17 16
9 Baník Ostrava II Baník 10 15 14 15
10 Uhersky Brod Uhersky Brod 10 15 17 14
11 Velké Meziříčí Velké 10 16 22 13
12 Slovan Rosice Slovan 10 12 13 12
13 Vrchovina Vrchovina 10 16 24 11
14 Sigma Olomouc II Sigma 9 12 14 9
15 Zlín II Zlín II 10 12 17 9
16 Znojmo Znojmo 10 13 23 7
17 Dolní Benešov Dolní 10 11 23 7
18 Vysocina Jihlava II Vysocina 10 11 22 3
TEMPORADA 2019/2020
3. LIGA CHECA GRUPO 1
Equipo PJ GF GC Puntos
1 Blansko Blansko 18 33 12 36
2 Odra Petřkovice Odra 18 32 17 34
3 Frýdek-Místek Frýdek-Mís 18 29 16 34
4 Uničov Uničov 18 32 24 33
5 Slovan Rosice Slovan 18 19 12 32
6 Baník Ostrava II Baník 18 39 19 31
7 SK Hanácká Hanácká 18 31 23 30
8 Sigma Olomouc II Sigma 18 36 22 29
9 Vrchovina Vrchovina 18 22 19 28
10 Vyškov Vyškov 18 27 24 24
11 Velké Meziříčí Velké 18 22 35 23
12 FC Zlínsko FC Zlínsko 18 27 37 22
13 Znojmo Znojmo 18 17 32 20
14 Uhersky Brod Uhersky Brod 18 28 31 18
15 Hlučín Hlučín 18 11 25 18
16 Slovácko II Slovácko 18 19 36 18
17 Zlín II Zlín II 18 20 34 14
18 Dolní Benešov Dolní 18 18 44 6
TEMPORADA 2018/2019
3. LIGA CHECA GRUPO 1
Equipo PJ GF GC Puntos
1 SK Líšeň SK Líšeň 30 67 33 61
2 Odra Petřkovice Odra 30 58 35 60
3 Frýdek-Místek Frýdek-Mís 30 54 33 60
4 SK Hanácká Hanácká 30 62 31 57
5 Vyškov Vyškov 30 59 35 51
6 Uničov Uničov 30 54 36 51
7 Velké Meziříčí Velké 30 55 61 42
8 FC Zlínsko FC Zlínsko 30 63 55 40
9 Hlučín Hlučín 30 46 41 39
10 Uhersky Brod Uhersky Brod 30 46 48 39
11 Dolní Benešov Dolní 30 37 52 37
12 Hodonín-Šardice Hodonín-Ša 30 43 43 35
13 Jiskra Rýmařov Jiskra 30 49 55 35
14 Vrchovina Vrchovina 30 44 58 35
15 Spartak Hulín Spartak 30 40 75 23
16 Valašské Meziříčí Valašské 30 14 100 5
TEMPORADA 2017/2018
4. LIGA CHECA GRUPO 5
Equipo PJ GF GC Puntos
1 Dolní Benešov Dolní 30 55 32 60
2 Havířov Havířov 30 75 41 59
3 Kozlovice Kozlovice 30 65 36 59
4 Nový Jičín Nový 30 53 29 55
5 Sokol Ústí Sokol Ústí 30 64 41 55
6 Opava II Opava II 30 60 33 54
7 Slavičín Slavičín 30 62 42 50
8 Frýdlant Frýdlant 30 44 47 43
9 Nove Sady Nove Sady 30 39 50 41
10 Bohumin Bospor Bohumin 30 49 47 37
11 FC Vsetín FC Vsetín 30 31 35 37
12 Jeseník Jeseník 30 41 69 30
13 Hranice Hranice 30 30 60 27
14 Lokomotiva Petrovice Lokomotiva 30 40 61 25
15 Šternberk Šternberk 30 39 72 21
16 Brumov Brumov 30 27 79 20
TEMPORADA 2016/2017
4. LIGA CHECA GRUPO 5
Equipo PJ GF GC Puntos
1 Valašské Meziříčí Valašské 30 66 33 67
2 Jiskra Rýmařov Jiskra 30 64 34 60
3 Havířov Havířov 30 47 40 52
4 Nový Jičín Nový 30 64 49 49
5 Dolní Benešov Dolní 30 50 41 45
6 Jeseník Jeseník 30 56 63 42
7 Hranice Hranice 30 46 53 41
8 Kozlovice Kozlovice 30 47 51 40
9 Šumperk Šumperk 30 52 52 39
10 Lokomotiva Petrovice Lokomotiva 30 38 50 38
11 Frýdlant Frýdlant 30 40 44 37
12 Nove Sady Nove Sady 30 40 45 37
13 Opava II Opava II 30 36 50 37
14 Pustá Polom Pustá Polom 30 35 42 36
15 Přerov Přerov 30 36 49 33
16 Velké Karlovice Velké 30 26 47 21
TEMPORADA 2015/2016
4. LIGA CHECA GRUPO 5
Equipo PJ GF GC Puntos
1 Odra Petřkovice Odra 30 53 29 64
2 Lokomotiva Petrovice Lokomotiva 30 54 23 55
3 Slavičín Slavičín 30 50 31 53
4 Valašské Meziříčí Valašské 30 50 36 51
5 Nový Jičín Nový 30 46 32 49
6 Jiskra Rýmařov Jiskra 30 58 40 46
7 Nove Sady Nove Sady 30 51 47 41
8 Dolní Benešov Dolní 30 41 47 41
9 Opava II Opava II 30 44 42 38
10 Hranice Hranice 30 48 48 37
11 Brumov Brumov 30 33 59 36
12 Havířov Havířov 30 37 56 35
13 Velké Karlovice Velké 30 25 37 34
14 Frýdlant Frýdlant 30 36 61 33
15 Krnov Krnov 30 34 54 31
16 FC Vsetín FC Vsetín 30 28 46 28
TEMPORADA 2014/2015
4. LIGA CHECA GRUPO 5
Equipo PJ GF GC Puntos
1 Mohelnice Mohelnice 30 53 25 59
2 Vitkovice Vitkovice 30 62 34 57
3 Slavičín Slavičín 30 53 39 54
4 Brumov Brumov 30 58 41 51
5 Hranice Hranice 30 58 41 47
6 Lokomotiva Petrovice Lokomotiva 30 37 41 46
7 Nový Jičín Nový 30 47 43 45
8 Havířov Havířov 30 51 52 42
9 Jiskra Rýmařov Jiskra 30 53 45 41
10 Valašské Meziříčí Valašské 30 44 51 39
11 Kozlovice Kozlovice 30 56 60 38
12 Přerov Přerov 30 41 51 38
13 Dolní Benešov Dolní 30 43 53 31
14 REAL Lískovec REAL 30 37 68 31
15 Velké Karlovice Velké 30 29 49 28
16 Sokol Určice Sokol 30 32 61 24
TEMPORADA 2013/2014
4. LIGA CHECA GRUPO 5
Equipo PJ GF GC Puntos
1 REAL Lískovec REAL 30 60 38 53
2 Opava II Opava II 30 53 44 51
3 Slavičín Slavičín 30 43 38 49
4 Dolní Benešov Dolní 30 59 45 48
5 Mohelnice Mohelnice 30 37 26 48
6 Havířov Havířov 30 47 57 44
7 Lokomotiva Petrovice Lokomotiva 30 47 36 43
8 Brumov Brumov 30 44 49 42
9 Nový Jičín Nový 30 41 50 41
10 Sokol Určice Sokol 30 35 41 38
11 FC Zlínsko FC Zlínsko 30 46 39 37
12 Přerov Přerov 30 42 45 37
13 Hranice Hranice 30 36 42 37
14 Valašské Meziříčí Valašské 30 50 59 36
15 Karviná II Karviná II 30 42 50 35
16 Šumperk Šumperk 30 33 56 26
TEMPORADA 2012/2013
4. LIGA CHECA GRUPO 1
Equipo PJ GF GC Puntos
1 Admira Praha Admira Praha 30 69 24 73
2 Povltavská FA Povltavská 30 50 24 64
3 Spartak Chrastava Spartak 30 46 30 49
4 Rokycany Rokycany 30 45 43 45
5 Dolní Benešov Dolní 30 34 30 44
6 Sokol Čížová Sokol 30 42 41 44
7 Hořovicko Hořovicko 30 56 44 43
8 Táborsko II Táborsko 30 42 28 42
9 Tachov Tachov 30 56 47 40
10 Cesky Krumlov Cesky 30 43 51 40
11 Doubravka Doubravka 30 60 48 38
12 Aritma Praha Aritma Praha 30 36 51 36
13 Milevsko Milevsko 30 32 44 34
14 Malše Roudné Malše 30 29 63 29
15 Nové Strašecí Nové 30 38 65 27
16 Přední Kopanina Přední 30 27 72 12
TEMPORADA 2011/2012
4. LIGA CHECA GRUPO 5
Equipo PJ GF GC Puntos
1 Slavia Orlová-Lutyně Slavia 30 62 29 66
2 Prostějov Prostějov 30 62 26 64
3 Mikulovice Mikulovice 30 70 52 55
4 Šumperk Šumperk 30 56 36 53
5 Mohelnice Mohelnice 30 53 49 50
6 Brumov Brumov 30 43 52 42
7 Lokomotiva Petrovice Lokomotiva 30 41 44 40
8 REAL Lískovec REAL 30 46 47 39
9 Kravaře Kravaře 30 46 52 37
10 Opava II Opava II 30 49 61 36
11 Valašské Meziříčí Valašské 30 45 59 36
12 Slavičín Slavičín 30 50 46 35
13 Havířov Havířov 30 47 51 35
14 Nový Jičín Nový 30 52 69 33
15 Dolní Benešov Dolní 30 26 58 30
16 Krnov Krnov 30 45 62 27
TEMPORADA 2010/2011
4. LIGA CHECA GRUPO 5
Equipo PJ GF GC Puntos
TEMPORADA 2009/2010
4. LIGA CHECA GRUPO 5
Equipo PJ GF GC Puntos
1 Zlín II Zlín II 30 81 34 61
2 Jakubcovice Jakubcovice 30 47 22 60
3 Spartak Hulín Spartak 30 47 24 54
4 Mikulovice Mikulovice 30 60 41 53
5 Šumperk Šumperk 30 44 30 51
6 Dolní Benešov Dolní 30 39 46 44
7 Opava II Opava II 30 47 43 43
8 Valašské Meziříčí Valašské 30 54 64 40
9 Slavia Orlová-Lutyně Slavia 30 47 45 39
10 Havířov Havířov 30 42 45 38
11 Brumov Brumov 30 45 53 38
12 Poruba Poruba 30 46 60 37
13 Kravaře Kravaře 30 35 54 31
14 Jiskra Rýmařov Jiskra 30 46 61 26
15 Hranice Hranice 30 44 78 26
16 Lázne Velké Losiny Lázne 30 46 70 24
TEMPORADA 2008/2009
4. LIGA CHECA GRUPO 5
Equipo PJ GF GC Puntos
1 Slavičín Slavičín 30 69 29 63
2 Šumperk Šumperk 30 62 26 63
3 Lázne Velké Losiny Lázne 30 70 43 58
4 Slavia Orlová-Lutyně Slavia 30 46 31 52
5 Brumov Brumov 30 60 51 47
6 Mesto Albrechtice Mesto 30 39 50 42
7 Havířov Havířov 30 40 41 41
8 Poruba Poruba 30 44 46 41
9 Dolní Benešov Dolní 30 46 48 40
10 Jiskra Rýmařov Jiskra 30 46 46 35
11 Kravaře Kravaře 30 32 43 35
12 Valašské Meziříčí Valašské 30 51 67 34
13 Hranice Hranice 30 40 66 34
14 Bystrice pod Hostýnem Bystrice 30 29 46 31
15 Velké Karlovice Velké 30 34 52 27
16 Beskyd Frenstat Beskyd 30 27 50 22
TEMPORADA 2007/2008
3. LIGA CHECA GRUPO 2
Equipo PJ GF GC Puntos
1 Sigma Olomouc II Sigma 30 65 28 61
2 Znojmo Znojmo 30 57 35 60
3 Mutenice Mutenice 30 60 30 57
4 Karviná Karviná 30 48 30 50
5 Frýdek-Místek Frýdek-Mís 30 50 38 48
6 Břeclav Břeclav 30 40 38 48
7 Bystrc Kníničky Bystrc 30 42 34 47
8 Slovácko II Slovácko 30 36 38 42
9 Vysocina Jihlava II Vysocina 30 44 54 38
10 Zábřeh Zábřeh 30 28 50 38
11 Zbrojovka Brno II Zbrojovka 30 23 30 35
12 SK Hanácká Hanácká 30 34 39 34
13 Uničov Uničov 30 30 40 33
14 Zlín II Zlín II 30 31 49 27
15 SK Lipová SK Lipová 30 33 59 25
16 Dolní Benešov Dolní 30 22 51 21
TEMPORADA 2006/2007
3. LIGA CHECA GRUPO 2
Equipo PJ GF GC Puntos
1 Fulnek Fulnek 30 64 30 64
2 Mutenice Mutenice 30 50 32 57
3 Slovácko II Slovácko 30 47 32 51
4 Uničov Uničov 30 50 35 49
5 Frýdek-Místek Frýdek-Mís 30 49 37 49
6 Zlín II Zlín II 30 38 27 47
7 Břeclav Břeclav 30 42 35 47
8 Karviná Karviná 30 47 40 42
9 Vysocina Jihlava II Vysocina 30 38 38 40
10 Zbrojovka Brno II Zbrojovka 30 43 45 39
11 Znojmo Znojmo 30 39 49 38
12 Dolní Benešov Dolní 30 33 42 37
13 SK Lipová SK Lipová 30 27 46 35
14 Baník Ostrava II Baník 30 31 34 34
15 Brumov Brumov 30 36 67 28
16 Hranice Hranice 30 28 73 16
TEMPORADA 2005/2006
3. LIGA CHECA GRUPO 2
Equipo PJ GF GC Puntos
1 Jakubcovice Jakubcovice 30 49 21 61
2 Bystrc Kníničky Bystrc 29 35 25 50
3 Dolní Benešov Dolní 30 47 41 48
4 SK Lipová SK Lipová 30 49 33 47
5 Třinec Třinec 30 44 34 47
6 Uničov Uničov 30 35 28 46
7 Znojmo Znojmo 30 47 36 43
8 Baník Ostrava II Baník 30 35 36 40
9 Břeclav Břeclav 30 36 41 40
10 Zlín II Zlín II 29 34 33 39
11 Slovácko II Slovácko 30 38 38 37
12 Vitkovice B Vitkovice B 30 33 42 35
13 Vysocina Jihlava II Vysocina 30 36 47 33
14 Hranice Hranice 30 23 33 29
15 Kohoutovice Kohoutovice 30 19 38 27
16 Bystrice pod Hostýnem Bystrice 30 21 55 23
TEMPORADA 2004/2005
3. LIGA CHECA GRUPO 2
Equipo PJ GF GC Puntos
1 HFK Olomouc HFK Olomouc 30 60 23 68
2 Hlučín Hlučín 30 64 25 63
3 Uničov Uničov 30 67 39 53
4 Zlín II Zlín II 29 47 34 53
5 Baník Ostrava II Baník 30 38 27 48
6 Dolní Benešov Dolní 30 45 43 45
7 Vitkovice B Vitkovice B 30 35 36 42
8 Bystrc Kníničky Bystrc 30 43 39 41
9 Slovácko II Slovácko 30 49 48 39
10 Znojmo Znojmo 30 39 42 38
11 Bystrice pod Hostýnem Bystrice 29 39 45 37
12 Hranice Hranice 30 36 41 35
13 Třinec Třinec 30 31 52 30
14 Kohoutovice Kohoutovice 30 27 43 27
15 SK Lipová SK Lipová 30 28 54 23
16 Postorna Postorna 30 27 84 17
TEMPORADA 2003/2004
3. LIGA CHECA GRUPO 2
Equipo PJ GF GC Puntos
1 SK Hanácká Hanácká 30 60 28 69
2 Uničov Uničov 30 48 28 54
3 Synot B Synot B 30 56 37 54
4 Baník Ostrava II Baník 30 50 23 53
5 Bystrc Kníničky Bystrc 29 45 33 53
6 Třinec Třinec 30 41 30 47
7 Vitkovice B Vitkovice B 29 35 42 41
8 Hranice Hranice 30 46 48 40
9 Dolní Benešov Dolní 30 41 45 35
10 Znojmo Znojmo 30 47 54 34
11 Dolni Kounice Dolni 30 30 46 34
12 Zlín II Zlín II 30 30 35 33
13 Bystrice pod Hostýnem Bystrice 30 35 48 33
14 Postorna Postorna 30 36 41 32
15 Frýdek-Místek Frýdek-Mís 30 28 45 29
16 Prostějov Prostějov 30 30 75 25
TEMPORADA 2002/2003
3. LIGA CHECA GRUPO 2
Equipo PJ GF GC Puntos
1 Drnovice Drnovice 29 49 26 63
2 Zbrojovka Brno II Zbrojovka 30 45 20 55
3 Baník Ostrava II Baník 29 67 25 54
4 Frýdek-Místek Frýdek-Mís 30 35 29 50
5 Hranice Hranice 30 38 25 47
6 Uničov Uničov 30 31 29 45
7 Znojmo Znojmo 30 42 40 43
8 SK Hanácká Hanácká 30 35 34 42
9 Dolní Benešov Dolní 30 44 39 41
10 Synot B Synot B 30 36 40 40
11 Postorna Postorna 30 30 54 37
12 Bystrice pod Hostýnem Bystrice 29 49 52 35
13 Třinec Třinec 30 44 59 34
14 Zlín II Zlín II 30 27 46 33
15 FC Kyjov 1919 Kyjov 1919 30 28 49 23
16 SK Detmarovice Detmarovice 29 19 52 20

  USO DE MEMORIA  
7,525,464 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.9842
Total Execution Time  0.9853
  CADENA URL  
/historico/Dolni-Benesov
  GET DATOS  
$_GET['/historico/Dolni-Benesov']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (79)  
0.0111  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 = 'Dolni-Benesov' 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.0241  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 = 'Dolni-Benesov' 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.0106  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=30962 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0107  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=30962 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0107  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=30962 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=30962 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=30962 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=30962 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=30962 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0107  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=30962 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0107  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=30962 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0107  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=30962 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0107  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=30962 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0107  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=30962 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=30962 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=30962 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=30962 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=30962 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=30962 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=30962 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=30962 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=30962 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=30962 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=30962 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=30962 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=30962 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=30962 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=30962 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=30962 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0119  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=30962 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=30962 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=30962 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0115  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=30962 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=30962 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=30962 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=30962 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=30962 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=30962 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0112  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 = 63515
0.0149  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 = 63448
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=30962 AND type_rel = 2
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1524 AND type_rel = 3
0.0112  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 = '30962' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0109  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 = '30962' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0107  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 = 63515 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0119  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 = 63448 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0118  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=30962 AND l.year in (2021,2022,2023) ORDER BY l.id DESC, l.year DESC ;
0.0108  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 (63515,63448,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.0114  SELECT count(id) as num_players from rel_players WHERE league_id = 63515 AND teamId = 30962
0.0116  SELECT count(id) as num_players from rel_players WHERE league_id = 63448 AND teamId = 30962
0.0107  SELECT count(id) as num_players from rel_players WHERE league_id = 56547 AND teamId = 30962
0.0112  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 = 63515 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0117  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 = '30962' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0105  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '30962' and rp.type = 4
0.0107  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 = '30962' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0122  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 = 63515 WHERE rp.league_id = 63515 AND rp.teamId = 30962 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.0120  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 = 63515 WHERE rp.league_id = 63515 AND rp.teamId = 30962 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0113  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 = 63515 WHERE rp.league_id = 63515 AND rp.teamId = 30962 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0115  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 = 30962 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0112  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 = 63515 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.0109  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 = 57119 AND t.round = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 50313 AND t.round = 32 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 44268 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 39719 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 33750 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 = 16003 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 9187 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 25088 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 25090 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 25124 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0106  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 = 25113 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 = 25134 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 25140 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112  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 = 24640 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 24511 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 24502 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 24497 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 24489 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 24480 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC