4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Brøndby IF

Brøndby IF

Entrenador: Jesper Sörensen

Temporada 2003/2004
TEMPORADA 2003/2004
SUPERLIGA DANESA
Equipo PJ GF GC Puntos
1 Kobenhavn Kobenhavn 33 56 27 68
2 Brøndby IF Brøndby IF 33 55 29 67
3 Esbjerg Esbjerg 33 71 44 62
4 Odense BK Odense BK 33 66 46 57
5 Aalborg BK Aalborg BK 33 55 41 57
6 Midtjylland Midtjylland 33 65 51 48
7 Viborg FF Viborg FF 33 47 44 42
8 AGF Aarhus AGF Aarhus 33 45 67 36
9 Nordsjaelland Nordsjaellan 33 35 59 32
10 Herfølge BK Herfølge 33 34 57 31
11 BK Frem 1886 Frem 1886 33 40 65 27
12 Akademisk Boldklub Akademisk 33 31 70 26
TEMPORADA 2002/2003
SUPERLIGA DANESA
Equipo PJ GF GC Puntos
1 Kobenhavn Kobenhavn 33 51 32 61
2 Brøndby IF Brøndby IF 33 61 35 56
3 Nordsjaelland Nordsjaellan 33 49 58 51
4 Odense BK Odense BK 33 55 50 48
5 Esbjerg Esbjerg 33 65 57 47
6 Aalborg BK Aalborg BK 33 42 45 46
7 Midtjylland Midtjylland 33 49 45 44
8 Viborg FF Viborg FF 33 58 55 43
9 Akademisk Boldklub Akademisk 33 44 48 42
10 AGF Aarhus AGF Aarhus 33 49 59 40
11 Silkeborg IF Silkeborg 33 52 54 36
12 Køge BK Køge BK 33 45 82 27
TEMPORADA 2001/2002
SUPERLIGA DANESA
Equipo PJ GF GC Puntos
1 Brøndby IF Brøndby IF 33 74 28 69
2 Kobenhavn Kobenhavn 33 62 25 69
3 Midtjylland Midtjylland 33 47 27 57
4 Aalborg BK Aalborg BK 33 52 45 54
5 Akademisk Boldklub Akademisk 33 48 38 50
6 Odense BK Odense BK 33 56 51 49
7 Esbjerg Esbjerg 33 42 44 45
8 Viborg FF Viborg FF 33 46 45 41
9 Silkeborg IF Silkeborg 33 41 50 32
10 AGF Aarhus AGF Aarhus 33 42 56 31
11 Vejle BK Vejle BK 33 38 72 28
12 Lyngby BK Lyngby BK 33 25 92 15
TEMPORADA 2000/2001
SUPERLIGA DANESA
Equipo PJ GF GC Puntos
1 Kobenhavn Kobenhavn 33 55 27 63
2 Brøndby IF Brøndby IF 33 71 42 58
3 Silkeborg IF Silkeborg 33 49 36 56
4 Midtjylland Midtjylland 33 54 43 53
5 Aalborg BK Aalborg BK 33 51 49 49
6 Viborg FF Viborg FF 33 52 42 46
7 Odense BK Odense BK 33 49 45 46
8 AGF Aarhus AGF Aarhus 33 54 58 44
9 Lyngby BK Lyngby BK 33 40 53 44
10 Akademisk Boldklub Akademisk 33 43 41 39
11 Herfølge BK Herfølge 33 41 65 30
12 HFK Sonderjyl Sonderjyl 33 30 88 11
TEMPORADA 1999/2000
SUPERLIGA DANESA
Equipo PJ GF GC Puntos
1 Herfølge BK Herfølge 33 52 49 56
2 Brøndby IF Brøndby IF 33 56 37 54
3 Akademisk Boldklub Akademisk 33 52 35 52
4 Viborg FF Viborg FF 33 56 50 52
5 Aalborg BK Aalborg BK 33 57 40 49
6 Silkeborg IF Silkeborg 33 49 33 49
7 Lyngby BK Lyngby BK 33 51 55 47
8 Kobenhavn Kobenhavn 33 44 37 44
9 Odense BK Odense BK 33 42 44 43
10 AGF Aarhus AGF Aarhus 33 36 55 36
11 Vejle BK Vejle BK 33 38 68 32
12 Esbjerg Esbjerg 33 40 70 28
TEMPORADA 1998/1999
SUPERLIGA DANESA
Equipo PJ GF GC Puntos
1 Aalborg BK Aalborg BK 33 65 37 64
2 Brøndby IF Brøndby IF 33 73 37 61
3 Akademisk Boldklub Akademisk 33 49 36 56
4 Lyngby BK Lyngby BK 33 55 60 52
5 Herfølge BK Herfølge 33 44 36 47
6 Vejle BK Vejle BK 33 54 48 47
7 Kobenhavn Kobenhavn 33 55 52 46
8 Viborg FF Viborg FF 33 61 59 44
9 Silkeborg IF Silkeborg 33 52 53 44
10 AGF Aarhus AGF Aarhus 33 45 55 43
11 Aarhus Fremad Aarhus 33 51 73 29
12 B93 B93 33 22 80 12
TEMPORADA 1997/1998
SUPERLIGA DANESA
Equipo PJ GF GC Puntos
1 Brøndby IF Brøndby IF 33 81 33 76
2 Silkeborg IF Silkeborg 33 55 31 63
3 Kobenhavn Kobenhavn 33 66 48 61
4 Vejle BK Vejle BK 33 53 51 52
5 Akademisk Boldklub Akademisk 33 61 52 47
6 Lyngby BK Lyngby BK 33 53 62 45
7 Aalborg BK Aalborg BK 33 54 48 44
8 AGF Aarhus AGF Aarhus 33 53 52 43
9 Herfølge BK Herfølge 33 44 69 34
10 Aarhus Fremad Aarhus 33 51 73 33
11 Ikast FS Ikast FS 33 51 86 29
12 Odense BK Odense BK 33 40 57 25
TEMPORADA 1996/1997
SUPERLIGA DANESA
Equipo PJ GF GC Puntos
1 Brøndby IF Brøndby IF 33 64 39 68
2 Vejle BK Vejle BK 33 57 38 54
3 AGF Aarhus AGF Aarhus 33 75 51 52
4 Herfølge BK Herfølge 33 46 42 52
5 Aalborg BK Aalborg BK 33 46 40 47
6 Silkeborg IF Silkeborg 33 51 55 45
7 Odense BK Odense BK 33 59 61 41
8 Kobenhavn Kobenhavn 33 35 43 41
9 Lyngby BK Lyngby BK 33 50 61 40
10 Akademisk Boldklub Akademisk 33 56 62 36
11 Viborg FF Viborg FF 33 31 58 29
12 Hvidovre IF Hvidovre IF 33 39 59 26
TEMPORADA 1995/1996
SUPERLIGA DANESA
Equipo PJ GF GC Puntos
1 Brøndby IF Brøndby IF 33 71 32 67
2 AGF Aarhus AGF Aarhus 33 61 28 66
3 Odense BK Odense BK 33 57 33 60
4 Lyngby BK Lyngby BK 33 61 35 53
5 Aalborg BK Aalborg BK 33 57 38 51
6 Silkeborg IF Silkeborg 33 44 42 49
7 Kobenhavn Kobenhavn 33 48 49 48
8 Viborg FF Viborg FF 33 48 67 38
9 Vejle BK Vejle BK 33 34 50 33
10 Herfølge BK Herfølge 33 41 62 27
11 Ikast FS Ikast FS 33 28 63 25
12 Næstved Næstved 33 29 80 23
TEMPORADA 1994/1995
SUPERLIGA DANESA GRUPO 2
Equipo PJ GF GC Puntos
1 Aalborg BK Aalborg BK 0 0 0 0
2 AGF Aarhus AGF Aarhus 0 0 0 0
3 Brøndby IF Brøndby IF 0 0 0 0
4 Kobenhavn Kobenhavn 0 0 0 0
5 Lyngby BK Lyngby BK 0 0 0 0
6 Næstved Næstved 0 0 0 0
7 Odense BK Odense BK 0 0 0 0
8 Silkeborg IF Silkeborg 0 0 0 0
TEMPORADA 1993/1994
SUPERLIGA DANESA GRUPO 2
Equipo PJ GF GC Puntos
1 Aalborg BK Aalborg BK 0 0 0 0
2 AGF Aarhus AGF Aarhus 0 0 0 0
3 Brøndby IF Brøndby IF 0 0 0 0
4 Ikast FS Ikast FS 0 0 0 0
5 Kobenhavn Kobenhavn 0 0 0 0
6 Lyngby BK Lyngby BK 0 0 0 0
7 Odense BK Odense BK 0 0 0 0
8 Silkeborg IF Silkeborg 0 0 0 0
TEMPORADA 1992/1993
SUPERLIGA DANESA GRUPO 2
Equipo PJ GF GC Puntos
1 Aalborg BK Aalborg BK 0 0 0 0
2 AGF Aarhus AGF Aarhus 0 0 0 0
3 Brøndby IF Brøndby IF 0 0 0 0
4 Kobenhavn Kobenhavn 0 0 0 0
5 Lyngby BK Lyngby BK 0 0 0 0
6 Næstved Næstved 0 0 0 0
7 Odense BK Odense BK 0 0 0 0
8 Silkeborg IF Silkeborg 0 0 0 0
TEMPORADA 1991/1992
SUPERLIGA DANESA GRUPO 1
Equipo PJ GF GC Puntos
1 Brøndby IF Brøndby IF 18 30 18 24
2 Lyngby BK Lyngby BK 18 32 18 23
3 B 1903 B 1903 18 32 26 21
4 Aalborg BK Aalborg BK 18 29 25 19
5 AGF Aarhus AGF Aarhus 18 19 19 19
6 Frem 1886 Frem 1886 18 25 27 17
7 Næstved Næstved 18 33 34 16
8 Silkeborg IF Silkeborg 18 24 30 16
9 Vejle BK Vejle BK 18 24 30 14
10 Odense BK Odense BK 18 28 49 11
TEMPORADA 1990/1991
SUPERLIGA DANESA
Equipo PJ GF GC Puntos
1 Brøndby IF Brøndby IF 18 26 15 26
2 Lyngby BK Lyngby BK 18 35 18 24
3 AGF Aarhus AGF Aarhus 18 29 26 20
4 Frem 1886 Frem 1886 18 25 24 19
5 Odense BK Odense BK 18 21 20 17
6 Aalborg BK Aalborg BK 18 29 33 17
7 B 1903 B 1903 18 19 18 16
8 Vejle BK Vejle BK 18 20 22 16
9 Silkeborg IF Silkeborg 18 23 33 15
10 Ikast FS Ikast FS 18 9 27 10

  USO DE MEMORIA  
6,645,008 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.1717
Total Execution Time  0.1732
  CADENA URL  
/historico/Brondby-If/2004
  GET DATOS  
$_GET['/historico/Brondby-If/2004']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (49)  
0.0054  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 = 2004 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.0019  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.0019  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.0019  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.0019  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.0019  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.0028  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 = 371
0.0030  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 = 23509
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=553 AND type_rel = 2
0.0026  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.0024  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.0063  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' ORDER BY l.year DESC,cat.coefficient DESC
0.0045  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 = 2004 ORDER BY l.year DESC,cat.coefficient DESC
0.0038  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.0021  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 = 23509 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  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 = 371 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0064  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 (2003,2004,2005) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (42358,40745,23513,10978,372) 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.0030  SELECT count(id) as num_players from rel_players WHERE league_id = 372 AND teamId = 553
0.0027  SELECT count(id) as num_players from rel_players WHERE league_id = 10978 AND teamId = 553
0.0037  SELECT count(id) as num_players from rel_players WHERE league_id = 40745 AND teamId = 553
0.0027  SELECT count(id) as num_players from rel_players WHERE league_id = 42358 AND teamId = 553
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 23513 AND teamId = 553
0.0019  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2004` 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 = 10978 AND t.round = 7 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 = '553' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '553' and rp.type = 4
0.0020  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 = '553' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0029  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 events2004 e ON e.player_id = p.id AND e.league_id = 10978 WHERE rp.league_id = 10978 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.0027  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 events2004 e ON e.player_id = p.id AND e.league_id = 10978 WHERE rp.league_id = 10978 AND rp.teamId = 553 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029  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 events2004 e ON e.player_id = p.id AND e.league_id = 10978 WHERE rp.league_id = 10978 AND rp.teamId = 553 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0034  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 <= 2004 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0021  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 `tables2004` 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 = 371 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,team.teamId FROM `tables2003` 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 = 372 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 `tables2002` 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 = 373 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,team.teamId FROM `tables2001` 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 = 374 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,team.teamId FROM `tables2000` 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 = 375 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 `tables1999` 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 = 376 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 `tables1998` 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 = 377 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,team.teamId FROM `tables1997` 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 = 378 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 `tables1996` 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 = 10285 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 `tables1995` 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 = 10289 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 `tables1995` 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 = 10293 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 `tables1994` 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 = 10288 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,team.teamId FROM `tables1994` 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 = 10292 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 `tables1993` 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 = 10287 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 `tables1993` 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 = 10291 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,team.teamId FROM `tables1992` 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 = 10290 AND t.round = 32 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,team.teamId FROM `tables1992` 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 = 10286 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,team.teamId FROM `tables1991` 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 = 10294 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC