4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Knokke
TEMPORADA 2023/2024
DIVISIÓN NACIONAL BELGA 1
Equipo PJ GF GC Puntos
1 RAAL La Louviere RAAL 32 75 16 80
2 Lokeren-Temse Lokeren-Tems 32 52 28 67
3 Charleroi II Charleroi 33 54 42 52
4 Knokke Knokke 32 51 39 50
5 Hoogstraten Hoogstraten 32 42 46 49
6 Thes Sport Thes Sport 33 53 59 48
7 KVC Winkel Sport Winkel Sport 32 41 42 46
8 Heist Heist 32 51 50 45
9 Gent II Gent II 32 56 39 45
10 Excelsior Virton Excelsior 32 43 50 44
11 Olympic Charleroi Olympic 32 51 49 44
12 Dessel Sport Dessel Sport 32 52 54 41
13 Tienen Tienen 32 42 39 41
14 Union Namur Union Namur 32 39 57 39
15 Antwerp II Antwerp II 32 36 51 37
16 Visé Visé 32 38 54 29
17 Leuven II Leuven II 32 38 62 26
18 Cappellen Cappellen 32 31 68 25
TEMPORADA 2022/2023
DIVISIÓN NACIONAL BELGA 1
Equipo PJ GF GC Puntos
1 Patro Eisden Patro Eisden 38 84 23 86
2 RFC Liège RFC Liège 38 99 29 86
3 Francs Borains Francs 38 79 46 77
4 RAAL La Louviere RAAL 38 72 39 73
5 Gent II Gent II 38 59 43 67
6 Heist Heist 38 69 59 61
7 Olympic Charleroi Olympic 38 71 52 60
8 Knokke Knokke 38 65 58 60
9 Visé Visé 38 66 52 56
10 Thes Sport Thes Sport 38 58 52 53
11 Leuven II Leuven II 38 61 68 50
12 Tienen Tienen 38 50 60 46
13 Charleroi II Charleroi 38 41 58 44
14 Dessel Sport Dessel Sport 38 45 65 43
15 KVC Winkel Sport Winkel Sport 38 44 58 42
16 Hoogstraten Hoogstraten 38 46 60 41
17 Antwerp II Antwerp II 38 33 58 39
18 Ninove Ninove 38 39 75 35
19 Rupel Boom Rupel Boom 38 29 83 24
20 Mandel United Mandel 38 16 88 14
TEMPORADA 2021/2022
DIVISIÓN NACIONAL BELGA 1 GRUPO 2
Equipo PJ GF GC Puntos
1 FCV Dender FCV Dender 6 12 3 40
2 RFC Liège RFC Liège 6 12 7 36
3 Knokke Knokke 6 10 15 29
4 Dessel Sport Dessel Sport 6 9 18 26
TEMPORADA 2020/2021
DIVISIÓN NACIONAL BELGA 1
Equipo PJ GF GC Puntos
1 Thes Sport Thes Sport 3 7 3 9
2 Tienen Tienen 4 5 5 6
3 Heist Heist 2 3 2 4
4 Mandel United Mandel 3 6 4 3
5 KVC Winkel Sport Winkel Sport 2 4 2 3
6 Francs Borains Francs 1 2 1 3
7 Knokke Knokke 2 2 1 3
8 Visé Visé 2 3 3 3
9 Olympic Charleroi Olympic 2 1 1 3
10 Patro Eisden Patro Eisden 1 2 2 1
11 RFC Liège RFC Liège 1 0 0 1
12 Rupel Boom Rupel Boom 2 0 2 1
13 FCV Dender FCV Dender 0 0 0 0
14 Dessel Sport Dessel Sport 0 0 0 0
15 La Louvière Centre Louvière 2 1 5 0
16 KSV Roeselare Roeselare 1 0 5 0
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 NACIONAL BELGA 1
Equipo PJ GF GC Puntos
1 Thes Sport Thes Sport 30 62 28 62
2 Deinze Deinze 30 53 30 59
3 Excelsior Virton Excelsior 30 42 20 54
4 Lierse Kempenzonen Lierse 30 42 36 48
5 Rupel Boom Rupel Boom 30 44 40 45
6 RFC Seraing RFC Seraing 30 46 40 41
7 RFC Liège RFC Liège 30 41 35 41
8 RWD Molenbeek Molenbeek 30 39 45 40
9 FCV Dender FCV Dender 30 42 40 40
10 Heist Heist 30 29 44 38
11 Châtelet Châtelet 30 30 37 36
12 Dessel Sport Dessel Sport 30 30 39 35
13 Oudenaarde Oudenaarde 30 37 59 34
14 Eendracht Aalst Eendracht 30 35 49 31
15 Geel-Meerhout Geel-Meerhou 30 42 62 31
16 Knokke Knokke 30 35 45 24
TEMPORADA 2017/2018
DIVISIÓN NACIONAL BELGA 1
Equipo PJ GF GC Puntos
1 Lommel SK Lommel SK 30 69 20 71
2 Knokke Knokke 30 69 32 61
3 Dessel Sport Dessel Sport 30 53 29 60
4 Deinze Deinze 30 44 30 50
5 RFC Seraing RFC Seraing 30 50 34 48
6 Heist Heist 30 47 45 47
7 Oudenaarde Oudenaarde 30 50 36 45
8 Eendracht Aalst Eendracht 30 48 46 44
9 Geel-Meerhout Geel-Meerhou 30 47 53 39
10 Excelsior Virton Excelsior 30 40 45 37
11 FCV Dender FCV Dender 30 39 52 36
12 Oosterwijk Oosterwijk 30 39 47 34
13 Châtelet Châtelet 30 34 53 29
14 VW Hamme VW Hamme 30 32 59 28
15 Berchem Sport Berchem 30 34 53 25
16 Patro Eisden Patro Eisden 30 18 79 14
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
PROVINCIAL BÉLGICA GRUPO 8
Equipo PJ GF GC Puntos
1 Knokke Knokke 28 76 22 72
2 De Ruiter Roeselare Ruiter 28 78 19 68
3 Oostnieuwkerke Oostnieuwker 28 54 22 53
4 Eendracht Wervik Eendracht 28 41 35 47
5 White Star Adinkerke White Star. 28 52 51 46
6 Wielsbeke Wielsbeke 28 45 32 44
7 Meulebeke Meulebeke 28 46 48 41
8 Wingene Wingene 28 47 41 39
9 Rumbeke Rumbeke 28 41 45 32
10 Damme Damme 28 45 51 32
11 Zwevegem Sport Zwevegem 28 43 57 32
12 Oostduinkerke Oostduinkerk 28 41 54 29
13 Helkijn Helkijn 28 27 59 25
14 Wevelgem City Wevelgem 28 37 57 24
15 Club Roeselare Club 28 18 98 4
16 VG Oostende VG Oostende 0 0 0 0

  USO DE MEMORIA  
6,473,736 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1675
Total Execution Time  0.1687
  CADENA URL  
/historico/Knokke
  GET DATOS  
$_GET['/historico/Knokke']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (39)  
0.0047  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 = 'Knokke' 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.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=16994 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=16994 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=16994 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0028  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=16994 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0039  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 = 72259
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=16994 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1894 AND type_rel = 3
0.0022  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1894 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0024  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 (1293576,1264941,900137,769348,500257) ORDER BY n.cover_points DESC, update_date DESC
0.0027  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 = '16994' ORDER BY l.year DESC,cat.coefficient DESC
0.0028  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 = '16994' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0028  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 = '16994' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = 72259 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0035  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=16994 AND l.year in (2023,2024,2025) 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 (73206,72259,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.0028  SELECT count(id) as num_players from rel_players WHERE league_id = 72259 AND teamId = 16994
0.0062  SELECT count(id) as num_players from rel_players WHERE league_id = 73206 AND teamId = 16994
0.0039  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 16994
0.0033  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 = 72259 AND t.round = 33 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0022  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 = '16994' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0020  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '16994' 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 = '16994' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0046  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 = 72259 WHERE rp.league_id = 72259 AND rp.teamId = 16994 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.0035  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 = 72259 WHERE rp.league_id = 72259 AND rp.teamId = 16994 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028  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 = 72259 WHERE rp.league_id = 72259 AND rp.teamId = 16994 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0031  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 = 16994 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0035  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 = 72259 AND t.round = 33 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033  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 = 68256 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 63431 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 `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 = 67463 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.0034  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 = 58503 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.0030  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.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 `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 = 44699 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034  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 = 38873 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034  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.0036  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.0038  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.0038  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 = 3526 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC