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

Diyarbekirspor

Entrenador: Hakan Yilmaz

Temporada 2023/2024
TEMPORADA 2023/2024
2. LIG GRUPO 2
Equipo PJ GF GC Puntos
1 Erokspor Erokspor 35 77 29 80
2 Vanspor FK Vanspor FK 35 63 34 78
3 Bucaspor Bucaspor 35 51 24 70
4 1461 Trabzon FK 1461 Trabzon 35 66 35 69
5 Mersin Mersin 35 48 31 58
6 Ankaraspor Ankaraspor 35 42 32 57
7 Karacabey Birlikspor Karacabey 35 42 34 51
8 Beyoglu Yeni Carsi FK Beyoglu Yeni 35 44 37 49
9 Ankara Demirspor Ankara 35 38 44 47
10 Diyarbekirspor Diyarbekirsp 35 38 38 45
11 Kirklarelispor Kirklarelisp 35 32 38 44
12 Altinordu Altinordu 35 42 36 42
13 Afjet Afyonspor Afjet 35 24 34 42
14 Serik Belediye Serik 35 29 39 40
15 Nazilli Belediyespor Nazilli 36 38 57 39
16 Zonguldak Kömürspor Zonguldak 35 38 56 35
17 Kirsehirspor Kirsehirspor 35 34 71 23
18 Bursaspor Bursaspor 35 25 64 20
19 Adıyaman 1954 Spor Adıyaman 35 24 62 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 2
Equipo PJ GF GC Puntos
1 Sakaryaspor Sakaryaspor 38 75 24 84
2 1461 Trabzon FK 1461 Trabzon 38 63 32 74
3 Bodrumspor Bodrumspor 38 61 27 72
4 Sivas Belediyespor Sivas 38 66 34 69
5 Bayburt Bayburt 38 50 35 66
6 Vanspor FK Vanspor FK 38 55 46 66
7 Corum FK Corum FK 38 58 41 65
8 Afjet Afyonspor Afjet 38 67 44 62
9 Ankaraspor Ankaraspor 38 53 40 55
10 Somaspor Somaspor 38 50 50 53
11 Inegolspor Inegolspor 38 51 54 51
12 Etimesgut Etimesgut 38 45 54 47
13 Serik Belediye Serik 38 47 55 45
14 Sariyer Sariyer 38 50 59 43
15 Diyarbekirspor Diyarbekirsp 38 34 46 41
16 Adıyaman 1954 Spor Adıyaman 38 47 71 41
17 Turgutluspor Turgutluspor 38 31 62 37
18 Ergene Velimese Spor Ergene 38 38 72 35
19 Nigde Anadolu Nigde 38 45 84 29
20 Kahramanmarasspor Kahramanmara 38 23 79 19
TEMPORADA 2020/2021
3. LIG GRUPO 1
Equipo PJ GF GC Puntos
1 Diyarbekirspor Diyarbekirsp 30 43 18 68
2 Bucaspor Bucaspor 30 58 18 67
3 Yeşilyurt Belediyespor Yeşilyurt 30 50 27 56
4 Ofspor Ofspor 30 43 31 53
5 Arnavutkoy Arnavutkoy 30 40 29 48
6 Edirnespor Edirnespor 30 34 31 45
7 Belediye Derincespor Belediye 30 41 29 43
8 Artvin Hopaspor Artvin 30 41 44 39
9 Fatsa Belediye Fatsa 30 22 31 38
10 Kizilcabolukspor Kizilcaboluk 30 34 33 37
11 Nevşehir Belediyespor Nevşehir 30 31 31 34
12 Çankaya FK Çankaya FK 30 28 48 34
13 1877 Alemdağspor 1877 30 37 48 33
14 Kemerspor Kemerspor 30 27 50 27
15 Payas Payas 30 29 56 23
16 Manisaspor Manisaspor 30 22 56 12
TEMPORADA 2019/2020
3. LIG GRUPO 3
Equipo PJ GF GC Puntos
1 Karacabey Birlikspor Karacabey 28 45 17 64
2 Somaspor Somaspor 28 39 29 45
3 Pazarspor Pazarspor 27 48 41 44
4 Nevşehir Belediyespor Nevşehir 28 28 19 42
5 Muğlaspor Muğlaspor 28 39 34 41
6 Osmaniyespor Kulübü Osmaniyespor 28 35 32 41
7 Nazilli Belediyespor Nazilli 28 47 30 40
8 Diyarbekirspor Diyarbekirsp 28 35 28 40
9 1954 Kelkit Belediyespor 1954 Kelkit 28 34 30 40
10 Darica Genclerbirligi Darica 28 29 34 35
11 Halide Edip Adivar Halide Edip 28 22 30 35
12 Yozgatspor Yozgatspor 28 24 32 34
13 Bayrampasaspor Bayrampasasp 28 22 24 33
14 Golcukspor Golcukspor 28 31 42 31
15 Yeşilyurt Belediyespor Yeşilyurt 27 27 32 29
16 Kalecik FK Kalecik FK 28 29 42 28
17 Batman Petrolspor Batman 28 31 49 28
18 Modafenspor Modafenspor 28 19 39 27
TEMPORADA 2018/2019
3. LIG GRUPO 3
Equipo PJ GF GC Puntos
1 Bayburt Bayburt 34 48 22 68
2 Kocaelispor Kocaelispor 34 40 31 58
3 Karacabey Birlikspor Karacabey 34 45 40 58
4 Corum FK Corum FK 34 42 32 52
5 Serik Belediye Serik 34 38 36 51
6 Turgutluspor Turgutluspor 34 49 47 49
7 Erzincanspor Erzincanspor 34 45 38 48
8 Payas Payas 34 32 37 48
9 Halide Edip Adivar Halide Edip 34 40 40 46
10 Diyarbekirspor Diyarbekirsp 34 38 40 45
11 Muğlaspor Muğlaspor 34 31 33 42
12 Çankaya FK Çankaya FK 34 37 35 41
13 Fatsa Belediye Fatsa 34 32 36 40
14 Golcukspor Golcukspor 34 28 32 40
15 Cizrespor 2010 Cizrespor 34 33 39 40
16 1461 Trabzon 1461 Trabzon 34 31 39 37
17 Bagcilarspor Bagcilarspor 34 37 47 37
18 Bucaspor Bucaspor 34 35 57 28
TEMPORADA 2017/2018
3. LIG GRUPO 2
Equipo PJ GF GC Puntos
1 Darica Genclerbirligi Darica 34 64 18 72
2 Ankara Demirspor Ankara 34 60 31 71
3 Diyarbekirspor Diyarbekirsp 34 63 40 64
4 Buca FK Buca FK 34 52 28 61
5 Erzincanspor Erzincanspor 34 53 30 61
6 Pazarspor Pazarspor 34 47 36 58
7 52 Orduspor 52 Orduspor 34 52 33 55
8 Vanspor FK Vanspor FK 34 56 47 49
9 Anadolu Bağcılar Anadolu 34 47 48 49
10 Golcukspor Golcukspor 34 56 49 47
11 Turgutluspor Turgutluspor 34 46 47 47
12 Erokspor Erokspor 34 42 37 46
13 Muğlaspor Muğlaspor 34 36 36 41
14 1461 Trabzon 1461 Trabzon 34 51 54 38
15 Ergene Velimese Spor Ergene 34 38 43 37
16 Kirikhanspor Kirikhanspor 34 28 55 27
17 Yeşil Bursa Yeşil Bursa 34 24 55 22
18 Kayseri Kayseri 34 17 145 3
TEMPORADA 2016/2017
3. LIG GRUPO 3
Equipo PJ GF GC Puntos
1 Afjet Afyonspor Afjet 34 62 25 74
2 Sakaryaspor Sakaryaspor 34 66 27 68
3 Darica Genclerbirligi Darica 34 60 28 68
4 Diyarbekirspor Diyarbekirsp 34 54 43 60
5 Bayrampasaspor Bayrampasasp 34 52 38 56
6 23 Elazig 23 Elazig 34 51 37 54
7 1461 Trabzon FK 1461 Trabzon 34 42 34 50
8 Tarsus Idman Yurdu Tarsus Idman 34 57 53 48
9 Çankaya FK Çankaya FK 34 38 49 42
10 Muğlaspor Muğlaspor 34 41 54 42
11 Orhangazispor Orhangazispo 34 40 43 41
12 Sultanbeyli Belediyespor Sultanbeyli 34 38 49 40
13 12 Bingölspor Bingölspor 34 31 42 39
14 Bergama Belediyespor Bergama 34 31 44 39
15 Payas Payas 34 26 40 35
16 Maltepespor Maltepespor 34 23 49 32
17 Denizli Belediyespor Denizli 34 26 54 22
18 Orduspor 1967 Orduspor 34 36 65 20
TEMPORADA 2015/2016
3. LIG GRUPO 2
Equipo PJ GF GC Puntos
1 Etimesgut Etimesgut 36 51 26 70
2 Bodrumspor Bodrumspor 36 48 23 60
3 Diyarbekirspor Diyarbekirsp 36 39 26 59
4 Ofspor Ofspor 36 43 28 58
5 Çankaya FK Çankaya FK 36 43 33 58
6 Orhangazispor Orhangazispo 36 40 32 54
7 Kemerspor Kemerspor 36 60 45 53
8 Sancaktepe Belediye Istanbu Sancaktepe 36 43 46 51
9 Denizli Belediyespor Denizli 36 42 39 50
10 Sultanbeyli Belediyespor Sultanbeyli 36 33 31 49
11 Derince Belediyespor Derince 36 35 42 49
12 Sakaryaspor Sakaryaspor 36 36 42 48
13 Yomraspor Yomraspor 36 39 48 47
14 Payas Payas 36 38 39 46
15 Manisa FK Manisa FK 36 37 40 46
16 Kahramanmaras Belediyespor Kahramanmara 36 33 37 42
17 Zaraspor Zaraspor 36 26 49 33
18 Ayvalikgucu Belediyespor Ayvalikgucu 36 40 64 33
19 Gaziosmanpasaspor Gaziosmanpas 36 30 66 25
TEMPORADA 2014/2015
3. LIG GRUPO 2
Equipo PJ GF GC Puntos
1 Eyupspor Eyupspor 34 50 25 71
2 Sivas Belediyespor Sivas 34 41 24 63
3 Diyarbekirspor Diyarbekirsp 34 48 27 62
4 Denizli Belediyespor Denizli 34 46 34 60
5 Golcukspor Golcukspor 34 48 37 56
6 Kemerspor Kemerspor 34 55 46 53
7 Maltepespor Maltepespor 34 42 36 48
8 Derince Belediyespor Derince 34 44 44 48
9 Canakkale Dardanelspor Canakkale 34 35 28 47
10 Sancaktepe Belediye Istanbu Sancaktepe 34 44 40 45
11 Yeşil Bursa Yeşil Bursa 34 42 32 44
12 Arsinspor Arsinspor 34 40 36 44
13 Payas Payas 34 40 41 43
14 Çine MadranSpor Çine 34 40 52 37
15 Erzincan Refahiyespor Erzincan 34 36 52 36
16 Halide Edip Adivar Halide Edip 34 32 54 32
17 Aksarayspor Aksarayspor 34 21 43 30
18 Cankirispor Cankirispor 34 22 75 14
TEMPORADA 2013/2014
3. LIG GRUPO 3
Equipo PJ GF GC Puntos
1 Keciorengucu Keciorengucu 34 54 38 66
2 Istanbulspor AS Istanbulspor 34 57 33 63
3 Diyarbekirspor Diyarbekirsp 34 57 24 61
4 Tuzlaspor Tuzlaspor 34 59 41 60
5 Menemenspor Menemenspor 34 47 32 59
6 Golcukspor Golcukspor 34 40 33 51
7 Ayvalikgucu Belediyespor Ayvalikgucu 34 49 42 48
8 Denizli Belediyespor Denizli 34 44 43 47
9 Anadolu Uskudar 1908 Anadolu 34 38 41 45
10 Erzincan Refahiyespor Erzincan 34 32 36 45
11 Kirikhanspor Kirikhanspor 34 52 45 44
12 Kayseri Sekerspor Kayseri 34 41 49 42
13 Turanspor Turanspor 34 31 40 42
14 Arsinspor Arsinspor 34 39 49 42
15 Belediye Vanspor Belediye 34 34 36 40
16 Yozgatspor Yozgatspor 34 32 41 39
17 Kocaelispor Kocaelispor 34 37 73 28
18 Bafraspor Bafraspor 34 28 75 18

  USO DE MEMORIA  
6,672,848 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.1513
Total Execution Time  0.1534
  CADENA URL  
/historico/Yeni-Diyarbakirspor
  GET DATOS  
$_GET['/historico/Yeni-Diyarbakirspor']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0031  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 = 'Yeni-Diyarbakirspor' 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.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=12974 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=12974 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=12974 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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 = 73214
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12974 AND type_rel = 2
0.0032  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 = '12974' ORDER BY l.year DESC,cat.coefficient DESC
0.0033  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 = '12974' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0040  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 = '12974' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0029  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 = 74094 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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.0029  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=12974 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.0034  SELECT count(id) as num_players from rel_players WHERE league_id = 73214 AND teamId = 12974
0.0053  SELECT count(id) as num_players from rel_players WHERE league_id = 74094 AND teamId = 12974
0.0024  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 = '12974' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '12974' 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 = '12974' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0061  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 = 12974 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.0040  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 = 12974 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0043  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 = 12974 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 = 12974 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0030  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 = 73214 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.0036  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.0035  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 = 63658 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.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 `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 = 58625 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.0028  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 = 50979 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.0033  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 = 44491 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032  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 = 38979 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0035  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 = 33915 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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 = 15824 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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 = 4466 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033  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 = 2807 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC