4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2023/2024
PRIMERA DINAMARCA GRUPO 3
Equipo PJ GF GC Puntos
1 Hillerød Hillerød 27 46 36 36
2 AC Horsens AC Horsens 27 33 41 35
3 B93 B93 27 33 49 32
4 HB Køge HB Køge 26 36 56 25
5 Næstved Næstved 27 30 48 21
6 FC Helsingør Helsingør 26 29 54 15
TEMPORADA 2022/2023
PRIMERA DINAMARCA GRUPO 1
Equipo PJ GF GC Puntos
1 Vejle BK Vejle BK 22 47 20 50
2 Hvidovre IF Hvidovre IF 22 50 28 44
3 FC Helsingør Helsingør 22 32 35 37
4 SonderjyskE SonderjyskE 22 41 29 35
5 Vendsyssel Vendsyssel 22 35 31 33
6 Næstved Næstved 22 32 26 32
7 Hillerød Hillerød 22 29 35 31
8 HB Køge HB Køge 22 29 33 25
9 Hobro Hobro 22 19 30 23
10 Fremad Amager Fremad 22 26 44 23
11 Fredericia Fredericia 22 29 40 21
12 Nykøbing FC Nykøbing 22 26 44 17
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 2
Equipo PJ GF GC Puntos
1 Nykøbing FC Nykøbing 26 60 22 62
2 Hellerup IK Hellerup IK 26 39 25 53
3 Akademisk Boldklub Akademisk 26 44 31 51
4 Næstved Næstved 26 48 31 43
5 Hillerød Hillerød 26 33 31 43
6 FA 2000 FA 2000 26 29 24 41
7 Roskilde Roskilde 26 39 33 39
8 Vanløse Vanløse 26 31 29 34
9 Slagelse B&I Slagelse 26 29 33 32
10 KFUM Roskilde KFUM 26 31 44 26
11 Skovshoved Skovshoved 26 30 43 24
12 Avarta Avarta 26 25 43 24
13 Brønshøj Brønshøj 26 34 50 23
14 AB Tårnby AB Tårnby 26 23 56 12
TEMPORADA 2019/2020
PRIMERA DINAMARCA
Equipo PJ GF GC Puntos
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
SEGUNDA DINAMARCA GRUPO 4
Equipo PJ GF GC Puntos
1 Hvidovre IF Hvidovre IF 16 42 14 54
2 Næstved Næstved 16 34 11 46
3 Jammerbugt Jammerbugt 16 25 16 38
4 Kjellerup Kjellerup 16 23 30 34
5 Kolding IF Kolding IF 16 20 19 33
6 Middelfart Middelfart 16 29 25 30
7 Marienlyst Marienlyst 16 19 36 27
8 Skovshoved Skovshoved 16 24 19 26
9 Frem 1886 Frem 1886 16 23 19 25
10 Ringkøbing Ringkøbing 16 22 34 22
11 Avarta Avarta 16 20 32 21
12 Sydvest Sydvest 16 12 38 14
TEMPORADA 2016/2017
PRIMERA DINAMARCA
Equipo PJ GF GC Puntos
1 Hobro Hobro 33 54 34 58
2 Vendsyssel Vendsyssel 33 51 39 55
3 FC Helsingør Helsingør 33 43 31 53
4 Roskilde Roskilde 33 45 42 53
5 Skive Skive 33 41 51 49
6 Nykøbing FC Nykøbing 33 50 51 46
7 HB Køge HB Køge 33 32 28 44
8 Fredericia Fredericia 33 36 43 43
9 Vejle BK Vejle BK 33 49 46 41
10 Fremad Amager Fremad 33 42 45 41
11 Næstved Næstved 33 45 51 35
12 Akademisk Boldklub Akademisk 33 34 61 24
TEMPORADA 2015/2016
PRIMERA DINAMARCA
Equipo PJ GF GC Puntos
1 Lyngby BK Lyngby BK 33 59 37 64
2 Silkeborg IF Silkeborg 33 59 29 63
3 AC Horsens AC Horsens 33 52 34 60
4 Vendsyssel Vendsyssel 33 41 33 56
5 Vejle BK Vejle BK 33 55 47 50
6 Fredericia Fredericia 33 45 45 47
7 FC Helsingør Helsingør 33 40 42 47
8 HB Køge HB Køge 33 34 35 45
9 Roskilde Roskilde 33 51 58 39
10 Næstved Næstved 33 38 47 37
11 Skive Skive 33 37 50 31
12 Vestsjælland Vestsjællan 33 19 73 13
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 2
Equipo PJ GF GC Puntos
1 Roskilde Roskilde 30 88 22 80
2 Næstved Næstved 29 67 33 58
3 Fremad Amager Fremad 30 76 55 51
4 B 1908 B 1908 29 45 34 50
5 FC Helsingør Helsingør 30 55 38 47
6 Nordvest Nordvest 30 66 58 45
7 Nykøbing FC Nykøbing 30 55 60 40
8 Frem 1886 Frem 1886 30 50 46 40
9 BSV Søllerød Søllerød 29 38 41 38
10 B93 B93 30 42 43 36
11 GVI GVI 29 40 60 35
12 Svebølle Svebølle 30 32 46 32
13 Avarta Avarta 30 50 67 31
14 Skjold Birkerød Skjold 30 41 70 30
15 Vanløse Vanløse 30 34 67 29
16 SC Egedal SC Egedal 30 31 70 20
TEMPORADA 2012/2013
SEGUNDA DINAMARCA GRUPO 2
Equipo PJ GF GC Puntos
1 Hvidovre IF Hvidovre IF 30 84 31 69
2 FC Helsingør Helsingør 30 79 38 64
3 Rishøj Rishøj 30 50 29 60
4 Næstved Næstved 30 64 32 59
5 HIK HIK 30 58 45 51
6 B 1908 B 1908 30 46 41 51
7 Frem 1886 Frem 1886 30 45 40 48
8 Roskilde Roskilde 30 52 41 46
9 Nordvest Nordvest 30 51 49 44
10 Nykøbing FC Nykøbing 30 48 59 36
11 Avarta Avarta 30 39 47 33
12 Svebølle Svebølle 30 37 61 31
13 Skjold Birkerød Skjold 30 44 65 29
14 Fremad Amager Fremad 30 39 59 23
15 Herlev Herlev 30 27 67 21
16 NB Bornholm NB Bornholm 30 14 73 6
TEMPORADA 2011/2012
PRIMERA DINAMARCA
Equipo PJ GF GC Puntos
1 Esbjerg Esbjerg 26 60 19 66
2 Randers Randers 26 38 22 49
3 Vejle BK Vejle BK 26 58 32 44
4 Viborg FF Viborg FF 26 45 34 40
5 Brønshøj Brønshøj 26 35 34 40
6 Vestsjælland Vestsjællan 26 42 35 38
7 Fredericia Fredericia 26 33 30 35
8 Skive Skive 26 31 41 34
9 Hobro Hobro 26 37 35 33
10 Vendsyssel Vendsyssel 26 31 42 31
11 Akademisk Boldklub Akademisk 26 32 44 29
12 Roskilde Roskilde 26 28 38 27
13 Næstved Næstved 26 32 51 22
14 Jammerbugt Jammerbugt 26 27 72 11
TEMPORADA 2010/2011
PRIMERA DINAMARCA
Equipo PJ GF GC Puntos
1 AGF Aarhus AGF Aarhus 30 66 25 72
2 Køge BK Køge BK 30 58 35 61
3 Vejle BK Vejle BK 30 49 32 52
4 Skive Skive 30 55 47 47
5 Brønshøj Brønshøj 30 38 38 46
6 Fredericia Fredericia 30 53 41 45
7 Vestsjælland Vestsjællan 30 58 57 42
8 Roskilde Roskilde 30 45 45 42
9 Akademisk Boldklub Akademisk 30 48 49 37
10 Næstved Næstved 30 43 44 33
11 Viborg FF Viborg FF 30 37 43 33
12 Hobro Hobro 30 41 55 33
13 Vendsyssel Vendsyssel 30 40 57 33
14 Kolding FC Kolding FC 30 38 53 30
15 Fyn Fyn 30 45 60 26
16 Hvidovre IF Hvidovre IF 30 36 69 23
TEMPORADA 2009/2010
PRIMERA DINAMARCA
Equipo PJ GF GC Puntos
1 AC Horsens AC Horsens 30 67 27 66
2 Lyngby BK Lyngby BK 30 59 39 62
3 Fredericia Fredericia 30 56 22 59
4 Akademisk Boldklub Akademisk 30 47 30 54
5 Vestsjælland Vestsjællan 30 54 46 50
6 Næstved Næstved 30 44 34 44
7 Viborg FF Viborg FF 30 30 26 44
8 Fyn Fyn 30 42 51 42
9 Skive Skive 30 44 50 41
10 Vejle BK Vejle BK 30 33 34 33
11 Roskilde Roskilde 30 37 51 33
12 Hvidovre IF Hvidovre IF 30 37 43 32
13 Kolding FC Kolding FC 30 41 59 31
14 Thisted Thisted 30 33 57 30
15 Frem 1886 Frem 1886 30 38 59 28
16 Brabrand Brabrand 30 18 52 13
TEMPORADA 2008/2009
PRIMERA DINAMARCA
Equipo PJ GF GC Puntos
1 Herfølge BK Herfølge 30 77 27 71
2 Silkeborg IF Silkeborg 30 68 27 69
3 Akademisk Boldklub Akademisk 30 56 30 61
4 Viborg FF Viborg FF 30 59 40 54
5 Næstved Næstved 30 55 34 52
6 Lyngby BK Lyngby BK 30 50 26 50
7 Fredericia Fredericia 30 58 43 47
8 Hvidovre IF Hvidovre IF 30 51 46 40
9 Thisted Thisted 30 54 49 39
10 Roskilde Roskilde 30 45 53 39
11 Frem 1886 Frem 1886 30 41 53 36
12 Kolding IF Kolding IF 30 45 59 36
13 Skive Skive 30 49 57 34
14 Nykøbing FC Nykøbing 30 25 66 12
15 FC Amager FC Amager 29 24 72 11
16 Køge BK Køge BK 29 11 86 7

  USO DE MEMORIA  
6,636,160 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6606
Total Execution Time  0.6618
  CADENA URL  
/historico/Nastved
  GET DATOS  
$_GET['/historico/Nastved']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (41)  
0.0140  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 = 'Nastved' 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=4818 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=4818 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=4818 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=4818 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=4818 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0256  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 = 75694
0.0141  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 = 72210
0.0163  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.0129  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=4818 AND type_rel = 2
0.0155  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 = '4818' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0168  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 = '4818' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0128  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 = 75694 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0136  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=4818 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0128  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 (75694,72646,71432) 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.0132  SELECT count(id) as num_players from rel_players WHERE league_id = 75694 AND teamId = 4818
0.0143  SELECT count(id) as num_players from rel_players WHERE league_id = 72646 AND teamId = 4818
0.0131  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 4818
0.0134  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 events2024 e ON e.player_id = p.id AND e.league_id = 75694 WHERE rp.league_id = 75694 AND rp.teamId = 4818 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.0133  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 events2024 e ON e.player_id = p.id AND e.league_id = 75694 WHERE rp.league_id = 75694 AND rp.teamId = 4818 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0127  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 events2024 e ON e.player_id = p.id AND e.league_id = 75694 WHERE rp.league_id = 75694 AND rp.teamId = 4818 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0132  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 = 4818 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 = 72210 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 = 75694 AND t.round = 5 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 = 71291 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.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 = 67913 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.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 `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.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 `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 = 58310 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.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 `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.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 `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 = 38874 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 `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 = 43168 AND t.round = 16 ORDER BY team.conference 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 `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 = 33345 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 = 15719 AND t.round = 33 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 `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.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 `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 = 2480 AND t.round = 30 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 `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 = 2022 AND t.round = 30 ORDER BY team.conference 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 `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 = 1361 AND t.round = 26 ORDER BY team.conference 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 `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 = 1156 AND t.round = 30 ORDER BY team.conference 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 `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 = 10297 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 `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 = 10296 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC