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

Kairat Almaty

Entrenador: Kirill Keker

Temporada 2007/2008
TEMPORADA 2007/2008
LIGA KAZAJISTÁN
Equipo PJ GF GC Puntos
1 FC Aktobe FC Aktobe 30 61 18 67
2 Tobol Kostanay Tobol 30 58 21 67
3 FC Irtysh Pavlodar Irtysh 30 58 28 62
4 Kaysar Kyzylorda Kaysar 30 29 22 49
5 Megasport Almaty Megasport 30 33 38 42
6 Zhetysu Taldykorgan Zhetysu 30 28 27 41
7 Shakhter Karagandy Shakhter 30 43 27 40
8 FC Alma-Ata FC Alma-Ata 30 33 39 37
9 Vostok Vostok 30 36 50 35
10 Okzhetpes Kokshetau Okzhetpes 30 32 48 35
11 Kairat Almaty Kairat 30 25 28 34
12 FC Astana-1964 Astana-1964 30 37 33 32
13 Ordabasy Ordabasy 30 25 44 30
14 FC Kyzylzhar Kyzylzhar 30 21 42 24
15 Energetik Pavlodar Energetik 30 21 43 23
16 Atyrau Atyrau 30 22 54 19
TEMPORADA 2006/2007
LIGA KAZAJISTÁN
Equipo PJ GF GC Puntos
1 FC Aktobe FC Aktobe 30 55 12 72
2 Tobol Kostanay Tobol 30 60 20 64
3 Shakhter Karagandy Shakhter 30 45 23 58
4 FC Irtysh Pavlodar Irtysh 30 34 27 52
5 Zhetysu Taldykorgan Zhetysu 30 33 32 46
6 FC Alma-Ata FC Alma-Ata 30 35 32 44
7 Vostok Vostok 30 30 38 41
8 FC Astana-1964 Astana-1964 30 34 25 38
9 Ordabasy Ordabasy 30 28 29 38
10 FC Kyzylzhar Kyzylzhar 30 24 28 37
11 Kaysar Kyzylorda Kaysar 30 27 37 37
12 Ekibastuzets Ekibastuzets 30 28 38 32
13 Atyrau Atyrau 30 29 39 30
14 Kairat Almaty Kairat 30 23 43 30
15 Okzhetpes Kokshetau Okzhetpes 30 26 56 29
16 Taraz Taraz 30 18 50 15
TEMPORADA 2005/2006
LIGA KAZAJISTÁN
Equipo PJ GF GC Puntos
1 FC Astana-1964 Astana-1964 30 45 23 64
2 FC Aktobe FC Aktobe 30 48 21 60
3 Tobol Kostanay Tobol 30 43 22 56
4 Shakhter Karagandy Shakhter 30 35 24 50
5 FC Alma-Ata FC Alma-Ata 30 36 29 48
6 FC Irtysh Pavlodar Irtysh 30 34 24 47
7 Kairat Almaty Kairat 30 39 30 46
8 Ekibastuzets Ekibastuzets 30 29 28 42
9 Vostok Vostok 30 33 40 35
10 Taraz Taraz 30 32 34 33
11 Okzhetpes Kokshetau Okzhetpes 30 23 36 33
12 FC Kyzylzhar Kyzylzhar 30 20 37 33
13 Ordabasy Ordabasy 30 29 36 32
14 Atyrau Atyrau 30 25 47 29
15 Kaysar Kyzylorda Kaysar 30 29 53 28
16 Energetik Pavlodar Energetik 30 28 44 26
TEMPORADA 2004/2005
LIGA KAZAJISTÁN
Equipo PJ GF GC Puntos
1 FC Aktobe FC Aktobe 30 50 27 70
2 Tobol Kostanay Tobol 30 53 21 69
3 Kairat Almaty Kairat 30 56 22 62
4 Shakhter Karagandy Shakhter 30 37 22 59
5 FC Irtysh Pavlodar Irtysh 30 51 24 57
6 Ordabasy Ordabasy 30 30 27 49
7 FC Kyzylzhar Kyzylzhar 30 38 25 48
8 FC Astana-1964 Astana-1964 30 35 23 43
9 Atyrau Atyrau 30 32 36 37
10 Okzhetpes Kokshetau Okzhetpes 30 26 32 37
11 Taraz Taraz 30 32 36 36
12 Ekibastuzets Ekibastuzets 30 30 32 34
13 FC Alma-Ata FC Alma-Ata 30 30 43 30
14 Vostok Vostok 30 24 49 28
15 Zhetysu Taldykorgan Zhetysu 30 28 60 19
16 Bolat Bolat 30 15 88 1
TEMPORADA 2003/2004
LIGA KAZAJISTÁN
Equipo PJ GF GC Puntos
1 Kairat Almaty Kairat 36 70 21 83
2 FC Irtysh Pavlodar Irtysh 36 56 16 79
3 Tobol Kostanay Tobol 36 87 27 77
4 FC Aktobe FC Aktobe 36 52 19 74
5 Atyrau Atyrau 36 49 31 71
6 FC Kyzylzhar Kyzylzhar 36 52 40 59
7 Taraz Taraz 36 35 23 59
8 Ekibastuzets Ekibastuzets 36 42 27 58
9 Shakhter Karagandy Shakhter 36 44 28 57
10 FC Astana-1964 Astana-1964 36 45 44 51
11 Okzhetpes Kokshetau Okzhetpes 36 26 39 43
12 Ordabasy Ordabasy 36 37 43 40
13 Vostok Vostok 36 42 54 40
14 Zhetysu Taldykorgan Zhetysu 36 34 55 40
15 Yassy Sayram Yassy Sayram 36 30 49 35
16 Kaysar Kyzylorda Kaysar 36 24 60 31
17 Akzhayik Akzhayik 36 24 83 25
18 FC Alma-Ata FC Alma-Ata 36 22 53 20
19 Spartak Semey Spartak 36 25 84 13
TEMPORADA 2002/2003
LIGA KAZAJISTÁN
Equipo PJ GF GC Puntos
1 FC Irtysh Pavlodar Irtysh 32 59 20 78
2 Tobol Kostanay Tobol 32 55 19 76
3 FC Astana-1964 Astana-1964 32 65 33 64
4 Atyrau Atyrau 32 48 40 53
5 FC Aktobe FC Aktobe 32 39 28 51
6 Kairat Almaty Kairat 32 51 42 49
7 Ordabasy Ordabasy 32 33 29 49
8 Zhetysu Taldykorgan Zhetysu 32 46 38 48
9 Spartak Semey Spartak 32 35 35 43
10 Shakhter Karagandy Shakhter 32 37 29 42
11 FC Kyzylzhar Kyzylzhar 32 42 53 36
12 Taraz Taraz 32 32 44 34
13 Kaysar Kyzylorda Kaysar 32 26 42 34
14 Vostok Vostok 32 34 46 32
15 Ekibastuzets Ekibastuzets 32 30 56 28
16 Akzhayik Akzhayik 32 25 74 26
17 Okzhetpes Kokshetau Okzhetpes 32 13 42 15
TEMPORADA 2001/2002
LIGA KAZAJISTÁN GRUPO 3
Equipo PJ GF GC Puntos
1 Kairat Almaty Kairat 9 17 6 22
2 Kaysar Kyzylorda Kaysar 9 14 8 18
3 FC Kyzylzhar Kyzylzhar 9 12 8 12
4 Yesil K Yesil K 9 11 16 11
5 Vostok Vostok 9 9 10 10
6 Yelimai Yelimai 9 7 22 6
TEMPORADA 2000/2001
LIGA KAZAJISTÁN
Equipo PJ GF GC Puntos
1 FC Astana-1964 Astana-1964 32 78 30 81
2 Atyrau Atyrau 32 53 16 70
3 FC Kyzylzhar Kyzylzhar 32 51 16 69
4 FC Irtysh Pavlodar Irtysh 32 48 22 60
5 Kairat Almaty Kairat 32 42 33 52
6 Tobol Kostanay Tobol 32 48 43 49
7 Spartak Semey Spartak 32 47 42 48
8 FC Aktobe FC Aktobe 32 33 40 45
9 Vostok Vostok 32 42 43 44
10 Okzhetpes Kokshetau Okzhetpes 32 35 37 44
11 Shakhter Karagandy Shakhter 32 31 37 40
12 Kaysar Kyzylorda Kaysar 32 33 40 40
13 Ekibastuzets Ekibastuzets 32 30 49 37
14 Zhetysu Taldykorgan Zhetysu 32 38 57 26
15 Ordabasy Ordabasy 32 28 58 21
16 Taraz Taraz 32 26 57 21
17 Kaspiy Aktau Kaspiy Aktau 32 16 59 15
TEMPORADA 1999/2000
LIGA KAZAJISTÁN
Equipo PJ GF GC Puntos
1 FC Astana-1964 Astana-1964 28 69 20 74
2 FC Kyzylzhar Kyzylzhar 28 59 10 74
3 Kairat Almaty Kairat 28 48 17 60
4 FC Irtysh Pavlodar Irtysh 28 50 26 60
5 Shakhter Karagandy Shakhter 28 38 26 48
6 Kaysar Kyzylorda Kaysar 28 36 23 43
7 CSKA Almaty CSKA Almaty 29 40 35 42
8 Tobol Kostanay Tobol 28 42 39 42
9 Spartak Semey Spartak 28 43 33 41
10 Okzhetpes Kokshetau Okzhetpes 28 25 34 29
11 Taraz Taraz 29 23 47 29
12 Vostok Vostok 28 30 45 28
13 Tomiris Shymkent Tomiris 15 17 21 17
14 Zhetysu Taldykorgan Zhetysu 28 15 73 14
15 Zhiger Shymkent Zhiger 28 13 72 4
16 Ordabasy Ordabasy 13 7 32 2
17 Ekibastuzets Ekibastuzets 2 0 2 0
TEMPORADA 1998/1999
LIGA KAZAJISTÁN
Equipo PJ GF GC Puntos
1 FC Irtysh Pavlodar Irtysh 30 69 19 76
2 FC Kyzylzhar Kyzylzhar 30 56 19 72
3 Kairat Almaty Kairat 30 62 19 64
4 Kaysar Kyzylorda Kaysar 30 47 19 58
5 FC Astana-1964 Astana-1964 30 56 26 56
6 Tomiris Shymkent Tomiris 30 48 31 56
7 Vostok Vostok 30 32 33 46
8 Tobol Kostanay Tobol 30 28 29 41
9 Spartak Semey Spartak 30 35 36 40
10 Shakhter Karagandy Shakhter 30 28 35 37
11 Ekibastuzets Ekibastuzets 30 36 54 34
12 CSKA Almaty CSKA Almaty 30 35 52 31
13 Zhiger Shymkent Zhiger 30 33 60 28
14 Taraz Taraz 30 25 64 23
15 Zhetysu Taldykorgan Zhetysu 30 19 64 16
16 Okzhetpes Kokshetau Okzhetpes 30 19 68 10

  USO DE MEMORIA  
6,140,208 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1255
Total Execution Time  0.1267
  CADENA URL  
/historico/Kairat-Almaty/2008
  GET DATOS  
$_GET['/historico/Kairat-Almaty/2008']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (39)  
0.0038  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 = 'Kairat-Almaty' AND l.year = 2008 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.0020  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=13789 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=13789 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=13789 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 = 10669
0.0025  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 = 24070
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13789 AND type_rel = 2
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 13789 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0023  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 (12916,45779,52333,58341,88074) ORDER BY n.cover_points DESC, update_date DESC
0.0030  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 = '13789' AND l.year = 2008 ORDER BY l.year DESC,cat.coefficient DESC
0.0033  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 = '13789' 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 = 24070 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  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 = 10669 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025  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=13789 AND l.year in (2007,2008,2009) 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 (42355,24077,15328,10671) 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.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 10671 AND teamId = 13789
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 15328 AND teamId = 13789
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 42355 AND teamId = 13789
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 24077 AND teamId = 13789
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 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 = 10669 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
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 = '13789' 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 = '13789' 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 = '13789' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0019  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 events2008 e ON e.player_id = p.id AND e.league_id = 10669 WHERE rp.league_id = 10669 AND rp.teamId = 13789 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.0019  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 events2008 e ON e.player_id = p.id AND e.league_id = 10669 WHERE rp.league_id = 10669 AND rp.teamId = 13789 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019  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 events2008 e ON e.player_id = p.id AND e.league_id = 10669 WHERE rp.league_id = 10669 AND rp.teamId = 13789 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  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 = 13789 AND l.year <= 2008 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 = 10669 AND t.round = 30 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 `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 = 10671 AND t.round = 30 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 `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 = 10672 AND t.round = 30 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 `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 = 10673 AND t.round = 30 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 `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 = 10674 AND t.round = 38 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 `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 = 10675 AND t.round = 36 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 `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 = 15322 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 15324 AND t.round = 9 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 `tables2001` 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 = 26401 AND t.round = 36 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 `tables2000` 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 = 26402 AND t.round = 32 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 26403 AND t.round = 32 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 10669 ORDER BY nameShow LIMIT 100