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

SD Sarriana

Entrenador: Jorge Cuesta

Temporada 2023/2024
TEMPORADA 2023/2024
TERCERA FEDERACIÓN GRUPO 1
Equipo PJ GF GC Puntos
1 Bergantiños FC Bergantiños 32 47 18 70
2 Celta C – Gran Peña Celta Gran. 32 46 30 57
3 Arosa Arosa 32 36 21 54
4 Ourense UD Ourense UD 32 44 34 51
5 SD Sarriana SD Sarriana 32 42 29 50
6 At. Arteixo At. Arteixo 32 45 35 47
7 Alondras CF Alondras CF 32 37 34 43
8 Silva SD Silva SD 32 35 32 43
9 CD Lugo B CD Lugo B 32 32 32 43
10 CD Estradense Estradense 32 29 30 42
11 Viveiro Viveiro 32 37 41 40
12 Betanzos CF Betanzos CF 32 34 31 39
13 Somozas Somozas 32 38 39 39
14 Rápido de Bouzas Rápido 32 33 38 39
15 Barbadás Barbadás 32 30 34 38
16 UD Paiosaco UD Paiosaco 32 29 39 38
17 Pontevedra B Pontevedra 32 25 61 23
18 CSD Arzua CSD Arzua 32 23 64 15
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
PREFERENTE GALICIA GRUPO 5
Equipo PJ GF GC Puntos
1 At. Arteixo At. Arteixo 10 16 7 29
2 UD Paiosaco UD Paiosaco 10 17 5 28
3 SD Sarriana SD Sarriana 10 15 10 26
4 Sigueiro CF Sigueiro CF 10 7 11 16
5 Betanzos CF Betanzos CF 10 12 12 15
6 Dubra Dubra 10 9 11 13
7 Club Lemos Club Lemos 10 7 10 12
8 SD Fisterra SD Fisterra 10 10 21 12
9 At. Coruña Montañeros Coruña 10 12 16 10
10 Galicia Mugardos Galicia 10 9 11 8
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
PRIMERA GALICIA GRUPO 3
Equipo PJ GF GC Puntos
1 SD Sarriana SD Sarriana 34 65 27 76
2 CD Foz CD Foz 34 81 39 75
3 Club Lemos Club Lemos 34 81 50 66
4 SD Chantada SD Chantada 34 63 39 63
5 Riotorto Riotorto 34 46 33 57
6 UD Xove Lago Xove Lago 34 74 48 56
7 SD Monterroso Monterroso 34 68 53 48
8 Santaballés Santaballés 34 49 38 47
9 Taboada CF Taboada CF 34 55 51 47
10 SD O Páramo Páramo 34 57 54 46
11 CD San Ciprián Ciprián 34 65 60 45
12 UD Pastoricense Pastoricense 34 45 43 45
13 ADC Valle del oro Valle 34 45 53 44
14 Sporting Pontenova Sporting 34 50 59 44
15 San Roque SDC Roque 34 35 68 36
16 Ferreira C.F. Ferreira 34 36 86 21
17 Xermade Xermade 34 33 88 21
18 AD Bóveda AD Bóveda 34 35 94 20
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
PREFERENTE GALICIA GRUPO 1
Equipo PJ GF GC Puntos
1 CD Castro CD Castro 38 67 31 78
2 Dubra Dubra 38 79 44 76
3 CSD Arzua CSD Arzua 38 58 40 76
4 At. Arteixo At. Arteixo 38 74 28 74
5 Bertamiráns FC Bertamiráns 38 56 31 66
6 UD Paiosaco UD Paiosaco 38 55 39 63
7 Sporting Sada Sporting 38 44 32 61
8 Viveiro Viveiro 38 62 48 56
9 Laracha Laracha 38 62 53 53
10 Club Lemos Club Lemos 38 59 48 51
11 SD Chantada SD Chantada 38 41 41 50
12 SD Sarriana SD Sarriana 38 39 41 48
13 Xallas FC Xallas FC 38 41 46 47
14 AD Estudiantil Estudiantil 38 48 52 46
15 SCD Milagrosa Milagrosa 38 41 62 44
16 SD Villestro Villestro 38 49 63 39
17 Puebla Galicia CF Puebla 38 41 64 31
18 Cidade de Ribeira CF Cidade 38 49 96 26
19 CF Dumbría CF Dumbría 38 31 86 22
20 O Val O Val 38 31 82 21
TEMPORADA 2014/2015
PREFERENTE GALICIA GRUPO 1
Equipo PJ GF GC Puntos
1 Negreira Negreira 38 74 41 82
2 Galicia Mugardos Galicia 38 64 47 72
3 Noia Noia 38 52 37 69
4 Dubra Dubra 38 67 53 66
5 At. Arteixo At. Arteixo 38 83 48 65
6 Sporting Sada Sporting 38 61 56 57
7 Viveiro Viveiro 38 53 60 55
8 CD Castro CD Castro 38 69 53 53
9 Cidade de Ribeira CF Cidade 38 68 69 51
10 CSD Arzua CSD Arzua 38 55 58 50
11 CF Dumbría CF Dumbría 38 43 52 50
12 AD Estudiantil Estudiantil 38 57 43 49
13 SD Chantada SD Chantada 38 53 58 49
14 O Val O Val 38 48 66 47
15 Xallas FC Xallas FC 38 52 58 45
16 SD Sarriana SD Sarriana 38 45 59 44
17 SDC Residencia Residencia 38 45 68 44
18 Atl. Escairón Atl. 38 51 69 39
19 Betanzos CF Betanzos CF 38 46 72 29
20 CD Dorneda CD Dorneda 38 53 72 28

  USO DE MEMORIA  
6,175,208 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5373
Total Execution Time  0.5386
  CADENA URL  
/historico/Sd-Sarriana
  GET DATOS  
$_GET['/historico/Sd-Sarriana']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (32)  
0.0134  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-Sarriana' 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=18875 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=18875 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=18875 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2470 AND type_rel = 3
0.0128  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 = '18875' ORDER BY l.year DESC,cat.coefficient DESC
0.0128  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 = '18875' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0127  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 = '18875' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126  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 = 72260 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0127  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=18875 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 (72260,68756) 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.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 72260 AND teamId = 18875
0.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 68756 AND teamId = 18875
0.0127  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 = '18875' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0126  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '18875' and rp.type = 4
0.0130  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 = '18875' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0164  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 = 72260 WHERE rp.league_id = 72260 AND rp.teamId = 18875 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.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 = 72260 WHERE rp.league_id = 72260 AND rp.teamId = 18875 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0154  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 = 72260 WHERE rp.league_id = 72260 AND rp.teamId = 18875 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 = 18875 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0255  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 = 72260 AND t.round = 32 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 `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.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 `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 = 64090 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.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 `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 = 67009 AND t.round = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 = 61703 AND t.round = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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.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 `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.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 = 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.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 `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 = 39706 AND t.round = 34 ORDER BY team.conference 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 `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.0135  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 = 16696 AND t.round = 38 ORDER BY team.conference 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 `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 = 4049 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC