4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Radan
TEMPORADA 2020/2021
TERCERA SERBIA GRUPO 3
Equipo PJ GF GC Puntos
1 Timok Timok 38 73 26 83
2 Budućnost Popovac Budućnost 38 91 27 82
3 Radnički Svilajnac Radnički 38 75 26 75
4 Vlasina Vlasina 38 52 35 70
5 Jedinstvo Paraćin Jedinstvo 38 74 38 66
6 Pcinja Trgoviste Pcinja 38 75 54 66
7 Rembas Rembas 38 75 49 65
8 Timočanin Timočanin 38 78 36 64
9 SFS Borac SFS Borac 38 72 49 63
10 Sinđelić Niš Sinđelić 38 66 37 62
11 Car Konstantin Konstantin 38 82 62 56
12 Dunav Prahovo Dunav 38 52 48 55
13 Trstenik PPT Trstenik 38 68 45 54
14 Radan Radan 38 68 44 51
15 Mladost Medsevac Mladost 38 49 67 41
16 Toplicanin Prokuplje Toplicanin 38 42 78 36
17 Župa Župa 38 53 88 31
18 Morava Vladicin Han Morava 38 50 81 30
19 Kablovi Zajecar Kablovi 38 29 185 15
20 Moravac Mrštane Moravac 38 33 182 7
TEMPORADA 2019/2020
TERCERA SERBIA GRUPO 3
Equipo PJ GF GC Puntos
1 Jagodina Jagodina 17 32 11 39
2 Budućnost Popovac Budućnost 17 27 6 34
3 Sinđelić Niš Sinđelić 17 27 15 33
4 Toplicanin Prokuplje Toplicanin 17 23 14 31
5 SFS Borac SFS Borac 17 23 14 30
6 Vlasina Vlasina 17 28 16 29
7 Timočanin Timočanin 17 22 17 27
8 Radan Radan 17 29 18 25
9 Moravac Mrštane Moravac 17 21 22 24
10 Dunav Prahovo Dunav 17 21 17 23
11 Car Konstantin Konstantin 17 18 26 22
12 Dubočica Dubočica 17 22 22 19
13 Rembas Rembas 17 24 31 15
14 Jedinstvo Bosnjace Jedinstvo 17 15 29 14
15 Trstenik PPT Trstenik 17 15 46 4
16 Temnic 1924 Temnic 1924 17 9 52 3
TEMPORADA 2018/2019
TERCERA SERBIA GRUPO 3
Equipo PJ GF GC Puntos
1 Radnički Pirot Radnički 34 96 19 85
2 Temnic 1924 Temnic 1924 34 66 20 80
3 Budućnost Popovac Budućnost 34 74 36 64
4 Jagodina Jagodina 34 53 26 64
5 Car Konstantin Konstantin 34 64 39 60
6 Moravac Mrštane Moravac 34 60 37 59
7 Sinđelić Niš Sinđelić 34 53 41 51
8 Dunav Prahovo Dunav 34 54 54 45
9 Dubočica Dubočica 34 62 66 45
10 SFS Borac SFS Borac 34 37 44 45
11 Jedinstvo Bosnjace Jedinstvo 34 41 55 44
12 Trstenik PPT Trstenik 34 37 49 40
13 Zaplanjac Zaplanjac 34 38 63 38
14 Radan Radan 34 31 52 37
15 Jedinstvo Paraćin Jedinstvo 34 36 72 36
16 Rtanj Rtanj 34 45 62 34
17 Radnički Svilajnac Radnički 34 39 79 30
18 Pukovac Pukovac 34 29 101 16
TEMPORADA 2017/2018
TERCERA SERBIA GRUPO 1
Equipo PJ GF GC Puntos
1 Trajal Krusevac Trajal 30 53 19 66
2 Car Konstantin Konstantin 30 49 44 52
3 Budućnost Popovac Budućnost 30 45 28 50
4 Sinđelić Niš Sinđelić 30 40 26 49
5 Jedinstvo Paraćin Jedinstvo 30 50 34 48
6 Rtanj Rtanj 30 46 32 47
7 Jedinstvo Bosnjace Jedinstvo 30 36 33 46
8 Dunav Prahovo Dunav 30 42 41 43
9 Radan Radan 30 36 39 42
10 Moravac Mrštane Moravac 30 46 40 41
11 Radnički Svilajnac Radnički 30 50 49 41
12 Pukovac Pukovac 30 44 46 41
13 Trstenik PPT Trstenik 30 37 45 34
14 Tabane Trgovački Tabane 30 43 51 32
15 Timok Timok 30 35 61 19
16 Ozren Sokobanja Ozren 30 17 81 11
TEMPORADA 2016/2017
TERCERA SERBIA GRUPO 2
Equipo PJ GF GC Puntos
1 Temnic 1924 Temnic 1924 30 61 29 66
2 Moravac Mrštane Moravac 30 52 20 61
3 Sinđelić Niš Sinđelić 30 42 19 53
4 Jedinstvo Bosnjace Jedinstvo 30 41 28 51
5 Radan Radan 30 47 42 46
6 Jedinstvo Paraćin Jedinstvo 30 47 27 43
7 Trstenik PPT Trstenik 30 46 44 42
8 Radnički Svilajnac Radnički 30 45 47 41
9 Dunav Prahovo Dunav 30 41 40 39
10 Timok Timok 30 28 21 36
11 Tabane Trgovački Tabane 30 51 62 35
12 Car Konstantin Konstantin 30 41 54 34
13 Ozren Sokobanja Ozren 30 35 49 32
14 Pukovac Pukovac 30 33 57 32
15 Sloga Despotovac Sloga 30 34 58 30
16 Vlasina Vlasina 30 14 61 12
TEMPORADA 2015/2016
TERCERA SERBIA GRUPO 2
Equipo PJ GF GC Puntos
1 Temnic 1924 Temnic 1924 15 19 10 31
2 Tabane Trgovački Tabane 15 28 11 30
3 Radnički Pirot Radnički 15 23 15 27
4 Dunav Prahovo Dunav 15 24 14 25
5 Radan Radan 15 21 14 24
6 Trstenik PPT Trstenik 15 15 17 23
7 Jedinstvo Bosnjace Jedinstvo 15 23 14 21
8 Car Konstantin Konstantin 15 24 19 21
9 Moravac Mrštane Moravac 15 11 7 21
10 Ozren Sokobanja Ozren 15 21 20 21
11 Radnički Svilajnac Radnički 15 27 27 21
12 Sinđelić Niš Sinđelić 15 18 17 19
13 Timok Timok 15 19 25 18
14 Sloga Despotovac Sloga 15 11 25 10
15 Timočanin Timočanin 15 11 32 8
16 Bor Bor 15 10 38 5
TEMPORADA 2014/2015
TERCERA SERBIA GRUPO 2
Equipo PJ GF GC Puntos
1 Dinamo Vranje Dinamo 30 57 30 65
2 Radnički Pirot Radnički 30 68 25 59
3 Trstenik PPT Trstenik 30 51 35 51
4 Car Konstantin Konstantin 30 46 37 48
5 Timok Timok 30 36 27 48
6 Radan Radan 30 32 26 48
7 Tabane Trgovački Tabane 30 40 30 45
8 Radnički Svilajnac Radnički 30 42 44 42
9 Bor Bor 30 46 52 42
10 Ozren Sokobanja Ozren 30 48 43 39
11 Timočanin Timočanin 30 36 49 39
12 Sloga Despotovac Sloga 30 36 63 38
13 Sinđelić Niš Sinđelić 30 40 46 36
14 Kopaonik Kopaonik 30 33 43 36
15 Djerdap Kladovo Djerdap 30 34 51 28
16 Hajduk Veljko Hajduk 30 32 76 22
TEMPORADA 2005/2006
TERCERA SERBIA Y MONTENEGRO GRUPO 4
Equipo PJ GF GC Puntos
1 Dinamo Vranje Dinamo 34 68 26 82
2 Sinđelić Niš Sinđelić 34 68 26 70
3 Železničar Niš Železničar 34 64 33 68
4 Sloga Leskovac Sloga 34 56 32 60
5 Jedinstvo DMu Jedinstvo 34 70 51 56
6 Dubočica Dubočica 34 65 40 55
7 Timok Timok 34 49 38 51
8 Rudar Alpos Rudar Alpos 34 61 56 51
9 Jedinstvo Paraćin Jedinstvo 34 42 46 49
10 Djerdap Kladovo Djerdap 34 62 46 48
11 Kopaonik Kopaonik 34 46 48 45
12 Car Konstantin Konstantin 34 51 51 42
13 Morava Vladicin Han Morava 34 45 53 40
14 Kosanica Kosanica 34 48 58 40
15 Radnički Svilajnac Radnički 34 44 52 38
16 Radan Radan 34 37 78 32
17 Pukovac Pukovac 34 39 107 24
18 Morava Ribare Morava 34 28 102 13

  USO DE MEMORIA  
5,814,840 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.7083
Total Execution Time  0.7103
  CADENA URL  
/historico/Radan
  GET DATOS  
$_GET['/historico/Radan']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (39)  
0.0150  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 = 'Radan' 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.0159  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 = 'Radan' 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=60198 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  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=60198 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=60198 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=60198 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=60198 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=60198 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=60198 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  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=60198 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=60198 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0151  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=60198 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150  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=60198 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=60198 AND type_rel = 2
0.0152  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 = '60198' ORDER BY l.year DESC,cat.coefficient DESC
0.0153  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 = '60198' AND l.year = 2021 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 = '60198' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0164  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 = '60198' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0156  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 = 58374 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0147  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=60198 AND l.year in (2020,2021,2022) ORDER BY l.id DESC, l.year DESC ;
0.0146  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 (58374,56547) 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.0145  SELECT count(id) as num_players from rel_players WHERE league_id = 58374 AND teamId = 60198
0.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 56547 AND teamId = 60198
0.0293  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 58374 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
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 = '60198' 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 = '60198' and rp.type = 4
0.0147  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 = '60198' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0147  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 events2021 e ON e.player_id = p.id AND e.league_id = 58374 WHERE rp.league_id = 58374 AND rp.teamId = 60198 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.0148  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 events2021 e ON e.player_id = p.id AND e.league_id = 58374 WHERE rp.league_id = 58374 AND rp.teamId = 60198 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0146  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 events2021 e ON e.player_id = p.id AND e.league_id = 58374 WHERE rp.league_id = 58374 AND rp.teamId = 60198 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0150  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 = 60198 AND l.year <= 2021 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0151  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 = 58374 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.0149  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 = 51079 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.0152  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 = 44708 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 39258 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 34067 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 15798 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 9197 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 14758 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC