4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Naft Masjed Soleyman
TEMPORADA 2023/2024
SEGUNDA IRÁN
Equipo PJ GF GC Puntos
1 Kheybar Kheybar 26 42 14 61
2 Chadormalu Chadormalu 26 39 19 55
3 Fajr Sepasi Fajr Sepasi 26 34 12 54
4 Naft Masjed Soleyman Naft Masjed 26 38 23 50
5 Saipa Saipa 26 25 19 38
6 Mes Soongoun Varzaghan Soongoun 26 22 22 38
7 Naft va Gaz Naft va Gaz 26 28 18 36
8 Ario Ario 26 19 19 36
9 Mes Kerman Mes Kerman 26 21 20 35
10 Pars Jonubi Pars Jonubi 26 26 32 34
11 Mes Shahr Babak Shahr Babak 26 21 17 33
12 Esteqlal Abi Push Esteqlal 26 20 21 30
13 Shahr Raz Shahr Raz 26 18 24 30
14 Shahrdari Astara Shahrdari 26 15 29 26
15 Shahin Bandar Ameri Shahin 26 19 43 22
16 Darya Caspian Darya 26 18 33 19
17 Damash Gilan Damash Gilan 26 19 37 19
18 Khooshe Talaee Khooshe 26 13 35 17
TEMPORADA 2022/2023
LIGA IRÁN
Equipo PJ GF GC Puntos
1 Persepolis Persepolis 30 46 13 66
2 Sepahan Sepahan 30 49 17 65
3 FC Esteghlal Esteghlal 30 52 22 62
4 Tractor Sazi Tractor Sazi 30 42 34 52
5 Mes Rafsanjan Rafsanjan 30 29 15 47
6 Gol Gohar Sirjan Gohar Sirjan 30 40 36 45
7 Aluminium Arak Aluminium 30 20 15 40
8 Foolad Khuzestan Foolad 30 27 26 40
9 Zob Ahan Zob Ahan 30 25 24 36
10 Havadar SC Havadar SC 30 24 34 33
11 Paykan Paykan 30 12 28 28
12 Malavan Malavan 30 21 40 27
13 Nassaji Mazandaran FC Nassaji 30 26 44 26
14 Naft Abadan Naft Abadan 30 22 36 25
15 Mes Kerman Mes Kerman 30 23 37 22
16 Naft Masjed Soleyman Naft Masjed 30 22 59 20
TEMPORADA 2021/2022
LIGA IRÁN
Equipo PJ GF GC Puntos
1 FC Esteghlal Esteghlal 30 39 10 68
2 Persepolis Persepolis 30 41 21 61
3 Sepahan Sepahan 30 43 21 56
4 Gol Gohar Sirjan Gohar Sirjan 30 37 28 51
5 Foolad Khuzestan Foolad 30 30 22 49
6 Mes Rafsanjan Rafsanjan 30 39 29 45
7 Zob Ahan Zob Ahan 30 21 25 37
8 Aluminium Arak Aluminium 30 20 23 37
9 Paykan Paykan 30 26 27 36
10 Naft Abadan Naft Abadan 30 26 30 36
11 Havadar SC Havadar SC 30 18 25 34
12 Nassaji Mazandaran FC Nassaji 30 24 34 33
13 Tractor Sazi Tractor Sazi 30 26 29 32
14 Naft Masjed Soleyman Naft Masjed 30 14 35 22
15 Padideh Khorasan Padideh 30 17 43 17
16 Fajr Sepasi Fajr Sepasi 30 10 29 17
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
SEGUNDA IRÁN
Equipo PJ GF GC Puntos
1 Pars Jonubi Pars Jonubi 34 29 14 62
2 Sepidrood Rasht Sepidrood 34 35 24 61
3 Gol Gohar Sirjan Gohar Sirjan 34 49 34 60
4 Malavan Malavan 34 34 27 58
5 Rayka Babol Rayka Babol 35 47 32 57
6 Baadraan Tehran Baadraan 34 34 21 56
7 Mes Kerman Mes Kerman 34 35 25 49
8 Gol Reyhan Gol Reyhan 34 38 29 49
9 Aluminium Arak Aluminium 34 38 31 48
10 Nassaji Mazandaran FC Nassaji 34 44 41 46
11 Mes Rafsanjan Rafsanjan 34 42 32 43
12 Iranjavan FC Iranjavan 34 39 41 38
13 Naft Masjed Soleyman Naft Masjed 34 33 32 37
14 Fajr Sepasi Fajr Sepasi 34 32 38 36
15 Rah Ahan Rah Ahan 34 31 49 36
16 Arvand Khorramshahr Arvand 34 23 41 34
17 Foolad Yazd Foolad Yazd 34 20 42 30
18 Esteghlal Ahvaz Esteghlal 35 18 68 12
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 2014/2015
LIGA IRÁN
Equipo PJ GF GC Puntos
1 Sepahan Sepahan 30 46 27 59
2 Tractor Sazi Tractor Sazi 30 58 34 58
3 Naft Tehran Naft Tehran 30 44 29 57
4 Zob Ahan Zob Ahan 30 46 26 52
5 Foolad Khuzestan Foolad 30 33 24 52
6 FC Esteghlal Esteghlal 30 40 34 47
7 Saipa Saipa 30 36 34 41
8 Persepolis Persepolis 30 31 35 36
9 Saba Qom Saba Qom 30 25 34 34
10 Padideh Khorasan Padideh 30 23 25 33
11 Gostaresh Foulad Gostaresh 30 30 39 31
12 Rah Ahan Rah Ahan 30 27 48 31
13 Malavan Malavan 30 26 34 30
14 Paykan Paykan 30 17 28 28
15 Esteghlal Khuzestan Esteghlal 30 35 46 27
16 Naft Masjed Soleyman Naft Masjed 30 19 39 22
TEMPORADA 2013/2014
SEGUNDA IRÁN GRUPO 2
Equipo PJ GF GC Puntos
1 Naft Masjed Soleyman Naft Masjed 24 31 22 43
2 Paykan Paykan 24 35 24 40
3 Parseh Tehran FC Parseh 24 27 21 39
4 Iranjavan FC Iranjavan 24 29 21 38
5 Mes Rafsanjan Rafsanjan 24 28 21 35
6 Aluminium Hormozgan Aluminium 24 28 20 31
7 Naft va Gaz Naft va Gaz 24 28 27 31
8 Rahian Kermanshah Rahian 24 23 29 31
9 Pas Hamedan Pas Hamedan 24 22 28 29
10 Tarbiat Novin Yazd Tarbiat 24 21 21 28
11 Al Badr Al Badr 24 21 30 25
12 Aboomoslem Aboomoslem 24 27 40 22
13 Persepolis Shomal Persepolis 24 26 42 19
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

  USO DE MEMORIA  
6,628,288 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0016
Controller Execution Time ( Home / Category )  0.1155
Total Execution Time  0.1171
  CADENA URL  
/historico/Naft-Masjed-Soleyman-Fc
  GET DATOS  
$_GET['/historico/Naft-Masjed-Soleyman-Fc']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (32)  
0.0042  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 = 73661
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13832 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=404 AND type_rel = 3
0.0023  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 = '13832' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = 73661 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  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=13832 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018  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 (73661,70816,68696) 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.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 68696 AND teamId = 13832
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 73661 AND teamId = 13832
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 70816 AND teamId = 13832
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 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 = 73661 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0022  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 = '13832' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0020  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '13832' and rp.type = 4
0.0022  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 = '13832' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0034  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 = 73661 WHERE rp.league_id = 73661 AND rp.teamId = 13832 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.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 = 73661 WHERE rp.league_id = 73661 AND rp.teamId = 13832 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027  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 = 73661 WHERE rp.league_id = 73661 AND rp.teamId = 13832 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  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 = 13832 AND l.year <= 2024 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 `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 = 73661 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.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 `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 = 68696 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 `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 = 65392 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.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 `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.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 `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.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 `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.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 `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.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 `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 = 33438 AND t.round = 34 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.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 `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 = 4191 AND t.round = 30 ORDER BY team.conference 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 `tables2014` 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 = 2903 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031  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.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 `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.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 `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