4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2023/2024
SUPERLIGA DANESA GRUPO 2
Equipo PJ GF GC Puntos
1 Brøndby IF Brøndby IF 26 51 25 55
2 Midtjylland Midtjylland 26 49 30 52
3 Kobenhavn Kobenhavn 26 51 29 49
4 Nordsjaelland Nordsjaellan 26 48 26 49
5 AGF Aarhus AGF Aarhus 26 32 33 38
6 Silkeborg IF Silkeborg 26 31 38 29
TEMPORADA 2022/2023
SUPERLIGA DANESA GRUPO 2
Equipo PJ GF GC Puntos
1 Kobenhavn Kobenhavn 32 61 35 59
2 Nordsjaelland Nordsjaellan 32 50 35 55
3 AGF Aarhus AGF Aarhus 32 42 31 51
4 Viborg FF Viborg FF 32 44 35 51
5 Brøndby IF Brøndby IF 32 48 52 44
6 Randers Randers 32 40 47 41
TEMPORADA 2021/2022
SUPERLIGA DANESA GRUPO 2
Equipo PJ GF GC Puntos
1 Kobenhavn Kobenhavn 32 56 19 68
2 Midtjylland Midtjylland 32 59 33 65
3 Silkeborg IF Silkeborg 32 54 37 49
4 Brøndby IF Brøndby IF 32 40 41 48
5 Aalborg BK Aalborg BK 32 47 45 45
6 Randers Randers 32 36 42 43
TEMPORADA 2020/2021
SUPERLIGA DANESA GRUPO 2
Equipo PJ GF GC Puntos
1 Brøndby IF Brøndby IF 32 58 38 61
2 Midtjylland Midtjylland 32 57 33 60
3 Kobenhavn Kobenhavn 32 61 53 55
4 AGF Aarhus AGF Aarhus 32 48 42 48
5 Nordsjaelland Nordsjaellan 32 51 51 43
6 Randers Randers 32 43 38 40
TEMPORADA 2019/2020
SUPERLIGA DANESA GRUPO 1
Equipo PJ GF GC Puntos
1 Midtjylland Midtjylland 26 42 14 65
2 Kobenhavn Kobenhavn 26 47 29 56
3 AGF Aarhus AGF Aarhus 26 42 28 47
4 Brøndby IF Brøndby IF 26 47 37 42
5 Nordsjaelland Nordsjaellan 26 48 35 41
6 Aalborg BK Aalborg BK 26 44 33 38
7 Randers Randers 26 39 35 35
8 AC Horsens AC Horsens 26 25 44 34
9 Odense BK Odense BK 26 34 30 33
10 Lyngby BK Lyngby BK 26 31 45 32
11 SonderjyskE SonderjyskE 26 31 44 27
12 Hobro Hobro 26 25 35 23
13 Esbjerg Esbjerg 26 22 44 18
14 Silkeborg IF Silkeborg 26 31 55 16
TEMPORADA 2018/2019
SUPERLIGA DANESA GRUPO 2
Equipo PJ GF GC Puntos
1 Kobenhavn Kobenhavn 10 21 14 82
2 Midtjylland Midtjylland 10 14 17 71
3 Esbjerg Esbjerg 10 13 12 56
4 Brøndby IF Brøndby IF 10 16 12 52
5 Odense BK Odense BK 10 13 17 52
6 Nordsjaelland Nordsjaellan 10 10 15 44
TEMPORADA 2017/2018
SUPERLIGA DANESA GRUPO 3
Equipo PJ GF GC Puntos
1 Midtjylland Midtjylland 10 20 10 85
2 Brøndby IF Brøndby IF 10 24 13 81
3 Nordsjaelland Nordsjaellan 10 14 17 59
4 Kobenhavn Kobenhavn 10 15 14 58
5 Aalborg BK Aalborg BK 10 10 17 45
6 AC Horsens AC Horsens 10 11 23 40
TEMPORADA 2016/2017
SUPERLIGA DANESA GRUPO 2
Equipo PJ GF GC Puntos
1 Kobenhavn Kobenhavn 10 17 10 84
2 Brøndby IF Brøndby IF 10 10 17 62
3 Lyngby BK Lyngby BK 10 17 12 58
4 Midtjylland Midtjylland 10 23 24 54
5 Nordsjaelland Nordsjaellan 10 18 14 49
6 SonderjyskE SonderjyskE 10 14 22 46
TEMPORADA 2015/2016
SUPERLIGA DANESA
Equipo PJ GF GC Puntos
1 Kobenhavn Kobenhavn 33 62 28 71
2 SonderjyskE SonderjyskE 33 56 36 62
3 Midtjylland Midtjylland 33 57 33 59
4 Brøndby IF Brøndby IF 33 43 37 54
5 Aalborg BK Aalborg BK 33 56 44 50
6 Randers Randers 33 45 43 47
7 Odense BK Odense BK 33 50 52 46
8 Viborg FF Viborg FF 33 34 42 40
9 Nordsjaelland Nordsjaellan 33 35 51 38
10 AGF Aarhus AGF Aarhus 33 47 49 37
11 Esbjerg Esbjerg 33 38 64 30
12 Hobro Hobro 33 26 70 18
TEMPORADA 2014/2015
SUPERLIGA DANESA
Equipo PJ GF GC Puntos
1 Midtjylland Midtjylland 33 64 34 71
2 Kobenhavn Kobenhavn 33 40 22 67
3 Brøndby IF Brøndby IF 33 43 29 55
4 Randers Randers 33 39 28 52
5 Aalborg BK Aalborg BK 33 39 31 48
6 Nordsjaelland Nordsjaellan 33 39 44 44
7 Hobro Hobro 33 40 47 43
8 Esbjerg Esbjerg 33 47 45 40
9 Odense BK Odense BK 33 35 43 40
10 SonderjyskE SonderjyskE 33 35 44 37
11 Vestsjælland Vestsjællan 33 31 52 33
12 Silkeborg IF Silkeborg 33 26 59 14
TEMPORADA 2013/2014
SUPERLIGA DANESA
Equipo PJ GF GC Puntos
1 Aalborg BK Aalborg BK 33 60 38 62
2 Kobenhavn Kobenhavn 33 54 38 56
3 Midtjylland Midtjylland 33 61 38 55
4 Brøndby IF Brøndby IF 33 47 38 52
5 Esbjerg Esbjerg 33 47 38 48
6 Nordsjaelland Nordsjaellan 33 38 44 46
7 Randers Randers 33 41 45 41
8 Odense BK Odense BK 33 47 46 40
9 Vestsjælland Vestsjællan 33 31 42 38
10 SonderjyskE SonderjyskE 33 41 53 38
11 AGF Aarhus AGF Aarhus 33 38 60 32
12 Viborg FF Viborg FF 33 38 63 28
TEMPORADA 2012/2013
SUPERLIGA DANESA
Equipo PJ GF GC Puntos
1 Kobenhavn Kobenhavn 33 62 32 65
2 Nordsjaelland Nordsjaellan 33 60 37 60
3 Randers Randers 33 36 42 52
4 Esbjerg Esbjerg 33 38 32 47
5 Aalborg BK Aalborg BK 33 51 46 47
6 Midtjylland Midtjylland 33 51 47 47
7 AGF Aarhus AGF Aarhus 33 50 49 41
8 SonderjyskE SonderjyskE 33 53 57 41
9 Brøndby IF Brøndby IF 33 39 45 39
10 Odense BK Odense BK 33 52 59 38
11 AC Horsens AC Horsens 33 31 49 34
12 Silkeborg IF Silkeborg 33 38 66 31

  USO DE MEMORIA  
6,005,328 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.8176
Total Execution Time  0.8191
  CADENA URL  
/historico/Brondby-If
  GET DATOS  
$_GET['/historico/Brondby-If']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (46)  
0.0172  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 = 'Brondby-If' 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.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=553 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=553 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=553 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=553 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=553 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=553 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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 = 75670
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 = 75120
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=553 AND type_rel = 2
0.0146  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 553 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0147  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 (1370,3940,4530,14595,49449) ORDER BY n.cover_points DESC, update_date DESC
0.0156  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 = '553' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0165  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 = '553' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0145  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 = 72110 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0154  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=553 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0145  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 (75670,75120,72646,71432,67757) 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.0154  SELECT count(id) as num_players from rel_players WHERE league_id = 75670 AND teamId = 553
0.0153  SELECT count(id) as num_players from rel_players WHERE league_id = 67757 AND teamId = 553
0.0158  SELECT count(id) as num_players from rel_players WHERE league_id = 72646 AND teamId = 553
0.0332  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 553
0.0162  SELECT count(id) as num_players from rel_players WHERE league_id = 75120 AND teamId = 553
0.0148  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 = 75670 AND t.round = 4 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
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 events2024 e ON e.player_id = p.id AND e.league_id = 75670 WHERE rp.league_id = 75670 AND rp.teamId = 553 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.0154  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 = 75670 WHERE rp.league_id = 75670 AND rp.teamId = 553 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0146  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 = 75670 WHERE rp.league_id = 75670 AND rp.teamId = 553 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0155  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 = 553 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0147  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 = 72110 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.0146  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 = 75670 AND t.round = 4 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 67759 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.0146  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 = 71334 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.0148  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 = 62854 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.0148  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 = 66997 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.0147  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 = 57888 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.0146  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 = 61994 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.0147  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 = 56773 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.0149  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 = 43820 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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 = 49320 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 38692 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  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 = 43138 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  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 = 38109 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 15435 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 3817 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 2366 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 2019 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0144  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 = 75670 ORDER BY nameShow LIMIT 100