4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Nashville SC

Nashville SC

Entrenador: Gary Smith

Temporada 2023/2024
TEMPORADA 2023/2024
MLS - LIGA USA
Equipo PJ GF GC Puntos
1 Inter Miami Inter Miami 10 22 15 18
2 New York RB New York RB 9 13 9 16
3 Cincinnati Cincinnati 9 10 8 15
4 Columbus Crew Columbus 9 12 9 14
5 Philadelphia Union Philadelphia 7 14 9 13
6 Toronto FC Toronto FC 9 9 12 13
7 Atlanta United Atlanta 8 13 9 11
8 New York City York City 9 9 9 11
9 Charlotte FC Charlotte 9 9 11 11
10 CF Montréal Montréal 8 12 16 11
11 DC United DC United 9 12 14 10
12 Orlando City Orlando City 8 10 15 9
13 Chicago Fire Chicago Fire 9 11 18 9
14 Nashville SC Nashville 8 9 16 7
15 New England Revolution England 8 5 14 4
16 LA Galaxy LA Galaxy 9 21 15 18
17 Vancouver Whitecaps Vancouver 8 17 9 16
18 Real Salt Lake Real Salt L. 9 15 8 15
19 Colorado Rapids Colorado 9 15 13 15
20 Minnesota United Minnesota 8 13 9 14
21 Houston Dynamo Houston 8 9 8 13
22 Los Angeles FC Angeles 9 15 14 12
23 St. Louis City Louis City 9 15 14 12
24 Austin FC Austin FC 9 12 13 12
25 Sporting Kansas City Sporting 9 17 16 11
26 Portland Timbers Portland 9 18 18 10
27 Seattle Sounders Seattle 8 9 9 6
28 FC Dallas FC Dallas 8 7 12 5
29 San Jose Earthquakes Jose 9 13 24 3
TEMPORADA 2022/2023
MLS - LIGA USA
Equipo PJ GF GC Puntos
1 Cincinnati Cincinnati 34 57 39 69
2 Orlando City Orlando City 34 55 39 63
3 Columbus Crew Columbus 34 67 46 57
4 Philadelphia Union Philadelphia 34 57 41 55
5 New England Revolution England 34 58 46 55
6 Atlanta United Atlanta 34 66 53 51
7 Nashville SC Nashville 34 39 32 49
8 New York RB New York RB 34 36 39 43
9 Charlotte FC Charlotte 34 45 52 43
10 CF Montréal Montréal 34 36 52 41
11 New York City York City 34 35 39 41
12 DC United DC United 34 45 49 40
13 Chicago Fire Chicago Fire 34 39 51 40
14 Inter Miami Inter Miami 34 41 54 34
15 Toronto FC Toronto FC 34 26 59 22
16 St. Louis City Louis City 33 62 43 56
17 Los Angeles FC Angeles 33 53 38 51
18 Houston Dynamo Houston 34 51 38 51
19 Real Salt Lake Real Salt L. 34 48 50 50
20 Seattle Sounders Seattle 33 39 32 50
21 Vancouver Whitecaps Vancouver 33 54 47 47
22 FC Dallas FC Dallas 34 41 37 46
23 San Jose Earthquakes Jose 34 39 43 44
24 Portland Timbers Portland 34 46 58 43
25 Sporting Kansas City Sporting 33 45 50 41
26 Minnesota United Minnesota 33 45 48 41
27 Austin FC Austin FC 34 49 55 39
28 LA Galaxy LA Galaxy 34 51 67 36
29 Colorado Rapids Colorado 34 26 54 27
TEMPORADA 2021/2022
MLS - LIGA USA
Equipo PJ GF GC Puntos
1 Philadelphia Union Philadelphia 34 72 26 67
2 CF Montréal Montréal 34 63 50 65
3 New York City York City 34 57 41 55
4 New York RB New York RB 34 50 41 53
5 Cincinnati Cincinnati 34 64 56 49
6 Inter Miami Inter Miami 34 47 56 48
7 Orlando City Orlando City 34 44 53 48
8 Columbus Crew Columbus 34 46 41 46
9 Charlotte FC Charlotte 34 44 52 42
10 New England Revolution England 34 47 50 42
11 Atlanta United Atlanta 34 48 54 40
12 Chicago Fire Chicago Fire 34 39 48 39
13 Toronto FC Toronto FC 34 49 66 34
14 DC United DC United 34 36 71 27
15 Los Angeles FC Angeles 34 66 38 67
16 Austin FC Austin FC 34 65 49 56
17 FC Dallas FC Dallas 34 48 37 53
18 LA Galaxy LA Galaxy 34 58 51 50
19 Nashville SC Nashville 34 52 41 50
20 Minnesota United Minnesota 34 48 51 48
21 Real Salt Lake Real Salt L. 34 43 45 47
22 Portland Timbers Portland 34 53 53 46
23 Vancouver Whitecaps Vancouver 34 40 57 43
24 Colorado Rapids Colorado 34 46 57 43
25 Seattle Sounders Seattle 34 47 46 41
26 Sporting Kansas City Sporting 34 42 54 40
27 Houston Dynamo Houston 34 43 56 36
28 San Jose Earthquakes Jose 34 52 69 35
TEMPORADA 2020/2021
MLS - LIGA USA
Equipo PJ GF GC Puntos
1 New England Revolution England 34 65 41 73
2 Philadelphia Union Philadelphia 34 48 35 54
3 Nashville SC Nashville 34 55 33 54
4 New York City York City 34 56 36 51
5 Atlanta United Atlanta 34 45 37 51
6 Orlando City Orlando City 34 50 48 51
7 New York RB New York RB 34 39 33 48
8 DC United DC United 34 56 54 47
9 Columbus Crew Columbus 34 46 45 47
10 CF Montréal Montréal 34 46 44 46
11 Inter Miami Inter Miami 34 36 53 41
12 Chicago Fire Chicago Fire 34 36 54 34
13 Toronto FC Toronto FC 34 39 66 28
14 Cincinnati Cincinnati 34 37 74 20
15 Colorado Rapids Colorado 34 51 35 61
16 Seattle Sounders Seattle 34 53 33 60
17 Sporting Kansas City Sporting 34 58 40 58
18 Portland Timbers Portland 34 56 52 55
19 Minnesota United Minnesota 34 42 44 49
20 Vancouver Whitecaps Vancouver 34 45 45 49
21 Real Salt Lake Real Salt L. 34 55 54 48
22 LA Galaxy LA Galaxy 34 50 54 48
23 Los Angeles FC Angeles 34 53 51 45
24 San Jose Earthquakes Jose 34 46 54 41
25 FC Dallas FC Dallas 34 47 56 33
26 Austin FC Austin FC 34 35 56 31
27 Houston Dynamo Houston 34 36 54 30
TEMPORADA 2019/2020
MLS - LIGA USA GRUPO 1
Equipo PJ GF GC Puntos
1 Philadelphia Union Philadelphia 20 40 18 47
2 Toronto FC Toronto FC 20 27 21 44
3 Columbus Crew Columbus 20 29 21 41
4 Orlando City Orlando City 20 34 22 41
5 New York City York City 20 35 21 39
6 Nashville SC Nashville 23 24 22 32
7 New York RB New York RB 20 28 27 32
8 New England Revolution England 20 24 24 32
9 CF Montréal Montréal 20 29 38 26
10 Inter Miami Inter Miami 20 23 30 24
11 Chicago Fire Chicago Fire 20 31 34 23
12 Atlanta United Atlanta 20 23 27 22
13 DC United DC United 20 22 37 21
14 Cincinnati Cincinnati 20 9 32 16
15 Seattle Sounders Seattle 19 40 21 39
16 Sporting Kansas City Sporting 18 32 21 39
17 Portland Timbers Portland 20 40 31 39
18 Minnesota United Minnesota 18 32 23 34
19 FC Dallas FC Dallas 22 28 24 34
20 Los Angeles FC Angeles 19 36 32 32
21 San Jose Earthquakes Jose 20 29 48 30
22 Colorado Rapids Colorado 15 28 21 28
23 Vancouver Whitecaps Vancouver 20 22 37 27
24 Real Salt Lake Real Salt L. 19 23 33 22
25 LA Galaxy LA Galaxy 19 23 37 22
26 Houston Dynamo Houston 20 25 34 21
TEMPORADA 2018/2019
USL CHAMPIONSHIP - USA
Equipo PJ GF GC Puntos
1 Pittsburgh Riverhounds Pittsburgh 35 59 30 71
2 Nashville SC Nashville 34 59 26 67
3 Indy Eleven Indy Eleven 34 48 29 63
4 Louisville City Louisville 34 58 41 60
5 Tampa Bay Rowdies Tampa 34 61 33 58
6 New York RB II York 34 74 51 57
7 North Carolina North 34 57 37 56
8 Ottawa Fury Ottawa Fury 34 50 43 52
9 Charleston Battery Charleston 34 44 44 46
10 Birmingham Legion Birmingham 34 35 51 43
11 Saint Louis Saint Louis 34 40 41 42
12 Loudoun United Loudoun 34 59 65 39
13 Charlotte Independence Charlotte 34 42 53 38
14 Atlanta United II Atlanta 34 45 77 35
15 Memphis 901 Memphis 901 35 37 53 34
16 Philadelphia Union II Philadelphia 34 49 78 31
17 Hartford Athletic Hartford 34 49 80 29
18 Sporting Kansas City II Sporting 34 46 80 26
19 Phoenix Rising Phoenix 34 89 36 78
20 Reno 1868 Reno 1868 34 72 51 60
21 Fresno FC Fresno FC 34 58 44 57
22 Real Monarchs Real 34 71 53 56
23 Orange County SC Orange 34 54 43 54
24 El Paso Locomotive Paso 34 42 36 50
25 Sacramento Republic Sacramento 34 50 43 48
26 Austin Bold Austin Bold 34 53 52 48
27 LA Galaxy II Galaxy 34 59 62 48
28 New Mexico United Mexico 34 59 57 46
29 San Antonio San Antonio 34 62 57 45
30 Rio Grande Valley Grande 34 50 58 41
31 Las Vegas Lights Vegas Lights 34 46 56 41
32 Portland Timbers II Portland 34 65 71 38
33 OKC Energy OKC Energy 34 45 58 38
34 FC Tulsa FC Tulsa 34 45 69 34
35 Tacoma Defiance Tacoma 34 42 82 31
36 Colorado Springs Switchback Colorado 34 31 65 27
TEMPORADA 2017/2018
USL CHAMPIONSHIP - USA
Equipo PJ GF GC Puntos
1 Cincinnati Cincinnati 35 74 36 78
2 Louisville City Louisville 36 73 40 69
3 Pittsburgh Riverhounds Pittsburgh 35 48 26 62
4 Charleston Battery Charleston 34 47 34 56
5 New York RB II York 34 73 58 53
6 Nashville SC Nashville 35 42 31 50
7 Indy Eleven Indy Eleven 34 47 44 49
8 Philadelphia Union II Philadelphia 34 55 43 48
9 North Carolina North 34 60 50 47
10 Ottawa Fury Ottawa Fury 34 31 43 45
11 Tampa Bay Rowdies Tampa 36 48 47 44
12 Charlotte Independence Charlotte 34 44 57 42
13 Penn FC Penn FC 35 38 50 34
14 Atlanta United II Atlanta 34 37 72 31
15 Richmond Kickers Richmond 35 33 80 28
16 Toronto II Toronto II 35 43 80 18
17 Orange County SC Orange 36 72 41 70
18 Sacramento Republic Sacramento 35 50 33 68
19 Phoenix Rising Phoenix 35 64 39 64
20 Real Monarchs Real 35 55 50 60
21 Reno 1868 Reno 1868 34 57 37 59
22 Portland Timbers II Portland 35 60 53 55
23 Saint Louis Saint Louis 34 44 38 53
24 Sporting Kansas City II Sporting 35 53 56 53
25 San Antonio San Antonio 34 45 48 50
26 Fresno FC Fresno FC 35 48 40 42
27 OKC Energy OKC Energy 34 43 47 41
28 Colorado Springs Switchback Colorado 35 37 40 40
29 LA Galaxy II Galaxy 35 65 70 40
30 Rio Grande Valley Grande 34 36 42 38
31 Las Vegas Lights Vegas Lights 33 49 72 31
32 Seattle Sounders II Seattle 35 43 76 25
33 FC Tulsa FC Tulsa 34 36 77 21

  USO DE MEMORIA  
6,927,832 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.1605
Total Execution Time  0.1625
  CADENA URL  
/historico/Nashville-Sc
  GET DATOS  
$_GET['/historico/Nashville-Sc']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0034  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 = 'Nashville-Sc' 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.0019  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=109669 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  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=109669 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  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=109669 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=109669 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0027  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=109669 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0027  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 = 74866
0.0025  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 = 75358
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=109669 AND type_rel = 2
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 109669 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0021  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 (628887,801600,801562,856974,858128) ORDER BY n.cover_points DESC, update_date DESC
0.0026  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 = '109669' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021  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 = 74866 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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 = 75358 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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 = 74856 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0029  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=109669 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (75358,74866,74856,71432,71035) 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.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 74856 AND teamId = 109669
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 71035 AND teamId = 109669
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 74866 AND teamId = 109669
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 75358 AND teamId = 109669
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 109669
0.0027  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 74856 AND t.round = 10 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0031  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 = '109669' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '109669' and rp.type = 4
0.0020  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 = '109669' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0032  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 = 74856 WHERE rp.league_id = 74856 AND rp.teamId = 109669 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.0035  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 = 74856 WHERE rp.league_id = 74856 AND rp.teamId = 109669 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0031  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 = 74856 WHERE rp.league_id = 74856 AND rp.teamId = 109669 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  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 = 109669 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0043  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 = 66172 AND t.round = 48 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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 = 60903 AND t.round = 46 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032  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 = 51829 AND t.round = 25 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0044  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 = 48501 AND t.round = 62 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0050  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 = 42470 AND t.round = 57 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC