4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver jornada
Jornada 1
03 Ago 19 Brechin CityBrechin 0 - 1 Annan AthleticAnnan ...
03 Ago 19 Cove RangersCove 5 - 0 Edinburgh CityEdinburgh ...
03 Ago 19 Elgin CityElgin City 3 - 0 CowdenbeathCowdenbeath ...
03 Ago 19 StenhousemuirStenhousemu 2 - 3 Albion RoversAlbion ...
03 Ago 19 Stirling AlbionStirling 0 - 1 Queen's ParkQueen's ...
Ver jornada
Jornada 2
10 Ago 19 Albion RoversAlbion 4 - 4 Cove RangersCove ...
10 Ago 19 Annan AthleticAnnan 1 - 1 Elgin CityElgin City ...
10 Ago 19 CowdenbeathCowdenbeath 1 - 0 Stirling AlbionStirling ...
10 Ago 19 Edinburgh CityEdinburgh 2 - 1 Brechin CityBrechin ...
10 Ago 19 Queen's ParkQueen's 1 - 1 StenhousemuirStenhousemu ...
Ver jornada
Jornada 3
17 Ago 19 Annan AthleticAnnan 3 - 2 Albion RoversAlbion ...
17 Ago 19 Brechin CityBrechin 0 - 3 Queen's ParkQueen's ...
17 Ago 19 Cove RangersCove 3 - 2 CowdenbeathCowdenbeath ...
17 Ago 19 Edinburgh CityEdinburgh 1 - 0 Stirling AlbionStirling ...
17 Ago 19 Elgin CityElgin City 0 - 1 StenhousemuirStenhousemu ...
Ver jornada
Jornada 4
24 Ago 19 Albion RoversAlbion 0 - 1 Brechin CityBrechin ...
24 Ago 19 CowdenbeathCowdenbeath 3 - 1 Annan AthleticAnnan ...
24 Ago 19 Queen's ParkQueen's 0 - 0 Elgin CityElgin City ...
24 Ago 19 StenhousemuirStenhousemu 1 - 3 Edinburgh CityEdinburgh ...
24 Ago 19 Stirling AlbionStirling 1 - 2 Cove RangersCove ...
Ver jornada
Jornada 5
31 Ago 19 Albion RoversAlbion 2 - 1 Stirling AlbionStirling ...
31 Ago 19 Annan AthleticAnnan 1 - 1 StenhousemuirStenhousemu ...
31 Ago 19 Cove RangersCove 3 - 0 Queen's ParkQueen's ...
31 Ago 19 CowdenbeathCowdenbeath 2 - 1 Brechin CityBrechin ...
31 Ago 19 Elgin CityElgin City 3 - 3 Edinburgh CityEdinburgh ...
Ver jornada
Jornada 6
14 Sep 19 Brechin CityBrechin 2 - 4 Cove RangersCove ...
14 Sep 19 Edinburgh CityEdinburgh 4 - 0 Annan AthleticAnnan ...
14 Sep 19 Queen's ParkQueen's 1 - 1 Albion RoversAlbion ...
14 Sep 19 StenhousemuirStenhousemu 0 - 3 CowdenbeathCowdenbeath ...
14 Sep 19 Stirling AlbionStirling 1 - 0 Elgin CityElgin City ...
Ver jornada
Jornada 7
21 Sep 19 Albion RoversAlbion 1 - 3 Edinburgh CityEdinburgh ...
21 Sep 19 Annan AthleticAnnan 0 - 0 Stirling AlbionStirling ...
21 Sep 19 Elgin CityElgin City 0 - 2 Cove RangersCove ...
21 Sep 19 Queen's ParkQueen's 0 - 3 CowdenbeathCowdenbeath ...
21 Sep 19 StenhousemuirStenhousemu 1 - 0 Brechin CityBrechin ...
Ver jornada
Jornada 8
28 Sep 19 Brechin CityBrechin 2 - 1 Elgin CityElgin City ...
28 Sep 19 Cove RangersCove 3 - 0 Annan AthleticAnnan ...
28 Sep 19 CowdenbeathCowdenbeath 1 - 0 Albion RoversAlbion ...
28 Sep 19 Edinburgh CityEdinburgh 2 - 1 Queen's ParkQueen's ...
28 Sep 19 Stirling AlbionStirling 1 - 1 StenhousemuirStenhousemu ...
Ver jornada
Jornada 9
05 Oct 19 Albion RoversAlbion 1 - 3 Elgin CityElgin City ...
05 Oct 19 Brechin CityBrechin 1 - 1 Stirling AlbionStirling ...
05 Oct 19 CowdenbeathCowdenbeath 1 - 0 Edinburgh CityEdinburgh ...
05 Oct 19 Queen's ParkQueen's 1 - 2 Annan AthleticAnnan ...
05 Oct 19 StenhousemuirStenhousemu 3 - 2 Cove RangersCove ...
Ver jornada
Jornada 10
12 Nov 19 Annan AthleticAnnan 5 - 2 Brechin CityBrechin ...
29 Oct 19 Cove RangersCove 3 - 0 Albion RoversAlbion ...
29 Oct 19 Edinburgh CityEdinburgh 4 - 0 StenhousemuirStenhousemu ...
26 Oct 19 Elgin CityElgin City 3 - 1 Queen's ParkQueen's ...
29 Oct 19 Stirling AlbionStirling 0 - 0 CowdenbeathCowdenbeath ...
Ver jornada
Jornada 11
02 Nov 19 Brechin CityBrechin 2 - 3 Edinburgh CityEdinburgh ...
02 Nov 19 CowdenbeathCowdenbeath 1 - 3 Cove RangersCove ...
02 Nov 19 Elgin CityElgin City 4 - 0 Annan AthleticAnnan ...
02 Nov 19 StenhousemuirStenhousemu 0 - 3 Queen's ParkQueen's ...
02 Nov 19 Stirling AlbionStirling 3 - 0 Albion RoversAlbion ...
Ver jornada
Jornada 12
09 Nov 19 Albion RoversAlbion 2 - 1 StenhousemuirStenhousemu ...
09 Nov 19 Annan AthleticAnnan 1 - 0 CowdenbeathCowdenbeath ...
09 Nov 19 Cove RangersCove 1 - 0 Stirling AlbionStirling ...
09 Nov 19 Edinburgh CityEdinburgh 1 - 1 Elgin CityElgin City ...
09 Nov 19 Queen's ParkQueen's 5 - 2 Brechin CityBrechin ...
Ver jornada
Jornada 13
16 Nov 19 Cove RangersCove 3 - 0 Brechin CityBrechin ...
16 Nov 19 CowdenbeathCowdenbeath 1 - 0 Queen's ParkQueen's ...
16 Nov 19 Edinburgh CityEdinburgh 3 - 2 Albion RoversAlbion ...
03 Dic 19 StenhousemuirStenhousemu 2 - 2 Elgin CityElgin City ...
16 Nov 19 Stirling AlbionStirling 2 - 0 Annan AthleticAnnan ...
Ver jornada
Jornada 14
24 Mar 20 Albion RoversAlbion Apl CowdenbeathCowdenbeath ...
30 Nov 19 Annan AthleticAnnan 6 - 1 Cove RangersCove ...
30 Nov 19 Brechin CityBrechin 1 - 2 StenhousemuirStenhousemu ...
30 Nov 19 Elgin CityElgin City 1 - 2 Stirling AlbionStirling ...
30 Nov 19 Queen's ParkQueen's 2 - 1 Edinburgh CityEdinburgh ...
Ver jornada
Jornada 15
07 Dic 19 Albion RoversAlbion 2 - 0 Queen's ParkQueen's ...
07 Dic 19 CowdenbeathCowdenbeath 0 - 0 Elgin CityElgin City ...
07 Dic 19 Edinburgh CityEdinburgh 2 - 1 Cove RangersCove ...
07 Dic 19 StenhousemuirStenhousemu 1 - 2 Annan AthleticAnnan ...
07 Dic 19 Stirling AlbionStirling 2 - 4 Brechin CityBrechin ...
Ver jornada
Jornada 16
14 Dic 19 Annan AthleticAnnan 0 - 2 Edinburgh CityEdinburgh ...
14 Dic 19 Brechin CityBrechin 2 - 1 CowdenbeathCowdenbeath ...
14 Dic 19 Cove RangersCove 2 - 1 StenhousemuirStenhousemu ...
14 Dic 19 Elgin CityElgin City 2 - 2 Albion RoversAlbion ...
14 Dic 19 Queen's ParkQueen's 1 - 1 Stirling AlbionStirling ...
Ver jornada
Jornada 17
21 Dic 19 Albion RoversAlbion 4 - 2 Annan AthleticAnnan ...
21 Dic 19 CowdenbeathCowdenbeath 3 - 1 StenhousemuirStenhousemu ...
21 Dic 19 Elgin CityElgin City 3 - 1 Brechin CityBrechin ...
21 Dic 19 Queen's ParkQueen's 1 - 3 Cove RangersCove ...
21 Dic 19 Stirling AlbionStirling 0 - 1 Edinburgh CityEdinburgh ...
Ver jornada
Jornada 18
28 Dic 19 Annan AthleticAnnan 3 - 2 Queen's ParkQueen's ...
28 Dic 19 Brechin CityBrechin 0 - 0 Albion RoversAlbion ...
28 Dic 19 Cove RangersCove 2 - 0 Elgin CityElgin City 1
28 Dic 19 Edinburgh CityEdinburgh 2 - 0 CowdenbeathCowdenbeath ...
28 Dic 19 StenhousemuirStenhousemu 0 - 2 Stirling AlbionStirling 1
Ver jornada
Jornada 19
04 Ene 20 Albion RoversAlbion 0 - 3 Stirling AlbionStirling ...
04 Ene 20 Brechin CityBrechin 1 - 5 Cove RangersCove ...
04 Ene 20 CowdenbeathCowdenbeath 3 - 1 Annan AthleticAnnan ...
04 Ene 20 Elgin CityElgin City 0 - 1 Edinburgh CityEdinburgh ...
04 Ene 20 Queen's ParkQueen's 2 - 1 StenhousemuirStenhousemu ...
Ver jornada
Jornada 20
11 Ene 20 Annan AthleticAnnan 0 - 4 Elgin CityElgin City ...
03 Mar 20 CowdenbeathCowdenbeath 2 - 1 Albion RoversAlbion ...
11 Ene 20 Edinburgh CityEdinburgh 1 - 2 Queen's ParkQueen's ...
11 Ene 20 StenhousemuirStenhousemu 2 - 2 Brechin CityBrechin ...
10 Mar 20 Stirling AlbionStirling 1 - 7 Cove RangersCove 1
Ver jornada
Jornada 21
17 Mar 20 Albion RoversAlbion Apl Edinburgh CityEdinburgh ...
18 Ene 20 Annan AthleticAnnan 2 - 3 Stirling AlbionStirling ...
26 Feb 20 Brechin CityBrechin 0 - 0 Queen's ParkQueen's 4
18 Ene 20 Cove RangersCove 3 - 1 CowdenbeathCowdenbeath ...
18 Ene 20 Elgin CityElgin City 2 - 3 StenhousemuirStenhousemu ...
Ver jornada
Jornada 22
25 Ene 20 Cove RangersCove 2 - 0 Annan AthleticAnnan ...
25 Ene 20 CowdenbeathCowdenbeath 3 - 2 Brechin CityBrechin ...
25 Ene 20 Queen's ParkQueen's 2 - 2 Albion RoversAlbion ...
25 Ene 20 StenhousemuirStenhousemu 1 - 2 Edinburgh CityEdinburgh ...
25 Ene 20 Stirling AlbionStirling 1 - 2 Elgin CityElgin City ...
Ver jornada
Jornada 23
01 Feb 20 Albion RoversAlbion 2 - 2 Cove RangersCove ...
01 Feb 20 Annan AthleticAnnan 0 - 3 StenhousemuirStenhousemu ...
01 Feb 20 Brechin CityBrechin 1 - 2 Elgin CityElgin City ...
01 Feb 20 Edinburgh CityEdinburgh 0 - 1 Stirling AlbionStirling ...
01 Feb 20 Queen's ParkQueen's 1 - 0 CowdenbeathCowdenbeath ...
Ver jornada
Jornada 24
08 Feb 20 Albion RoversAlbion 4 - 1 Brechin CityBrechin ...
08 Feb 20 Edinburgh CityEdinburgh 3 - 0 Annan AthleticAnnan ...
08 Feb 20 Elgin CityElgin City 3 - 0 Cove RangersCove ...
08 Feb 20 StenhousemuirStenhousemu 2 - 2 CowdenbeathCowdenbeath ...
08 Feb 20 Stirling AlbionStirling 1 - 3 Queen's ParkQueen's ...
Ver jornada
Jornada 25
18 Mar 20 Brechin CityBrechin Apl Annan AthleticAnnan ...
15 Feb 20 Cove RangersCove 2 - 1 Edinburgh CityEdinburgh ...
15 Feb 20 CowdenbeathCowdenbeath 1 - 4 Stirling AlbionStirling ...
15 Feb 20 Queen's ParkQueen's 2 - 0 Elgin CityElgin City ...
15 Feb 20 StenhousemuirStenhousemu 1 - 0 Albion RoversAlbion ...
Ver jornada
Jornada 26
22 Feb 20 Annan AthleticAnnan 2 - 1 Albion RoversAlbion ...
22 Feb 20 Cove RangersCove 2 - 0 Queen's ParkQueen's ...
22 Feb 20 Edinburgh CityEdinburgh 0 - 0 Brechin CityBrechin ...
10 Mar 20 Elgin CityElgin City 3 - 2 CowdenbeathCowdenbeath ...
03 Mar 20 Stirling AlbionStirling 0 - 0 StenhousemuirStenhousemu ...
Ver jornada
Jornada 27
29 Feb 20 Albion RoversAlbion 1 - 2 Elgin CityElgin City ...
29 Feb 20 Brechin CityBrechin 0 - 2 Stirling AlbionStirling ...
29 Feb 20 CowdenbeathCowdenbeath 1 - 1 Edinburgh CityEdinburgh ...
29 Feb 20 Queen's ParkQueen's 2 - 0 Annan AthleticAnnan ...
29 Feb 20 StenhousemuirStenhousemu 0 - 3 Cove RangersCove ...
Ver jornada
Jornada 28
07 Mar 20 Annan AthleticAnnan 0 - 0 CowdenbeathCowdenbeath ...
07 Mar 20 Cove RangersCove 3 - 2 Brechin CityBrechin ...
07 Mar 20 Edinburgh CityEdinburgh 3 - 0 Albion RoversAlbion ...
07 Mar 20 Elgin CityElgin City 3 - 1 Stirling AlbionStirling ...
07 Mar 20 StenhousemuirStenhousemu 0 - 0 Queen's ParkQueen's ...
Ver jornada
Jornada 29
14 Mar 20 Albion RoversAlbion Apl Queen's ParkQueen's ...
14 Mar 20 CowdenbeathCowdenbeath Apl Cove RangersCove ...
14 Mar 20 Edinburgh CityEdinburgh Apl StenhousemuirStenhousemu ...
14 Mar 20 Elgin CityElgin City Apl Brechin CityBrechin ...
14 Mar 20 Stirling AlbionStirling Apl Annan AthleticAnnan ...
Ver jornada
Jornada 30
21 Mar 20 Annan AthleticAnnan Apl Edinburgh CityEdinburgh ...
21 Mar 20 Brechin CityBrechin Apl CowdenbeathCowdenbeath ...
21 Mar 20 Cove RangersCove Apl Albion RoversAlbion ...
21 Mar 20 Queen's ParkQueen's Apl Stirling AlbionStirling ...
21 Mar 20 StenhousemuirStenhousemu Apl Elgin CityElgin City ...
Ver jornada
Jornada 31
28 Mar 20 Annan AthleticAnnan Apl Brechin CityBrechin ...
28 Mar 20 CowdenbeathCowdenbeath Apl StenhousemuirStenhousemu ...
28 Mar 20 Edinburgh CityEdinburgh Apl Cove RangersCove ...
28 Mar 20 Elgin CityElgin City Apl Queen's ParkQueen's ...
28 Mar 20 Stirling AlbionStirling Apl Albion RoversAlbion ...
Ver jornada
Jornada 32
04 Abr 20 Albion RoversAlbion Apl Annan AthleticAnnan ...
04 Abr 20 Brechin CityBrechin Apl StenhousemuirStenhousemu ...
04 Abr 20 Cove RangersCove Apl Elgin CityElgin City ...
04 Abr 20 Queen's ParkQueen's Apl Edinburgh CityEdinburgh ...
04 Abr 20 Stirling AlbionStirling Apl CowdenbeathCowdenbeath ...
Ver jornada
Jornada 33
11 Abr 20 Annan AthleticAnnan Apl Cove RangersCove ...
11 Abr 20 Brechin CityBrechin Apl Albion RoversAlbion ...
11 Abr 20 CowdenbeathCowdenbeath Apl Queen's ParkQueen's ...
11 Abr 20 Edinburgh CityEdinburgh Apl Elgin CityElgin City ...
11 Abr 20 StenhousemuirStenhousemu Apl Stirling AlbionStirling ...
Ver jornada
Jornada 34
18 Abr 20 Albion RoversAlbion Apl CowdenbeathCowdenbeath ...
18 Abr 20 Cove RangersCove Apl StenhousemuirStenhousemu ...
18 Abr 20 Elgin CityElgin City Apl Annan AthleticAnnan ...
18 Abr 20 Queen's ParkQueen's Apl Brechin CityBrechin ...
18 Abr 20 Stirling AlbionStirling Apl Edinburgh CityEdinburgh ...
Ver jornada
Jornada 35
25 Abr 20 Edinburgh CityEdinburgh Apl CowdenbeathCowdenbeath ...
25 Abr 20 Elgin CityElgin City Apl Albion RoversAlbion ...
25 Abr 20 Queen's ParkQueen's Apl Cove RangersCove ...
25 Abr 20 StenhousemuirStenhousemu Apl Annan AthleticAnnan ...
25 Abr 20 Stirling AlbionStirling Apl Brechin CityBrechin ...
Ver jornada
Jornada 36
02 May 20 Albion RoversAlbion Apl StenhousemuirStenhousemu ...
02 May 20 Annan AthleticAnnan Apl Queen's ParkQueen's ...
02 May 20 Brechin CityBrechin Apl Edinburgh CityEdinburgh ...
02 May 20 Cove RangersCove Apl Stirling AlbionStirling ...
02 May 20 CowdenbeathCowdenbeath Apl Elgin CityElgin City ...

Clasificación

Equipo PJ GF GC Puntos
1 Cove Rangers Cove Rangers 28 76 34 68
2 Edinburgh City Edinburgh 27 49 28 55
3 Elgin City Elgin City 28 48 34 43
4 Cowdenbeath Cowdenbeath 27 37 35 41
5 Queen's Park Queen's Park 28 37 35 40
6 Stirling Albion Stirling 28 34 35 36
7 Annan Athletic Annan 27 33 54 31
8 Stenhousemuir Stenhousemui 28 32 48 29
9 Albion Rovers Albion 26 37 51 24
10 Brechin City Brechin City 27 31 60 17

  USO DE MEMORIA  
6,030,728 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1523
Total Execution Time  0.1542
  CADENA URL  
/third_division2020/grupo1/calendario
  GET DATOS  
$_GET['/third_division2020/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=105 AND type_rel = 3
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 105 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0021  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 (993054,986341,823337,822097,808283) ORDER BY n.cover_points DESC, update_date DESC
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=105 ORDER BY order_id ASC
0.0020  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 50157 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0042  SELECT c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2, dt1.stadium as stadium_name FROM calendars2020 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 50157 ORDER BY round ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-01 18:41:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-01 18:41:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-01 18:41:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-01 18:41:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0247  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2020 e ON e.player_id = p.id AND e.league_id = 50157 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50157 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0295  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2020 e ON e.player_id = p.id AND e.league_id = 50157 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50157 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0032  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2020 e ON e.player_id = p.id AND e.league_id = 50157 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50157 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0027  SELECT *,(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 = 50157 AND t.round = 28 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC