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

Beerschot VA

Entrenador: Dirk Kuyt

Temporada 2023/2024
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
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
SEGUNDA DIVISIÓN BÉLGICA GRUPO 1
Equipo PJ GF GC Puntos
1 OH Leuven OH Leuven 14 22 10 29
2 Excelsior Virton Excelsior 14 26 10 27
3 KVC Westerlo Westerlo 14 21 10 26
4 Union Saint-Gilloise Union 14 18 15 23
5 Beerschot VA Beerschot 14 13 19 17
6 Lokeren Lokeren 14 13 23 13
7 Lommel SK Lommel SK 14 9 19 11
8 KSV Roeselare Roeselare 14 15 31 11
TEMPORADA 2018/2019
SEGUNDA DIVISIÓN BÉLGICA GRUPO 2
Equipo PJ GF GC Puntos
1 Beerschot VA Beerschot 14 29 14 30
2 KV Mechelen KV Mechelen 14 26 16 29
3 Union Saint-Gilloise Union 14 18 15 21
4 KSV Roeselare Roeselare 14 19 17 20
5 KVC Westerlo Westerlo 14 12 17 15
6 OH Leuven OH Leuven 14 21 24 14
7 Tubize Tubize 14 13 22 14
8 Lommel SK Lommel SK 14 13 26 9
TEMPORADA 2017/2018
SEGUNDA DIVISIÓN BÉLGICA GRUPO 2
Equipo PJ GF GC Puntos
1 Cercle Brugge Cercle 14 26 13 27
2 Lierse SK Lierse SK 14 16 21 22
3 OH Leuven OH Leuven 14 15 12 21
4 Union Saint-Gilloise Union 14 16 15 18
5 Beerschot VA Beerschot 14 13 17 17
6 KVC Westerlo Westerlo 14 15 13 15
7 KSV Roeselare Roeselare 14 11 18 14
8 Tubize Tubize 14 11 14 13
TEMPORADA 2016/2017
DIVISIÓN NACIONAL BELGA 1
Equipo PJ GF GC Puntos
1 Beerschot VA Beerschot 30 67 16 80
2 Dessel Sport Dessel Sport 30 73 28 68
3 Excelsior Virton Excelsior 30 67 28 62
4 Heist Heist 30 65 40 54
5 FCV Dender FCV Dender 30 57 41 53
6 RFC Seraing RFC Seraing 30 47 35 51
7 Geel-Meerhout Geel-Meerhou 30 53 44 44
8 Patro Eisden Patro Eisden 30 42 43 41
9 Oudenaarde Oudenaarde 30 45 43 40
10 VW Hamme VW Hamme 30 58 56 37
11 Oosterwijk Oosterwijk 30 35 41 34
12 Sporting Hasselt Sporting 30 33 43 29
13 White Star Woluwé White Star. 30 33 58 26
14 Coxyde Coxyde 30 32 77 25
15 Sprimont-Comblain Sprimont-Com 30 35 59 22
16 Deinze Deinze 30 12 102 13
TEMPORADA 2015/2016
DIVISIÓN BELGA 2 GRUPO 2
Equipo PJ GF GC Puntos
1 Oosterwijk Oosterwijk 36 68 38 71
2 Beerschot VA Beerschot 36 64 39 71
3 Bocholt Bocholt 36 52 41 64
4 Sporting Hasselt Sporting 36 64 41 60
5 Ciney Ciney 36 57 42 57
6 Sprimont-Comblain Sprimont-Com 36 56 43 56
7 RFC Liège RFC Liège 36 58 56 53
8 Hamoir Hamoir 36 70 74 52
9 Rupel Boom Rupel Boom 36 65 55 51
10 Berchem Sport Berchem 36 51 55 50
11 Cappellen Cappellen 36 51 56 49
12 Hoogstraten Hoogstraten 36 60 60 48
13 Walhain Walhain 36 48 57 47
14 Tempo Overijse Tempo 36 47 56 45
15 Tienen Tienen 36 52 56 40
16 La Calamine La Calamine 37 44 61 40
17 Grimbergen Grimbergen 36 38 55 34
18 Diegem Sport Diegem Sport 37 35 68 34
19 Woluwe Woluwe 36 34 61 33
TEMPORADA 2014/2015
PROMOCIÓN BÉLGICA GRUPO 3
Equipo PJ GF GC Puntos
1 Esperanza Neerpelt Esperanza 7 23 6 19
2 Sint-Lenaarts Sint-Lenaart 7 12 6 16
3 Beerschot VA Beerschot 7 19 7 15
4 Belisia Bilzen Belisia 7 14 6 13
5 Wellen Wellen 7 15 17 12
6 KSC City Pirates City Pirates 7 13 10 11
7 Hades Hades 7 9 8 11
8 Vosselaar Vosselaar 7 12 11 10
9 KFC Duffel KFC Duffel 7 17 16 8
10 Lyra Lyra 7 6 7 8
11 Zwarte Leeuw Zwarte Leeuw 7 6 9 8
12 VC Herentals Herentals 7 7 15 7
13 Bree Bree 7 7 16 7
14 Bilzerse Waltwilder Bilzerse 7 8 18 5
15 Leopoldsburg Leopoldsburg 7 5 13 2
16 Witgoor Sport Witgoor 7 4 12 2
TEMPORADA 2009/2010
PROMOCIÓN BÉLGICA GRUPO 2
Equipo PJ GF GC Puntos
1 Bornem Bornem 30 60 32 60
2 Grimbergen Grimbergen 30 57 31 52
3 Oosterwijk Oosterwijk 30 39 30 49
4 TK Meldert TK Meldert 30 48 34 48
5 Olympia Wijgmaal Olympia 30 46 44 48
6 KFC Duffel KFC Duffel 30 44 38 46
7 Sint-Gillis Waas Sint-Gillis 30 51 39 44
8 Lyra Lyra 30 33 32 41
9 Tempo Overijse Tempo 30 35 36 38
10 VC Groot Dilbeek Groot 30 42 45 38
11 Londerzeel Londerzeel 30 37 40 37
12 Berchem Sport Berchem 30 44 47 36
13 Opwijk Opwijk 30 44 53 35
14 Vilvoorde Vilvoorde 30 44 55 34
15 Beerschot VA Beerschot 30 41 60 31
16 Vrasene Vrasene 30 24 73 18
TEMPORADA 2008/2009
PROMOCIÓN BÉLGICA GRUPO 2
Equipo PJ GF GC Puntos
1 Temse Temse 30 63 37 59
2 Bornem Bornem 30 49 25 56
3 VC Groot Dilbeek Groot 30 56 31 55
4 TK Meldert TK Meldert 30 56 37 51
5 Ternat Ternat 30 64 48 49
6 Opwijk Opwijk 30 42 31 49
7 KFC Duffel KFC Duffel 30 48 38 49
8 Berchem Sport Berchem 30 43 37 44
9 Grimbergen Grimbergen 30 57 44 42
10 Beerschot VA Beerschot 30 55 52 42
11 Berlare Berlare 30 48 38 40
12 Eendracht Zele Eendracht 30 42 60 33
13 Londerzeel Londerzeel 30 41 44 32
14 Eendracht Buggenhout Eendracht 30 29 65 23
15 Tubantia Borgerhout Tubantia 30 24 65 20
16 Schoten Schoten 30 18 83 10

  USO DE MEMORIA  
6,442,232 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.7160
Total Execution Time  0.7180
  CADENA URL  
/historico/Beerschot-Wilrijk
  GET DATOS  
$_GET['/historico/Beerschot-Wilrijk']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (39)  
0.0157  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 = 'Beerschot-Wilrijk' 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.0145  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=20669 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=20669 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=20669 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  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=20669 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=20669 AND type_rel = 2
0.0146  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 20669 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0148  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 (237816,411854,582894,867679,880295) ORDER BY n.cover_points DESC, update_date DESC
0.0152  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 = '20669' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0150  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 = '20669' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0146  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.0157  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=20669 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0146  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.0148  SELECT count(id) as num_players from rel_players WHERE league_id = 72091 AND teamId = 20669
0.0150  SELECT count(id) as num_players from rel_players WHERE league_id = 73206 AND teamId = 20669
0.0299  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 20669
0.0150  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 = 72091 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0147  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 = '20669' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0144  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '20669' and rp.type = 4
0.0146  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 = '20669' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0161  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 = 20669 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.0165  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 = 20669 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0153  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 = 20669 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0151  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 = 20669 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0149  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.0147  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.0151  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.0152  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.0152  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 = 50311 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 50114 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 43915 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 43916 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 38731 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 38732 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 33772 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 15756 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 4470 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 27976 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 27981 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC