4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del SDO Bussum
TEMPORADA 2022/2023
EERSTE KLASSE ZONDAG GRUPO 4
Equipo PJ GF GC Puntos
1 MASV MASV 24 72 34 52
2 De Bataven De Bataven 24 44 25 49
3 Voorwaarts Twello Voorwaarts 24 65 41 46
4 RKHVV RKHVV 24 50 42 46
5 Bemmel Bemmel 24 63 34 44
6 TOP Oss Amateurs Amateurs 24 53 46 37
7 Winterswijk Winterswijk 24 45 36 36
8 WSV WSV 24 38 43 33
9 Woezik Woezik 24 38 48 33
10 Leones Leones 24 42 60 24
11 SDO Bussum SDO Bussum 24 35 51 18
12 Columbia Columbia 24 30 67 13
13 Berghem Sport Berghem 24 23 71 13
TEMPORADA 2021/2022
HOOFDKLASSE ZONDAG GRUPO 1
Equipo PJ GF GC Puntos
1 TOGB TOGB 28 63 36 62
2 HBS HBS 28 65 25 58
3 Hoogeveen Hoogeveen 28 77 40 56
4 SJC Noordwijk Noordwijk 28 74 47 55
5 Be Quick 1887 Quick 1887 28 66 29 52
6 RKAVV RKAVV 28 49 41 44
7 Purmersteijn Purmersteijn 28 56 51 38
8 Alphense Boys Alphense 28 57 65 38
9 RKVV Velsen RKVV Velsen 28 38 46 34
10 VOC VOC 28 45 53 33
11 Alcides Alcides 28 48 68 29
12 De Zouaven De Zouaven 28 46 63 27
13 TAC'90 TAC'90 28 41 68 26
14 SDO Bussum SDO Bussum 28 29 80 18
15 VV Emmen VV Emmen 28 26 68 17
TEMPORADA 2020/2021
HOOFDKLASSE ZONDAG GRUPO 1
Equipo PJ GF GC Puntos
1 RKVV Velsen RKVV Velsen 6 11 3 11
2 Hoogeveen Hoogeveen 6 12 7 10
3 SJC Noordwijk Noordwijk 6 11 7 10
4 RKZVC RKZVC 6 11 12 10
5 De Zouaven De Zouaven 6 10 11 10
6 Alphense Boys Alphense 5 10 7 8
7 HBS HBS 6 10 7 8
8 LONGA '30 LONGA '30 5 7 11 8
9 Silvolde Silvolde 5 11 9 7
10 Be Quick 1887 Quick 1887 5 8 7 7
11 Alcides Alcides 5 6 9 6
12 TAC'90 TAC'90 5 9 12 5
13 SDO Bussum SDO Bussum 6 9 13 5
14 Purmersteijn Purmersteijn 4 4 7 4
15 RKAVV RKAVV 3 4 6 3
16 VV Emmen VV Emmen 5 8 13 3
TEMPORADA 2019/2020
HOOFDKLASSE ZONDAG GRUPO 1
Equipo PJ GF GC Puntos
1 Hollandia Hollandia 20 42 20 43
2 JOS Watergraafsmeer Watergraafsm 19 47 24 40
3 RKAVV RKAVV 21 53 33 36
4 SJC Noordwijk Noordwijk 20 45 31 35
5 Alphense Boys Alphense 20 43 28 34
6 Hoogeveen Hoogeveen 19 36 31 33
7 Leonidas Leonidas 19 38 33 30
8 HBS HBS 20 30 26 29
9 Quick '20 Quick '20 20 52 46 28
10 SDO Bussum SDO Bussum 20 45 44 26
11 RKVV Velsen RKVV Velsen 19 28 30 26
12 Be Quick 1887 Quick 1887 21 32 25 25
13 VV Emmen VV Emmen 20 41 55 19
14 Alcides Alcides 20 24 48 14
15 MSC MSC 19 18 67 14
16 VOC VOC 21 25 58 11
TEMPORADA 2018/2019
HOOFDKLASSE ZONDAG GRUPO 1
Equipo PJ GF GC Puntos
1 RKVV DEM RKVV DEM 30 60 31 60
2 Hoogeveen Hoogeveen 30 71 45 57
3 SDO Bussum SDO Bussum 30 69 48 57
4 RKZVC RKZVC 30 59 53 53
5 Hoogland Hoogland 30 53 43 49
6 Alcides Alcides 30 51 51 44
7 Silvolde Silvolde 30 54 46 42
8 Hollandia Hollandia 30 43 49 42
9 Purmersteijn Purmersteijn 30 48 37 41
10 MSC MSC 30 53 58 39
11 AWC AWC 30 52 69 39
12 Be Quick 1887 Quick 1887 30 52 51 37
13 De Bataven De Bataven 30 51 60 37
14 Fortuna Wormerveer Fortuna 30 39 52 31
15 Achilles 1894 Achilles 30 47 59 30
16 RKHVV RKHVV 30 30 80 14
TEMPORADA 2017/2018
HOOFDKLASSE ZONDAG GRUPO 1
Equipo PJ GF GC Puntos
1 SJC Noordwijk Noordwijk 30 75 37 62
2 Achilles 1894 Achilles 30 73 34 56
3 Silvolde Silvolde 30 69 35 55
4 Leonidas Leonidas 30 65 53 51
5 Purmersteijn Purmersteijn 30 57 47 48
6 Hollandia Hollandia 30 65 48 47
7 Alphense Boys Alphense 30 54 49 47
8 SDO Bussum SDO Bussum 30 60 50 44
9 RKAVV RKAVV 30 55 51 41
10 MSC MSC 30 60 77 41
11 De Bataven De Bataven 30 42 48 35
12 RKHVV RKHVV 30 50 63 35
13 SWZ SWZ 30 37 49 33
14 DHC Delft DHC Delft 30 47 73 30
15 VV Heerenveen Heerenveen 30 34 72 24
16 Achilles 29 II Achilles 30 45 102 17
TEMPORADA 2016/2017
HOOFDKLASSE ZONDAG GRUPO 1
Equipo PJ GF GC Puntos
1 ADO 20 ADO 20 30 82 41 64
2 Woezik Woezik 30 57 32 55
3 SJC Noordwijk Noordwijk 30 64 39 53
4 Hollandia Hollandia 30 51 33 53
5 Silvolde Silvolde 30 54 51 49
6 De Meern De Meern 30 70 55 45
7 SWZ SWZ 30 65 52 41
8 SDO Bussum SDO Bussum 30 42 45 40
9 VV Heerenveen Heerenveen 30 49 52 38
10 De Bataven De Bataven 30 45 60 38
11 MSC MSC 30 53 55 37
12 RKHVV RKHVV 30 42 52 37
13 Alverna Alverna 30 50 45 36
14 JOS Watergraafsmeer Watergraafsm 30 51 55 36
15 Hoogland Hoogland 30 42 56 33
16 Dieze West Dieze West 30 28 122 6
TEMPORADA 2015/2016
HOOFDKLASSE ZONDAG GRUPO 1
Equipo PJ GF GC Puntos
1 Westlandia Westlandia 26 75 39 65
2 De Dijk De Dijk 26 68 37 55
3 DHC Delft DHC Delft 26 52 26 55
4 OFC Oostzaan Oostzaan 26 55 35 52
5 HV & CV Quick Quick 26 51 38 48
6 ADO 20 ADO 20 26 54 34 42
7 De Meern De Meern 26 45 48 30
8 RKAVV RKAVV 26 36 41 30
9 JOS Watergraafsmeer Watergraafsm 26 34 39 30
10 SDO Bussum SDO Bussum 26 28 29 29
11 EDO HFC EDO HFC 26 35 52 24
12 Nieuwerkerk Nieuwerkerk 26 33 62 23
13 Leonidas Leonidas 26 31 79 12
14 Nieuw Utrecht Nieuw 26 21 59 11
TEMPORADA 2014/2015
EERSTE KLASSE ZONDAG GRUPO 1
Equipo PJ GF GC Puntos
1 De Meern De Meern 26 73 33 60
2 Alphense Boys Alphense 26 72 38 53
3 SDO Bussum SDO Bussum 26 62 36 50
4 Purmersteijn Purmersteijn 26 51 40 41
5 SJC Noordwijk Noordwijk 26 63 62 36
6 VVIJ VVIJ 26 56 52 35
7 SC Woerden SC Woerden 26 48 45 33
8 RKVV DEM RKVV DEM 26 51 57 32
9 SO Soest SO Soest 26 41 53 30
10 Foresters Foresters 26 43 58 29
11 Elinkwijk Elinkwijk 26 49 75 29
12 Nieuw Utrecht Nieuw 26 43 56 27
13 Stormvogels Stormvogels 26 50 74 27
14 De Kennemers Kennemers 26 44 67 18
TEMPORADA 2013/2014
EERSTE KLASSE ZONDAG GRUPO 1
Equipo PJ GF GC Puntos
1 JOS Watergraafsmeer Watergraafsm 26 75 28 63
2 AFC '34 AFC '34 26 66 38 51
3 OFC Oostzaan Oostzaan 26 74 33 50
4 De Meern De Meern 26 54 22 49
5 Elinkwijk Elinkwijk 26 68 61 41
6 SDO Bussum SDO Bussum 26 47 59 38
7 Stormvogels Stormvogels 26 69 72 34
8 De Kennemers Kennemers 26 41 49 33
9 Foresters Foresters 26 41 60 32
10 RKVV DEM RKVV DEM 26 48 65 30
11 NVC NVC 26 43 60 28
12 Pancratius Pancratius 26 36 58 27
13 Uitgeest Uitgeest 26 42 73 27
14 Zeeburgia Zeeburgia 26 39 65 18

  USO DE MEMORIA  
5,801,376 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.1231
Total Execution Time  0.1252
  CADENA URL  
/historico/Sdo-Bussum
  GET DATOS  
$_GET['/historico/Sdo-Bussum']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (43)  
0.0028  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 = 'Sdo-Bussum' 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.0037  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 = 'Sdo-Bussum' 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.0018  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=61236 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=61236 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=61236 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=61236 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=61236 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=61236 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=61236 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=61236 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=61236 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=61236 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=61236 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=61236 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=61236 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0023  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 = 70703
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=61236 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=229 AND type_rel = 3
0.0022  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 = '61236' AND l.year = 2023 ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '61236' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 70703 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  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=61236 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (70703,63264) 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.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 63264 AND teamId = 61236
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 70703 AND teamId = 61236
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 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 = 70703 AND t.round = 26 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 = '61236' 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 = '61236' and rp.type = 4
0.0021  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 = '61236' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0020  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 events2023 e ON e.player_id = p.id AND e.league_id = 70703 WHERE rp.league_id = 70703 AND rp.teamId = 61236 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.0019  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 events2023 e ON e.player_id = p.id AND e.league_id = 70703 WHERE rp.league_id = 70703 AND rp.teamId = 61236 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019  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 events2023 e ON e.player_id = p.id AND e.league_id = 70703 WHERE rp.league_id = 70703 AND rp.teamId = 61236 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022  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 = 61236 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 70703 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.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 `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 = 63264 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 58336 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.0024  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 = 50984 AND t.round = 21 ORDER BY team.conference ASC,t.position 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 `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 = 44702 AND t.round = 30 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 `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 = 39750 AND t.round = 30 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 `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 = 33960 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 15938 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 9399 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 = 9416 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC