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

Kirsehirspor

Entrenador: Ali Kemal Yavuzyiğitoğlu

Temporada 2023/2024
TEMPORADA 2023/2024
2. LIG GRUPO 2
Equipo PJ GF GC Puntos
1 Erokspor Erokspor 34 76 29 77
2 Vanspor FK Vanspor FK 34 57 33 75
3 Bucaspor Bucaspor 34 51 24 69
4 1461 Trabzon FK 1461 Trabzon 34 64 35 66
5 Mersin Mersin 34 47 29 58
6 Ankaraspor Ankaraspor 34 42 32 56
7 Karacabey Birlikspor Karacabey 34 40 32 50
8 Ankara Demirspor Ankara 34 37 38 47
9 Beyoglu Yeni Carsi FK Beyoglu Yeni 34 42 36 46
10 Kirklarelispor Kirklarelisp 35 32 38 44
11 Diyarbekirspor Diyarbekirsp 34 36 37 42
12 Altinordu Altinordu 34 40 34 41
13 Afjet Afyonspor Afjet 34 24 34 41
14 Serik Belediye Serik 34 29 37 40
15 Nazilli Belediyespor Nazilli 35 38 57 38
16 Zonguldak Kömürspor Zonguldak 34 35 54 32
17 Kirsehirspor Kirsehirspor 34 32 68 23
18 Bursaspor Bursaspor 34 24 62 20
19 Adıyaman 1954 Spor Adıyaman 34 24 61 16
TEMPORADA 2022/2023
2. LIG GRUPO 2
Equipo PJ GF GC Puntos
1 Kocaelispor Kocaelispor 38 73 28 84
2 Bucaspor Bucaspor 38 63 22 81
3 İskenderunspor İskenderuns 38 65 31 77
4 1461 Trabzon FK 1461 Trabzon 38 62 27 74
5 Vanspor FK Vanspor FK 38 58 27 74
6 Ankara Demirspor Ankara 38 65 32 71
7 Karacabey Birlikspor Karacabey 38 55 31 68
8 Fethiyespor Fethiyespor 38 59 51 55
9 Zonguldak Kömürspor Zonguldak 38 45 50 53
10 Serik Belediye Serik 38 54 43 50
11 Kirsehirspor Kirsehirspor 38 49 54 48
12 Kirklarelispor Kirklarelisp 38 38 35 46
13 Etimesgut Etimesgut 38 43 51 45
14 Kastamonuspor Kastamonuspo 38 41 47 43
15 Sariyer Sariyer 38 46 57 42
16 Usakspor Usakspor 38 37 64 33
17 Balikesirspor Balikesirspo 38 32 76 25
18 Adıyaman 1954 Spor Adıyaman 37 22 70 23
19 Pazarspor Pazarspor 38 29 79 23
20 Diyarbekirspor Diyarbekirsp 37 18 79 15
TEMPORADA 2021/2022
2. LIG GRUPO 1
Equipo PJ GF GC Puntos
1 Pendikspor Pendikspor 34 56 25 77
2 Amedspor Amedspor 34 43 35 57
3 Karacabey Birlikspor Karacabey 34 58 41 56
4 Ispartaspor Ispartaspor 34 39 28 55
5 Tarsus Idman Yurdu Tarsus Idman 34 43 34 55
6 Erzincanspor Erzincanspor 34 59 42 54
7 Bucaspor Bucaspor 34 50 42 53
8 Ankara Demirspor Ankara 34 44 35 49
9 Kirsehirspor Kirsehirspor 34 44 35 49
10 Kirklarelispor Kirklarelisp 34 40 35 47
11 Sanliurfaspor Sanliurfaspo 34 50 41 46
12 Nazilli Belediyespor Nazilli 34 36 37 45
13 Usakspor Usakspor 34 31 47 40
14 Zonguldak Kömürspor Zonguldak 34 37 47 38
15 Pazarspor Pazarspor 34 35 60 34
16 Akhisar Belediyespor Akhisar 34 34 56 31
17 1922 Konyaspor 1922 34 36 52 29
18 Eskişehirspor Eskişehirsp 34 31 74 22
19 Kastamonuspor Kastamonuspo 0 0 0 0
TEMPORADA 2020/2021
2. LIG GRUPO 2
Equipo PJ GF GC Puntos
1 Eyupspor Eyupspor 38 82 25 92
2 Sakaryaspor Sakaryaspor 38 74 35 75
3 Kirsehirspor Kirsehirspor 38 57 32 72
4 Kirklarelispor Kirklarelisp 38 60 32 70
5 Vanspor FK Vanspor FK 38 59 35 69
6 Bodrumspor Bodrumspor 38 80 48 63
7 Etimesgut Etimesgut 38 63 36 61
8 Karacabey Birlikspor Karacabey 38 52 41 56
9 Turgutluspor Turgutluspor 38 44 56 54
10 Serik Belediye Serik 38 51 48 53
11 Pendikspor Pendikspor 38 66 53 52
12 Pazarspor Pazarspor 38 60 64 50
13 Tarsus Idman Yurdu Tarsus Idman 38 56 55 49
14 Bayburt Bayburt 38 52 61 48
15 Sivas Belediyespor Sivas 38 63 58 46
16 1922 Konyaspor 1922 38 47 49 42
17 Kastamonuspor Kastamonuspo 38 31 58 36
18 Elazigspor Elazigspor 38 61 90 33
19 Mamak Fk Mamak Fk 38 32 121 24
20 Karabükspor Karabükspor 38 16 109 3
TEMPORADA 2019/2020
2. LIG GRUPO 2
Equipo PJ GF GC Puntos
1 Bandirmaspor Bandirmaspor 28 58 26 60
2 Ankara Demirspor Ankara 28 46 21 57
3 Sakaryaspor Sakaryaspor 28 36 21 54
4 Kastamonuspor Kastamonuspo 28 49 28 53
5 Tuzlaspor Tuzlaspor 27 42 25 50
6 Kirsehirspor Kirsehirspor 28 33 24 47
7 Vanspor FK Vanspor FK 28 46 32 44
8 Usakspor Usakspor 27 40 34 44
9 Kahramanmarasspor Kahramanmara 28 30 32 41
10 Ergene Velimese Spor Ergene 28 43 34 37
11 Bodrumspor Bodrumspor 28 40 41 36
12 Sivas Belediyespor Sivas 28 36 38 36
13 Bayburt Bayburt 28 30 40 35
14 Eyupspor Eyupspor 28 25 39 29
15 Etimesgut Etimesgut 28 28 34 28
16 Elazigspor Elazigspor 26 18 53 19
17 Nigde Anadolu Nigde 28 28 52 17
18 Karabükspor Karabükspor 28 11 65 9
TEMPORADA 2018/2019
3. LIG GRUPO 2
Equipo PJ GF GC Puntos
1 Kirsehirspor Kirsehirspor 34 54 38 63
2 Erokspor Erokspor 34 56 30 62
3 Vanspor FK Vanspor FK 34 60 27 60
4 Kizilcabolukspor Kizilcaboluk 34 60 39 55
5 Karsiyaka Karsiyaka 34 39 32 55
6 Kalecik FK Kalecik FK 34 46 30 54
7 Çatalca Spor Çatalca 34 39 45 48
8 Pazarspor Pazarspor 34 39 42 47
9 52 Orduspor 52 Orduspor 34 49 38 46
10 Osmaniyespor Kulübü Osmaniyespor 34 40 42 44
11 Sultanbeyli Belediyespor Sultanbeyli 34 32 39 43
12 Kemerspor Kemerspor 34 36 45 43
13 Düzcespor Düzcespor 34 35 44 43
14 Ofspor Ofspor 34 37 39 42
15 23 Elazig 23 Elazig 34 34 50 41
16 Adıyaman 1954 Spor Adıyaman 34 35 51 37
17 Alibeykoyspor Alibeykoyspo 34 40 51 33
18 Bergama Belediyespor Bergama 34 25 74 15
TEMPORADA 2010/2011
3. LIG GRUPO 1
Equipo PJ GF GC Puntos
1 Tepecik Belediyespor Tepecik 34 56 38 61
2 Bursa Niluferspor Bursa 34 39 24 59
3 Nazilli Belediyespor Nazilli 34 53 26 57
4 Lüleburgazspor Lüleburgazs 34 33 27 57
5 Inegolspor Inegolspor 34 43 28 56
6 Unyespor Unyespor 34 40 30 56
7 Bayrampasaspor Bayrampasasp 34 52 30 54
8 Hatayspor Hatayspor 34 46 27 53
9 Belediye Bingölspor K. Belediye 34 44 34 49
10 Menemenspor Menemenspor 34 41 40 48
11 Arsinspor Arsinspor 34 35 37 46
12 Istanbulspor AS Istanbulspor 34 30 30 44
13 Kemerspor Kemerspor 34 30 41 44
14 Ankara Demirspor Ankara 34 33 40 39
15 Kayapınar Belediyespor Kayapınar 34 24 34 39
16 Kirsehirspor Kirsehirspor 34 38 49 32
17 72 Batman Spor Batman Spor 34 23 47 31
18 Malatyaspor Malatyaspor 34 11 89 10
TEMPORADA 2009/2010
2. LIG GRUPO 7
Equipo PJ GF GC Puntos
1 1461 Trabzon 1461 Trabzon 16 26 7 33
2 Ofspor Ofspor 16 23 14 30
3 Akçaabat Sebatspor Akçaabat 16 26 23 28
4 Mamak Fk Mamak Fk 16 25 17 27
5 Karsspor Karsspor 16 19 14 24
6 Gölbaşispor Gölbaşispo 16 18 16 24
7 Cankirispor Cankirispor 16 18 15 20
8 Kirsehirspor Kirsehirspor 16 22 23 16
9 Erzurumspor Erzurumspor 16 0 48 0
TEMPORADA 2008/2009
2. LIG GRUPO 8
Equipo PJ GF GC Puntos
1 1922 Konyaspor 1922 16 26 12 60
2 Kirsehirspor Kirsehirspor 16 30 14 53
3 Zeytinburnuspor Zeytinburnus 16 22 20 51
4 Etimesgut Etimesgut 16 26 16 50
5 Türk Telekom Türk 16 20 20 48
6 Istanbulspor AS Istanbulspor 16 16 20 48
7 MKE Kırıkkalespor Kırıkkales 16 18 19 46
8 Maltepespor Maltepespor 16 15 27 36
9 Alibeykoyspor Alibeykoyspo 16 9 34 22
TEMPORADA 2007/2008
2. LIG GRUPO 8
Equipo PJ GF GC Puntos
1 Mamak Fk Mamak Fk 14 17 10 50
2 Türk Telekom Türk 14 23 22 47
3 Alibeykoyspor Alibeykoyspo 14 22 16 42
4 MKE Kırıkkalespor Kırıkkales 14 14 26 42
5 Kirsehirspor Kirsehirspor 14 18 11 40
6 Maltepespor Maltepespor 14 20 13 38
7 Kucukkoyspor Istanbul Kucukkoyspor 14 19 23 35
8 Tepecik Belediyespor Tepecik 14 13 25 27
TEMPORADA 2006/2007
2. LIG GRUPO 10
Equipo PJ GF GC Puntos
1 Erzurumspor Erzurumspor 14 27 23 27
2 Giresunspor Giresunspor 14 25 17 24
3 Kirsehirspor Kirsehirspor 14 20 17 22
4 Erzincanspor Erzincanspor 14 17 14 21
5 Tokatspor Tokatspor 14 14 11 20
6 Pazarspor Pazarspor 14 18 21 15
7 Yozgatspor Yozgatspor 14 11 20 12
8 Unyespor Unyespor 14 12 21 9
TEMPORADA 2005/2006
2. LIG GRUPO 9
Equipo PJ GF GC Puntos
1 Darica Genclerbirligi Darica 14 21 17 25
2 Aksarayspor Aksarayspor 14 20 21 21
3 Tarsus Idman Yurdu Tarsus Idman 14 22 19 20
4 MKE Kırıkkalespor Kırıkkales 14 15 15 20
5 Kirsehirspor Kirsehirspor 14 18 19 18
6 Bursa Merinosspor Bursa 14 20 19 15
7 Yeşil Bursa Yeşil Bursa 14 15 17 15
8 Yalovaspor Yalovaspor 14 14 18 15
TEMPORADA 2004/2005
2. LIG GRUPO 3
Equipo PJ GF GC Puntos
1 Gaziantep Gaziantep 32 90 43 73
2 Siirtspor Siirtspor 32 64 22 70
3 Tarsus Idman Yurdu Tarsus Idman 32 75 41 61
4 Adiyamanspor Adiyamanspor 32 47 40 51
5 Adana Demirspor Adana 32 38 42 48
6 Hatayspor Hatayspor 32 32 35 47
7 Kirsehirspor Kirsehirspor 32 39 37 45
8 Sanliurfa Belediyespor Sanliurfa 32 58 54 44
9 Osmaniyespor Kulübü Osmaniyespor 32 44 35 41
10 Cizrespor 2010 Cizrespor 32 38 39 41
11 Sanliurfaspor Sanliurfaspo 32 45 55 41
12 Erzurumspor Erzurumspor 32 48 56 38
13 Batman Petrolspor Batman 32 26 36 36
14 Aksarayspor Aksarayspor 32 37 56 34
15 Kahramanmarasspor Kahramanmara 32 37 53 32
16 Erzincanspor Erzincanspor 32 28 59 25
17 Karamanspor Karamanspor 32 37 80 20
TEMPORADA 2003/2004
2. LIG GRUPO 2
Equipo PJ GF GC Puntos
1 Sariyer Sariyer 32 57 36 63
2 Karabükspor Karabükspor 32 44 31 61
3 Kartalspor Kartalspor 32 59 35 60
4 Orduspor 1967 Orduspor 32 49 30 57
5 Yalovaspor Yalovaspor 32 48 31 56
6 Kirsehirspor Kirsehirspor 32 37 34 45
7 Darica Genclerbirligi Darica 32 33 32 42
8 MKE Kırıkkalespor Kırıkkales 32 34 40 42
9 Ankara Demirspor Ankara 31 46 57 37
10 Bulancakspor Bulancakspor 32 38 49 37
11 Fenerspor Fenerspor 32 39 52 37
12 Eyupspor Eyupspor 32 33 40 36
13 Cankirispor Cankirispor 32 27 45 36
14 Bagcilarspor Bagcilarspor 31 35 40 35
15 Maltepespor Maltepespor 31 42 48 35
16 Amasyaspor Amasyaspor 31 28 36 32
17 Gumushanespor Gumushanespo 32 39 52 31
TEMPORADA 2002/2003
3. LIG GRUPO 2
Equipo PJ GF GC Puntos
1 Kirsehirspor Kirsehirspor 27 34 19 55
2 Giresunspor Giresunspor 26 34 17 48
3 Pazarspor Pazarspor 26 40 25 46
4 DC Divrigispor Divrigispor 26 53 39 40
5 Merzifonspor Merzifonspor 26 34 27 39
6 Unyespor Unyespor 26 35 30 39
7 Artvin Hopaspor Artvin 26 25 29 38
8 Corumspor Corumspor 27 43 40 36
9 Ofspor Ofspor 26 30 35 36
10 Yozgatspor Yozgatspor 26 32 38 35
11 SinopSpor SinopSpor 26 29 28 33
12 Trabzon Telekomspor Trabzon 26 26 28 28
13 Murgul Bakırspor Murgul 26 25 37 28
14 Çaykurspor Çaykurspor 26 21 39 23
15 Çarşambaspor Çarşambasp 26 9 39 15

  USO DE MEMORIA  
6,917,600 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.1973
Total Execution Time  0.1995
  CADENA URL  
/historico/Kirsehirspor
  GET DATOS  
$_GET['/historico/Kirsehirspor']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0032  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 = 'Kirsehirspor' 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=65673 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=65673 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=65673 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0023  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=65673 AND type_rel = 2
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 = '65673' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0031  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 = '65673' 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 = 73214 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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=65673 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 (74094,73214) 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.0040  SELECT count(id) as num_players from rel_players WHERE league_id = 73214 AND teamId = 65673
0.0055  SELECT count(id) as num_players from rel_players WHERE league_id = 74094 AND teamId = 65673
0.0021  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 = '65673' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '65673' and rp.type = 4
0.0021  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 = '65673' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0039  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 = 73214 WHERE rp.league_id = 73214 AND rp.teamId = 65673 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.0045  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 = 73214 WHERE rp.league_id = 73214 AND rp.teamId = 65673 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0073  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 = 73214 WHERE rp.league_id = 73214 AND rp.teamId = 65673 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0058  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 = 65673 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0058  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 = 68199 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.0043  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 = 63657 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.0043  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 = 58624 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.0044  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 = 50823 AND t.round = 28 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0054  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 = 44490 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0046  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 = 27109 AND t.round = 34 ORDER BY team.conference 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 `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 = 16535 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0042  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 = 16539 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0040  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 = 16549 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0043  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 = 16555 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0049  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 = 16566 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0041  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 = 16573 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0058  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 `tables2007` 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 = 50654 AND t.round = 18 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 `tables2007` 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 = 50660 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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 = 50679 AND t.round = 18 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 `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 = 50685 AND t.round = 14 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 `tables2005` 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 = 50691 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0042  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 `tables2004` 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 = 50693 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 `tables2003` 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 = 50247 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC