4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2023/2024
SEGUNDA DIVISIÓN BÉLGICA GRUPO 1
Equipo PJ GF GC Puntos
1 Beerschot VA Beerschot 30 46 29 56
2 FCV Dender FCV Dender 30 55 32 54
3 Deinze Deinze 30 48 37 53
4 Lommel SK Lommel SK 30 51 31 52
5 Zulte-Waregem Zulte-Warege 30 51 34 51
6 Patro Eisden Patro Eisden 30 40 28 51
7 RFC Liège RFC Liège 30 49 41 49
8 SK Beveren SK Beveren 30 44 40 45
9 Club NXT Club NXT 30 40 49 37
10 Jong Genk Jong Genk 30 46 52 37
11 Lierse Kempenzonen Lierse 30 44 59 35
12 Anderlecht Sub 23 Anderlecht 30 39 47 34
13 KV Oostende KV Oostende 30 32 39 32
14 Francs Borains Francs 30 38 52 32
15 RFC Seraing RFC Seraing 30 33 51 28
16 SL16 FC SL16 FC 30 25 60 17
TEMPORADA 2022/2023
LIGA BELGA GRUPO 1
Equipo PJ GF GC Puntos
1 Genk Genk 34 78 37 75
2 Union Saint-Gilloise Union 34 70 41 75
3 Antwerp Antwerp 34 59 26 72
4 Club Brugge Club Brugge 34 61 36 59
5 KAA Gent KAA Gent 34 64 38 56
6 Standard de Liège Standard 34 58 45 55
7 KVC Westerlo Westerlo 34 61 53 51
8 Cercle Brugge Cercle 34 50 46 50
9 Charleroi Charleroi 34 45 52 48
10 OH Leuven OH Leuven 34 56 48 48
11 Anderlecht Anderlecht 34 49 46 46
12 Sint-Truidense V.V. Sint-Truiden 34 37 40 42
13 KV Mechelen KV Mechelen 34 49 63 40
14 Kortrijk Kortrijk 34 37 61 31
15 KAS Eupen KAS Eupen 34 40 75 28
16 KV Oostende KV Oostende 34 37 76 27
17 Zulte-Waregem Zulte-Warege 34 50 78 27
18 RFC Seraing RFC Seraing 34 28 68 20
TEMPORADA 2021/2022
LIGA BELGA GRUPO 1
Equipo PJ GF GC Puntos
1 Union Saint-Gilloise Union 34 78 27 77
2 Club Brugge Club Brugge 34 72 37 72
3 Anderlecht Anderlecht 34 72 36 64
4 Antwerp Antwerp 34 55 38 63
5 KAA Gent KAA Gent 34 56 30 62
6 Charleroi Charleroi 34 55 46 54
7 KV Mechelen KV Mechelen 34 57 61 52
8 Genk Genk 34 66 47 51
9 Sint-Truidense V.V. Sint-Truiden 34 42 40 51
10 Cercle Brugge Cercle 34 49 46 45
11 OH Leuven OH Leuven 34 47 58 41
12 KV Oostende KV Oostende 34 34 61 37
13 Kortrijk Kortrijk 34 43 48 37
14 Standard de Liège Standard 34 32 51 36
15 KAS Eupen KAS Eupen 34 37 61 32
16 Zulte-Waregem Zulte-Warege 34 42 69 32
17 RFC Seraing RFC Seraing 34 30 68 28
18 Beerschot VA Beerschot 34 33 76 16
TEMPORADA 2020/2021
LIGA BELGA GRUPO 1
Equipo PJ GF GC Puntos
1 Club Brugge Club Brugge 34 73 26 76
2 Antwerp Antwerp 34 57 48 60
3 Anderlecht Anderlecht 34 51 34 58
4 Genk Genk 34 67 48 56
5 KV Oostende KV Oostende 34 49 41 53
6 Standard de Liège Standard 34 52 41 50
7 KAA Gent KAA Gent 34 55 42 49
8 KV Mechelen KV Mechelen 34 54 54 48
9 Beerschot VA Beerschot 34 58 64 47
10 Zulte-Waregem Zulte-Warege 34 53 69 46
11 OH Leuven OH Leuven 34 54 59 45
12 KAS Eupen KAS Eupen 34 44 55 43
13 Charleroi Charleroi 34 46 49 42
14 Kortrijk Kortrijk 34 44 57 39
15 Sint-Truidense V.V. Sint-Truiden 34 41 52 38
16 Cercle Brugge Cercle 34 40 51 36
17 SK Beveren SK Beveren 34 44 70 31
18 Mouscron Mouscron 34 32 54 31
TEMPORADA 2019/2020
LIGA BELGA
Equipo PJ GF GC Puntos
1 Club Brugge Club Brugge 29 58 14 70
2 KAA Gent KAA Gent 29 59 34 55
3 Charleroi Charleroi 29 49 23 54
4 Antwerp Antwerp 29 49 32 53
5 Standard de Liège Standard 29 47 32 49
6 KV Mechelen KV Mechelen 29 46 43 44
7 Genk Genk 29 45 42 44
8 Anderlecht Anderlecht 29 45 29 43
9 Zulte-Waregem Zulte-Warege 29 41 49 36
10 Mouscron Mouscron 29 38 40 36
11 Kortrijk Kortrijk 29 40 44 33
12 Sint-Truidense V.V. Sint-Truiden 29 33 50 33
13 KAS Eupen KAS Eupen 29 28 51 30
14 Cercle Brugge Cercle 29 27 54 23
15 KV Oostende KV Oostende 29 29 58 22
16 SK Beveren SK Beveren 29 21 60 20
TEMPORADA 2018/2019
LIGA BELGA GRUPO 1
Equipo PJ GF GC Puntos
1 Genk Genk 30 63 31 63
2 Club Brugge Club Brugge 30 64 32 56
3 Standard de Liège Standard 30 49 35 53
4 Anderlecht Anderlecht 30 49 34 51
5 KAA Gent KAA Gent 30 53 45 50
6 Antwerp Antwerp 30 39 34 49
7 Sint-Truidense V.V. Sint-Truiden 30 47 36 47
8 Kortrijk Kortrijk 30 44 42 43
9 Charleroi Charleroi 30 43 43 42
10 Mouscron Mouscron 30 33 33 40
11 Zulte-Waregem Zulte-Warege 30 49 60 33
12 KAS Eupen KAS Eupen 30 34 57 32
13 Cercle Brugge Cercle 30 35 59 28
14 KV Oostende KV Oostende 30 29 52 27
15 SK Beveren SK Beveren 30 37 50 27
16 Lokeren Lokeren 30 28 53 20
TEMPORADA 2017/2018
LIGA BELGA GRUPO 1
Equipo PJ GF GC Puntos
1 Club Brugge Club Brugge 30 68 33 67
2 Anderlecht Anderlecht 30 49 42 55
3 Charleroi Charleroi 30 46 30 51
4 KAA Gent KAA Gent 30 45 27 50
5 Genk Genk 30 44 36 44
6 Standard de Liège Standard 30 43 41 44
7 Kortrijk Kortrijk 30 42 39 42
8 Antwerp Antwerp 30 38 40 41
9 Zulte-Waregem Zulte-Warege 30 47 52 37
10 Sint-Truidense V.V. Sint-Truiden 30 29 41 37
11 KV Oostende KV Oostende 30 42 41 36
12 SK Beveren SK Beveren 30 50 51 35
13 Lokeren Lokeren 30 33 49 31
14 Mouscron Mouscron 30 40 59 30
15 KAS Eupen KAS Eupen 30 40 57 27
16 KV Mechelen KV Mechelen 30 31 49 27
TEMPORADA 2016/2017
LIGA BELGA GRUPO 2
Equipo PJ GF GC Puntos
1 Anderlecht Anderlecht 10 14 6 52
2 Club Brugge Club Brugge 10 16 14 45
3 KAA Gent KAA Gent 10 16 11 41
4 KV Oostende KV Oostende 10 14 17 37
5 Charleroi Charleroi 10 10 13 35
6 Zulte-Waregem Zulte-Warege 10 12 21 33
TEMPORADA 2015/2016
LIGA BELGA GRUPO 1
Equipo PJ GF GC Puntos
1 Club Brugge Club Brugge 30 64 30 64
2 KAA Gent KAA Gent 30 56 29 60
3 Anderlecht Anderlecht 30 51 29 55
4 KV Oostende KV Oostende 30 55 44 49
5 Genk Genk 30 42 30 48
6 Zulte-Waregem Zulte-Warege 30 51 50 43
7 Standard de Liège Standard 30 41 51 41
8 Charleroi Charleroi 30 36 39 39
9 Kortrijk Kortrijk 30 31 35 39
10 KV Mechelen KV Mechelen 30 48 50 37
11 Lokeren Lokeren 30 35 40 34
12 SK Beveren SK Beveren 30 40 57 33
13 Mouscron Mouscron 30 39 51 30
14 Sint-Truidense V.V. Sint-Truiden 30 28 47 30
15 KVC Westerlo Westerlo 30 35 59 30
16 OH Leuven OH Leuven 30 42 53 29
TEMPORADA 2014/2015
LIGA BELGA GRUPO 3
Equipo PJ GF GC Puntos
1 KV Mechelen KV Mechelen 6 14 3 15
2 Genk Genk 6 14 7 15
3 Zulte-Waregem Zulte-Warege 6 6 10 4
4 SK Beveren SK Beveren 6 5 19 1
5 Lokeren Lokeren 6 19 9 13
6 Mouscron Mouscron 6 9 8 10
7 KV Oostende KV Oostende 6 6 12 6
8 KVC Westerlo Westerlo 6 7 12 5
TEMPORADA 2013/2014
LIGA BELGA GRUPO 2
Equipo PJ GF GC Puntos
1 Anderlecht Anderlecht 10 17 6 51
2 Standard de Liège Standard 10 14 11 49
3 Club Brugge Club Brugge 10 16 11 48
4 Zulte-Waregem Zulte-Warege 10 16 15 41
5 Lokeren Lokeren 10 14 25 34
6 Genk Genk 10 10 19 32
TEMPORADA 2012/2013
LIGA BELGA GRUPO 2
Equipo PJ GF GC Puntos
1 Anderlecht Anderlecht 10 16 11 49
2 Zulte-Waregem Zulte-Warege 10 20 20 47
3 Club Brugge Club Brugge 10 21 17 46
4 Standard de Liège Standard 10 18 17 42
5 Genk Genk 10 11 12 40
6 Lokeren Lokeren 10 15 24 31
TEMPORADA 2011/2012
LIGA BELGA GRUPO 4
Equipo PJ GF GC Puntos
1 Mons Mons 6 8 4 11
2 Zulte-Waregem Zulte-Warege 6 7 8 8
3 Beerschot Beerschot 6 9 10 7
4 Lokeren Lokeren 6 9 11 6
TEMPORADA 2010/2011
LIGA BELGA GRUPO 1
Equipo PJ GF GC Puntos
1 Anderlecht Anderlecht 30 58 20 65
2 Genk Genk 30 64 27 64
3 KAA Gent KAA Gent 30 59 42 57
4 Club Brugge Club Brugge 30 60 35 53
5 Lokeren Lokeren 30 43 36 50
6 Standard de Liège Standard 30 50 38 49
7 KV Mechelen KV Mechelen 30 34 30 48
8 KVC Westerlo Westerlo 30 41 40 41
9 Cercle Brugge Cercle 30 33 34 39
10 Kortrijk Kortrijk 30 36 39 38
11 Zulte-Waregem Zulte-Warege 30 39 41 33
12 Sint-Truidense V.V. Sint-Truiden 30 20 51 29
13 Germinal Beerschot Germinal 30 24 40 26
14 Lierse SK Lierse SK 30 26 58 24
15 Eupen Eupen 30 28 50 23
16 Charleroi Charleroi 30 20 54 19

  USO DE MEMORIA  
6,435,984 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.1422
Total Execution Time  0.1435
  CADENA URL  
/historico/Zulte-Waregem
  GET DATOS  
$_GET['/historico/Zulte-Waregem']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (44)  
0.0034  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 = 'Zulte-Waregem' 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=2799 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=2799 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=2799 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=2799 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=2799 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0031  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 = 75889
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2799 AND type_rel = 2
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2799 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 (81614,96316,104578,116549,127880) ORDER BY n.cover_points DESC, update_date DESC
0.0037  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 = '2799' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0026  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 = '2799' 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 = 75889 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0026  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=2799 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 (75889,73206,71432,67769) 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.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 67769 AND teamId = 2799
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 75889 AND teamId = 2799
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 73206 AND teamId = 2799
0.0034  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 2799
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 `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 = 75889 AND t.round = 1 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021  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 = '2799' 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 = '2799' and rp.type = 4
0.0022  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 = '2799' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0021  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 = 75889 WHERE rp.league_id = 75889 AND rp.teamId = 2799 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.0023  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 = 75889 WHERE rp.league_id = 75889 AND rp.teamId = 2799 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 events2024 e ON e.player_id = p.id AND e.league_id = 75889 WHERE rp.league_id = 75889 AND rp.teamId = 2799 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 = 2799 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 = 63065 AND t.round = 34 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 = 56829 AND t.round = 34 ORDER BY team.conference ASC,t.position 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 `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 = 49865 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.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 `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 = 43914 AND t.round = 30 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 `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 = 38639 AND t.round = 30 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 `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 = 38066 AND t.round = 10 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 `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 = 21698 AND t.round = 10 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 `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 = 15156 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 `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 = 3814 AND t.round = 30 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 `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 = 11090 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 2409 AND t.round = 30 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 `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 = 10117 AND t.round = 10 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 `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 = 2015 AND t.round = 30 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 `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 = 10122 AND t.round = 10 ORDER BY team.conference 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 `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 = 1356 AND t.round = 30 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 `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 = 10141 AND t.round = 6 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 `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 = 1077 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC