4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Shahin Bushehr
TEMPORADA 2023/2024
TERCERA IRÁN
Equipo PJ GF GC Puntos
1 Niroye Zamini Niroye 23 37 21 46
2 Bahman Tehran Bahman 23 24 13 45
3 Shahrdari Mahshahr Shahrdari 23 30 13 42
4 Sepidrood Rasht Sepidrood 23 25 23 35
5 Chooka Talesh Chooka 23 29 25 32
6 Sh. Babolsar Babolsar 23 24 23 32
7 Pas Hamedan Pas Hamedan 23 17 20 29
8 FC Yasa FC Yasa 23 19 28 27
9 Foolad Novin Foolad Novin 23 21 17 26
10 Shohadaye Razkan Karaj Shohadaye 23 13 14 24
11 Shahrdari Bandar Abbas Shahrdari 23 25 28 24
12 Ayandeh Sazan Ardabil Ayandeh 23 19 25 24
13 Shahrdari Bam Shahrdari 23 19 32 19
14 Shohadaye Sari Shohadaye 23 15 35 15
15 Kavir Moqava Kavir Moqava 23 31 12 50
16 Shahrdari Nowshahr Shahrdari 23 27 10 47
17 Shenavar Sazi Qeshm Shenavar 23 32 17 45
18 Be'sat Kermanshah Be'sat 23 27 12 43
19 Nikapars Nikapars 23 31 21 41
20 Foolad Hormozgan Foolad 23 23 19 31
21 Ariyan Hamedan Ariyan 23 27 24 31
22 Spad Alvand Spad Alvand 23 23 20 31
23 Petro Palayesh Petro 23 24 28 29
24 Shahid Ghandi Shahid 23 21 24 28
25 Navad Urmia Navad Urmia 23 23 28 27
26 KIA Football Academy Football 23 30 37 23
27 Setaregan Sorkh Setaregan 23 15 33 12
28 Shahin Bushehr Shahin 23 8 57 2
TEMPORADA 2022/2023
TERCERA IRÁN
Equipo PJ GF GC Puntos
1 Foolad Novin Foolad Novin 13 19 9 28
2 Mes Soongoun Varzaghan Soongoun 12 25 7 26
3 Iman Sabz Iman Sabz 13 16 10 19
4 Sepidrood Rasht Sepidrood 13 13 10 19
5 Navad Urmia Navad Urmia 13 13 13 18
6 Pas Hamedan Pas Hamedan 13 11 14 17
7 Foolad Hormozgan Foolad 13 14 13 16
8 Be'sat Kermanshah Be'sat 13 12 15 15
9 Spad Alvand Spad Alvand 13 8 9 14
10 FC Panik FC Panik 13 12 15 14
11 Atrak Bojnord Atrak 13 18 26 14
12 Shahid Oraki Shahid Oraki 13 9 11 11
13 Vista Toorbin Vista 13 11 29 7
14 Naft va Gaz Naft va Gaz 14 27 7 30
15 Shahid Ghandi Shahid 14 21 8 28
16 Shahrdari Nowshahr Shahrdari 14 18 7 27
17 Damash Gilan Damash Gilan 14 16 8 26
18 Shohadaye Razkan Karaj Shohadaye 14 11 9 24
19 Shahrdari Mahshahr Shahrdari 14 11 9 22
20 Shahrdari Bam Shahrdari 14 10 8 22
21 Ario Ario 14 12 9 20
22 Sh. Babolsar Babolsar 14 9 14 17
23 Shahrdari Bandar Abbas Shahrdari 14 9 15 13
24 Niroye Zamini Niroye 14 5 14 13
25 Kian Sam Kian Sam 14 5 15 9
26 Mes Novin Mes Novin 14 8 17 8
27 Shahin Bushehr Shahin 14 5 27 7
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
SEGUNDA IRÁN
Equipo PJ GF GC Puntos
1 Fajr Sepasi Fajr Sepasi 34 41 21 60
2 Havadar SC Havadar SC 34 42 26 60
3 Baadraan Tehran Baadraan 34 41 28 60
4 Mes Kerman Mes Kerman 34 32 23 55
5 Shahin Bushehr Shahin 34 27 20 53
6 Esteghlal Khuzestan Esteghlal 34 31 20 52
7 Kheybar Kheybar 34 45 26 49
8 Khooshe Talaee Khooshe 34 34 27 49
9 Arman Gohar Arman Gohar 34 47 44 49
10 Pars Jonubi Pars Jonubi 34 38 34 48
11 Malavan Malavan 34 30 30 46
12 Rayka Babol Rayka Babol 34 33 38 43
13 Esteqlal Abi Push Esteqlal 34 39 43 42
14 Qashqai Qashqai 34 29 35 42
15 Shahrdari Astara Shahrdari 34 35 43 41
16 Chooka Talesh Chooka 34 29 44 34
17 Navad Urmia Navad Urmia 34 14 36 27
18 Gol Reyhan Gol Reyhan 34 25 74 18
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
SEGUNDA IRÁN
Equipo PJ GF GC Puntos
1 Gol Gohar Sirjan Gohar Sirjan 30 47 26 58
2 Shahin Bushehr Shahin 30 34 17 54
3 Gol Reyhan Gol Reyhan 30 30 19 48
4 Aluminium Arak Aluminium 30 27 23 48
5 Mes Kerman Mes Kerman 30 38 22 47
6 Havadar SC Havadar SC 30 48 38 43
7 Baadraan Tehran Baadraan 30 35 32 43
8 Fajr Sepasi Fajr Sepasi 31 28 24 41
9 Qashqai Qashqai 30 28 34 39
10 Mes Rafsanjan Rafsanjan 30 40 42 36
11 Malavan Malavan 30 29 28 35
12 Navad Urmia Navad Urmia 30 23 40 31
13 Kheybar Kheybar 30 17 35 28
14 Rayka Babol Rayka Babol 29 19 30 28
15 Elmoadab Tabriz Elmoadab 30 27 45 28
16 Shahrdari Mahshahr Shahrdari 30 19 34 25
TEMPORADA 2017/2018
TERCERA IRÁN
Equipo PJ GF GC Puntos
1 Kheybar Kheybar 19 37 17 42
2 Damash Gilan Damash Gilan 19 18 7 36
3 Shahin Bushehr Shahin 19 26 14 34
4 Moghavemat Tehran Moghavemat 19 26 16 32
5 Foolad Novin Foolad Novin 19 32 14 29
6 Niroye Zamini Niroye 19 27 22 25
7 Qashqai Qashqai 19 16 17 22
8 Mes Novin Mes Novin 19 23 25 21
9 Gol Abrisham Abrisham 19 18 30 18
10 Shemushack Noshahr Shemushack 19 14 45 11
11 Termeh Dastjerdi Termeh 10 0 30 0
12 Shahrdari Bandar Abbas Shahrdari 20 42 14 45
13 Naft va Gaz Naft va Gaz 20 29 13 38
14 Sardar Bukan Sardar Bukan 20 28 21 34
15 FC Esteghlal Esteghlal 20 23 20 34
16 Esteghlal Ahvaz Esteghlal 20 23 23 29
17 Caspian Qazvin Caspian 20 23 19 28
18 Sh. Babolsar Babolsar 20 19 26 25
19 Persepolis Shomal Persepolis 20 20 27 24
20 Shahrdari Kashan Shahrdari 20 19 33 19
21 Sanaye Arak Sanaye Arak 19 15 24 18
22 Shahrdari Urmia Shahrdari 20 15 33 10
23 Shahrdari Fuman Shahrdari 20 35 17 39
24 Naft Omidiyeh Naft 20 30 22 32
25 Naft Abadan Naft Abadan 21 26 17 30
26 Arvand Khorramshahr Arvand 20 34 28 29
27 Hr. Hamedan Hr. Hamedan 20 25 23 29
28 Khosheh Talaei Khosheh 20 18 19 29
29 Be'sat Kermanshah Be'sat 20 21 22 28
30 Shahrdari Bam Shahrdari 20 31 34 27
31 Pas Hamedan Pas Hamedan 20 27 22 26
32 Giti Pasand Giti Pasand 20 16 29 19
33 Kimiya Farayand Kimiya 20 14 47 12
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
LIGA IRÁN
Equipo PJ GF GC Puntos
1 Sepahan Sepahan 34 54 27 67
2 Tractor Sazi Tractor Sazi 34 57 32 66
3 FC Esteghlal Esteghlal 34 58 34 66
4 Saba Qom Saba Qom 34 40 38 50
5 Naft Tehran Naft Tehran 34 36 38 49
6 Zob Ahan Zob Ahan 34 29 33 45
7 Damash Gilan Damash Gilan 34 34 38 44
8 Saipa Saipa 34 50 39 43
9 Mes Kerman Mes Kerman 34 35 39 43
10 Naft Abadan Naft Abadan 34 49 57 43
11 Rah Ahan Rah Ahan 34 43 42 42
12 Persepolis Persepolis 34 50 54 42
13 Fajr Sepasi Fajr Sepasi 34 31 38 41
14 Foolad Khuzestan Foolad 34 35 37 40
15 Malavan Malavan 34 32 33 39
16 Elmoadab Tabriz Elmoadab 34 34 44 34
17 Shahin Bushehr Shahin 34 30 43 33
18 Mes Sarcheshme Sarcheshme 34 23 54 24
TEMPORADA 2010/2011
LIGA IRÁN
Equipo PJ GF GC Puntos
1 Sepahan Sepahan 34 56 29 66
2 FC Esteghlal Esteghlal 34 55 34 65
3 Zob Ahan Zob Ahan 34 49 31 63
4 Persepolis Persepolis 34 50 36 58
5 Tractor Sazi Tractor Sazi 34 42 29 57
6 Foolad Khuzestan Foolad 34 58 36 54
7 Mes Kerman Mes Kerman 34 41 30 52
8 Malavan Malavan 34 33 32 48
9 Naft Abadan Naft Abadan 34 36 54 42
10 Saba Qom Saba Qom 34 39 40 41
11 Saipa Saipa 34 42 47 37
12 Elmoadab Tabriz Elmoadab 34 45 53 37
13 Naft Tehran Naft Tehran 34 38 44 36
14 Shahin Bushehr Shahin 34 31 37 35
15 Rah Ahan Rah Ahan 34 29 39 35
16 Pas Hamedan Pas Hamedan 34 30 48 35
17 Paykan Paykan 34 38 60 33
18 Steel Azin Steel Azin 34 30 63 28
TEMPORADA 2009/2010
LIGA IRÁN
Equipo PJ GF GC Puntos
1 Sepahan Sepahan 34 67 30 67
2 Zob Ahan Zob Ahan 34 48 29 61
3 FC Esteghlal Esteghlal 34 49 32 59
4 Persepolis Persepolis 34 46 40 53
5 Steel Azin Steel Azin 34 55 49 52
6 Saba Qom Saba Qom 34 52 45 48
7 Tractor Sazi Tractor Sazi 34 43 42 47
8 Saipa Saipa 34 48 53 46
9 Mes Kerman Mes Kerman 34 55 56 42
10 Foolad Khuzestan Foolad 34 31 34 42
11 Paykan Paykan 34 40 44 41
12 Malavan Malavan 34 31 47 41
13 Shahin Bushehr Shahin 34 37 37 39
14 Pas Hamedan Pas Hamedan 34 36 44 38
15 Sorinet Sorinet 34 36 44 38
16 Fajr Sepasi Fajr Sepasi 34 34 45 37
17 Aboomoslem Aboomoslem 34 36 51 32
18 Esteghlal Ahvaz Esteghlal 34 38 60 30
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,851,696 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.1170
Total Execution Time  0.1191
  CADENA URL  
/historico/Shahin-Bushehr
  GET DATOS  
$_GET['/historico/Shahin-Bushehr']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0027  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 = 'Shahin-Bushehr' 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.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=4518 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=4518 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=4518 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2117 AND type_rel = 3
0.0024  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 = '4518' ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '4518' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
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 = '4518' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0024  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=4518 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (75354) 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 = 75354 AND teamId = 4518
0.0020  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 = '4518' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0017  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '4518' and rp.type = 4
0.0020  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 = '4518' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0022  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 = 75354 WHERE rp.league_id = 75354 AND rp.teamId = 4518 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.0023  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 = 75354 WHERE rp.league_id = 75354 AND rp.teamId = 4518 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0020  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 = 75354 WHERE rp.league_id = 75354 AND rp.teamId = 4518 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0034  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 = 4518 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 = 70994 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.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.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 = 60079 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.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 `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.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 `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 = 44751 AND t.round = 34 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 `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 = 49093 AND t.round = 22 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.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 = 1588 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0045  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 = 1589 AND t.round = 34 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 `tables2010` 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 = 1065 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 `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