4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del SD Sofán
TEMPORADA 2023/2024
PREFERENTE GALICIA GRUPO 1
Equipo PJ GF GC Puntos
1 Noia Noia 31 62 28 63
2 Boiro Boiro 30 51 25 56
3 Sigueiro CF Sigueiro CF 30 54 35 54
4 San Tirso SD Tirso 30 36 28 53
5 CD Lalín CD Lalín 30 49 39 49
6 SD Sofán SD Sofán 30 52 38 48
7 AD Miño AD Miño 30 42 33 46
8 At. Coruña Montañeros Coruña 30 40 26 45
9 Cidade de Ribeira CF Cidade 30 52 52 39
10 Dubra Dubra 31 35 43 39
11 Galicia Mugardos Galicia 30 33 35 38
12 Ribadeo FC Ribadeo FC 30 43 50 36
13 Club Lemos Club Lemos 30 31 40 35
14 CD Castro CD Castro 30 41 50 33
15 Victoria CF Victoria CF 30 30 52 30
16 SDC Residencia Residencia 30 34 56 29
17 As Pontes As Pontes 30 30 42 28
18 Eume Deportivo Eume 30 29 72 18
TEMPORADA 2022/2023
PREFERENTE GALICIA GRUPO 1
Equipo PJ GF GC Puntos
1 SD Sarriana SD Sarriana 38 79 31 83
2 Betanzos CF Betanzos CF 38 83 38 82
3 Boiro Boiro 38 74 25 79
4 Noia Noia 38 70 28 79
5 San Tirso SD Tirso 38 74 43 57
6 Dubra Dubra 38 51 54 56
7 SDC Residencia Residencia 38 51 46 55
8 Galicia Mugardos Galicia 38 53 43 55
9 SD Sofán SD Sofán 38 55 59 54
10 Ribadeo FC Ribadeo FC 38 53 62 53
11 O Pino O Pino 38 66 80 52
12 At. Coruña Montañeros Coruña 38 62 55 51
13 Sigueiro CF Sigueiro CF 38 55 50 51
14 Club Lemos Club Lemos 38 55 57 50
15 Victoria CF Victoria CF 38 53 51 49
16 As Pontes As Pontes 38 47 52 49
17 Club Ordenes SD Club Ordenes 38 49 54 46
18 CD Union CD Union 38 49 71 42
19 SD Fisterra SD Fisterra 38 30 143 15
20 Portomarín Portomarín 38 31 98 9
TEMPORADA 2021/2022
TERCERA FEDERACIÓN GRUPO 1
Equipo PJ GF GC Puntos
1 CD Lugo B CD Lugo B 32 54 23 68
2 Ourense CF Ourense CF 32 48 21 67
3 Somozas Somozas 32 43 30 63
4 Barco Barco 32 50 37 54
5 Deportivo Fabril Deportivo 32 49 23 53
6 Rápido de Bouzas Rápido 32 39 26 51
7 RC Villalbés Villalbés 32 43 24 50
8 CD Estradense Estradense 32 36 40 44
9 Alondras CF Alondras CF 32 30 29 40
10 Silva SD Silva SD 32 34 41 39
11 CSD Arzua CSD Arzua 32 29 35 38
12 Viveiro Viveiro 32 32 42 36
13 Choco Choco 32 32 43 35
14 Noia Noia 32 30 49 29
15 Juvenil Ponteareas Juvenil 32 25 43 28
16 At. Arnoia At. Arnoia 32 25 54 22
17 SD Sofán SD Sofán 32 29 68 17
TEMPORADA 2020/2021
PREFERENTE GALICIA GRUPO 7
Equipo PJ GF GC Puntos
1 Noia Noia 4 8 2 12
2 SD Sofán SD Sofán 4 4 2 10
3 SD Sarriana SD Sarriana 4 4 3 10
4 At. Coruña Montañeros Coruña 4 3 2 7
5 Boiro Boiro 4 4 4 7
6 Club Lemos Club Lemos 4 0 10 1
TEMPORADA 2019/2020
PREFERENTE GALICIA GRUPO 1
Equipo PJ GF GC Puntos
1 Viveiro Viveiro 26 57 21 62
2 SD Fisterra SD Fisterra 26 45 29 51
3 Boiro Boiro 26 38 31 47
4 Noia Noia 26 44 26 46
5 Galicia Mugardos Galicia 26 41 29 45
6 Puebla CF Puebla CF 26 28 23 43
7 At. Arteixo At. Arteixo 26 32 24 42
8 SD Sofán SD Sofán 26 44 33 41
9 SD Sarriana SD Sarriana 26 53 33 38
10 Ribadeo FC Ribadeo FC 26 38 35 37
11 Sigueiro CF Sigueiro CF 26 28 26 35
12 San Tirso SD Tirso 26 29 34 35
13 Boimorto CF Boimorto CF 26 41 45 32
14 SDC Residencia Residencia 26 32 39 32
15 Club Lemos Club Lemos 26 31 46 31
16 Dubra Dubra 26 41 48 27
17 At. Coruña Montañeros Coruña 26 26 40 24
18 Xallas FC Xallas FC 26 31 66 20
19 Laracha Laracha 26 27 41 19
20 CD Foz CD Foz 26 24 61 15
TEMPORADA 2018/2019
PREFERENTE GALICIA GRUPO 1
Equipo PJ GF GC Puntos
1 As Pontes As Pontes 38 123 40 92
2 CSD Arzua CSD Arzua 38 88 45 81
3 Viveiro Viveiro 38 101 52 79
4 SD Sarriana SD Sarriana 38 71 39 76
5 Noia Noia 38 80 51 76
6 Ribadeo FC Ribadeo FC 38 63 58 67
7 SD Sofán SD Sofán 38 74 59 56
8 Dubra Dubra 38 67 61 56
9 At. Arteixo At. Arteixo 38 61 46 55
10 At. Coruña Montañeros Coruña 38 54 50 52
11 Boimorto CF Boimorto CF 38 65 58 51
12 San Tirso SD Tirso 38 58 61 49
13 Puebla CF Puebla CF 38 48 53 49
14 Xallas FC Xallas FC 38 56 63 49
15 CD Foz CD Foz 38 58 76 48
16 Negreira Negreira 38 45 51 46
17 Club Ordenes SD Club Ordenes 38 53 70 41
18 SD Agolada SD Agolada 38 47 73 26
19 CD Castro CD Castro 38 36 138 10
20 AD Estudiantil Estudiantil 38 28 132 6
TEMPORADA 2017/2018
PREFERENTE GALICIA GRUPO 1
Equipo PJ GF GC Puntos
1 CD Lugo B CD Lugo B 38 83 31 79
2 UD Paiosaco UD Paiosaco 38 66 32 79
3 As Pontes As Pontes 38 85 34 77
4 Ribadeo FC Ribadeo FC 38 71 58 67
5 Dubra Dubra 38 58 45 62
6 CD Castro CD Castro 38 59 50 59
7 CSD Arzua CSD Arzua 38 51 48 56
8 At. Arteixo At. Arteixo 38 61 62 54
9 Xallas FC Xallas FC 38 48 48 51
10 AD Estudiantil Estudiantil 38 45 48 49
11 San Tirso SD Tirso 38 52 55 48
12 SD Sofán SD Sofán 38 55 61 48
13 Club Ordenes SD Club Ordenes 38 56 55 47
14 Viveiro Viveiro 38 67 69 46
15 Boimorto CF Boimorto CF 38 46 67 46
16 SDC Residencia Residencia 38 52 63 44
17 Betanzos CF Betanzos CF 38 50 66 44
18 CF Dumbría CF Dumbría 38 41 78 41
19 Atl. Escairón Atl. 38 38 67 32
20 Outeiro De Rei Outeiro 38 31 78 28
TEMPORADA 2016/2017
PREFERENTE GALICIA GRUPO 1
Equipo PJ GF GC Puntos
1 Noia Noia 38 62 34 79
2 Laracha Laracha 38 82 45 77
3 AD Estudiantil Estudiantil 38 74 38 76
4 CD Lugo B CD Lugo B 38 87 36 73
5 UD Paiosaco UD Paiosaco 38 64 41 65
6 Atl. Escairón Atl. 38 55 50 61
7 Ribadeo FC Ribadeo FC 38 65 60 60
8 Viveiro Viveiro 38 68 44 58
9 CSD Arzua CSD Arzua 38 73 40 57
10 At. Arteixo At. Arteixo 38 76 66 53
11 Xallas FC Xallas FC 38 52 48 53
12 SD Sofán SD Sofán 38 57 61 53
13 Betanzos CF Betanzos CF 38 51 49 51
14 Galicia Mugardos Galicia 38 53 55 47
15 Club Lemos Club Lemos 38 45 62 44
16 Bertamiráns FC Bertamiráns 38 40 62 39
17 SD Chantada SD Chantada 38 42 76 36
18 Soneira Sd Soneira Sd 38 46 88 35
19 SD Sarriana SD Sarriana 38 30 75 23
20 Sporting Sada Sporting 38 23 115 12
TEMPORADA 2015/2016
PRIMERA GALICIA GRUPO 2
Equipo PJ GF GC Puntos
1 Soneira Sd Soneira Sd 33 73 36 68
2 SD Sofán SD Sofán 34 67 35 67
3 Flavia Flavia 34 74 43 66
4 Val do Ulla Val do Ulla 34 71 45 65
5 CD Union CD Union 33 69 34 62
6 Cordeiro CF Cordeiro CF 34 75 44 60
7 SD Piloño SD Piloño 34 64 38 57
8 Sigueiro CF Sigueiro CF 34 66 54 51
9 Tordoia Tordoia 34 59 51 50
10 SD Agolada SD Agolada 34 53 40 50
11 Outes Outes 34 62 60 48
12 Lesende CFC Lousame Lesende 33 46 45 47
13 CD Baio CD Baio 34 34 55 37
14 Corme CF Corme CF 34 59 82 35
15 Bertamirans B Bertamirans 34 44 69 33
16 Hijos Palmeira Hijos 33 45 110 24
17 Carcacía Carcacía 34 31 88 18
18 Malpica SDC Malpica SDC 34 42 105 18
TEMPORADA 2014/2015
PRIMERA GALICIA GRUPO 2
Equipo PJ GF GC Puntos
1 SD Villestro Villestro 34 58 34 68
2 Puebla Galicia CF Puebla 34 52 27 66
3 CD Union CD Union 34 49 27 63
4 CD Baio CD Baio 34 52 43 58
5 Bertamirans B Bertamirans 34 55 50 55
6 SD Sofán SD Sofán 34 47 49 53
7 Malpica SDC Malpica SDC 34 42 43 45
8 Corme CF Corme CF 34 47 50 45
9 Cordeiro CF Cordeiro CF 34 37 40 45
10 Sigueiro CF Sigueiro CF 34 52 47 44
11 SD Piloño SD Piloño 34 41 42 44
12 Flavia Flavia 34 34 43 44
13 Soneira Sd Soneira Sd 34 44 42 43
14 Lesende CFC Lousame Lesende 34 43 49 41
15 SD Agolada SD Agolada 34 42 46 39
16 Amio CF Amio CF 34 42 54 37
17 CF Silleda CF Silleda 34 33 57 33
18 SD Esteirana Esteirana 34 36 63 31

  USO DE MEMORIA  
6,314,624 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.7138
Total Execution Time  0.7149
  CADENA URL  
/historico/Sd-Sofan
  GET DATOS  
$_GET['/historico/Sd-Sofan']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
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 = 'Sd-Sofan' 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=18907 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0149  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=18907 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0148  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=18907 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0307  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 = 73534
0.0161  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 = 74656
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=18907 AND type_rel = 2
0.0148  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=71 AND type_rel = 3
0.0162  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 71 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0161  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 (1255742,1252769,1104950,915136,915027) ORDER BY n.cover_points DESC, update_date DESC
0.0161  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 = '18907' ORDER BY l.year DESC,cat.coefficient DESC
0.0168  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 = '18907' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0160  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 = '18907' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0159  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 = 73534 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0154  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 = 74656 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0153  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=18907 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0147  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 (74656,73534) 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.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 73534 AND teamId = 18907
0.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 74656 AND teamId = 18907
0.0147  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 = '18907' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '18907' and rp.type = 4
0.0150  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 = '18907' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0156  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 = 73534 WHERE rp.league_id = 73534 AND rp.teamId = 18907 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.0155  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 = 73534 WHERE rp.league_id = 73534 AND rp.teamId = 18907 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0160  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 = 73534 WHERE rp.league_id = 73534 AND rp.teamId = 18907 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0155  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 = 18907 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0165  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 = 73534 AND t.round = 31 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0170  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 = 68756 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.0166  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 = 62385 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.0160  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 = 61701 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0159  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 = 62843 AND t.round = 4 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0178  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 = 51173 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0169  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 = 44618 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0166  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 = 39342 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0157  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 = 34033 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0158  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 = 16766 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0158  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 = 4052 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC