4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2023/2024
TERCERA DINAMARCA GRUPO 2
Equipo PJ GF GC Puntos
1 Frem 1886 Frem 1886 24 40 22 49
2 Ishøj Ishøj 24 44 31 40
3 VSK Aarhus VSK Aarhus 24 40 28 38
4 Næsby BK Næsby BK 24 36 36 32
5 Holbæk Holbæk 24 24 26 31
6 Avarta Avarta 24 22 31 31
TEMPORADA 2022/2023
TERCERA DINAMARCA GRUPO 2
Equipo PJ GF GC Puntos
1 Middelfart Middelfart 32 60 20 75
2 FA 2000 FA 2000 32 56 32 58
3 VSK Aarhus VSK Aarhus 32 56 35 53
4 Ishøj Ishøj 32 67 47 48
5 Vanløse Vanløse 32 48 45 47
6 Næsby BK Næsby BK 32 49 37 43
TEMPORADA 2021/2022
TERCERA DINAMARCA GRUPO 2
Equipo PJ GF GC Puntos
1 Roskilde Roskilde 32 93 38 69
2 Frem 1886 Frem 1886 32 72 38 60
3 VSK Aarhus VSK Aarhus 32 56 45 53
4 Næsby BK Næsby BK 32 53 46 47
5 Dalum Dalum 32 42 47 42
6 IF Lyseng IF Lyseng 32 40 68 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 4
Equipo PJ GF GC Puntos
1 B93 B93 6 18 5 35
2 Hillerød Hillerød 6 13 2 35
3 VSK Aarhus VSK Aarhus 6 4 10 29
4 Holbæk Holbæk 6 11 9 27
5 FA 2000 FA 2000 6 6 8 27
6 Dalum Dalum 6 3 7 26
7 Sydvest Sydvest 6 8 8 25
8 Skovshoved Skovshoved 6 7 4 23
9 Næsby BK Næsby BK 6 5 11 22
10 Slagelse B&I Slagelse 6 10 8 21
11 Vejgaard B Vejgaard B 6 9 12 18
12 Ringkøbing Ringkøbing 6 7 17 16
TEMPORADA 2018/2019
SERIES DINAMARCA GRUPO 3
Equipo PJ GF GC Puntos
1 Næsby BK Næsby BK 27 82 22 63
2 SfB-Oure SfB-Oure 27 64 29 62
3 Varde IF Elite Varde Elite 27 53 41 47
4 Kolding BK B Kolding 27 43 52 41
5 Young Boys FD Young Boys 27 51 45 38
6 Hedensted Hedensted 27 49 50 38
7 Otterup Otterup 27 44 59 31
8 Boldklubben 1909 Boldklubben 27 39 65 29
9 B 1913 B 1913 27 35 55 26
10 Viborg II Viborg II 27 29 71 13
TEMPORADA 2017/2018
SEGUNDA DINAMARCA GRUPO 5
Equipo PJ GF GC Puntos
1 Hellerup IK Hellerup IK 16 38 20 51
2 Akademisk Boldklub Akademisk 16 27 17 38
3 Aarhus Fremad Aarhus 16 23 26 37
4 B93 B93 16 28 22 35
5 Hillerød Hillerød 16 41 26 34
6 Brønshøj Brønshøj 16 34 23 32
7 Dalum Dalum 16 18 26 30
8 Odder Odder 16 20 30 30
9 Greve IF Greve IF 16 28 32 28
10 Næsby BK Næsby BK 16 36 29 27
11 VSK Aarhus VSK Aarhus 16 27 35 22
12 IF Lyseng IF Lyseng 16 8 42 5
TEMPORADA 2016/2017
SEGUNDA DINAMARCA GRUPO 5
Equipo PJ GF GC Puntos
1 Middelfart Middelfart 16 30 12 51
2 Frem 1886 Frem 1886 16 17 20 36
3 Næsby BK Næsby BK 16 21 22 35
4 Sydvest Sydvest 16 24 17 34
5 VSK Aarhus VSK Aarhus 16 24 20 33
6 Odder Odder 16 27 22 30
7 Jammerbugt Jammerbugt 16 24 21 29
8 Hellerup IK Hellerup IK 16 22 22 29
9 Holbæk Holbæk 16 25 21 25
10 Svendborg Svendborg 16 17 26 23
11 Vejgaard Vejgaard 16 15 27 17
12 Fredensborg BI Fredensborg 16 10 26 16
TEMPORADA 2015/2016
SEGUNDA DINAMARCA GRUPO 5
Equipo PJ GF GC Puntos
1 B93 B93 16 39 21 39
2 Avarta Avarta 16 18 16 39
3 Odder Odder 16 30 15 38
4 Dalum Dalum 16 25 11 37
5 Næsby BK Næsby BK 16 31 15 36
6 VSK Aarhus VSK Aarhus 16 30 27 29
7 Kolding IF Kolding IF 16 23 28 28
8 Holbæk Holbæk 16 20 26 28
9 Svendborg Svendborg 16 19 23 27
10 Jammerbugt Jammerbugt 16 24 30 27
11 AB Tårnby AB Tårnby 16 21 41 22
12 B 1908 B 1908 16 16 43 16
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

  USO DE MEMORIA  
6,183,568 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6347
Total Execution Time  0.6359
  CADENA URL  
/historico/N-Aelig-Sby
  GET DATOS  
$_GET['/historico/N-Aelig-Sby']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (39)  
0.0273  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 = 75803
0.0135  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 = 72492
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=7431 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2481 AND type_rel = 3
0.0130  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 = '7431' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126  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 = 75803 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0134  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=7431 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (75803,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.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 75803 AND teamId = 7431
0.0135  SELECT count(id) as num_players from rel_players WHERE league_id = 72646 AND teamId = 7431
0.0131  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 7431
0.0134  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 75803 AND t.round = 3 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0130  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 = '7431' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0127  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '7431' and rp.type = 4
0.0132  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 = '7431' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0148  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 = 75803 WHERE rp.league_id = 75803 AND rp.teamId = 7431 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.0136  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 = 75803 WHERE rp.league_id = 75803 AND rp.teamId = 7431 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0137  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 = 75803 WHERE rp.league_id = 75803 AND rp.teamId = 7431 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0167  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 = 7431 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0141  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 = 72492 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 = 75803 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.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 `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 = 68165 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.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 `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 = 71481 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.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 = 63192 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 `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 = 67333 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.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 `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.0131  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 = 56777 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.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 `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 = 44328 AND t.round = 27 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 `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 = 38875 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 = 43169 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 = 33544 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 = 38477 AND t.round = 16 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 `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 = 16251 AND t.round = 14 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 = 20329 AND t.round = 16 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0140  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.0144  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.0144  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.0144  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