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

Gaziantep

Entrenador: Selcuk Inan

Temporada 2005/2006
TEMPORADA 2005/2006
1. LIG
Equipo PJ GF GC Puntos
1 Bursaspor Bursaspor 34 54 26 71
2 Antalyaspor Antalyaspor 34 67 34 66
3 Altay Altay 34 54 39 64
4 Sakaryaspor Sakaryaspor 34 54 36 60
5 Istanbulspor AS Istanbulspor 34 58 35 54
6 Orduspor 1967 Orduspor 34 49 41 54
7 İstanbul Başakşehir İstanbul 34 43 31 52
8 Kocaelispor Kocaelispor 34 41 41 45
9 Türk Telekom Türk 34 40 40 45
10 Elazigspor Elazigspor 34 40 45 45
11 Mardinspor Mardinspor 34 38 41 43
12 Usakspor Usakspor 34 40 51 43
13 Karsiyaka Karsiyaka 34 47 49 41
14 Gaziantep Gaziantep 34 47 50 41
15 Akçaabat Sebatspor Akçaabat 34 37 54 34
16 Mersin Mersin 34 30 54 29
17 Yozgatspor Yozgatspor 34 29 55 25
18 Canakkale Dardanelspor Canakkale 34 23 69 20
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 3
Equipo PJ GF GC Puntos
1 Mardinspor Mardinspor 31 44 15 71
2 Adiyamanspor Adiyamanspor 32 49 23 66
3 Hatayspor Hatayspor 31 62 39 58
4 Gaziantep Gaziantep 32 59 43 54
5 Tarsus Idman Yurdu Tarsus Idman 32 50 34 52
6 Sanliurfaspor Sanliurfaspo 32 54 47 46
7 Aksarayspor Aksarayspor 32 39 36 45
8 Erzincanspor Erzincanspor 32 34 35 40
9 Kahramanmarasspor Kahramanmara 31 34 50 39
10 Osmaniyespor Kulübü Osmaniyespor 32 45 53 38
11 Sanliurfa Belediyespor Sanliurfa 32 34 41 37
12 Batman Petrolspor Batman 31 33 40 36
13 Cizrespor 2010 Cizrespor 32 29 40 36
14 Siirtspor Siirtspor 32 44 58 36
15 Erzurumspor Erzurumspor 32 33 46 34
16 Mezitlispor Mezitlispor 32 31 42 32
17 Iğdırspor Iğdırspor 32 25 57 24
TEMPORADA 2002/2003
2. LIG GRUPO 3
Equipo PJ GF GC Puntos
1 Kayserispor Kayserispor 32 82 29 75
2 Hatayspor Hatayspor 32 76 30 75
3 Sanliurfaspor Sanliurfaspo 31 61 20 67
4 Gaziantep Gaziantep 32 51 26 64
5 Tarsus Idman Yurdu Tarsus Idman 32 67 38 59
6 Kahramanmarasspor Kahramanmara 32 57 37 50
7 Adiyamanspor Adiyamanspor 32 46 35 46
8 Sanliurfa Belediyespor Sanliurfa 32 48 47 40
9 Batman Petrolspor Batman 32 50 67 40
10 Iğdırspor Iğdırspor 32 38 41 38
11 Mardinspor Mardinspor 32 37 45 38
12 Mezitlispor Mezitlispor 32 54 57 37
13 Erzincanspor Erzincanspor 31 34 50 37
14 Siirtspor Siirtspor 32 53 66 34
15 Cizrespor 2010 Cizrespor 32 42 62 33
16 Hakkari Spor Hakkari Spor 32 32 65 28
17 Silopi Cudispor Silopi 32 7 120 0
TEMPORADA 2001/2002
2. LIG GRUPO 1
Equipo PJ GF GC Puntos
1 Mersin İdmanyurdu Mersin 17 34 15 35
2 Gaziantep Gaziantep 18 35 17 32
3 Kartalspor Kartalspor 18 32 18 32
4 Eskişehirspor Eskişehirsp 18 22 20 30
5 Mezitlispor Mezitlispor 18 28 32 22
6 Maltepespor Maltepespor 18 29 35 21
7 Kartal Belediyespor Kartal 17 24 25 20
8 Kucukkoyspor Istanbul Kucukkoyspor 18 25 40 18
9 Sapancaspor Sapancaspor 18 17 30 16
10 Zeytinburnuspor Zeytinburnus 18 20 34 13
TEMPORADA 1998/1999
1. LIG GRUPO 7
Equipo PJ GF GC Puntos
1 Bakırköyspor Bakırköysp 14 22 11 25
2 Gaziantep Gaziantep 14 31 23 23
3 Hatayspor Hatayspor 14 25 21 22
4 Mersin İdmanyurdu Mersin 14 22 19 21
5 Adana Demirspor Adana 14 18 20 17
6 Zeytinburnuspor Zeytinburnus 14 16 17 16
7 Kilimli Belediyespor Kilimli 14 13 24 14
8 Konyaspor Konyaspor 14 11 23 12
TEMPORADA 1997/1998
1. LIG GRUPO 11
Equipo PJ GF GC Puntos
1 Diyarbakirspor Diyarbakirsp 14 24 15 27
2 Gaziantep Gaziantep 14 22 13 24
3 Batman Petrolspor Batman 14 21 20 22
4 Sanliurfaspor Sanliurfaspo 14 13 15 19
5 Malatyaspor Malatyaspor 14 19 25 19
6 Adiyamanspor Adiyamanspor 14 12 10 18
7 Siirtspor Siirtspor 14 19 27 15
8 Türk Telekom Türk 14 14 19 14
TEMPORADA 1996/1997
2. LIG GRUPO 3
Equipo PJ GF GC Puntos
1 Gaziantep Gaziantep 34 66 15 85
2 Kilis Belediyespor Kilis 34 62 30 68
3 Tarsus Idman Yurdu Tarsus Idman 34 60 33 68
4 Kayseri Elektrikspor Kayseri 34 58 27 60
5 Gaskispor Gaskispor 34 48 33 51
6 Ceyhanspor Adana Ceyhanspor 33 42 34 51
7 İslahiyespor İslahiyespo 34 36 28 49
8 Körfez İskenderunspor Körfez 34 52 46 48
9 Kahramanmarasspor Kahramanmara 34 36 40 47
10 Fırat Üniversitesi Fırat 34 42 50 45
11 Kayserispor Kayserispor 34 46 65 43
12 Pütürge Belediyespor Pütürge 34 41 57 39
13 Silifke Belediyesi Silifke 34 29 42 37
14 Siverek Belediyespor Siverek 34 31 51 37
15 Kozan Belediyespor Kozan 34 39 59 36
16 Nizipspor Nizipspor 34 42 66 36
17 Şehitkamil Belediyespor Şehitkamil 33 21 32 34
18 Osmaniyespor Kulübü Osmaniyespor 34 27 70 22
TEMPORADA 1995/1996
2. LIG GRUPO 3
Equipo PJ GF GC Puntos
1 İskenderunspor İskenderuns 24 37 6 51
2 Körfez İskenderunspor Körfez 24 53 23 50
3 Gaziantep Gaziantep 24 51 26 43
4 Gaskispor Gaskispor 24 28 26 36
5 Osmaniyespor Kulübü Osmaniyespor 24 30 33 34
6 Ceyhanspor Adana Ceyhanspor 24 34 29 32
7 Kilis Belediyespor Kilis 24 25 27 32
8 Nizipspor Nizipspor 24 33 33 31
9 Amedspor Amedspor 24 32 29 30
10 Siverek Belediyespor Siverek 24 20 38 25
11 İslahiyespor İslahiyespo 24 25 35 23
12 Kayapınar Belediyespor Kayapınar 24 13 44 20
13 Yeni Samandağspor Yeni 24 25 57 14
TEMPORADA 1994/1995
2. LIG GRUPO 3
Equipo PJ GF GC Puntos
1 Sanliurfaspor Sanliurfaspo 26 38 20 53
2 İskenderunspor İskenderuns 26 51 26 47
3 Ceyhanspor Adana Ceyhanspor 26 33 18 40
4 Adana Polisgücü Adana 26 28 30 38
5 Yeni Samandağspor Yeni 26 29 27 37
6 Kozan Spor FK Kozan Spor 26 28 35 36
7 Kilis Belediyespor Kilis 26 25 31 35
8 Osmaniyespor Kulübü Osmaniyespor 26 41 28 34
9 Gaziantep Gaziantep 26 24 27 34
10 Nizipspor Nizipspor 26 33 34 32
11 Gaskispor Gaskispor 26 27 34 30
12 İslahiyespor İslahiyespo 26 26 37 28
13 Adana Vefa 01 Spor Adana Vefa. 26 27 40 26
14 Mezitlispor Mezitlispor 26 24 47 23
TEMPORADA 1993/1994
2. LIG GRUPO 3
Equipo PJ GF GC Puntos
1 Silifke Belediyesi Silifke 24 45 12 57
2 Kahramanmarasspor Kahramanmara 24 38 14 49
3 Gaziantep Gaziantep 24 40 17 46
4 Kayserispor Kayserispor 24 34 34 38
5 Osmaniyespor Kulübü Osmaniyespor 24 45 31 36
6 Kozan Spor FK Kozan Spor 24 44 39 32
7 Kilis Belediyespor Kilis 24 32 38 31
8 İslahiyespor İslahiyespo 24 26 34 30
9 Adana Polisgücü Adana 24 26 44 27
10 Nizipspor Nizipspor 24 29 43 26
11 Ceyhanspor Adana Ceyhanspor 23 23 27 25
12 Kirikhanspor Kirikhanspor 24 23 37 22
13 Besnispor Besnispor 23 9 44 12

  USO DE MEMORIA  
5,966,472 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.5166
Total Execution Time  0.5179
  CADENA URL  
/historico/Gaziantep-Bb/2006
  GET DATOS  
$_GET['/historico/Gaziantep-Bb/2006']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
0.0122  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 = 'Gaziantep-Bb' AND l.year = 2006 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.0107  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=12892 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0108  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=12892 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0230  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 = 13094
0.0110  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12892 AND type_rel = 2
0.0115  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 12892 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0119  SELECT /*35 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (676623,690821,708436,742508,795956) ORDER BY n.cover_points DESC, update_date DESC
0.0135  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 = '12892' AND l.year = 2006 ORDER BY l.year DESC,cat.coefficient DESC
0.0135  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 = '12892' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0115  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 = 13094 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0131  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=12892 AND l.year in (2005,2006,2007) ORDER BY l.id DESC, l.year DESC ;
0.0113  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 (50691,20667,13094) 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.0111  SELECT count(id) as num_players from rel_players WHERE league_id = 13094 AND teamId = 12892
0.0105  SELECT count(id) as num_players from rel_players WHERE league_id = 50691 AND teamId = 12892
0.0108  SELECT count(id) as num_players from rel_players WHERE league_id = 20667 AND teamId = 12892
0.0112  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 13094 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0109  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 = '12892' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0107  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '12892' and rp.type = 4
0.0112  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 = '12892' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0114  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 events2006 e ON e.player_id = p.id AND e.league_id = 13094 WHERE rp.league_id = 13094 AND rp.teamId = 12892 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.0106  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 events2006 e ON e.player_id = p.id AND e.league_id = 13094 WHERE rp.league_id = 13094 AND rp.teamId = 12892 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0106  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 events2006 e ON e.player_id = p.id AND e.league_id = 13094 WHERE rp.league_id = 13094 AND rp.teamId = 12892 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0111  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 = 12892 AND l.year <= 2006 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0113  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 = 13094 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0115  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.0118  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 = 50694 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0123  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 = 50697 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0122  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 `tables2002` 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 = 50698 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0120  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 `tables1999` 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 = 50299 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0118  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 `tables1999` 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 = 50305 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0120  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 `tables1998` 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 = 50318 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0117  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 `tables1998` 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 = 50324 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 `tables1997` 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 = 50772 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0115  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 `tables1996` 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 = 50802 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 `tables1995` 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 = 50813 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 `tables1994` 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 = 50829 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC