4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Meux
TEMPORADA 2023/2024
DIVISIÓN BELGA 2 GRUPO 1
Equipo PJ GF GC Puntos
1 RAEC Mons RAEC Mons 31 67 21 78
2 Union Rochefortoise Union 30 58 34 61
3 Tubize Tubize 31 57 32 57
4 Tournai Tournai 31 50 32 56
5 Warnant Warnant 31 43 36 45
6 Binche Binche 30 40 42 44
7 Stockay-Warfusée Stockay-Warf 30 52 45 43
8 Meux Meux 31 42 42 43
9 La Louvière Centre Louvière 30 45 40 41
10 La Calamine La Calamine 31 50 51 41
11 Union Saint-Gilloise II Union 30 48 48 40
12 Verlaine Verlaine 31 46 52 36
13 Verviers Verviers 31 52 59 35
14 Jette Jette 31 32 51 35
15 Ganshoren Ganshoren 30 37 53 31
16 Acren Lessines Acren 31 46 64 30
17 Hamoir Hamoir 31 29 63 23
18 Rebecq Rebecq 31 37 66 22
TEMPORADA 2022/2023
DIVISIÓN BELGA 2 GRUPO 1
Equipo PJ GF GC Puntos
1 Warnant Warnant 34 58 31 72
2 Union Namur Union Namur 34 75 53 62
3 Tubize Tubize 34 70 33 61
4 La Louvière Centre Louvière 34 62 46 56
5 Meux Meux 34 51 46 56
6 Binche Binche 34 54 43 55
7 Rebecq Rebecq 34 61 54 53
8 Stockay-Warfusée Stockay-Warf 34 45 41 53
9 Verlaine Verlaine 34 55 41 51
10 Stade Disonais Stade 34 45 44 50
11 Hamoir Hamoir 34 47 64 45
12 Ganshoren Ganshoren 34 47 47 44
13 Acren Lessines Acren 34 54 66 44
14 Union Saint-Gilloise II Union 34 53 53 38
15 Jette Jette 34 45 56 35
16 Solières Sport Solières 34 54 77 31
17 Seraing B Seraing B 34 39 76 24
18 Waremme Waremme 34 30 74 19
TEMPORADA 2021/2022
DIVISIÓN BELGA 2 GRUPO 1
Equipo PJ GF GC Puntos
1 RAAL La Louviere RAAL 30 75 18 78
2 Meux Meux 30 73 32 65
3 Warnant Warnant 30 61 24 61
4 Tubize Tubize 30 63 42 52
5 Rebecq Rebecq 30 53 40 49
6 Ganshoren Ganshoren 30 46 33 49
7 Solières Sport Solières 30 74 47 48
8 Hamoir Hamoir 30 55 53 47
9 Acren Lessines Acren 30 61 61 42
10 Jette Jette 30 37 48 36
11 Waremme Waremme 30 48 58 31
12 Stockay-Warfusée Stockay-Warf 30 35 59 30
13 Verlaine Verlaine 30 35 53 29
14 Couvin-Mariembourg Couvin-Marie 30 31 59 24
15 Givry Givry 30 31 65 22
16 RES Durbuy RES Durbuy 30 16 102 8
TEMPORADA 2020/2021
DIVISIÓN BELGA 2 GRUPO 3
Equipo PJ GF GC Puntos
1 Tubize Tubize 4 14 2 12
2 RAAL La Louviere RAAL 3 15 0 9
3 Ganshoren Ganshoren 3 6 4 7
4 Stockay-Warfusée Stockay-Warf 4 6 5 7
5 Hamoir Hamoir 4 10 7 6
6 Couvin-Mariembourg Couvin-Marie 3 8 5 6
7 Givry Givry 4 6 6 5
8 Jette Jette 2 4 2 3
9 Solières Sport Solières 3 6 6 3
10 Verlaine Verlaine 2 1 3 3
11 Waremme Waremme 3 5 9 3
12 RES Durbuy RES Durbuy 4 7 14 3
13 Meux Meux 3 4 4 3
14 Rebecq Rebecq 2 2 2 2
15 Acren Lessines Acren 2 3 4 1
16 Warnant Warnant 2 2 6 0
17 Excelsior Virton Excelsior 4 0 20 0
TEMPORADA 2019/2020
DIVISIÓN BELGA 2 GRUPO 1
Equipo PJ GF GC Puntos
1 Francs Borains Francs 24 50 17 52
2 Meux Meux 24 46 26 48
3 RAAL La Louviere RAAL 23 38 18 46
4 Rebecq Rebecq 24 41 24 44
5 Hamoir Hamoir 24 48 34 43
6 RES Durbuy RES Durbuy 24 44 39 35
7 Stockay-Warfusée Stockay-Warf 22 43 37 34
8 Givry Givry 24 33 38 33
9 Acren Lessines Acren 24 45 49 28
10 RFC Tilleur RFC Tilleur 23 28 40 26
11 Couvin-Mariembourg Couvin-Marie 23 35 38 25
12 Verlaine Verlaine 22 33 47 24
13 Waremme Waremme 24 30 52 22
14 Union Namur Union Namur 24 29 53 21
15 Solières Sport Solières 23 26 45 21
16 Onhaye Onhaye 24 27 39 21
TEMPORADA 2018/2019
DIVISIÓN BELGA 2 GRUPO 1
Equipo PJ GF GC Puntos
1 La Louvière Centre Louvière 30 83 19 77
2 Visé Visé 30 68 36 61
3 Hamoir Hamoir 30 56 34 59
4 Francs Borains Francs 30 59 42 52
5 Rebecq Rebecq 30 60 44 51
6 RFC Tilleur RFC Tilleur 30 54 45 47
7 RAAL La Louviere RAAL 30 42 30 46
8 Meux Meux 30 51 51 39
9 RES Durbuy RES Durbuy 30 37 50 39
10 Couvin-Mariembourg Couvin-Marie 30 50 51 38
11 Waremme Waremme 30 46 53 35
12 Solières Sport Solières 30 38 56 31
13 Acren Lessines Acren 30 42 53 29
14 Walhain Walhain 30 33 52 28
15 Olympic Charleroi Olympic 30 32 61 24
16 Ciney Ciney 30 22 96 9
TEMPORADA 2017/2018
DIVISIÓN BELGA 2 GRUPO 1
Equipo PJ GF GC Puntos
1 RWD Molenbeek Molenbeek 28 84 19 76
2 RFC Liège RFC Liège 28 68 30 66
3 Olympic Charleroi Olympic 28 53 37 54
4 RES Durbuy RES Durbuy 28 40 37 45
5 Hamoir Hamoir 28 44 43 44
6 La Louvière Centre Louvière 28 38 43 42
7 Waremme Waremme 28 47 45 38
8 Walhain Walhain 28 38 44 37
9 Solières Sport Solières 28 36 40 35
10 Acren Lessines Acren 28 44 46 34
11 Meux Meux 28 48 55 31
12 Rebecq Rebecq 28 41 51 31
13 Ciney Ciney 28 35 48 24
14 Sprimont-Comblain Sprimont-Com 28 29 62 18
15 La Calamine La Calamine 28 25 70 12
16 White Star Woluwé White Star. 0 0 0 0
TEMPORADA 2016/2017
DIVISIÓN BELGA 2 GRUPO 1
Equipo PJ GF GC Puntos
1 Châtelet Châtelet 30 67 32 70
2 RFC Liège RFC Liège 30 66 30 65
3 Olympic Charleroi Olympic 30 61 46 51
4 La Louvière Centre Louvière 30 54 35 50
5 Hamoir Hamoir 30 50 49 44
6 Solières Sport Solières 30 52 48 42
7 Acren Lessines Acren 30 48 48 42
8 Walhain Walhain 30 52 53 41
9 La Calamine La Calamine 30 65 59 40
10 Waremme Waremme 30 60 58 38
11 Ciney Ciney 30 56 57 37
12 Meux Meux 30 53 51 36
13 Couvin-Mariembourg Couvin-Marie 30 54 66 33
14 Givry Givry 30 39 60 30
15 Charleroi-Couillet-Fleurus Charleroi-Co 30 37 77 26
16 Union Namur Union Namur 30 32 77 16
TEMPORADA 2015/2016
PROMOCIÓN BÉLGICA GRUPO 4
Equipo PJ GF GC Puntos
1 Meux Meux 30 71 44 59
2 Givry Givry 30 59 32 59
3 Solières Sport Solières 30 56 30 59
4 Couvin-Mariembourg Couvin-Marie 30 60 33 58
5 Waremme Waremme 30 73 45 57
6 Union Namur Union Namur 30 62 37 52
7 Cointe-Liège Cointe-Lièg 30 53 55 43
8 Bertrix Bertrix 30 52 47 41
9 Jeunesse Tamines Jeunesse 30 48 52 40
10 Richelle United Richelle 30 48 56 40
11 Patro Lensois Patro 30 41 47 35
12 Lorraine Arlon Lorraine 30 41 60 33
13 Longlier Longlier 30 45 62 31
14 Verlaine Verlaine 30 42 58 29
15 Aywaille Aywaille 30 30 80 22
16 Loyers Loyers 30 32 75 11
TEMPORADA 2014/2015
PROMOCIÓN BÉLGICA GRUPO 4
Equipo PJ GF GC Puntos
1 Waremme Waremme 11 35 13 25
2 RFC Liège RFC Liège 11 22 13 22
3 Couvin-Mariembourg Couvin-Marie 11 14 8 22
4 Solières Sport Solières 11 27 16 19
5 Huy Huy 11 18 15 18
6 Tilleur-Saint-Gilles Tilleur-Sain 11 20 17 17
7 Union Namur Union Namur 11 14 14 17
8 Meux Meux 11 19 18 16
9 Lorraine Arlon Lorraine 11 24 21 15
10 Givry Givry 11 18 15 15
11 Bertrix Bertrix 11 18 20 15
12 Hamoir Hamoir 11 22 26 14
13 Aywaille Aywaille 11 17 22 12
14 Jeunesse Tamines Jeunesse 11 13 21 9
15 Mormont Mormont 11 10 30 3
16 Onhaye Onhaye 11 9 31 2
TEMPORADA 2013/2014
PROMOCIÓN BÉLGICA GRUPO 4
Equipo PJ GF GC Puntos
1 RFC Liège RFC Liège 21 52 30 47
2 Walhain Walhain 21 45 23 45
3 Union Namur Union Namur 21 33 22 37
4 Cité Sport Cité Sport 21 38 31 36
5 Aywaille Aywaille 21 34 27 33
6 Meux Meux 20 36 29 32
7 Lorraine Arlon Lorraine 21 32 30 31
8 Bertrix Bertrix 21 33 29 29
9 Hamoir Hamoir 21 27 31 29
10 Couvin-Mariembourg Couvin-Marie 21 30 35 28
11 Solières Sport Solières 21 37 44 25
12 Givry Givry 20 28 23 25
13 Onhaye Onhaye 21 22 41 21
14 Longlier Longlier 21 18 33 19
15 Royal Spa Royal Spa 21 21 37 16
16 Faymonville Faymonville 21 14 35 13
TEMPORADA 2012/2013
PROMOCIÓN BÉLGICA GRUPO 4
Equipo PJ GF GC Puntos
1 Sprimont-Comblain Sprimont-Com 30 77 38 69
2 Union Namur Union Namur 30 59 32 57
3 Aywaille Aywaille 30 59 37 55
4 RFC Liège RFC Liège 30 54 22 54
5 Tilleur-Saint-Gilles Tilleur-Sain 30 58 55 48
6 Givry Givry 30 42 35 45
7 Faymonville Faymonville 30 61 54 42
8 Hamoir Hamoir 30 46 48 42
9 Olympic Charleroi Olympic 30 44 45 39
10 Meux Meux 30 46 51 37
11 Lorraine Arlon Lorraine 30 42 46 36
12 Charleroi Fleurus Charleroi 30 53 63 33
13 Jeunesse Tamines Jeunesse 30 36 59 33
14 Entente Blegnytoise Entente 30 28 55 27
15 Bièvre Bièvre 30 42 68 26
16 Mormont Mormont 30 32 71 23
TEMPORADA 2011/2012
PROMOCIÓN BÉLGICA GRUPO 4
Equipo PJ GF GC Puntos
1 Ciney Ciney 30 76 31 73
2 Walhain Walhain 30 68 36 58
3 RFC Liège RFC Liège 30 56 43 56
4 Faymonville Faymonville 30 61 54 52
5 Givry Givry 30 41 32 46
6 Aywaille Aywaille 30 49 37 43
7 Hamoir Hamoir 30 52 52 43
8 Sprimont-Comblain Sprimont-Com 30 51 56 37
9 Meux Meux 30 53 55 36
10 Mormont Mormont 30 50 60 34
11 Union Namur Union Namur 30 38 45 32
12 Bièvre Bièvre 30 41 61 32
13 Entente Blegnytoise Entente 30 30 51 31
14 RFC Seraing RFC Seraing 30 34 46 30
15 Habay-la-Vieille Habay-la-Vie 30 39 55 30
16 Elsautoise Elsautoise 30 37 62 22
TEMPORADA 2007/2008
PROMOCIÓN BÉLGICA GRUPO 4
Equipo PJ GF GC Puntos
1 La Louvière Centre Louvière 30 76 23 74
2 Faymonville Faymonville 30 81 47 56
3 BX Brussels BX Brussels 30 63 35 54
4 Ciney Ciney 30 68 53 53
5 Bertrix Bertrix 30 53 36 52
6 Couvin-Mariembourg Couvin-Marie 30 45 48 49
7 Walhain Walhain 30 51 46 44
8 Malmundaria Malmundaria 30 52 55 44
9 Aische Aische 30 66 59 43
10 Jeunesse Tamines Jeunesse 30 46 52 38
11 Royal Spa Royal Spa 30 37 44 37
12 Paturageois Paturageois 30 43 51 33
13 Petit-Waret Petit-Waret 30 35 64 25
14 Soignies Sports Soignies 30 41 64 23
15 Jamoigne Jamoigne 30 32 71 23
16 Meux Meux 30 35 76 19

  USO DE MEMORIA  
6,839,376 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.6725
Total Execution Time  0.6744
  CADENA URL  
/historico/Meux
  GET DATOS  
$_GET['/historico/Meux']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
0.0199  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 = 'Meux' 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.0147  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=16869 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=16869 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=16869 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=16869 AND type_rel = 2
0.0155  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 = '16869' ORDER BY l.year DESC,cat.coefficient DESC
0.0150  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 = '16869' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0148  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 = '16869' 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 = 72463 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0149  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=16869 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,72463,71730) 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.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 72463 AND teamId = 16869
0.0148  SELECT count(id) as num_players from rel_players WHERE league_id = 73206 AND teamId = 16869
0.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 71730 AND teamId = 16869
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 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 = 72463 AND t.round = 32 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0155  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 = '16869' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0148  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '16869' and rp.type = 4
0.0155  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 = '16869' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0174  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 = 72463 WHERE rp.league_id = 72463 AND rp.teamId = 16869 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.0174  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 = 72463 WHERE rp.league_id = 72463 AND rp.teamId = 16869 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0151  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 = 72463 WHERE rp.league_id = 72463 AND rp.teamId = 16869 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0150  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 = 16869 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72463 AND t.round = 32 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 `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 = 68499 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.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 = 63432 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.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 `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 = 58662 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.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 = 50974 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.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 = 44609 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 `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 = 38942 AND t.round = 30 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 = 33881 AND t.round = 30 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 `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 = 15782 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 `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 = 4475 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0160  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 = 3518 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 `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 = 27957 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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 = 27962 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0157  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 = 27987 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC