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

Häcken

Entrenador: Pal Arne Johansen

Temporada 2004/2005
TEMPORADA 2004/2005
LIGA SUECA
Equipo PJ GF GC Puntos
1 Djurgårdens IF Djurgårdens 26 60 26 53
2 IFK Göteborg Göteborg 26 38 22 49
3 Kalmar FF Kalmar FF 26 36 21 43
4 Hammarby IF Hammarby IF 26 43 30 43
5 Malmö FF Malmö FF 26 38 27 41
6 Helsingborgs IF Helsingborgs 26 32 38 39
7 IF Elfsborg IF Elfsborg 26 35 43 37
8 Häcken Häcken 26 29 29 36
9 Örgryte Örgryte 26 37 38 35
10 Halmstads Halmstads 26 38 38 32
11 Gefle Gefle 26 27 33 31
12 Landskrona BoIS Landskrona 26 26 44 30
13 GIF Sundsvall Sundsvall 26 31 46 25
14 Assyriska FF Assyriska 26 17 52 14
TEMPORADA 2003/2004
SEGUNDA SUECIA
Equipo PJ GF GC Puntos
1 Häcken Häcken 30 60 31 65
2 Gefle Gefle 30 50 28 58
3 Assyriska FF Assyriska 30 48 39 54
4 IFK Norrköping Norrköping 30 58 37 50
5 Osters IF Osters IF 30 51 36 50
6 GAIS GAIS 30 45 40 49
7 Åtvidabergs Åtvidabergs 30 55 47 48
8 Västerås SK Västerås 30 47 47 44
9 Cafe Opera Cafe Opera 30 45 39 40
10 Brommapojkarna Brommapojkar 30 43 42 36
11 Västra Frölunda Västra 30 40 48 36
12 Falkenbergs Falkenbergs 30 30 52 29
13 Bodens Bodens 30 32 40 28
14 Enköpings SK Enköpings 30 31 44 26
15 IK Brage IK Brage 30 41 62 25
16 Friska Viljor Friska 30 30 74 20
TEMPORADA 2002/2003
SEGUNDA SUECIA
Equipo PJ GF GC Puntos
1 Kalmar FF Kalmar FF 30 51 28 67
2 Trelleborgs FF Trelleborgs 30 63 33 60
3 Häcken Häcken 30 56 40 57
4 Åtvidabergs Åtvidabergs 30 47 37 48
5 Västra Frölunda Västra 30 47 40 48
6 Brommapojkarna Brommapojkar 30 41 41 45
7 Cafe Opera Cafe Opera 30 53 48 41
8 Gefle Gefle 30 46 51 40
9 IFK Norrköping Norrköping 30 47 49 39
10 Assyriska FF Assyriska 30 47 53 39
11 Bodens Bodens 30 43 50 39
12 Västerås SK Västerås 30 44 48 37
13 Falkenbergs Falkenbergs 30 37 44 34
14 IFK Malmö IFK Malmö 30 42 58 33
15 BK Forward BK Forward 30 45 63 26
16 Sylvia Sylvia 30 34 60 19
TEMPORADA 2001/2002
SEGUNDA SUECIA
Equipo PJ GF GC Puntos
1 Osters IF Osters IF 30 61 35 54
2 Enköpings SK Enköpings 30 55 43 52
3 Västra Frölunda Västra 30 54 33 51
4 Häcken Häcken 30 52 33 51
5 Assyriska FF Assyriska 30 36 27 45
6 Cafe Opera Cafe Opera 30 48 45 44
7 IFK Malmö IFK Malmö 30 34 34 42
8 Västerås SK Västerås 30 49 49 41
9 Trelleborgs FF Trelleborgs 30 42 41 39
10 Åtvidabergs Åtvidabergs 30 31 50 37
11 Gefle Gefle 30 45 47 35
12 Brommapojkarna Brommapojkar 30 40 52 35
13 Sylvia Sylvia 30 37 55 35
14 IK Brage IK Brage 30 49 55 34
15 Ängelholm Ängelholm 30 29 45 34
16 Mjällby AIF Mjällby 30 42 60 29
TEMPORADA 2000/2001
LIGA SUECA
Equipo PJ GF GC Puntos
1 Hammarby IF Hammarby IF 26 45 28 48
2 Djurgårdens IF Djurgårdens 26 36 24 47
3 AIK Solna AIK Solna 26 45 29 45
4 IFK Göteborg Göteborg 26 41 31 44
5 Helsingborgs IF Helsingborgs 26 47 29 42
6 Örgryte Örgryte 26 36 33 39
7 Halmstads Halmstads 26 50 31 38
8 Orebro SK Orebro SK 26 48 44 33
9 Malmö FF Malmö FF 26 39 46 32
10 IF Elfsborg IF Elfsborg 26 31 51 30
11 GIF Sundsvall Sundsvall 26 28 37 29
12 IFK Norrköping Norrköping 26 29 40 29
13 Häcken Häcken 26 35 50 24
14 Trelleborgs FF Trelleborgs 26 25 62 14
TEMPORADA 1999/2000
LIGA SUECA
Equipo PJ GF GC Puntos
1 Halmstads Halmstads 26 47 24 52
2 Helsingborgs IF Helsingborgs 26 51 30 46
3 AIK Solna AIK Solna 26 38 30 45
4 IFK Göteborg Göteborg 26 46 33 44
5 IF Elfsborg IF Elfsborg 26 43 37 43
6 Trelleborgs FF Trelleborgs 26 30 28 38
7 Örgryte Örgryte 26 32 32 37
8 Hammarby IF Hammarby IF 26 34 38 36
9 IFK Norrköping Norrköping 26 40 31 35
10 Orebro SK Orebro SK 26 44 40 33
11 GIF Sundsvall Sundsvall 26 34 42 29
12 Häcken Häcken 26 40 52 25
13 GAIS GAIS 26 26 43 20
14 Västra Frölunda Västra 26 17 62 15
TEMPORADA 1998/1999
SEGUNDA SUECIA GRUPO 1
Equipo PJ GF GC Puntos
1 Häcken Häcken 26 62 28 51
2 GAIS GAIS 26 35 27 49
3 Mjällby AIF Mjällby 26 51 33 47
4 Ljungskile Ljungskile 26 38 26 46
5 Landskrona BoIS Landskrona 26 52 30 45
6 Gunnilse Gunnilse 26 39 30 42
7 Åtvidabergs Åtvidabergs 26 38 32 41
8 Osters IF Osters IF 26 32 30 39
9 Kristianstad FC Kristianstad 26 34 46 31
10 Kongahälla Kongahälla 26 31 40 28
11 Husqvarna Husqvarna 26 32 50 27
12 Falkenbergs Falkenbergs 26 36 59 26
13 Motala Motala 26 28 47 23
14 Stenungsund Stenungsund 26 28 58 15
TEMPORADA 1997/1998
LIGA SUECA
Equipo PJ GF GC Puntos
1 AIK Solna AIK Solna 26 25 15 46
2 Helsingborgs IF Helsingborgs 26 43 28 44
3 Hammarby IF Hammarby IF 26 39 34 42
4 Halmstads Halmstads 26 42 40 41
5 Västra Frölunda Västra 26 29 31 38
6 Orebro SK Orebro SK 26 35 38 36
7 IFK Norrköping Norrköping 26 43 35 35
8 IFK Göteborg Göteborg 26 27 29 35
9 Malmö FF Malmö FF 26 35 30 33
10 IF Elfsborg IF Elfsborg 26 36 33 33
11 Trelleborgs FF Trelleborgs 26 31 35 32
12 Örgryte Örgryte 26 35 36 28
13 Häcken Häcken 26 27 46 27
14 Osters IF Osters IF 26 26 43 22
TEMPORADA 1996/1997
SEGUNDA SUECIA GRUPO 1
Equipo PJ GF GC Puntos
1 Västra Frölunda Västra 26 72 24 54
2 Häcken Häcken 26 64 29 51
3 Gunnilse Gunnilse 26 55 23 51
4 Åtvidabergs Åtvidabergs 26 37 38 42
5 Stenungsund Stenungsund 26 43 35 40
6 Mjällby AIF Mjällby 26 42 38 37
7 IFK Hässleholm Hässleholm 26 46 44 37
8 Motala Motala 26 31 35 37
9 Falkenbergs Falkenbergs 26 50 38 35
10 Norrby Norrby 26 41 45 33
11 Hertzöga Hertzöga 26 34 53 26
12 Vetlanda FK Vetlanda FK 26 27 65 20
13 IFK Malmö IFK Malmö 26 30 63 17
14 IK Oddevold IK Oddevold 26 24 66 15
TEMPORADA 1993/1994
LIGA SUECA
Equipo PJ GF GC Puntos
1 IFK Göteborg Göteborg 26 54 28 38
2 Orebro SK Orebro SK 26 62 30 37
3 Malmö FF Malmö FF 26 51 33 35
4 IFK Norrköping Norrköping 26 52 22 34
5 Osters IF Osters IF 26 48 30 32
6 Halmstads Halmstads 26 41 39 28
7 AIK Solna AIK Solna 26 42 41 28
8 Degerfors IF Degerfors 26 28 37 24
9 Trelleborgs FF Trelleborgs 26 25 40 23
10 Helsingborgs IF Helsingborgs 26 30 46 23
11 Västra Frölunda Västra 26 30 33 20
12 Hammarby IF Hammarby IF 26 28 44 17
13 Landskrona BoIS Landskrona 26 22 59 13
14 Häcken Häcken 26 27 58 12
TEMPORADA 1992/1993
LIGA SUECA
Equipo PJ GF GC Puntos
1 IFK Göteborg Göteborg 26 48 17 59
2 IFK Norrköping Norrköping 26 56 23 54
3 AIK Solna AIK Solna 26 49 43 46
4 Trelleborgs FF Trelleborgs 26 46 39 42
5 Halmstads Halmstads 26 50 41 38
6 Häcken Häcken 26 44 49 37
7 Västra Frölunda Västra 26 38 45 37
8 Osters IF Osters IF 26 43 34 36
9 Helsingborgs IF Helsingborgs 26 43 46 36
10 Malmö FF Malmö FF 26 43 38 35
11 Orebro SK Orebro SK 26 35 38 33
12 Degerfors IF Degerfors 26 32 54 23
13 Örgryte Örgryte 26 26 44 21
14 IK Brage IK Brage 26 26 68 16
TEMPORADA 1982/1983
LIGA SUECA
Equipo PJ GF GC Puntos
1 AIK Solna AIK Solna 22 37 12 45
2 Malmö FF Malmö FF 22 46 30 41
3 IFK Göteborg Göteborg 22 35 19 38
4 Osters IF Osters IF 22 32 18 37
5 Hammarby IF Hammarby IF 22 41 32 35
6 Halmstads Halmstads 22 32 34 35
7 IF Elfsborg IF Elfsborg 22 31 31 30
8 Örgryte Örgryte 22 34 26 28
9 IK Brage IK Brage 22 21 40 21
10 Gefle Gefle 22 21 37 17
11 Mjällby AIF Mjällby 22 18 44 16
12 Häcken Häcken 22 16 41 14

  USO DE MEMORIA  
6,307,976 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.7385
Total Execution Time  0.7397
  CADENA URL  
/historico/Hacken/2005
  GET DATOS  
$_GET['/historico/Hacken/2005']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (39)  
0.0160  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 = 'Hacken' AND l.year = 2005 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.0145  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=3046 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=3046 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=3046 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0293  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 = 689
0.0150  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 = 21111
0.0147  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=3046 AND type_rel = 2
0.0149  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 3046 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0151  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 (98654,546476,850956,877681,1168462) ORDER BY n.cover_points DESC, update_date DESC
0.0168  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 = '3046' AND l.year = 2005 ORDER BY l.year DESC,cat.coefficient DESC
0.0163  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 = '3046' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0149  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 = 21111 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0146  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 = 689 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0157  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=3046 AND l.year in (2004,2005,2006) ORDER BY l.id DESC, l.year DESC ;
0.0150  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 (21111,13931,689) 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.0148  SELECT count(id) as num_players from rel_players WHERE league_id = 689 AND teamId = 3046
0.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 13931 AND teamId = 3046
0.0152  SELECT count(id) as num_players from rel_players WHERE league_id = 21111 AND teamId = 3046
0.0166  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 689 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0151  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 = '3046' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '3046' and rp.type = 4
0.0148  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 = '3046' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0158  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 events2005 e ON e.player_id = p.id AND e.league_id = 689 WHERE rp.league_id = 689 AND rp.teamId = 3046 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.0160  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 events2005 e ON e.player_id = p.id AND e.league_id = 689 WHERE rp.league_id = 689 AND rp.teamId = 3046 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0165  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 events2005 e ON e.player_id = p.id AND e.league_id = 689 WHERE rp.league_id = 689 AND rp.teamId = 3046 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0191  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 = 3046 AND l.year <= 2005 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0163  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 = 689 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163  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 = 13931 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0169  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 = 13933 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0164  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 = 13935 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0162  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 = 693 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0161  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 = 694 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163  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 = 13941 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0162  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 = 696 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0162  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 = 13946 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0162  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 = 13066 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0171  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 `tables1993` 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 = 22983 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0162  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 `tables1983` 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 = 23059 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154  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 = 689 ORDER BY nameShow LIMIT 100