4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2023/2024
SEGUNDA DINAMARCA GRUPO 3
Equipo PJ GF GC Puntos
1 Fremad Amager Fremad 3 7 2 9
2 Hellerup IK Hellerup IK 3 2 3 6
3 FA 2000 FA 2000 3 4 4 4
4 Skive Skive 3 4 5 3
5 Thisted Thisted 3 2 3 3
6 Brabrand Brabrand 3 1 3 1
TEMPORADA 2022/2023
SEGUNDA DINAMARCA GRUPO 2
Equipo PJ GF GC Puntos
1 Kolding IF Kolding IF 32 62 27 66
2 B93 B93 32 63 38 66
3 Esbjerg Esbjerg 32 61 34 65
4 Aarhus Fremad Aarhus 32 64 35 63
5 Akademisk Boldklub Akademisk 32 63 51 48
6 Thisted Thisted 32 34 48 34
TEMPORADA 2021/2022
SEGUNDA DINAMARCA GRUPO 2
Equipo PJ GF GC Puntos
1 Næstved Næstved 32 60 33 73
2 Hillerød Hillerød 32 53 38 56
3 Thisted Thisted 32 44 41 54
4 B93 B93 32 53 49 42
5 Akademisk Boldklub Akademisk 32 42 38 38
6 Hellerup IK Hellerup IK 32 46 56 37
TEMPORADA 2020/2021
SEGUNDA DINAMARCA GRUPO 1
Equipo PJ GF GC Puntos
1 Jammerbugt Jammerbugt 26 53 24 60
2 B93 B93 26 48 29 53
3 Aarhus Fremad Aarhus 26 53 35 46
4 Middelfart Middelfart 26 47 36 43
5 Thisted Thisted 26 34 25 43
6 Brabrand Brabrand 26 39 29 41
7 VSK Aarhus VSK Aarhus 26 33 26 39
8 Frem 1886 Frem 1886 26 36 31 39
9 Dalum Dalum 26 33 40 33
10 Næsby BK Næsby BK 26 35 44 32
11 Holbæk Holbæk 26 35 47 28
12 Sydvest Sydvest 26 30 45 24
13 SfB-Oure SfB-Oure 26 34 72 15
14 Holstebro Holstebro 26 27 54 11
TEMPORADA 2019/2020
SEGUNDA DINAMARCA GRUPO 3
Equipo PJ GF GC Puntos
1 Aarhus Fremad Aarhus 6 21 2 54
2 FC Helsingør Helsingør 6 9 4 54
3 Middelfart Middelfart 6 15 10 43
4 Brabrand Brabrand 6 7 10 39
5 Thisted Thisted 6 8 9 38
6 Jammerbugt Jammerbugt 6 11 3 37
7 Akademisk Boldklub Akademisk 6 13 12 36
8 Hellerup IK Hellerup IK 6 9 9 35
9 Vanløse Vanløse 6 6 11 34
10 Brønshøj Brønshøj 6 6 20 31
11 Frem 1886 Frem 1886 6 9 17 29
12 Avarta Avarta 6 7 14 25
TEMPORADA 2018/2019
PRIMERA DINAMARCA
Equipo PJ GF GC Puntos
1 Silkeborg IF Silkeborg 33 60 41 61
2 Viborg FF Viborg FF 33 61 37 60
3 Lyngby BK Lyngby BK 33 51 47 52
4 Næstved Næstved 33 43 40 50
5 Fremad Amager Fremad 33 42 45 50
6 Fredericia Fredericia 33 51 47 47
7 HB Køge HB Køge 33 52 47 45
8 Nykøbing FC Nykøbing 33 44 47 45
9 Roskilde Roskilde 33 57 66 35
10 Hvidovre IF Hvidovre IF 33 39 49 35
11 FC Helsingør Helsingør 33 35 43 31
12 Thisted Thisted 33 35 61 30
TEMPORADA 2017/2018
PRIMERA DINAMARCA
Equipo PJ GF GC Puntos
1 Vejle BK Vejle BK 33 47 24 65
2 Esbjerg Esbjerg 33 61 36 60
3 Vendsyssel Vendsyssel 33 59 42 56
4 Viborg FF Viborg FF 33 58 42 54
5 HB Køge HB Køge 33 42 31 52
6 Fredericia Fredericia 33 48 47 42
7 Nykøbing FC Nykøbing 33 54 59 40
8 Thisted Thisted 33 42 53 40
9 Fremad Amager Fremad 33 27 42 40
10 Roskilde Roskilde 33 41 49 38
11 Brabrand Brabrand 33 34 61 34
12 Skive Skive 33 33 60 18
TEMPORADA 2016/2017
SEGUNDA DINAMARCA GRUPO 4
Equipo PJ GF GC Puntos
1 Thisted Thisted 16 38 9 52
2 Brabrand Brabrand 16 32 17 41
3 Kolding IF Kolding IF 16 30 17 40
4 Avarta Avarta 16 32 20 37
5 B93 B93 16 25 22 35
6 Kjellerup Kjellerup 16 32 27 29
7 Brønshøj Brønshøj 16 21 29 27
8 Marienlyst Marienlyst 16 22 30 26
9 Aarhus Fremad Aarhus 16 18 21 24
10 Hvidovre IF Hvidovre IF 16 17 27 22
11 Dalum Dalum 16 12 32 18
12 Greve IF Greve IF 16 15 43 16
TEMPORADA 2015/2016
SEGUNDA DINAMARCA GRUPO 3
Equipo PJ GF GC Puntos
1 Thisted Thisted 14 39 15 32
2 Brabrand Brabrand 14 26 17 28
3 Middelfart Middelfart 14 22 22 25
4 Aarhus Fremad Aarhus 14 27 20 22
5 Jammerbugt Jammerbugt 14 21 29 17
6 Odder Odder 14 20 30 13
7 Kolding IF Kolding IF 14 19 27 11
8 VSK Aarhus VSK Aarhus 14 15 29 11
TEMPORADA 2014/2015
SEGUNDA DINAMARCA GRUPO 1
Equipo PJ GF GC Puntos
1 Næstved Næstved 30 66 30 67
2 Marienlyst Marienlyst 30 73 39 58
3 Jammerbugt Jammerbugt 30 58 42 54
4 Thisted Thisted 30 61 49 52
5 VSK Aarhus VSK Aarhus 30 50 48 51
6 Kolding IF Kolding IF 30 66 46 48
7 Næsby BK Næsby BK 30 62 49 44
8 Svendborg Svendborg 30 45 40 39
9 Odder Odder 30 49 45 39
10 Brabrand Brabrand 30 44 47 39
11 Middelfart Middelfart 30 50 56 39
12 Ringkøbing Ringkøbing 30 41 51 39
13 Sydvest Sydvest 30 45 62 35
14 Varde IF Elite Varde Elite 30 36 63 27
15 Kjellerup Kjellerup 30 47 74 20
16 Kolding BK B Kolding 30 42 94 20
TEMPORADA 2013/2014
SEGUNDA DINAMARCA GRUPO 1
Equipo PJ GF GC Puntos
1 Skive Skive 30 78 28 77
2 HIK HIK 30 51 39 55
3 Rishøj Rishøj 30 57 40 53
4 Jammerbugt Jammerbugt 30 55 42 52
5 Thisted Thisted 30 46 41 46
6 Ringkøbing Ringkøbing 30 55 50 44
7 Brabrand Brabrand 30 51 46 42
8 VSK Aarhus VSK Aarhus 30 49 50 42
9 Middelfart Middelfart 30 44 50 38
10 Svendborg Svendborg 30 41 39 37
11 Næsby BK Næsby BK 30 49 52 36
12 Odder Odder 30 38 44 36
13 Sydvest Sydvest 30 51 70 33
14 Aarhus Fremad Aarhus 30 29 42 32
15 Skanderborg Skanderborg 30 51 65 31
16 Djursland Djursland 30 23 70 7
TEMPORADA 2012/2013
SEGUNDA DINAMARCA GRUPO 1
Equipo PJ GF GC Puntos
1 Marienlyst Marienlyst 30 81 45 68
2 Aarhus Fremad Aarhus 30 63 17 61
3 Brabrand Brabrand 30 47 36 52
4 Jammerbugt Jammerbugt 30 53 42 48
5 Svendborg Svendborg 30 54 45 48
6 Næsby BK Næsby BK 30 60 49 47
7 Middelfart Middelfart 30 45 38 41
8 Thisted Thisted 30 51 49 41
9 Skanderborg Skanderborg 30 58 60 39
10 VSK Aarhus VSK Aarhus 30 45 51 37
11 BSV Søllerød Søllerød 30 49 58 36
12 Sydvest Sydvest 30 44 59 33
13 Ringkøbing Ringkøbing 30 47 61 31
14 Kjellerup Kjellerup 30 39 60 30
15 Otterup Otterup 30 47 73 29
16 Varde Varde 30 33 73 17
TEMPORADA 2011/2012
SEGUNDA DINAMARCA GRUPO 1
Equipo PJ GF GC Puntos
1 Fyn Fyn 30 71 21 72
2 Næsby BK Næsby BK 30 77 29 70
3 Varde Varde 30 42 27 55
4 Thisted Thisted 29 62 39 50
5 Aarhus Fremad Aarhus 30 59 43 46
6 Marienlyst Marienlyst 30 57 55 45
7 Svendborg Svendborg 30 50 39 43
8 VSK Aarhus VSK Aarhus 30 44 50 41
9 Nykøbing FC Nykøbing 30 47 58 38
10 Kjellerup Kjellerup 30 39 43 36
11 Otterup Otterup 30 42 64 33
12 Brabrand Brabrand 30 36 40 32
13 Aarup Aarup 30 38 66 29
14 Lindholm Lindholm 30 32 62 28
15 Skjold Skjold 29 38 58 21
16 Viby Viby 30 27 67 17
TEMPORADA 2010/2011
SEGUNDA DINAMARCA GRUPO 2
Equipo PJ GF GC Puntos
1 Jammerbugt Jammerbugt 30 78 33 70
2 Aarhus Fremad Aarhus 30 68 36 63
3 Thisted Thisted 30 69 39 57
4 Næsby BK Næsby BK 30 51 38 48
5 VSK Aarhus VSK Aarhus 30 50 41 48
6 Brabrand Brabrand 30 40 26 46
7 Svendborg Svendborg 30 53 50 39
8 B 1908 B 1908 30 40 42 36
9 Lindholm Lindholm 30 50 63 35
10 Rishøj Rishøj 30 41 55 34
11 Otterup Otterup 30 49 73 34
12 Varde Varde 30 42 56 33
13 Middelfart Middelfart 30 46 72 33
14 Djursland Djursland 30 47 53 32
15 Holstebro Holstebro 30 42 56 31
16 Tjørring Tjørring 30 35 68 27

  USO DE MEMORIA  
6,290,600 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.5249
Total Execution Time  0.5271
  CADENA URL  
/historico/Thisted
  GET DATOS  
$_GET['/historico/Thisted']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (32)  
0.0138  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 = 'Thisted' 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.0125  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=7435 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=7435 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=7435 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=7435 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=7435 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131  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 = 72491
0.0131  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 = 72646
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=7435 AND type_rel = 2
0.0131  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 = '7435' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0130  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 = 72646 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0131  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 = 7435 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0128  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 = 72491 AND t.round = 22 ORDER BY team.conference ASC,t.position 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 `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 = 75800 AND t.round = 3 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 68164 AND t.round = 22 ORDER BY team.conference ASC,t.position 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 `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 = 71479 AND t.round = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 63169 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 67321 AND t.round = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 58309 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 50400 AND t.round = 17 ORDER BY team.conference ASC,t.position 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 `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 = 56776 AND t.round = 6 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 43923 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0173  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 = 38748 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 33545 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 38476 AND t.round = 16 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 20328 AND t.round = 16 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0137  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 = 16252 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 = 4160 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 2479 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 2021 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 1733 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 24349 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC