4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Thesprotos
TEMPORADA 2023/2024
TERCERA GRECIA GRUPO 2
Equipo PJ GF GC Puntos
1 Ethnikos Neou Keramidiou Ethnikos 34 57 18 78
2 Nea Artaki Nea Artaki 34 62 19 76
3 Svoronos Svoronos 34 63 23 72
4 Zakynthos Zakynthos 34 50 30 58
5 Pierikos Pierikos 34 49 27 55
6 Anagennisi Arta Anagennisi 34 35 33 54
7 AE Kileler AE Kileler 34 36 22 53
8 Asteras Stavros Asteras 34 38 35 52
9 Thesprotos Thesprotos 34 54 45 52
10 Trikala Trikala 34 49 37 52
11 Asteras Petriti Asteras 34 36 38 50
12 Eordaikos Eordaikos 34 39 30 50
13 Thyella Katsika Thyella 34 49 32 48
14 AE Lefkimmi AE Lefkimmi 34 37 51 33
15 Kastoria Kastoria 34 35 52 33
16 Vataniakos Vataniakos 34 36 67 31
17 Fikis Fikis 33 12 90 7
18 Magnisiakos Magnisiakos 33 1 89 1
TEMPORADA 2022/2023
SEGUNDA GRECIA GRUPO 1
Equipo PJ GF GC Puntos
1 Panserraikos FC Panserraikos 28 43 13 64
2 AE Larisa AE Larisa 28 50 19 58
3 Niki Volos Niki Volos 28 41 20 52
4 Iraklis Thessaloniki Iraklis 28 53 22 50
5 PAOK B PAOK B 28 51 33 49
6 Almopos Aridea Almopos 28 23 17 36
7 Anagennisi Karditsas Anagennisi 28 34 21 35
8 Makedonikos Neapolis Makedonikos 28 28 30 33
9 Panathinaikos B Panathinaiko 28 39 41 33
10 Diagoras Diagoras 28 38 42 33
11 Apollon Pontou Apollon 28 21 37 32
12 Veria NPS Veria NPS 28 28 32 31
13 Iraklis Larissa Iraklis 28 17 42 26
14 Thesprotos Thesprotos 28 26 49 17
15 Apollon Larisas Apollon 28 8 82 4
TEMPORADA 2021/2022
SEGUNDA GRECIA GRUPO 1
Equipo PJ GF GC Puntos
1 Veria NPS Veria NPS 32 61 23 75
2 AE Larisa AE Larisa 32 42 15 67
3 Xanthi Xanthi 32 43 25 53
4 Niki Volos Niki Volos 32 38 20 52
5 Anagennisi Karditsas Anagennisi 32 47 34 51
6 Olympiacos Piraeus B Olympiacos 32 40 31 51
7 Iraklis Thessaloniki Iraklis 32 51 29 48
8 PAOK B PAOK B 32 41 32 44
9 Almopos Aridea Almopos 32 40 39 39
10 Apollon Pontou Apollon 32 34 38 37
11 Apollon Larisas Apollon 32 27 42 35
12 Thesprotos Thesprotos 32 34 43 34
13 Panserraikos FC Panserraikos 32 31 39 33
14 Pierikos Pierikos 32 36 49 32
15 Kavala Kavala 32 25 71 31
16 Olympiakos Volos Olympiakos 32 34 49 29
17 Trikala Trikala 32 17 62 21
TEMPORADA 2020/2021
FOOTBALL LEAGUE GRECIA
Equipo PJ GF GC Puntos
1 Veria NPS Veria NPS 18 24 6 38
2 Kavala Kavala 18 32 18 35
3 Panserraikos FC Panserraikos 18 21 12 31
4 Olympiakos Volos Olympiakos 18 23 21 29
5 Pierikos Pierikos 18 23 21 26
6 Thesprotos Thesprotos 18 19 24 22
7 Triglia Rafinas Triglia 18 14 16 21
8 Almopos Aridea Almopos 18 18 21 20
9 Apollon Pontou Apollon 18 16 25 19
10 AEP Kozani AEP Kozani 18 7 33 7
11 Kalamata FC Kalamata FC 18 20 7 35
12 Rodos Rodos 18 20 15 30
13 Athens Kallithea Athens 18 20 14 29
14 Episkopi Episkopi 18 15 10 27
15 Santorini Santorini 18 15 16 24
16 Ialysos Ialysos 18 16 22 24
17 Egaleo Egaleo 18 14 14 23
18 Niki Volos Niki Volos 18 18 14 22
19 Asteras Vlachioti Asteras 18 14 16 19
20 Enosis Aspropyrgos Enosis 18 10 34 8
TEMPORADA 2019/2020
FOOTBALL LEAGUE GRECIA
Equipo PJ GF GC Puntos
1 Trikala Trikala 23 28 14 46
2 Ionikos Nikea Ionikos 23 26 13 40
3 Diagoras Diagoras 23 27 15 38
4 Niki Volos Niki Volos 23 27 20 37
5 OF Ierapetra Ierapetra 23 23 19 37
6 Kavala Kavala 23 23 12 36
7 Veria NPS Veria NPS 23 27 19 35
8 Olympiakos Volos Olympiakos 23 28 32 31
9 Egaleo Egaleo 23 14 22 27
10 Thesprotos Thesprotos 23 26 33 24
11 Ialysos Ialysos 23 17 28 24
12 Enosis Aspropyrgos Enosis 23 21 33 20
13 Triglia Rafinas Triglia 23 17 33 20
14 Kalamata FC Kalamata FC 23 17 28 19
TEMPORADA 2018/2019
TERCERA GRECIA GRUPO 3
Equipo PJ GF GC Puntos
1 Kronos Argyrades Kronos 24 28 9 48
2 Thesprotos Thesprotos 24 38 13 47
3 Acheron Kanalaki Acheron 24 37 17 47
4 AE Lefkimmi AE Lefkimmi 24 43 19 42
5 Makedonikos Foufas Makedonikos 24 40 22 42
6 Nafpaktiakos Asteras Nafpaktiakos 24 37 22 40
7 Tilikratis Tilikratis 24 32 21 39
8 Souli Paramythia Souli 23 30 20 37
9 M. Alexandros Kallithea Alexandros 24 33 29 32
10 Thriamvos Serviana Thriamvos 24 29 23 30
11 Makedonikos Siatista Makedonikos 24 24 37 22
12 Grevena Aerata Grevena 24 9 86 5
13 Floriada Floriada 23 0 62 2
TEMPORADA 2017/2018
TERCERA GRECIA GRUPO 3
Equipo PJ GF GC Puntos
1 Tilikratis Tilikratis 23 38 15 48
2 Panamvrakakikos A-M Panamvrakaki 24 45 20 47
3 Makedonikos Foufas Makedonikos 24 31 18 46
4 Ermis Amyntaio Ermis 24 36 24 45
5 Thesprotos Thesprotos 24 38 15 42
6 AE Lefkimmi AE Lefkimmi 24 32 23 41
7 Doxa Kranoula Doxa 24 25 22 37
8 Ethnikos Filippiada Ethnikos 24 18 28 27
9 AEP Karagiannia Karagiannia 24 25 36 27
10 Panlefkadios Panlefkadios 24 16 24 21
11 Skoufas Kompoti Skoufas 24 15 29 21
12 Asteras Parapotamos Asteras 24 17 44 14
13 Kastoria Kastoria 23 10 48 9
TEMPORADA 2016/2017
TERCERA GRECIA GRUPO 2
Equipo PJ GF GC Puntos
1 Apollon Larisas Apollon 30 64 17 73
2 Karaiskakis Karaiskakis 30 43 14 66
3 Olympiakos Volos Olympiakos 30 46 16 62
4 Diagoras Sevastis Diagoras 30 47 27 61
5 Pydna Kitros Pydna Kitros 30 42 24 53
6 Niki Volos Niki Volos 30 36 30 50
7 Tilikratis Tilikratis 30 28 28 43
8 Apolloniou Istiaias Apolloniou 30 29 39 35
9 Thesprotos Thesprotos 30 36 40 34
10 Pierikos Pierikos 30 21 35 33
11 Rigas Feraios Rigas 30 36 46 32
12 Amvrakia Kostakis Amvrakia 30 26 42 30
13 Mavroi Aetoi Eleftherochori Mavroi Aetoi 30 25 42 30
14 Ethnikos Filippiada Ethnikos 30 21 37 28
15 Achilleas Neokaisareia Achilleas 30 30 54 26
16 Asteras Petriti Asteras 30 16 55 14
TEMPORADA 2015/2016
TERCERA GRECIA GRUPO 2
Equipo PJ GF GC Puntos
1 Aiginiakos Aiginiakos 32 74 20 78
2 Karaiskakis Karaiskakis 32 52 24 69
3 Niki Volos Niki Volos 32 47 22 64
4 Pydna Kitros Pydna Kitros 32 50 22 62
5 Pierikos Pierikos 32 35 24 54
6 Thesprotos Thesprotos 32 43 29 52
7 Rigas Feraios Rigas 32 43 28 51
8 Achilleas Neokaisareia Achilleas 32 46 49 48
9 Ethnikos Filippiada Ethnikos 32 23 25 40
10 Pyrasos Pyrasos 32 32 38 39
11 Oikonomos Tsaritsani Oikonomos 32 32 47 39
12 Dotieas Agias Dotieas 32 24 37 34
13 Tyrnavos Tyrnavos 32 25 30 33
14 Acheron Kanalaki Acheron 32 21 33 31
15 Opountios Opountios 32 23 36 27
16 Farkadona Farkadona 32 29 64 19
17 Fokikos Fokikos 32 9 80 5
TEMPORADA 2014/2015
TERCERA GRECIA GRUPO 2
Equipo PJ GF GC Puntos
1 Trikala Trikala 30 55 15 71
2 Karaiskakis Karaiskakis 30 60 14 70
3 Achilleas Neokaisareia Achilleas 30 47 18 59
4 Opountios Opountios 30 52 26 53
5 Thesprotos Thesprotos 30 39 28 53
6 Rigas Feraios Rigas 30 42 19 49
7 Pyrasos Pyrasos 30 40 27 49
8 Oikonomos Tsaritsani Oikonomos 30 42 31 46
9 Ethnikos Filippiada Ethnikos 30 40 31 46
10 AEP Kozani AEP Kozani 30 48 40 45
11 Dotieas Agias Dotieas 30 37 28 42
12 Anagennisi Arta Anagennisi 29 39 30 39
13 Vataniakos Vataniakos 30 25 59 19
14 EAP Makrochori Makrochori 30 22 73 13
15 Pyrsos Grevena Pyrsos 29 10 77 1
16 Lefkadia Lefkadia 30 10 92 0
TEMPORADA 2013/2014
TERCERA GRECIA GRUPO 2
Equipo PJ GF GC Puntos
1 AE Larisa AE Larisa 30 87 15 73
2 Oikonomos Tsaritsani Oikonomos 30 59 25 61
3 Kampaniakos Chalastra Kampaniakos 30 50 34 55
4 AEP Kozani AEP Kozani 30 52 32 54
5 Ethnikos Filippiada Ethnikos 30 48 24 52
6 Pyrsos Grevena Pyrsos 30 42 31 52
7 Thesprotos Thesprotos 30 42 27 51
8 Kastoria Kastoria 30 48 38 51
9 Doxa Pentalofos Doxa 30 40 30 49
10 Odysseas Kordeliou FC Odysseas 30 38 42 44
11 Doxa Kranoula Doxa 30 43 40 37
12 Agios Thomas Agios Thomas 30 42 51 30
13 Kastor Kastor 30 30 45 24
14 Keravnos Thesprotikou Keravnos 30 36 67 23
15 Olympos Kerkyra Olympos 30 18 84 17
16 Tilikratis Tilikratis 30 0 90 0

  USO DE MEMORIA  
6,118,544 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5731
Total Execution Time  0.5744
  CADENA URL  
/historico/Thesprotos-Igoumenitsa
  GET DATOS  
$_GET['/historico/Thesprotos-Igoumenitsa']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0154  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 = 'Thesprotos-Igoumenitsa' 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.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=63207 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=63207 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=63207 AND type_rel = 2
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=344 AND type_rel = 3
0.0146  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 344 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0149  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (1098455,1051323,606708,277509,105444) ORDER BY n.cover_points DESC, update_date DESC
0.0148  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 = '63207' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0147  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 = '63207' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0147  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=63207 AND l.year in (2023,2024,2025) 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 (73557,69284,68776,67320) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0148  SELECT count(id) as num_players from rel_players WHERE league_id = 69284 AND teamId = 63207
0.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 73557 AND teamId = 63207
0.0148  SELECT count(id) as num_players from rel_players WHERE league_id = 68776 AND teamId = 63207
0.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 63207
0.0146  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73557 WHERE rp.league_id = 73557 AND rp.teamId = 63207 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.0146  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73557 WHERE rp.league_id = 73557 AND rp.teamId = 63207 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0146  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73557 WHERE rp.league_id = 73557 AND rp.teamId = 63207 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0148  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 = 63207 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0292  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2024` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 73557 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.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 `tables2023` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 69284 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.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 `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 = 65350 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.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 `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 = 60731 AND t.round = 18 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 = 51506 AND t.round = 23 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 = 45475 AND t.round = 26 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 `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 = 40662 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 `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 = 36066 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 `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 = 15927 AND t.round = 34 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 `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 = 12486 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 `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 = 12263 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC