4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Machine Sazi
TEMPORADA 2021/2022
SEGUNDA IRÁN
Equipo PJ GF GC Puntos
1 Mes Kerman Mes Kerman 34 40 10 70
2 Malavan Malavan 34 39 16 68
3 Arman Gohar Arman Gohar 34 41 26 61
4 Kheybar Kheybar 34 47 29 59
5 Pars Jonubi Pars Jonubi 34 37 36 52
6 Khooshe Talaee Khooshe 34 48 39 50
7 Mes Shahr Babak Shahr Babak 34 30 23 46
8 Esteqlal Abi Push Esteqlal 34 31 27 46
9 Shams Azar Qazvin Shams Azar. 34 37 35 44
10 Shahrdari Hamedan Shahrdari 34 27 24 43
11 Shahrdari Astara Shahrdari 34 26 29 42
12 Esteghlal Khuzestan Esteghlal 34 37 34 40
13 Saipa Saipa 34 33 35 40
14 Vista Toorbin Vista 34 27 32 40
15 Qashqai Qashqai 34 26 34 39
16 Rayka Babol Rayka Babol 34 32 36 38
17 Shahin Bushehr Shahin 34 14 55 15
18 Machine Sazi Machine Sazi 34 29 81 12
TEMPORADA 2020/2021
LIGA IRÁN
Equipo PJ GF GC Puntos
1 Persepolis Persepolis 30 47 14 67
2 Sepahan Sepahan 30 53 24 65
3 FC Esteghlal Esteghlal 30 36 19 56
4 Tractor Sazi Tractor Sazi 30 35 29 45
5 Gol Gohar Sirjan Gohar Sirjan 30 33 32 45
6 Foolad Khuzestan Foolad 30 27 18 44
7 Paykan Paykan 30 32 30 40
8 Mes Rafsanjan Rafsanjan 30 23 29 39
9 Padideh Khorasan Padideh 30 27 31 38
10 Naft Abadan Naft Abadan 30 24 29 37
11 Aluminium Arak Aluminium 30 25 33 37
12 Nassaji Mazandaran FC Nassaji 30 27 34 33
13 Naft Masjed Soleyman Naft Masjed 30 21 29 31
14 Zob Ahan Zob Ahan 30 28 39 26
15 Saipa Saipa 30 19 34 26
16 Machine Sazi Machine Sazi 30 19 52 14
TEMPORADA 2019/2020
LIGA IRÁN
Equipo PJ GF GC Puntos
1 Persepolis Persepolis 30 46 17 67
2 FC Esteghlal Esteghlal 30 55 31 53
3 Foolad Khuzestan Foolad 30 28 19 51
4 Tractor Sazi Tractor Sazi 30 31 23 50
5 Sepahan Sepahan 30 39 22 49
6 Padideh Khorasan Padideh 30 27 25 46
7 Naft Abadan Naft Abadan 30 29 33 41
8 Naft Masjed Soleyman Naft Masjed 30 24 22 38
9 Nassaji Mazandaran FC Nassaji 30 30 32 38
10 Gol Gohar Sirjan Gohar Sirjan 30 27 34 33
11 Machine Sazi Machine Sazi 30 28 40 31
12 Zob Ahan Zob Ahan 30 31 39 30
13 Paykan Paykan 30 38 44 29
14 Saipa Saipa 30 24 35 29
15 Pars Jonubi Pars Jonubi 30 20 30 27
16 Shahin Bushehr Shahin 30 26 57 22
TEMPORADA 2018/2019
LIGA IRÁN
Equipo PJ GF GC Puntos
1 Persepolis Persepolis 30 36 14 61
2 Sepahan Sepahan 30 46 20 58
3 FC Esteghlal Esteghlal 30 40 13 57
4 Padideh Khorasan Padideh 30 32 16 56
5 Tractor Sazi Tractor Sazi 30 42 25 52
6 Zob Ahan Zob Ahan 30 28 28 40
7 Saipa Saipa 30 28 33 38
8 Foolad Khuzestan Foolad 30 30 39 38
9 Naft Abadan Naft Abadan 30 31 30 37
10 Nassaji Mazandaran FC Nassaji 30 29 29 36
11 Paykan Paykan 30 27 35 35
12 Pars Jonubi Pars Jonubi 30 28 33 30
13 Machine Sazi Machine Sazi 30 19 26 29
14 Naft Masjed Soleyman Naft Masjed 30 16 34 22
15 Sepidrood Rasht Sepidrood 30 24 53 20
16 Esteghlal Khuzestan Esteghlal 30 19 47 12
TEMPORADA 2017/2018
SEGUNDA IRÁN
Equipo PJ GF GC Puntos
1 Naft Masjed Soleyman Naft Masjed 34 46 25 65
2 Nassaji Mazandaran FC Nassaji 34 49 26 64
3 Rayka Babol Rayka Babol 34 39 17 64
4 Fajr Sepasi Fajr Sepasi 34 49 25 61
5 Baadraan Tehran Baadraan 34 54 32 59
6 Malavan Malavan 34 39 26 55
7 Gol Gohar Sirjan Gohar Sirjan 34 47 35 52
8 Mes Kerman Mes Kerman 34 37 33 52
9 Gol Reyhan Gol Reyhan 34 40 27 51
10 Mes Rafsanjan Rafsanjan 34 38 29 48
11 Shahrdari Mahshahr Shahrdari 34 42 43 41
12 Bargh Shiraz Bargh Shiraz 34 30 34 41
13 Aluminium Arak Aluminium 34 29 34 39
14 Elmoadab Tabriz Elmoadab 34 36 45 38
15 Machine Sazi Machine Sazi 34 27 33 37
16 Iranjavan FC Iranjavan 34 33 49 33
17 Saba Qom Saba Qom 34 24 90 12
18 Rah Ahan Rah Ahan 34 15 71 10
TEMPORADA 2016/2017
LIGA IRÁN
Equipo PJ GF GC Puntos
1 Persepolis Persepolis 30 46 14 66
2 FC Esteghlal Esteghlal 30 45 27 57
3 Tractor Sazi Tractor Sazi 30 38 24 56
4 Zob Ahan Zob Ahan 30 39 30 46
5 Sepahan Sepahan 30 38 34 45
6 Paykan Paykan 30 39 38 44
7 Esteghlal Khuzestan Esteghlal 30 36 34 41
8 Gostaresh Foulad Gostaresh 30 26 24 38
9 Naft Tehran Naft Tehran 30 31 34 36
10 Foolad Khuzestan Foolad 30 30 32 35
11 Padideh Khorasan Padideh 30 28 36 34
12 Naft Abadan Naft Abadan 30 24 34 33
13 Saipa Saipa 30 20 30 32
14 Mashhad Mashhad 30 24 35 30
15 Saba Qom Saba Qom 30 22 33 28
16 Machine Sazi Machine Sazi 30 18 45 16
TEMPORADA 2015/2016
SEGUNDA IRÁN
Equipo PJ GF GC Puntos
1 Paykan Paykan 38 50 29 70
2 Naft Abadan Naft Abadan 38 52 38 63
3 Machine Sazi Machine Sazi 38 54 37 61
4 Fajr Sepasi Fajr Sepasi 38 40 28 61
5 Rayka Babol Rayka Babol 38 40 35 59
6 Mes Rafsanjan Rafsanjan 38 44 35 58
7 Nassaji Mazandaran FC Nassaji 38 39 40 53
8 Aluminium Arak Aluminium 38 48 41 52
9 Mes Kerman Mes Kerman 38 37 35 52
10 Arvand Khorramshahr Arvand 38 45 43 50
11 Naft Masjed Soleyman Naft Masjed 38 39 39 48
12 Gol Gohar Sirjan Gohar Sirjan 38 35 34 47
13 Foolad Yazd Foolad Yazd 38 31 38 44
14 Iranjavan FC Iranjavan 38 42 55 44
15 Parseh Tehran FC Parseh 38 44 47 42
16 Pas Hamedan Pas Hamedan 38 34 40 42
17 Shahrdari Ardabil Shahrdari 38 43 50 40
18 Giti Pasand Giti Pasand 38 26 41 39
19 Damash Gilan Damash Gilan 38 29 43 37
20 Aluminium Hormozgan Aluminium 38 30 54 31
TEMPORADA 2012/2013
SEGUNDA IRÁN GRUPO 1
Equipo PJ GF GC Puntos
1 Gostaresh Foulad Gostaresh 26 44 25 50
2 Mes Sarcheshme Sarcheshme 26 29 15 47
3 Naft Masjed Soleyman Naft Masjed 26 41 31 45
4 Alvand Hamedan FC Alvand 26 33 23 43
5 Gol Gohar Sirjan Gohar Sirjan 26 29 25 41
6 Aboomoslem Aboomoslem 26 39 34 38
7 Nassaji Mazandaran FC Nassaji 26 33 27 36
8 Tarbiat Novin Yazd Tarbiat 26 37 32 34
9 Parseh Tehran FC Parseh 26 30 30 31
10 Esteghlal Ahvaz Esteghlal 26 26 35 30
11 Etka Gorgan FC Etka Gorgan 26 15 24 30
12 Shahin Bushehr Shahin 26 18 30 26
13 Shahrdari Arak Shahrdari 26 16 30 25
14 Machine Sazi Machine Sazi 26 18 47 13
TEMPORADA 2011/2012
SEGUNDA IRÁN GRUPO 2
Equipo PJ GF GC Puntos
1 Aluminium Hormozgan Aluminium 26 28 12 52
2 Gahar Zagros Gahar Zagros 26 23 16 42
3 Machine Sazi Machine Sazi 26 32 25 41
4 Pas Hamedan Pas Hamedan 26 29 25 39
5 Nassaji Mazandaran FC Nassaji 26 26 26 37
6 Esteghlal Khuzestan Esteghlal 26 28 23 35
7 Shahrdari Yasuj Shahrdari 26 24 27 35
8 Naft Masjed Soleyman Naft Masjed 26 25 26 34
9 Gol Gohar Sirjan Gohar Sirjan 26 28 28 33
10 Niroye Zamini Niroye 26 23 24 32
11 Rahian Kermanshah Rahian 26 22 27 32
12 Tarbiat Novin Yazd Tarbiat 26 21 26 30
13 Kaveh Khuzestan Kaveh 26 24 23 29
14 Bargh Shiraz Bargh Shiraz 26 12 37 18
TEMPORADA 2010/2011
SEGUNDA IRÁN GRUPO 1
Equipo PJ GF GC Puntos
1 Damash Gilan Damash Gilan 26 39 24 48
2 Fajr Sepasi Fajr Sepasi 26 24 18 41
3 Shahrdari Yasuj Shahrdari 26 28 26 39
4 Naft Masjed Soleyman Naft Masjed 26 33 32 35
5 Shahrdari Bandar Abbas Shahrdari 26 26 26 35
6 Etka Gorgan FC Etka Gorgan 26 30 28 34
7 Gol Gohar Sirjan Gohar Sirjan 26 29 27 34
8 Tarbiat Novin Yazd Tarbiat 26 24 22 33
9 Payam Mashhad Payam 26 30 30 32
10 Mes Rafsanjan Rafsanjan 26 20 26 32
11 Shahrdari Arak Shahrdari 26 20 28 32
12 Kaveh Khuzestan Kaveh 26 28 32 31
13 Machine Sazi Machine Sazi 26 30 36 31
14 Foolad Khuzestan II Foolad 26 30 36 28
TEMPORADA 2008/2009
SEGUNDA IRÁN GRUPO 2
Equipo PJ GF GC Puntos
1 Tractor Sazi Tractor Sazi 26 41 18 54
2 Shahin Bushehr Shahin 26 33 20 53
3 Mes Rafsanjan Rafsanjan 26 42 20 46
4 Gahar Zagros Gahar Zagros 26 26 19 40
5 Tarbiat Novin Yazd Tarbiat 26 32 26 38
6 Niroye Zamini Niroye 26 25 19 38
7 Rahian Kermanshah Rahian 26 30 25 36
8 Payam Mokhaberat Payam 26 33 30 34
9 Etka Gorgan FC Etka Gorgan 26 37 30 33
10 Aluminium Hormozgan Aluminium 26 30 24 33
11 Shemushack Noshahr Shemushack 26 20 25 27
12 Shahin Ahvaz Shahin Ahvaz 26 20 55 21
13 Machine Sazi Machine Sazi 26 21 49 20
14 Deyhim Ahvaz Deyhim Ahvaz 26 20 50 18
TEMPORADA 2007/2008
SEGUNDA IRÁN GRUPO 2
Equipo PJ GF GC Puntos
1 Foolad Khuzestan Foolad 22 33 15 44
2 Sepahan Novin Sepahan 22 28 18 40
3 Tarbiat Novin Yazd Tarbiat 22 36 29 37
4 Mes Rafsanjan Rafsanjan 22 34 26 34
5 Nassaji Mazandaran FC Nassaji 22 27 30 34
6 Elmoadab Tabriz Elmoadab 22 20 23 27
7 Etka Gorgan FC Etka Gorgan 22 28 34 26
8 Shahin Bushehr Shahin 22 22 24 25
9 Kowsar Tehran Kowsar 22 21 25 25
10 Sanaye Arak Sanaye Arak 22 19 24 23
11 Machine Sazi Machine Sazi 22 15 25 21
12 Homa Tehran Homa Tehran 22 17 27 19

  USO DE MEMORIA  
6,427,888 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1288
Total Execution Time  0.1307
  CADENA URL  
/historico/Machine-Sazi-Fc
  GET DATOS  
$_GET['/historico/Machine-Sazi-Fc']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0025  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 = 'Machine-Sazi-Fc' 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.0036  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 = 'Machine-Sazi-Fc' 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=13830 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=13830 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=13830 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=13830 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=13830 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=13830 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=13830 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=13830 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=13830 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=13830 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=13830 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=13830 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=13830 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=13830 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=13830 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=13830 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=13830 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=13830 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13830 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=404 AND type_rel = 3
0.0021  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 = '13830' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = '13830' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021  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 = 13830 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0024  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 = 65398 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.0025  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 = 60078 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.0023  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 = 50109 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.0037  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 = 43571 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 38987 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 33437 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 15619 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 `tables2013` 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 = 16150 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 `tables2012` 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 = 16154 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 `tables2011` 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 = 16156 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 `tables2009` 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 = 16163 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 `tables2008` 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 = 16166 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC