4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Thame United FC
TEMPORADA 2023/2024
NON LEAGUE DIVISION 1 GRUPO 7
Equipo PJ GF GC Puntos
1 Biggleswade Town Biggleswade 34 69 38 66
2 Bedford Town Bedford Town 34 72 37 63
3 Ware Ware 34 67 55 59
4 Waltham Abbey Waltham 35 67 53 58
5 AFC Dunstable Dunstable 34 71 65 58
6 Welwyn Garden City Welwyn 34 76 73 53
7 Cirencester Town Cirencester 34 60 42 51
8 Stotfold FC Stotfold FC 34 61 55 49
9 Hadley Hadley 33 59 55 49
10 Kings Langley Kings 35 71 71 48
11 Biggleswade Biggleswade 32 58 54 44
12 North Leigh North Leigh 33 52 70 43
13 Leighton Town Leighton 34 51 59 42
14 Barton Rovers Barton 34 53 59 41
15 Hertford Town Hertford 33 51 66 41
16 Kidlington Kidlington 34 46 59 40
17 Aylesbury United Aylesbury 33 57 69 39
18 Thame United FC Thame United 34 46 67 34
19 Kempston Rovers Kempston 34 35 75 29
TEMPORADA 2022/2023
NON LEAGUE DIVISION 1 GRUPO 7
Equipo PJ GF GC Puntos
1 Berkhamsted Berkhamsted 36 91 32 88
2 Biggleswade Biggleswade 37 75 46 70
3 Didcot Town Didcot Town 37 58 43 69
4 Walthamstow Walthamstow 36 58 49 63
5 Ware Ware 36 76 60 62
6 Cirencester Town Cirencester 37 69 39 61
7 Biggleswade Town Biggleswade 37 76 56 61
8 Hadley Hadley 37 66 55 56
9 Welwyn Garden City Welwyn 36 56 60 55
10 Kidlington Kidlington 36 47 48 53
11 Thame United FC Thame United 37 64 55 50
12 Waltham Abbey Waltham 37 56 52 49
13 AFC Dunstable Dunstable 36 53 47 46
14 Aylesbury United Aylesbury 37 42 64 43
15 Hertford Town Hertford 36 70 70 41
16 Kempston Rovers Kempston 36 51 69 34
17 Highworth Town Highworth 37 54 96 29
18 FC Romania FC Romania 36 36 97 24
19 Barton Rovers Barton 37 32 81 23
20 Harlow Town Harlow Town 10 13 24 6
TEMPORADA 2021/2022
NON LEAGUE DIVISION 1 GRUPO 7
Equipo PJ GF GC Puntos
1 Bedford Town Bedford Town 38 100 28 91
2 Berkhamsted Berkhamsted 38 64 29 81
3 AFC Dunstable Dunstable 38 64 33 73
4 Ware Ware 38 90 47 71
5 Welwyn Garden City Welwyn 38 80 48 71
6 North Leigh North Leigh 38 69 42 68
7 Harlow Town Harlow Town 38 71 49 61
8 Thame United FC Thame United 38 64 45 60
9 Biggleswade Biggleswade 38 62 56 60
10 St. Neots Town Neots Town 38 57 53 53
11 Waltham Abbey Waltham 38 64 64 52
12 FC Romania FC Romania 38 71 83 48
13 Didcot Town Didcot Town 38 50 69 47
14 Aylesbury United Aylesbury 38 64 70 43
15 Barton Rovers Barton 38 47 63 41
16 Hertford Town Hertford 38 58 82 36
17 Kidlington Kidlington 38 47 86 35
18 Kempston Rovers Kempston 38 50 102 29
19 Colney Heath Colney Heath 38 35 92 23
20 Wantage Town Wantage Town 38 37 103 20
TEMPORADA 2020/2021
NON LEAGUE DIVISION 1 GRUPO 6
Equipo PJ GF GC Puntos
1 Barton Rovers Barton 0 0 0 0
2 AFC Dunstable Dunstable 0 0 0 0
3 Bedford Town Bedford Town 0 0 0 0
4 Bedworth United Bedworth 0 0 0 0
5 Kempston Rovers Kempston 0 0 0 0
6 North Leigh North Leigh 0 0 0 0
7 Welwyn Garden City Welwyn 0 0 0 0
8 Yaxley FC Yaxley FC 0 0 0 0
9 Aylesbury United Aylesbury 0 0 0 0
10 Coleshill Town FC Coleshill 0 0 0 0
11 Wantage Town Wantage Town 0 0 0 0
12 Berkhamsted Berkhamsted 0 0 0 0
13 Biggleswade Biggleswade 0 0 0 0
14 Corby Town Corby Town 0 0 0 0
15 Daventry Town Daventry 0 0 0 0
16 Didcot Town Didcot Town 0 0 0 0
17 Halesowen Town Halesowen 0 0 0 0
18 St. Neots Town Neots Town 0 0 0 0
19 Thame United FC Thame United 0 0 0 0
20 Kidlington Kidlington 0 0 0 0
TEMPORADA 2019/2020
NON LEAGUE DIVISION 1 GRUPO 6
Equipo PJ GF GC Puntos
1 Berkhamsted Berkhamsted 28 69 24 64
2 Halesowen Town Halesowen 27 72 19 63
3 Corby Town Corby Town 28 64 26 59
4 Welwyn Garden City Welwyn 28 59 34 51
5 Aylesbury United Aylesbury 29 49 30 49
6 Biggleswade Biggleswade 27 44 33 44
7 Barton Rovers Barton 29 65 55 44
8 Bedworth United Bedworth 27 46 44 44
9 Yaxley FC Yaxley FC 29 55 55 42
10 North Leigh North Leigh 27 50 50 42
11 Thame United FC Thame United 27 52 35 41
12 Bedford Town Bedford Town 29 49 54 40
13 Daventry Town Daventry 28 42 48 40
14 Coleshill Town FC Coleshill 28 50 47 36
15 Kidlington Kidlington 28 34 48 33
16 AFC Dunstable Dunstable 28 50 54 31
17 Didcot Town Didcot Town 27 20 44 25
18 St. Neots Town Neots Town 28 33 59 21
19 Kempston Rovers Kempston 27 25 68 14
20 Wantage Town Wantage Town 27 16 117 4
TEMPORADA 2018/2019
NON LEAGUE DIVISION 1 GRUPO 4
Equipo PJ GF GC Puntos
1 Peterborough Sports Peterborough 38 109 28 95
2 Bromsgrove Sporting Bromsgrove 38 108 44 87
3 Corby Town Corby Town 38 106 60 77
4 Bedford Town Bedford Town 38 84 52 65
5 Sutton Coldfield Town Sutton 38 65 49 62
6 Berkhamsted Berkhamsted 38 68 53 59
7 Didcot Town Didcot Town 38 69 61 58
8 Thame United FC Thame United 38 60 61 57
9 Coleshill Town FC Coleshill 38 60 58 56
10 AFC Dunstable Dunstable 38 58 71 55
11 Yaxley FC Yaxley FC 38 72 92 49
12 Cambridge City Cambridge 38 58 54 47
13 Welwyn Garden City Welwyn 38 52 64 43
14 Kempston Rovers Kempston 38 58 75 43
15 Aylesbury United Aylesbury 38 62 86 42
16 Barton Rovers Barton 38 45 68 41
17 North Leigh North Leigh 38 67 106 34
18 Kidlington Kidlington 38 43 82 34
19 Aylesbury Aylesbury 38 42 79 31
20 Dunstable Town Dunstable 38 49 92 31
TEMPORADA 2017/2018
NON LEAGUE DIVISION 1 GRUPO 5
Equipo PJ GF GC Puntos
1 Beaconsfield Beaconsfield 42 99 46 92
2 Rushden & Diamonds Rushden 42 92 25 91
3 Hayes & Yeading United Hayes 42 103 49 83
4 Hartley Wintney Hartley 42 96 53 82
5 AFC Dunstable Dunstable 42 80 37 79
6 Cambridge City Cambridge 42 99 53 77
7 Kempston Rovers Kempston 42 80 68 73
8 Bedford Town Bedford Town 42 70 48 72
9 Chalfont St Peter Chalfont 42 56 39 72
10 Moneyfields Moneyfields 42 79 63 69
11 Thame United FC Thame United 42 84 78 64
12 Ashford Town Ashford Town 42 81 68 56
13 Aylesbury United Aylesbury 42 52 73 55
14 Marlow FC Marlow FC 42 54 75 49
15 Uxbridge Uxbridge 42 58 87 49
16 Egham Town Egham Town 42 54 88 48
17 Northwood Northwood 42 54 71 41
18 Hanwell Town Hanwell Town 42 48 88 34
19 Fleet Town Fleet Town 42 38 86 34
20 Barton Rovers Barton 42 39 86 33
21 Aylesbury Aylesbury 42 40 88 33
22 Arlesey Town Arlesey Town 42 36 123 14
TEMPORADA 2005/2006
NON LEAGUE DIVISION 1 GRUPO 2
Equipo PJ GF GC Puntos
1 Clevedon Town Clevedon 42 85 45 90
2 Ashford Town Ashford Town 42 84 50 80
3 Brackley Town Brackley 42 71 34 78
4 Hemel Hempstead Town Hemel 42 86 47 75
5 Swindon Supermarine Swindon 41 67 47 72
6 Marlow FC Marlow FC 42 62 60 70
7 Sutton Coldfield Town Sutton 42 91 62 69
8 Leighton Town Leighton 42 55 48 65
9 Willenhall Town FC Willenhall 42 78 61 63
10 Rushall Olympic Rushall 42 73 57 62
11 Bromsgrove Rovers Bromsgrove 42 65 50 62
12 Solihull Borough Solihull 42 50 51 58
13 Beaconsfield Beaconsfield 42 60 66 53
14 Burnham Burnham 42 58 71 53
15 Bedworth United Bedworth 42 47 57 52
16 Cinderford Town Cinderford 42 71 79 51
17 Paulton Rovers Paulton 41 55 73 46
18 Taunton Town Taunton Town 42 67 81 45
19 Bracknell Town FC Bracknell 42 53 77 42
20 Stourport Swifts Stourport 42 55 80 41
21 Dunstable Town Dunstable 42 45 91 36
22 Thame United FC Thame United 42 31 122 18
TEMPORADA 2004/2005
NON LEAGUE DIVISION 1 GRUPO 3
Equipo PJ GF GC Puntos
1 Mangotsfield United Mangotsfield 41 88 48 82
2 Yate Town Yate Town 42 83 40 81
3 Clevedon Town Clevedon 43 84 50 81
4 Evesham United Evesham 42 66 31 79
5 Bromsgrove Rovers Bromsgrove 41 59 39 72
6 Brackley Town Brackley 42 69 53 64
7 Ashford Town Ashford Town 41 62 45 63
8 Paulton Rovers Paulton 42 62 61 61
9 Sutton Coldfield Town Sutton 42 54 61 59
10 Rothwell Town Rothwell 42 57 57 58
11 Thame United FC Thame United 43 59 71 57
12 Burnham Burnham 41 61 63 55
13 Corby Town Corby Town 42 52 62 54
14 Marlow FC Marlow FC 42 58 67 53
15 Stourport Swifts Stourport 42 62 63 52
16 Bedworth United Bedworth 42 51 60 52
17 Cinderford Town Cinderford 42 50 64 51
18 Taunton Town Taunton Town 42 66 75 50
19 Swindon Supermarine Swindon 42 43 60 48
20 Bracknell Town FC Bracknell 42 53 75 43
21 Oxford City Oxford City 42 49 71 41
22 Egham Town Egham Town 42 25 97 22

  USO DE MEMORIA  
6,583,296 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.5467
Total Execution Time  0.5488
  CADENA URL  
/historico/Thame-United-Fc
  GET DATOS  
$_GET['/historico/Thame-United-Fc']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (32)  
0.0137  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 = 'Thame-United-Fc' 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.0125  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=10623 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=10623 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=10623 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=10623 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0252  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 = 72986
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=10623 AND type_rel = 2
0.0131  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '10623' ORDER BY l.year DESC,cat.coefficient DESC
0.0129  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 = '10623' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0129  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 = '10623' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0129  SELECT t.id 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=10623 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (72986,72728,72677,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.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 72986 AND teamId = 10623
0.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 72728 AND teamId = 10623
0.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 72677 AND teamId = 10623
0.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 10623
0.0128  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 = '10623' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '10623' and rp.type = 4
0.0126  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 = '10623' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0128  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 = 72986 WHERE rp.league_id = 72986 AND rp.teamId = 10623 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.0127  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 = 72986 WHERE rp.league_id = 72986 AND rp.teamId = 10623 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0126  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 = 72986 WHERE rp.league_id = 72986 AND rp.teamId = 10623 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0130  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 = 10623 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0130  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 72986 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 68460 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 63534 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 58744 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 50971 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.0131  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2019` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 44459 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 39172 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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 = 25097 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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 = 25117 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC