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
DIVISIÓN NACIONAL BELGA 1
Equipo PJ GF GC Puntos
1 Patro Eisden Patro Eisden 38 84 23 86
2 RFC Liège RFC Liège 38 99 29 86
3 Francs Borains Francs 38 79 46 77
4 RAAL La Louviere RAAL 38 72 39 73
5 Gent II Gent II 38 59 43 67
6 Heist Heist 38 69 59 61
7 Olympic Charleroi Olympic 38 71 52 60
8 Knokke Knokke 38 65 58 60
9 Visé Visé 38 66 52 56
10 Thes Sport Thes Sport 38 58 52 53
11 Leuven II Leuven II 38 61 68 50
12 Tienen Tienen 38 50 60 46
13 Charleroi II Charleroi 38 41 58 44
14 Dessel Sport Dessel Sport 38 45 65 43
15 KVC Winkel Sport Winkel Sport 38 44 58 42
16 Hoogstraten Hoogstraten 38 46 60 41
17 Antwerp II Antwerp II 38 33 58 39
18 Ninove Ninove 38 39 75 35
19 Rupel Boom Rupel Boom 38 29 83 24
20 Mandel United Mandel 38 16 88 14
TEMPORADA 2021/2022
DIVISIÓN NACIONAL BELGA 1 GRUPO 2
Equipo PJ GF GC Puntos
1 FCV Dender FCV Dender 6 12 3 40
2 RFC Liège RFC Liège 6 12 7 36
3 Knokke Knokke 6 10 15 29
4 Dessel Sport Dessel Sport 6 9 18 26
TEMPORADA 2020/2021
DIVISIÓN NACIONAL BELGA 1
Equipo PJ GF GC Puntos
1 Thes Sport Thes Sport 3 7 3 9
2 Tienen Tienen 4 5 5 6
3 Heist Heist 2 3 2 4
4 Mandel United Mandel 3 6 4 3
5 KVC Winkel Sport Winkel Sport 2 4 2 3
6 Francs Borains Francs 1 2 1 3
7 Knokke Knokke 2 2 1 3
8 Visé Visé 2 3 3 3
9 Olympic Charleroi Olympic 2 1 1 3
10 Patro Eisden Patro Eisden 1 2 2 1
11 RFC Liège RFC Liège 1 0 0 1
12 Rupel Boom Rupel Boom 2 0 2 1
13 FCV Dender FCV Dender 0 0 0 0
14 Dessel Sport Dessel Sport 0 0 0 0
15 La Louvière Centre Louvière 2 1 5 0
16 KSV Roeselare Roeselare 1 0 5 0
TEMPORADA 2019/2020
DIVISIÓN NACIONAL BELGA 1
Equipo PJ GF GC Puntos
1 Deinze Deinze 24 52 16 62
2 Thes Sport Thes Sport 24 32 23 42
3 RFC Seraing RFC Seraing 23 42 27 40
4 Heist Heist 24 28 23 38
5 Patro Eisden Patro Eisden 24 25 23 36
6 RWD Molenbeek Molenbeek 24 26 25 34
7 FCV Dender FCV Dender 24 36 34 31
8 Dessel Sport Dessel Sport 24 29 29 31
9 Rupel Boom Rupel Boom 24 35 32 31
10 Olympic Charleroi Olympic 24 29 33 30
11 Visé Visé 24 32 36 30
12 RFC Liège RFC Liège 23 30 37 27
13 Lierse Kempenzonen Lierse 24 27 30 26
14 La Louvière Centre Louvière 24 36 49 26
15 Tubize Tubize 24 19 40 23
16 KVC Winkel Sport Winkel Sport 24 21 42 13
TEMPORADA 2018/2019
DIVISIÓN NACIONAL BELGA 1
Equipo PJ GF GC Puntos
1 Thes Sport Thes Sport 30 62 28 62
2 Deinze Deinze 30 53 30 59
3 Excelsior Virton Excelsior 30 42 20 54
4 Lierse Kempenzonen Lierse 30 42 36 48
5 Rupel Boom Rupel Boom 30 44 40 45
6 RFC Seraing RFC Seraing 30 46 40 41
7 RFC Liège RFC Liège 30 41 35 41
8 RWD Molenbeek Molenbeek 30 39 45 40
9 FCV Dender FCV Dender 30 42 40 40
10 Heist Heist 30 29 44 38
11 Châtelet Châtelet 30 30 37 36
12 Dessel Sport Dessel Sport 30 30 39 35
13 Oudenaarde Oudenaarde 30 37 59 34
14 Eendracht Aalst Eendracht 30 35 49 31
15 Geel-Meerhout Geel-Meerhou 30 42 62 31
16 Knokke Knokke 30 35 45 24
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
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 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 2010/2011
DIVISIÓN BELGA 2 GRUPO 2
Equipo PJ GF GC Puntos
1 WS Bruxelles Bruxelles 34 78 20 77
2 Excelsior Virton Excelsior 34 68 31 69
3 Woluwe Woluwe 34 58 40 64
4 Bertrix Bertrix 34 60 43 62
5 Union Saint-Gilloise Union 34 60 32 61
6 Bocholt Bocholt 34 52 28 60
7 La Louvière Centre Louvière 34 60 42 58
8 Olympic Charleroi Olympic 34 57 37 55
9 Sporting Hasselt Sporting 34 60 32 53
10 Diegem Sport Diegem Sport 34 51 47 49
11 Huy Huy 34 42 50 39
12 Charleroi Fleurus Charleroi 34 38 50 39
13 BX Brussels BX Brussels 34 34 66 35
14 Verviers Verviers 34 35 55 33
15 Grimbergen Grimbergen 34 40 53 31
16 Ternat Ternat 34 51 77 31
17 RFC Liège RFC Liège 34 33 79 17
18 Union Namur Union Namur 34 18 113 15
TEMPORADA 2009/2010
SEGUNDA DIVISIÓN BÉLGICA
Equipo PJ GF GC Puntos
1 Lierse SK Lierse SK 36 75 32 75
2 KVSK United KVSK United 36 55 27 70
3 Mons Mons 36 56 32 66
4 KAS Eupen KAS Eupen 36 56 37 60
5 RBD Borinage Borinage 36 46 43 53
6 Red Star Waasland Star 36 46 49 52
7 KV Oostende KV Oostende 36 49 45 51
8 Antwerp Antwerp 36 55 53 47
9 OH Leuven OH Leuven 36 50 66 45
10 Tournai Tournai 36 50 51 44
11 Standaard Wetteren Standaard 36 48 59 44
12 FCV Dender FCV Dender 36 45 49 43
13 Tienen Tienen 36 44 58 43
14 Tubize Tubize 36 41 41 42
15 Brussels Brussels 36 47 53 42
16 KFC Turnhout Turnhout 36 50 57 41
17 Ronse Ronse 36 51 57 39
18 KSK Beveren KSK Beveren 36 37 55 36
19 RFC Liège RFC Liège 36 23 60 23
TEMPORADA 2008/2009
SEGUNDA DIVISIÓN BÉLGICA
Equipo PJ GF GC Puntos
1 Sint-Truidense V.V. Sint-Truiden 36 72 29 80
2 Lierse SK Lierse SK 36 75 40 75
3 Antwerp Antwerp 36 55 32 61
4 Red Star Waasland Star 36 56 48 55
5 Tournai Tournai 36 53 41 54
6 Tienen Tienen 36 58 49 53
7 KV Oostende KV Oostende 36 54 51 53
8 Ronse Ronse 36 54 52 52
9 KVSK United KVSK United 36 48 38 51
10 Brussels Brussels 36 50 37 49
11 RFC Liège RFC Liège 36 49 48 48
12 OH Leuven OH Leuven 36 46 48 46
13 KSK Beveren KSK Beveren 36 47 57 45
14 KAS Eupen KAS Eupen 36 47 63 43
15 Excelsior Virton Excelsior 36 46 58 39
16 Olympic Charleroi Olympic 36 48 65 39
17 VW Hamme VW Hamme 36 48 64 36
18 Deinze Deinze 36 46 65 36
19 Union Namur Union Namur 36 22 89 13
TEMPORADA 2007/2008
DIVISIÓN BELGA 2 GRUPO 2
Equipo PJ GF GC Puntos
1 RFC Liège RFC Liège 28 47 21 66
2 KFC Turnhout Turnhout 28 45 19 59
3 WS Bruxelles Bruxelles 28 49 30 57
4 Cappellen Cappellen 28 54 25 56
5 Visé Visé 27 59 28 51
6 Wezel Wezel 27 42 41 43
7 Hamoir Hamoir 28 37 47 39
8 Bocholt Bocholt 28 32 40 36
9 Dessel Sport Dessel Sport 28 39 45 29
10 Tongeren Tongeren 28 27 45 29
11 RFC Seraing RFC Seraing 28 30 47 28
12 Veldwezelt Veldwezelt 28 26 42 26
13 Verviers Verviers 28 34 39 25
14 La Calamine La Calamine 28 28 54 22
15 Sprimont-Comblain Sprimont-Com 28 21 47 18
TEMPORADA 2006/2007
DIVISIÓN BELGA 2 GRUPO 2
Equipo PJ GF GC Puntos
1 Olympic Charleroi Olympic 30 49 29 57
2 Sprimont-Comblain Sprimont-Com 30 34 31 50
3 Union Namur Union Namur 29 55 35 49
4 WS Bruxelles Bruxelles 30 52 42 47
5 Charleroi Fleurus Charleroi 29 37 30 45
6 Tongeren Tongeren 30 50 45 44
7 Bocholt Bocholt 30 47 35 42
8 RFC Seraing RFC Seraing 30 48 40 41
9 Visé Visé 30 38 39 41
10 Verviers Verviers 30 39 41 38
11 RFC Liège RFC Liège 30 22 27 36
12 Francs Borains Francs 30 37 50 36
13 RAAL La Louviere RAAL 30 31 41 35
14 La Calamine La Calamine 30 27 44 35
15 Sporting Hasselt Sporting 30 41 59 31
16 Walhain Walhain 30 34 53 25
TEMPORADA 2003/2004
DIVISIÓN BELGA 2 GRUPO 1
Equipo PJ GF GC Puntos
1 Union Saint-Gilloise Union 30 56 24 60
2 Lommel SK Lommel SK 30 55 33 55
3 OH Leuven OH Leuven 30 43 23 53
4 Bocholt Bocholt 30 48 35 51
5 Veldwezelt Veldwezelt 29 41 38 46
6 Walhain Walhain 30 51 45 44
7 Union Namur Union Namur 30 38 45 37
8 Olympic Charleroi Olympic 30 43 47 36
9 Tongeren Tongeren 30 32 37 36
10 RFC Liège RFC Liège 30 43 43 35
11 Francs Borains Francs 30 33 38 35
12 Diegem Sport Diegem Sport 29 43 50 35
13 Sprimont-Comblain Sprimont-Com 30 39 45 34
14 RFC Seraing RFC Seraing 30 31 49 33
15 Tournai Tournai 30 30 49 31
16 Royal Spa Royal Spa 30 29 54 27

  USO DE MEMORIA  
7,679,680 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.6365
Total Execution Time  0.6384
  CADENA URL  
/historico/Liege
  GET DATOS  
$_GET['/historico/Liege']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0184  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 = '16875' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0152  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.0182  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=16875 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0152  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,68256) 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.0153  SELECT count(id) as num_players from rel_players WHERE league_id = 72091 AND teamId = 16875
0.0151  SELECT count(id) as num_players from rel_players WHERE league_id = 68256 AND teamId = 16875
0.0153  SELECT count(id) as num_players from rel_players WHERE league_id = 73206 AND teamId = 16875
0.0150  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 16875
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 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.0159  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 = 16875 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.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 = 72091 WHERE rp.league_id = 72091 AND rp.teamId = 16875 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0155  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 = 16875 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 = 16875 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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.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 = 68256 AND t.round = 38 ORDER BY team.conference ASC,t.position 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 `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 = 63431 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.0146  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 = 67463 AND t.round = 6 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 `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 = 58503 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.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 `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 = 50973 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.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 `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 = 44699 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.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 `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.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 = 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.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 `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.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 `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.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 `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.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 `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 = 24295 AND t.round = 34 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 `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 = 10158 AND t.round = 38 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 `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 = 10159 AND t.round = 38 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 `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 = 24304 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 `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 = 24307 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 `tables2004` 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 = 24310 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC