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

Östersunds FK

Entrenador: Magnus Powell

Temporada 2015/2016
TEMPORADA 2015/2016
LIGA SUECA
Equipo PJ GF GC Puntos
1 Malmö FF Malmö FF 30 60 26 66
2 AIK Solna AIK Solna 30 52 26 60
3 IFK Norrköping Norrköping 30 59 37 60
4 IFK Göteborg Göteborg 30 56 47 50
5 IF Elfsborg IF Elfsborg 30 58 38 48
6 Kalmar FF Kalmar FF 30 45 40 44
7 Djurgårdens IF Djurgårdens 30 48 47 43
8 Östersunds FK Östersunds 30 44 46 42
9 Orebro SK Orebro SK 30 48 51 41
10 Häcken Häcken 30 58 45 40
11 Hammarby IF Hammarby IF 30 46 49 39
12 Jönköpings Södra Jönköpings 30 32 39 35
13 GIF Sundsvall Sundsvall 30 38 54 30
14 Helsingborgs IF Helsingborgs 30 34 52 29
15 Gefle Gefle 30 34 56 27
16 Falkenbergs Falkenbergs 30 25 84 10
TEMPORADA 2014/2015
SEGUNDA SUECIA
Equipo PJ GF GC Puntos
1 Jönköpings Södra Jönköpings 30 54 28 63
2 Östersunds FK Östersunds 30 56 25 62
3 IK Sirius IK Sirius 30 53 25 58
4 Assyriska FF Assyriska 30 46 37 47
5 Varbergs BoIS Varbergs 30 34 27 47
6 Ljungskile Ljungskile 30 44 37 43
7 Syrianska FC Syrianska 30 37 30 43
8 AFC Eskilstuna Eskilstuna 30 43 44 40
9 Degerfors IF Degerfors 30 36 38 38
10 IFK Varnamo IFK Varnamo 30 37 40 38
11 GAIS GAIS 30 37 44 35
12 Ängelholm Ängelholm 30 31 47 33
13 Mjällby AIF Mjällby 30 23 43 30
14 IK Frej IK Frej 30 22 44 29
15 Utsiktens BK Utsiktens 30 28 56 26
16 Brommapojkarna Brommapojkar 30 30 46 23
TEMPORADA 2013/2014
SEGUNDA SUECIA
Equipo PJ GF GC Puntos
1 Hammarby IF Hammarby IF 30 68 27 61
2 GIF Sundsvall Sundsvall 30 55 34 61
3 Ljungskile Ljungskile 30 60 25 60
4 Jönköpings Södra Jönköpings 30 60 42 52
5 Östersunds FK Östersunds 30 40 40 45
6 IK Sirius IK Sirius 30 47 36 43
7 Degerfors IF Degerfors 30 47 46 40
8 Varbergs BoIS Varbergs 30 38 43 39
9 IFK Varnamo IFK Varnamo 30 43 52 39
10 Syrianska FC Syrianska 30 37 55 37
11 GAIS GAIS 30 31 38 35
12 Ängelholm Ängelholm 30 30 51 35
13 Osters IF Osters IF 30 39 48 32
14 Assyriska FF Assyriska 30 28 44 27
15 Landskrona BoIS Landskrona 30 35 55 26
16 Husqvarna Husqvarna 30 27 49 22
TEMPORADA 2012/2013
SEGUNDA SUECIA
Equipo PJ GF GC Puntos
1 Falkenbergs Falkenbergs 30 63 31 62
2 Orebro SK Orebro SK 30 52 21 61
3 GIF Sundsvall Sundsvall 30 54 35 58
4 Degerfors IF Degerfors 30 52 41 52
5 Hammarby IF Hammarby IF 30 34 28 47
6 Ängelholm Ängelholm 30 55 47 43
7 GAIS GAIS 30 45 47 43
8 Assyriska FF Assyriska 30 42 44 42
9 Ljungskile Ljungskile 30 34 31 39
10 Östersunds FK Östersunds 30 39 38 39
11 Jönköpings Södra Jönköpings 30 39 44 38
12 Landskrona BoIS Landskrona 30 40 48 32
13 Varbergs BoIS Varbergs 30 47 65 32
14 IFK Varnamo IFK Varnamo 30 30 51 31
15 Örgryte Örgryte 30 23 40 28
16 IK Brage IK Brage 30 21 59 12
TEMPORADA 2011/2012
TERCERA SUECIA GRUPO 1
Equipo PJ GF GC Puntos
1 Östersunds FK Östersunds 26 50 21 53
2 BK Forward BK Forward 26 50 25 53
3 IK Sirius IK Sirius 26 51 20 52
4 Vasalunds IF Vasalunds 26 43 24 48
5 IK Frej IK Frej 26 48 34 48
6 Eskilstuna City Eskilstuna 26 38 44 40
7 Västerås SK Västerås 26 46 43 36
8 Dalkurd FF Dalkurd FF 26 56 50 34
9 Sandvikens IF Sandvikens 26 43 45 34
10 IFK Luleå IFK Luleå 26 41 50 31
11 AFC Eskilstuna Eskilstuna 26 36 43 30
12 Syrianska IF Syrianska 26 34 70 24
13 Akropolis Akropolis 26 27 46 20
14 Enköpings SK Enköpings 26 19 67 8
TEMPORADA 2010/2011
CUARTA SUECIA GRUPO 6
Equipo PJ GF GC Puntos
1 Östersunds FK Östersunds 22 51 12 52
2 Hudiksvall Hudiksvall 22 57 25 43
3 Mariehem Mariehem 22 45 29 43
4 Anundsjö Anundsjö 22 41 36 38
5 Skellefteå Skellefteå 22 41 30 36
6 Umedalen Umedalen 22 42 37 32
7 Piteå Piteå 22 41 38 32
8 Härnösand Härnösand 22 38 33 30
9 Morön Morön 22 41 44 28
10 Sollefteå Sollefteå 22 26 31 23
11 Älgarna Älgarna 22 26 49 15
12 Junsele Junsele 22 19 104 4
TEMPORADA 2009/2010
TERCERA SUECIA GRUPO 1
Equipo PJ GF GC Puntos
1 Västerås SK Västerås 26 54 29 52
2 IK Sirius IK Sirius 26 46 24 47
3 Syrianska IF Syrianska 26 50 44 45
4 Hammarby Nacka FF Hammarby 26 44 41 41
5 Vasalunds IF Vasalunds 26 42 37 40
6 Dalkurd FF Dalkurd FF 26 49 46 39
7 Umeå Umeå 26 51 42 34
8 Grondals IK Grondals IK 26 38 46 33
9 Valsta Syrianska Valsta 26 36 45 32
10 Bodens Bodens 26 35 59 32
11 BK Forward BK Forward 26 45 40 31
12 Carlstad United Carlstad 26 28 38 31
13 Östersunds FK Östersunds 26 30 43 30
14 Arameiska / Syrianska Arameiska 26 27 41 27
TEMPORADA 2008/2009
TERCERA SUECIA GRUPO 1
Equipo PJ GF GC Puntos
1 Degerfors IF Degerfors 26 58 25 60
2 IK Brage IK Brage 26 47 31 52
3 Valsta Syrianska Valsta 26 53 36 48
4 Umeå Umeå 26 51 37 48
5 Västerås SK Västerås 26 49 37 37
6 Grondals IK Grondals IK 26 37 43 35
7 Carlstad United Carlstad 26 30 31 33
8 Arameiska / Syrianska Arameiska 26 30 38 32
9 BK Forward BK Forward 26 41 45 31
10 Syrianska IF Syrianska 26 42 48 31
11 Östersunds FK Östersunds 26 37 39 30
12 Karlslund Karlslund 26 34 42 29
13 Enköpings SK Enköpings 26 35 55 25
14 Skellefteå Skellefteå 26 27 64 15
TEMPORADA 2007/2008
TERCERA SUECIA GRUPO 1
Equipo PJ GF GC Puntos
1 Syrianska FC Syrianska 26 44 16 59
2 Vasalunds IF Vasalunds 26 57 26 51
3 Västerås SK Västerås 26 59 36 51
4 Grondals IK Grondals IK 26 49 33 50
5 Umeå Umeå 26 43 38 41
6 Valsta Syrianska Valsta 26 41 40 36
7 BK Forward BK Forward 26 46 49 34
8 Arameiska / Syrianska Arameiska 26 26 35 31
9 Sylvia Sylvia 26 41 56 30
10 Östersunds FK Östersunds 26 30 36 29
11 IK Brage IK Brage 26 35 43 26
12 Ersboda SK Ersboda SK 26 48 67 25
13 Falu FK Falu FK 26 31 49 24
14 Bodens Bodens 26 27 53 22
TEMPORADA 2006/2007
TERCERA SUECIA GRUPO 1
Equipo PJ GF GC Puntos
1 Assyriska FF Assyriska 26 53 27 54
2 AFC Eskilstuna Eskilstuna 26 51 31 51
3 Vasalunds IF Vasalunds 26 54 29 49
4 Syrianska FC Syrianska 26 37 28 46
5 BK Forward BK Forward 26 43 28 41
6 Västerås SK Västerås 26 45 39 37
7 Bodens Bodens 26 26 33 37
8 Umeå Umeå 26 50 43 35
9 Falu FK Falu FK 26 31 44 31
10 Grondals IK Grondals IK 26 32 45 30
11 Östersunds FK Östersunds 26 39 40 29
12 Valsta Syrianska Valsta 26 31 33 29
13 Skiljebo Skiljebo 26 28 43 27
14 IFK Timra IFK Timra 26 20 77 9
TEMPORADA 2005/2006
TERCERA SUECIA GRUPO 1
Equipo PJ GF GC Puntos
1 Enköpings SK Enköpings 26 53 36 55
2 IK Sirius IK Sirius 26 62 24 54
3 Västerås SK Västerås 26 58 26 49
4 Vasalunds IF Vasalunds 26 49 30 46
5 Gute Gute 26 53 45 43
6 Syrianska FC Syrianska 26 41 32 42
7 Valsta Syrianska Valsta 26 39 34 38
8 Bodens Bodens 26 35 32 33
9 BK Forward BK Forward 26 33 35 33
10 Falu FK Falu FK 26 31 38 27
11 Östersunds FK Östersunds 26 39 47 27
12 Robertsfors IK Robertsfors 26 35 50 27
13 Anundsjö Anundsjö 26 27 77 11
14 Kiruna FF Kiruna FF 26 18 67 10

  USO DE MEMORIA  
6,343,584 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.1478
Total Execution Time  0.1491
  CADENA URL  
/historico/Ostersunds-Fk/2016
  GET DATOS  
$_GET['/historico/Ostersunds-Fk/2016']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (43)  
0.0035  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 = 'Ostersunds-Fk' AND l.year = 2016 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=16476 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=16476 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=16476 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=16476 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=16476 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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 = 20090
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 = 15055
0.0024  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 = 20092
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=16476 AND type_rel = 2
0.0027  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 16476 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0021  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 (110099,132514,283490,291268,297633) ORDER BY n.cover_points DESC, update_date DESC
0.0029  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 = '16476' ORDER BY l.year DESC,cat.coefficient DESC
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 = '16476' AND l.year = 2016 ORDER BY l.year DESC,cat.coefficient DESC
0.0024  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 = '16476' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 20092 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024  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 = 20090 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0033  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=16476 AND l.year in (2015,2016,2017) ORDER BY l.id DESC, l.year DESC ;
0.0023  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 (37608,37467,30386,9517) 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.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 37608 AND teamId = 16476
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 9517 AND teamId = 16476
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 37467 AND teamId = 16476
0.0076  SELECT count(id) as num_players from rel_players WHERE league_id = 30386 AND teamId = 16476
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 `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 = 20090 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 = '16476' 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 = '16476' and rp.type = 4
0.0025  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 = '16476' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0048  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 events2016 e ON e.player_id = p.id AND e.league_id = 20090 WHERE rp.league_id = 20090 AND rp.teamId = 16476 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 events2016 e ON e.player_id = p.id AND e.league_id = 20090 WHERE rp.league_id = 20090 AND rp.teamId = 16476 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0031  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 events2016 e ON e.player_id = p.id AND e.league_id = 20090 WHERE rp.league_id = 20090 AND rp.teamId = 16476 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0030  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 = 16476 AND l.year <= 2016 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 20090 AND t.round = 30 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 `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 = 9517 AND t.round = 30 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 `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 = 3466 AND t.round = 30 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 `tables2013` 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 = 2796 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 `tables2012` 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 = 10454 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 25215 AND t.round = 22 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 `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 = 10456 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 10457 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 16474 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 16476 AND t.round = 26 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 `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 = 16478 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 20090 ORDER BY nameShow LIMIT 100