4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Hamoir
TEMPORADA 2023/2024
DIVISIÓN BELGA 2 GRUPO 1
Equipo PJ GF GC Puntos
1 RAEC Mons RAEC Mons 32 68 22 79
2 Union Rochefortoise Union 32 62 37 65
3 Tournai Tournai 32 52 32 59
4 Tubize Tubize 31 57 32 57
5 Warnant Warnant 32 44 36 48
6 Binche Binche 32 42 42 48
7 La Louvière Centre Louvière 32 46 42 44
8 Stockay-Warfusée Stockay-Warf 32 54 48 44
9 Meux Meux 32 43 43 44
10 La Calamine La Calamine 32 50 52 41
11 Union Saint-Gilloise II Union 32 49 52 40
12 Verlaine Verlaine 32 48 52 39
13 Verviers Verviers 32 53 59 38
14 Ganshoren Ganshoren 32 39 53 35
15 Jette Jette 32 32 52 35
16 Acren Lessines Acren 31 46 64 30
17 Hamoir Hamoir 32 29 65 23
18 Rebecq Rebecq 32 37 68 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
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
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 2009/2010
PROMOCIÓN BÉLGICA GRUPO 4
Equipo PJ GF GC Puntos
1 Bertrix Bertrix 30 68 26 73
2 Ciney Ciney 30 65 43 57
3 RFC Seraing RFC Seraing 30 60 35 54
4 Huy Huy 30 62 44 54
5 Walhain Walhain 30 51 38 45
6 Givry Givry 30 58 54 45
7 Jeunesse Tamines Jeunesse 30 60 53 42
8 Aywaille Aywaille 30 53 49 42
9 Sprimont-Comblain Sprimont-Com 30 48 46 40
10 Hamoir Hamoir 30 46 50 40
11 Wanze / Bas-Oha Wanze 30 48 55 36
12 Hannutois Hannutois 30 38 51 35
13 Racing Jet Wavre Racing Wavre 30 48 60 34
14 Lorraine Arlon Lorraine 30 44 72 29
15 Aische Aische 30 36 61 25
16 Petit-Waret Petit-Waret 30 28 76 19
TEMPORADA 2008/2009
DIVISIÓN BELGA 2 GRUPO 2
Equipo PJ GF GC Puntos
1 KFC Turnhout Turnhout 30 50 18 67
2 Visé Visé 30 61 34 59
3 Racing Mechelen Racing 30 55 44 51
4 Wuustwezel Wuustwezel 30 51 50 51
5 Rupel Boom Rupel Boom 30 57 37 49
6 Willebroek-Meerhof Willebroek-M 30 47 34 49
7 Bocholt Bocholt 30 52 39 45
8 Hoogstraten Hoogstraten 30 49 49 41
9 Veldwezelt Veldwezelt 30 45 46 38
10 Verviers Verviers 29 33 37 34
11 Tongeren Tongeren 29 36 50 33
12 Cappellen Cappellen 30 33 43 32
13 Hamoir Hamoir 30 46 55 30
14 Dessel Sport Dessel Sport 30 37 57 30
15 RFC Seraing RFC Seraing 30 22 45 26
16 La Calamine La Calamine 30 26 62 19
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

  USO DE MEMORIA  
7,268,928 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.3795
Total Execution Time  0.3807
  CADENA URL  
/historico/Hamoir
  GET DATOS  
$_GET['/historico/Hamoir']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0031  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 = 'Hamoir' 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=16867 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=16867 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=16867 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0061  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 = 72463
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=16867 AND type_rel = 2
0.0036  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 = '16867' ORDER BY l.year DESC,cat.coefficient DESC
0.0023  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 = '16867' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0023  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 = '16867' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0023  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=16867 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,72463) 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.0072  SELECT count(id) as num_players from rel_players WHERE league_id = 72463 AND teamId = 16867
0.0029  SELECT count(id) as num_players from rel_players WHERE league_id = 73206 AND teamId = 16867
0.0021  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 = '16867' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '16867' and rp.type = 4
0.0021  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 = '16867' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 72463 WHERE rp.league_id = 72463 AND rp.teamId = 16867 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.0032  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 = 16867 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0032  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 = 16867 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  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 = 16867 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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.0053  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.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 `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.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 `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.0043  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.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 `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.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 `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.0031  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.0067  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.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 `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.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 `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.0028  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.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 `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.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 `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.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 `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 = 27978 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034  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 = 24301 AND t.round = 30 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 `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.0022  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 72463 ORDER BY nameShow LIMIT 100