4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Couvin-Mariembourg
TEMPORADA 2023/2024
PROMOCIÓN BÉLGICA GRUPO 1
Equipo PJ GF GC Puntos
1 Onhaye Onhaye 30 70 17 72
2 Crossing Schaerbeek Crossing 30 65 32 61
3 Entité Manageoise Entité 30 65 28 60
4 Ostiches Ostiches 30 59 24 60
5 Ciney Ciney 30 69 61 50
6 Aische Aische 30 54 36 43
7 Perwez Perwez 30 43 46 42
8 Braine Braine 30 36 30 41
9 RAS Monceau RAS Monceau 30 43 42 40
10 Jodoigne Jodoigne 30 37 42 37
11 Flénu Flénu 30 46 47 36
12 Belœil Belœil 30 44 53 35
13 Arquet Arquet 30 52 54 34
14 Jeunesse Tamines Jeunesse 30 45 56 33
15 Rapid Symphorinois Rapid 30 41 52 30
16 Couvin-Mariembourg Couvin-Marie 30 20 169 3
TEMPORADA 2022/2023
PROMOCIÓN BÉLGICA GRUPO 1
Equipo PJ GF GC Puntos
1 RAEC Mons RAEC Mons 29 56 18 64
2 Onhaye Onhaye 29 54 32 57
3 Rapid Symphorinois Rapid 29 44 37 52
4 Tournai Tournai 29 45 33 46
5 Ostiches Ostiches 29 39 32 46
6 Crossing Schaerbeek Crossing 29 41 32 45
7 Aische Aische 29 57 42 44
8 Entité Manageoise Entité 29 38 40 41
9 RAS Monceau RAS Monceau 29 43 43 39
10 Jeunesse Tamines Jeunesse 29 32 34 36
11 RCS Brainois Brainois 29 39 43 32
12 Jodoigne Jodoigne 29 41 51 31
13 Couvin-Mariembourg Couvin-Marie 29 35 45 31
14 SG-Tertre-Hautrage SG-Tertre-Ha 29 41 59 30
15 Léopold Uccle-Woluwé Léopold 29 23 54 23
16 Gosselies Sports Gosselies 29 29 62 20
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
PROMOCIÓN BÉLGICA GRUPO 1
Equipo PJ GF GC Puntos
1 RAAL La Louviere RAAL 30 74 24 69
2 Francs Borains Francs 30 78 32 66
3 Onhaye Onhaye 30 66 47 56
4 Tournai Tournai 30 45 27 55
5 Couvin-Mariembourg Couvin-Marie 30 62 41 54
6 Racing Jet Wavre Racing Wavre 30 58 47 52
7 Binche Binche 30 56 53 52
8 Entité Manageoise Entité 30 52 50 41
9 RAEC Mons RAEC Mons 30 44 40 39
10 Jeunesse Tamines Jeunesse 30 46 56 37
11 Ganshoren Ganshoren 30 40 54 36
12 Léopold Uccle-Woluwé Léopold 30 47 50 32
13 Stade Brainois Stade 30 35 52 29
14 Spy Spy 30 39 83 22
15 Solre-sur-Sambre Solre-sur-Sa 30 35 67 20
16 Waterloo Waterloo 30 34 88 14
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 2010/2011
PROMOCIÓN BÉLGICA GRUPO 4
Equipo PJ GF GC Puntos
1 La Calamine La Calamine 30 67 43 64
2 Walhain Walhain 30 65 29 62
3 Faymonville Faymonville 30 70 49 53
4 Sprimont-Comblain Sprimont-Com 30 45 26 53
5 Ciney Ciney 30 63 56 51
6 Givry Givry 30 50 44 44
7 Hamoir Hamoir 30 48 46 44
8 RFC Seraing RFC Seraing 30 48 50 44
9 Habay-la-Vieille Habay-la-Vie 30 51 46 39
10 Elsautoise Elsautoise 30 43 46 39
11 Aywaille Aywaille 30 38 45 35
12 Léopold Uccle-Woluwé Léopold 30 45 55 33
13 Wanze / Bas-Oha Wanze 30 39 52 32
14 Couvin-Mariembourg Couvin-Marie 30 43 62 28
15 R.R.F.C. Montegnée R.R.F.C. 30 32 56 28
16 Hannutois Hannutois 30 30 72 15
TEMPORADA 2008/2009
PROMOCIÓN BÉLGICA GRUPO 1
Equipo PJ GF GC Puntos
1 Coxyde Coxyde 30 46 17 61
2 KVC Winkel Sport Winkel Sport 30 56 15 58
3 Jeunesse Tamines Jeunesse 30 47 28 54
4 Diksmuide Diksmuide 30 58 39 50
5 Westhoek Westhoek 30 59 41 50
6 Sparta Petegem Sparta 30 51 47 50
7 Izegem Izegem 30 53 39 48
8 Charleroi Fleurus Charleroi 30 61 41 44
9 Torhout Torhout 30 48 46 44
10 Paturageois Paturageois 30 42 41 41
11 Olsa Brakel Olsa Brakel 30 46 59 38
12 Charleroi-Couillet-Fleurus Charleroi-Co 30 33 49 35
13 Belœil Belœil 30 41 57 34
14 Couvin-Mariembourg Couvin-Marie 30 34 44 31
15 RC Lauwe RC Lauwe 30 22 83 15
16 VG Oostende VG Oostende 30 28 79 13
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,640,384 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.6769
Total Execution Time  0.6783
  CADENA URL  
/historico/Couvin-Mariembourg
  GET DATOS  
$_GET['/historico/Couvin-Mariembourg']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0197  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 = 'Couvin-Mariembourg' 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.0151  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=16864 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0152  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=16864 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150  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=16864 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0302  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 = 72771
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=16864 AND type_rel = 2
0.0151  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 = '16864' ORDER BY l.year DESC,cat.coefficient DESC
0.0149  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 = '16864' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0151  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 = '16864' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0149  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 = 72771 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0154  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=16864 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0148  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,72771) 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.0145  SELECT count(id) as num_players from rel_players WHERE league_id = 72771 AND teamId = 16864
0.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 73206 AND teamId = 16864
0.0156  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 = '16864' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0150  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '16864' and rp.type = 4
0.0158  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 = '16864' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0158  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 = 72771 WHERE rp.league_id = 72771 AND rp.teamId = 16864 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.0150  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 = 72771 WHERE rp.league_id = 72771 AND rp.teamId = 16864 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 = 72771 WHERE rp.league_id = 72771 AND rp.teamId = 16864 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0154  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 = 16864 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0164  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 = 72771 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.0162  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 = 68883 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.0168  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.0154  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.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 `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.0156  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.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 `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 = 38981 AND t.round = 30 ORDER BY team.conference 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 `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.0167  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.0164  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.0164  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.0165  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 = 27972 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0164  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 = 27980 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0156  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