4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del SK Beveren

SK Beveren

Entrenador: Flavien Le Postollec

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
SEGUNDA DIVISIÓN BÉLGICA GRUPO 2
Equipo PJ GF GC Puntos
1 RWD Molenbeek Molenbeek 32 65 29 69
2 SK Beveren SK Beveren 32 76 34 68
3 Beerschot VA Beerschot 32 43 41 49
4 Club NXT Club NXT 32 51 48 49
5 Lierse Kempenzonen Lierse 32 53 59 46
6 Anderlecht Sub 23 Anderlecht 32 46 56 37
TEMPORADA 2021/2022
SEGUNDA DIVISIÓN BÉLGICA
Equipo PJ GF GC Puntos
1 KVC Westerlo Westerlo 28 52 29 56
2 RWD Molenbeek Molenbeek 28 41 33 49
3 SK Beveren SK Beveren 28 47 40 41
4 Deinze Deinze 28 47 39 39
5 Lierse Kempenzonen Lierse 28 39 42 36
6 Lommel SK Lommel SK 28 39 40 35
7 Mouscron Mouscron 28 31 45 30
8 Excelsior Virton Excelsior 28 24 52 21
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 1
Equipo PJ GF GC Puntos
1 Anderlecht Anderlecht 30 67 30 61
2 Club Brugge Club Brugge 30 56 24 59
3 Zulte-Waregem Zulte-Warege 30 49 38 54
4 KAA Gent KAA Gent 30 45 29 50
5 KV Oostende KV Oostende 30 52 37 50
6 Charleroi Charleroi 30 34 29 49
7 KV Mechelen KV Mechelen 30 41 36 48
8 Genk Genk 30 40 35 48
9 Standard de Liège Standard 30 47 38 39
10 Kortrijk Kortrijk 30 38 55 31
11 Lokeren Lokeren 30 24 34 31
12 Sint-Truidense V.V. Sint-Truiden 30 35 48 30
13 KAS Eupen KAS Eupen 30 40 64 30
14 SK Beveren SK Beveren 30 28 43 30
15 Mouscron Mouscron 30 29 53 24
16 KVC Westerlo Westerlo 30 33 65 23
TEMPORADA 2015/2016
LIGA BELGA GRUPO 3
Equipo PJ GF GC Puntos
1 Kortrijk Kortrijk 6 13 5 14
2 Standard de Liège Standard 6 8 5 10
3 Mouscron Mouscron 6 5 8 5
4 SK Beveren SK Beveren 6 3 11 4
5 Charleroi Charleroi 6 13 6 11
6 Lokeren Lokeren 6 12 7 11
7 KV Mechelen KV Mechelen 6 7 14 7
8 Sint-Truidense V.V. Sint-Truiden 6 4 9 3
TEMPORADA 2014/2015
LIGA BELGA GRUPO 1
Equipo PJ GF GC Puntos
1 Club Brugge Club Brugge 30 69 28 61
2 KAA Gent KAA Gent 30 52 29 57
3 Anderlecht Anderlecht 30 51 30 57
4 Standard de Liège Standard 30 49 39 53
5 Kortrijk Kortrijk 30 54 35 51
6 Charleroi Charleroi 30 44 31 49
7 Genk Genk 30 38 28 49
8 Lokeren Lokeren 30 38 32 42
9 KV Mechelen KV Mechelen 30 37 39 41
10 KV Oostende KV Oostende 30 40 52 38
11 KVC Westerlo Westerlo 30 42 63 33
12 Zulte-Waregem Zulte-Warege 30 41 54 31
13 Mouscron Mouscron 30 32 51 26
14 SK Beveren SK Beveren 30 30 49 26
15 Cercle Brugge Cercle 30 21 45 24
16 Lierse SK Lierse SK 30 30 63 22
TEMPORADA 2013/2014
LIGA BELGA GRUPO 3
Equipo PJ GF GC Puntos
1 KV Oostende KV Oostende 6 7 1 14
2 KAA Gent KAA Gent 6 11 6 10
3 Lierse SK Lierse SK 6 5 12 6
4 SK Beveren SK Beveren 6 7 11 4
TEMPORADA 2012/2013
LIGA BELGA GRUPO 1
Equipo PJ GF GC Puntos
1 Anderlecht Anderlecht 30 69 27 67
2 Zulte-Waregem Zulte-Warege 30 49 29 63
3 Genk Genk 30 63 40 55
4 Club Brugge Club Brugge 30 66 43 54
5 Lokeren Lokeren 30 53 38 51
6 Standard de Liège Standard 30 54 33 50
7 Mons Mons 30 48 53 44
8 KV Mechelen KV Mechelen 30 44 42 41
9 Kortrijk Kortrijk 30 31 30 39
10 OH Leuven OH Leuven 30 46 51 36
11 KAA Gent KAA Gent 30 33 40 34
12 Charleroi Charleroi 30 30 49 34
13 SK Beveren SK Beveren 30 28 49 30
14 Lierse SK Lierse SK 30 28 53 26
15 Beerschot Beerschot 30 31 61 23
16 Cercle Brugge Cercle 30 30 65 14
TEMPORADA 2011/2012
SEGUNDA DIVISIÓN BÉLGICA
Equipo PJ GF GC Puntos
1 Charleroi Charleroi 34 64 34 74
2 KAS Eupen KAS Eupen 34 61 34 68
3 SK Beveren SK Beveren 34 61 34 68
4 KV Oostende KV Oostende 34 61 29 66
5 Lommel SK Lommel SK 34 48 42 52
6 White Star Woluwé White Star. 34 48 43 51
7 Heist Heist 34 46 46 46
8 Eendracht Aalst Eendracht 34 46 52 46
9 Visé Visé 34 44 41 44
10 Antwerp Antwerp 34 39 42 43
11 RBD Borinage Borinage 34 44 54 42
12 Tubize Tubize 34 36 55 41
13 KSV Roeselare Roeselare 34 46 51 40
14 Brussels Brussels 34 44 46 38
15 Sint-Niklaas Sint-Niklaas 34 41 54 34
16 FCV Dender FCV Dender 34 33 43 33
17 Tienen Tienen 34 34 61 33
18 Standaard Wetteren Standaard 34 19 54 21
TEMPORADA 2010/2011
SEGUNDA DIVISIÓN BÉLGICA
Equipo PJ GF GC Puntos
1 OH Leuven OH Leuven 34 75 38 73
2 Lommel SK Lommel SK 34 73 44 65
3 Mons Mons 34 63 38 59
4 SK Beveren SK Beveren 34 51 35 56
5 Visé Visé 34 52 48 51
6 Antwerp Antwerp 34 54 53 50
7 FCV Dender FCV Dender 34 54 54 49
8 Tubize Tubize 34 46 55 47
9 KV Oostende KV Oostende 34 41 48 45
10 Heist Heist 34 57 67 43
11 Brussels Brussels 34 50 51 42
12 Standaard Wetteren Standaard 34 42 51 42
13 RBD Borinage Borinage 34 48 52 41
14 KSV Roeselare Roeselare 34 38 42 41
15 Tienen Tienen 34 35 47 41
16 KFC Turnhout Turnhout 34 48 59 40
17 Rupel Boom Rupel Boom 34 36 56 37
18 Tournai Tournai 34 38 63 24
TEMPORADA 2006/2007
SEGUNDA DIVISIÓN BÉLGICA
Equipo PJ GF GC Puntos
1 FCV Dender FCV Dender 34 73 27 79
2 KV Mechelen KV Mechelen 34 64 36 70
3 Kortrijk Kortrijk 34 69 35 67
4 Antwerp Antwerp 34 63 36 60
5 OH Leuven OH Leuven 34 53 49 56
6 KAS Eupen KAS Eupen 34 50 46 50
7 Deinze Deinze 34 50 54 50
8 Tubize Tubize 34 36 32 48
9 Union Saint-Gilloise Union 34 47 44 45
10 Tienen Tienen 34 50 57 45
11 KV Oostende KV Oostende 34 51 58 40
12 VW Hamme VW Hamme 34 38 43 39
13 Excelsior Virton Excelsior 34 37 55 39
14 Lommel SK Lommel SK 34 39 49 36
15 SK Beveren SK Beveren 34 41 56 36
16 Dessel Sport Dessel Sport 34 45 58 34
17 Racing Waregem Racing 34 32 58 27
18 Ronse Ronse 34 26 71 20

  USO DE MEMORIA  
6,840,272 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1525
Total Execution Time  0.1537
  CADENA URL  
/historico/Waasland-Beveren
  GET DATOS  
$_GET['/historico/Waasland-Beveren']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (45)  
0.0032  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 = 'Waasland-Beveren' 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=7507 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=7507 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=7507 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=7507 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 = 72091
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=7507 AND type_rel = 2
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 7507 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0022  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 (3849,31683,65000,93874,108316) ORDER BY n.cover_points DESC, update_date 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 = '7507' ORDER BY l.year DESC,cat.coefficient DESC
0.0025  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 = '7507' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0032  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 = '7507' 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 = 72091 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=7507 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,72091,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.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 72091 AND teamId = 7507
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 73206 AND teamId = 7507
0.0028  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 7507
0.0024  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 = '7507' 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 = '7507' 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 = '7507' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0055  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 = 72091 WHERE rp.league_id = 72091 AND rp.teamId = 7507 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 = 72091 WHERE rp.league_id = 72091 AND rp.teamId = 7507 AND (e.action = 4 or e.action = 5) 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 events2024 e ON e.player_id = p.id AND e.league_id = 72091 WHERE rp.league_id = 72091 AND rp.teamId = 7507 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0033  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 = 7507 AND l.year <= 2024 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 `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 = 72091 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 `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 = 68027 AND t.round = 22 ORDER BY team.conference ASC,t.position 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 `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 = 71100 AND t.round = 10 ORDER BY team.conference ASC,t.position 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 `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 = 63244 AND t.round = 28 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.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 `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.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 `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.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 = 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.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 `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 = 33313 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 `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.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 = 21700 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 `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.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 = 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.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 `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.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 `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 = 10118 AND t.round = 6 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 = 10124 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 `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.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 `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 = 1741 AND t.round = 34 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 `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 = 10154 AND t.round = 34 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 `tables2007` 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 = 13513 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC