4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Westhoek
TEMPORADA 2019/2020
DIVISIÓN BELGA 2 GRUPO 2
Equipo PJ GF GC Puntos
1 Knokke Knokke 24 57 15 63
2 Mandel United Mandel 24 51 31 45
3 Ronse Ronse 24 42 26 45
4 Oudenaarde Oudenaarde 24 54 46 42
5 KRC Gent KRC Gent 24 36 29 41
6 Sparta Petegem Sparta 24 51 39 39
7 Gullegem Gullegem 24 36 32 39
8 Voorwaarts Zwevezele Voorwaarts 24 41 28 38
9 Racing Club Harelbeke Racing Club 24 30 35 35
10 Dikkelvenne Dikkelvenne 24 35 37 31
11 Westhoek Westhoek 24 29 48 28
12 Temse Temse 24 22 38 24
13 KSCT Menen KSCT Menen 24 28 47 20
14 Merelbeke Merelbeke 24 25 41 19
15 Sint-Niklaas Sint-Niklaas 24 22 49 16
16 VW Hamme VW Hamme 24 34 52 15
TEMPORADA 2018/2019
DIVISIÓN BELGA 2 GRUPO 3
Equipo PJ GF GC Puntos
1 KVC Winkel Sport Winkel Sport 30 60 24 69
2 Mandel United Mandel 30 58 30 60
3 Sparta Petegem Sparta 30 55 44 49
4 KRC Gent KRC Gent 30 56 39 48
5 Olympia Wijgmaal Olympia 30 52 46 47
6 Ronse Ronse 30 41 35 43
7 KSCT Menen KSCT Menen 30 51 56 42
8 Londerzeel Londerzeel 30 37 35 40
9 Diegem Sport Diegem Sport 30 37 51 39
10 Westhoek Westhoek 30 48 56 37
11 Dikkelvenne Dikkelvenne 30 28 42 36
12 Racing Club Harelbeke Racing Club 30 37 38 35
13 Gullegem Gullegem 30 40 52 35
14 Eppegem Eppegem 30 36 66 34
15 Tempo Overijse Tempo 30 36 50 29
16 Olsa Brakel Olsa Brakel 30 39 47 28
TEMPORADA 2017/2018
DIVISIÓN BELGA 2 GRUPO 2
Equipo PJ GF GC Puntos
1 Rupel Boom Rupel Boom 30 74 49 61
2 Izegem Izegem 30 59 33 57
3 KVC Winkel Sport Winkel Sport 30 60 41 55
4 Sparta Petegem Sparta 30 64 40 53
5 Westhoek Westhoek 30 61 56 51
6 Sint-Niklaas Sint-Niklaas 30 55 43 50
7 Temse Temse 30 51 42 48
8 Racing Club Harelbeke Racing Club 30 45 42 43
9 Olsa Brakel Olsa Brakel 30 41 49 41
10 Gullegem Gullegem 30 51 52 40
11 KRC Gent KRC Gent 30 47 59 37
12 Londerzeel Londerzeel 30 55 51 36
13 Ronse Ronse 30 33 44 33
14 Pepingen-Halle Pepingen-Hal 30 30 56 28
15 Torhout Torhout 30 36 67 26
16 Bornem Bornem 30 28 66 17
TEMPORADA 2016/2017
DIVISIÓN BELGA 2 GRUPO 2
Equipo PJ GF GC Puntos
1 Knokke Knokke 30 73 25 72
2 Sparta Petegem Sparta 30 60 44 58
3 Eendracht Aalst Eendracht 30 55 37 56
4 KVC Winkel Sport Winkel Sport 30 55 30 53
5 Izegem Izegem 30 53 42 53
6 Olsa Brakel Olsa Brakel 30 59 51 43
7 Temse Temse 30 38 45 42
8 KRC Gent KRC Gent 30 46 43 41
9 Torhout Torhout 30 36 45 39
10 Gullegem Gullegem 30 46 52 37
11 Sint-Niklaas Sint-Niklaas 30 45 49 35
12 Bornem Bornem 30 31 39 34
13 Racing Club Harelbeke Racing Club 30 36 45 34
14 Westhoek Westhoek 30 40 56 34
15 Halle Halle 30 27 55 23
16 KSCT Menen KSCT Menen 30 35 77 16
TEMPORADA 2015/2016
PROMOCIÓN BÉLGICA GRUPO 1
Equipo PJ GF GC Puntos
1 Knokke Knokke 30 69 33 60
2 Racing Club Harelbeke Racing Club 30 47 28 58
3 Westhoek Westhoek 30 57 32 57
4 Dikkelvenne Dikkelvenne 30 65 32 54
5 Berlare Berlare 30 51 39 51
6 Eendracht Zele Eendracht 30 63 44 50
7 OMS Ingelmunster Ingelmunster 30 55 42 49
8 KSCT Menen KSCT Menen 30 47 40 49
9 Pepingen-Halle Pepingen-Hal 30 49 39 45
10 Wetteren-Kwatrecht Wetteren-Kwa 30 48 48 39
11 Ronse Ronse 30 46 46 39
12 Ninove Ninove 30 54 49 37
13 Sint-Gillis Waas Sint-Gillis 30 36 63 25
14 Damme Damme 30 19 56 21
15 Eernegem Eernegem 30 27 65 21
16 White Star Adinkerke White Star. 30 30 107 14
TEMPORADA 2014/2015
PROMOCIÓN BÉLGICA GRUPO 1
Equipo PJ GF GC Puntos
1 Sparta Petegem Sparta 30 67 30 66
2 Sint-Niklaas Sint-Niklaas 30 64 33 63
3 Racing Club Harelbeke Racing Club 30 67 34 58
4 OMS Ingelmunster Ingelmunster 30 73 38 56
5 Westhoek Westhoek 30 74 53 53
6 Ronse Ronse 30 55 47 48
7 Knokke Knokke 30 53 46 46
8 KSCT Menen KSCT Menen 30 44 42 41
9 Standaard Wetteren Standaard 30 45 42 40
10 Sint-Gillis Waas Sint-Gillis 30 41 60 36
11 Berlare Berlare 30 52 59 34
12 Eernegem Eernegem 30 33 51 33
13 Wetteren-Kwatrecht Wetteren-Kwa 30 41 63 33
14 Jong Lede Jong Lede 30 29 43 31
15 Racing Waregem Racing 30 37 81 18
16 Sassport Boezinge Sassport 30 32 85 10
TEMPORADA 2013/2014
PROMOCIÓN BÉLGICA GRUPO 1
Equipo PJ GF GC Puntos
1 Gullegem Gullegem 30 66 22 72
2 KVC Winkel Sport Winkel Sport 30 75 28 60
3 OMS Ingelmunster Ingelmunster 30 71 33 60
4 Westhoek Westhoek 30 65 34 60
5 Menen Menen 30 56 36 52
6 Olympic Charleroi Olympic 30 45 30 50
7 Racing Club Harelbeke Racing Club 30 53 30 49
8 Ronse Ronse 30 52 43 42
9 Eernegem Eernegem 30 48 48 42
10 Binche Binche 30 43 47 38
11 Sassport Boezinge Sassport 30 50 52 38
12 Acren Lessines Acren 30 39 54 34
13 Racing Waregem Racing 30 40 59 29
14 RAEC Mons RAEC Mons 30 33 56 27
15 Templeuve Templeuve 30 33 66 19
16 Charleroi Fleurus Charleroi 30 11 142 5
TEMPORADA 2012/2013
PROMOCIÓN BÉLGICA GRUPO 1
Equipo PJ GF GC Puntos
1 KRC Gent KRC Gent 30 48 30 55
2 Westhoek Westhoek 30 66 41 53
3 KVC Winkel Sport Winkel Sport 30 49 36 51
4 TK Meldert TK Meldert 30 45 37 47
5 KSCT Menen KSCT Menen 30 56 42 46
6 Ingelmunster Ingelmunster 30 46 34 46
7 Terjoden-Welle Terjoden-Wel 30 54 45 45
8 BS Poperinge Poperinge 30 51 52 43
9 Eernegem Eernegem 30 31 39 42
10 Eendracht Zele Eendracht 30 47 36 41
11 Berlare Berlare 30 44 51 41
12 Sparta Petegem Sparta 30 45 48 40
13 Racing Club Harelbeke Racing Club 30 49 61 40
14 Jong Lede Jong Lede 30 35 47 29
15 Maldegem Maldegem 30 47 62 27
16 Appelterre-Eichem Appelterre-E 30 26 78 18
TEMPORADA 2011/2012
PROMOCIÓN BÉLGICA GRUPO 1
Equipo PJ GF GC Puntos
1 Izegem Izegem 30 59 32 60
2 Westhoek Westhoek 30 56 43 54
3 TK Meldert TK Meldert 30 62 36 53
4 Berlare Berlare 30 56 46 51
5 Terjoden-Welle Terjoden-Wel 30 64 38 50
6 Racing Club Harelbeke Racing Club 30 53 39 50
7 KRC Gent KRC Gent 30 50 40 49
8 KVC Winkel Sport Winkel Sport 30 46 46 49
9 Sparta Petegem Sparta 30 37 30 42
10 Eernegem Eernegem 30 47 49 37
11 BS Poperinge Poperinge 30 48 53 37
12 Maldegem Maldegem 30 49 66 37
13 Jong Lede Jong Lede 30 46 68 34
14 Diksmuide Diksmuide 30 44 72 23
15 Wingene Wingene 30 38 66 21
16 Wielsbeke Wielsbeke 30 28 59 18
TEMPORADA 2010/2011
PROMOCIÓN BÉLGICA GRUPO 1
Equipo PJ GF GC Puntos
1 Mouscron Mouscron 30 67 17 69
2 Géants Athois Géants 30 72 27 69
3 Sparta Petegem Sparta 30 71 42 61
4 Westhoek Westhoek 30 63 34 60
5 KRC Gent KRC Gent 30 57 40 46
6 Eernegem Eernegem 30 53 44 45
7 BS Poperinge Poperinge 30 43 42 41
8 Diksmuide Diksmuide 30 48 41 39
9 Terjoden-Welle Terjoden-Wel 30 33 52 38
10 Charleroi Fleurus Charleroi 30 42 47 37
11 SG-Tertre-Hautrage SG-Tertre-Ha 30 37 42 36
12 KVC Winkel Sport Winkel Sport 30 38 52 34
13 Jeunesse Tamines Jeunesse 30 35 50 34
14 Appelterre-Eichem Appelterre-E 30 34 64 24
15 PAC Buzet PAC Buzet 30 19 87 15
16 Sottegem Sottegem 30 30 61 14
TEMPORADA 2009/2010
DIVISIÓN BELGA 2 GRUPO 1
Equipo PJ GF GC Puntos
1 Heist Heist 36 73 34 76
2 Rupel Boom Rupel Boom 36 82 46 72
3 Eendracht Aalst Eendracht 36 82 44 67
4 Deinze Deinze 36 50 38 60
5 Temse Temse 36 61 61 56
6 Coxyde Coxyde 36 67 43 55
7 VW Hamme VW Hamme 36 59 51 55
8 Hoogstraten Hoogstraten 36 59 55 50
9 Sint-Niklaas Sint-Niklaas 36 62 55 49
10 Oudenaarde Oudenaarde 36 62 62 48
11 Racing Waregem Racing 36 43 51 48
12 Torhout Torhout 36 49 51 45
13 Wielsbeke Wielsbeke 36 50 62 45
14 Ternat Ternat 36 53 72 41
15 Cappellen Cappellen 36 40 62 39
16 Sottegem Sottegem 36 32 65 38
17 Westhoek Westhoek 36 53 70 37
18 Racing Mechelen Racing 36 52 71 37
19 Willebroek-Meerhof Willebroek-M 36 40 76 30
TEMPORADA 2008/2009
PROMOCIÓN BÉLGICA GRUPO 1
Equipo PJ GF GC Puntos
1 Coxyde Coxyde 30 46 17 61
2 KVC Winkel Sport Winkel Sport 30 56 15 58
3 Jeunesse Tamines Jeunesse 30 47 28 54
4 Diksmuide Diksmuide 30 58 39 50
5 Westhoek Westhoek 30 59 41 50
6 Sparta Petegem Sparta 30 51 47 50
7 Izegem Izegem 30 53 39 48
8 Charleroi Fleurus Charleroi 30 61 41 44
9 Torhout Torhout 30 48 46 44
10 Paturageois Paturageois 30 42 41 41
11 Olsa Brakel Olsa Brakel 30 46 59 38
12 Charleroi-Couillet-Fleurus Charleroi-Co 30 33 49 35
13 Belœil Belœil 30 41 57 34
14 Couvin-Mariembourg Couvin-Marie 30 34 44 31
15 RC Lauwe RC Lauwe 30 22 83 15
16 VG Oostende VG Oostende 30 28 79 13
TEMPORADA 2007/2008
PROMOCIÓN BÉLGICA GRUPO 1
Equipo PJ GF GC Puntos
1 KVC Winkel Sport Winkel Sport 30 54 28 55
2 Wielsbeke Wielsbeke 30 46 36 55
3 VG Oostende VG Oostende 30 69 34 53
4 Opwijk Opwijk 30 53 35 50
5 Diksmuide Diksmuide 30 74 49 48
6 Ternat Ternat 30 52 39 47
7 Eendracht Buggenhout Eendracht 30 46 47 45
8 Izegem Izegem 30 47 41 44
9 Olsa Brakel Olsa Brakel 30 60 60 43
10 Westhoek Westhoek 30 43 42 39
11 TK Meldert TK Meldert 30 37 43 38
12 Wevelgem City Wevelgem 30 40 62 38
13 RC Lauwe RC Lauwe 30 51 63 35
14 Appelterre-Eichem Appelterre-E 30 39 66 30
15 Racing Club Harelbeke Racing Club 30 40 73 23
16 Maldegem Maldegem 30 28 61 23

  USO DE MEMORIA  
6,566,224 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6542
Total Execution Time  0.6554
  CADENA URL  
/historico/Westhoek/2020
  GET DATOS  
$_GET['/historico/Westhoek/2020']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (42)  
0.0135  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 = 'Westhoek' AND l.year = 2020 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=16831 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=16831 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=16831 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0252  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 = 50975
0.0132  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 = 50389
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=16831 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=241 AND type_rel = 3
0.0126  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 241 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0129  SELECT /*53 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 (900137,520396,273795,255821,104680) ORDER BY n.cover_points DESC, update_date DESC
0.0129  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 = '16831' ORDER BY l.year DESC,cat.coefficient DESC
0.0128  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 = '16831' AND l.year = 2020 ORDER BY l.year DESC,cat.coefficient DESC
0.0128  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 = '16831' 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 = 50975 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0136  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 = 50389 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0128  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=16831 AND l.year in (2019,2020,2021) 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 (57812,57008,56547) 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.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 57812 AND teamId = 16831
0.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 57008 AND teamId = 16831
0.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 56547 AND teamId = 16831
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 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 = 50975 AND t.round = 24 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0126  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 = '16831' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '16831' and rp.type = 4
0.0127  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 = '16831' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 events2020 e ON e.player_id = p.id AND e.league_id = 50975 WHERE rp.league_id = 50975 AND rp.teamId = 16831 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.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 events2020 e ON e.player_id = p.id AND e.league_id = 50975 WHERE rp.league_id = 50975 AND rp.teamId = 16831 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0126  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 events2020 e ON e.player_id = p.id AND e.league_id = 50975 WHERE rp.league_id = 50975 AND rp.teamId = 16831 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0130  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 = 16831 AND l.year <= 2020 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 50975 AND t.round = 24 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 = 45034 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 `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 = 39090 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 `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 = 33882 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 `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 = 15779 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 `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 = 13373 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 `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 = 3515 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 `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 = 27949 AND t.round = 30 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 `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 = 27959 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 `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 = 27969 AND t.round = 30 ORDER BY team.conference 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 `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 = 24297 AND t.round = 38 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 `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 = 27980 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 `tables2008` 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 = 27984 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  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 = 50975 ORDER BY nameShow LIMIT 100