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

US Hostert

Entrenador: Henri Bossi

Temporada 2023/2024
TEMPORADA 2023/2024
SEGUNDA LUXEMBURGO
Equipo PJ GF GC Puntos
1 Bettembourg Bettembourg 26 62 34 54
2 FC Rodange 91 Rodange 26 56 40 48
3 Etzella Ettelbruck Etzella 26 36 26 40
4 Rumelange Rumelange 26 46 43 40
5 Mamer Mamer 26 50 37 38
6 US Hostert US Hostert 26 57 48 38
7 Résidence Walferdange Résidence 26 52 49 35
8 Koeppchen Koeppchen 26 35 39 34
9 Grevenmacher Grevenmacher 26 48 52 33
10 Avenir Beggen Avenir 26 35 45 33
11 Jeunesse Canach Jeunesse 26 33 43 33
12 Alisontia Steinsel Alisontia 26 41 48 32
13 Berdenia Berbourg Berdenia 26 31 39 32
14 Yellow Boys Weiler Yellow Boys 26 50 61 32
15 Lorentzweiler Lorentzweile 26 39 45 31
16 Blô-Weiss Medernach Blô-Weiss 26 36 58 22
TEMPORADA 2022/2023
LIGA LUXEMBURGO
Equipo PJ GF GC Puntos
1 Swift Hesperange Swift 30 100 28 77
2 Progrès Niederkorn Progrès 30 67 31 70
3 F91 Dudelange Dudelange 30 86 38 67
4 Union Titus Pétange Union Titus 30 62 38 59
5 Differdange 03 Differdange 30 60 43 45
6 US Mondorf les Bains Mondorf 30 52 52 45
7 Jeunesse d'Esch Jeunesse 30 44 39 43
8 Racing Union Racing Union 30 43 39 43
9 Una Strassen Strassen 30 33 46 39
10 Wiltz 71 Wiltz 71 30 48 59 36
11 Victoria Rosport Victoria 30 48 58 32
12 Mondercange Mondercange 30 41 55 29
13 Fola Esch Fola Esch 30 36 71 26
14 Käerjéng 97 Käerjéng 30 30 69 25
15 Etzella Ettelbruck Etzella 30 32 71 23
16 US Hostert US Hostert 30 20 65 18
TEMPORADA 2021/2022
LIGA LUXEMBURGO
Equipo PJ GF GC Puntos
1 F91 Dudelange Dudelange 30 78 27 67
2 Differdange 03 Differdange 30 58 28 62
3 Fola Esch Fola Esch 30 64 37 62
4 Swift Hesperange Swift 30 61 26 60
5 Progrès Niederkorn Progrès 30 68 37 55
6 Una Strassen Strassen 30 53 36 51
7 Racing Union Racing Union 30 56 48 49
8 Jeunesse d'Esch Jeunesse 30 44 30 47
9 US Mondorf les Bains Mondorf 30 38 44 37
10 Etzella Ettelbruck Etzella 30 45 66 37
11 Union Titus Pétange Union Titus 30 40 41 35
12 Victoria Rosport Victoria 30 45 59 33
13 Wiltz 71 Wiltz 71 30 42 53 31
14 US Hostert US Hostert 30 42 63 30
15 FC Rodange 91 Rodange 30 23 70 19
16 FC Luxembourg City Luxembourg 30 13 105 4
TEMPORADA 2020/2021
LIGA LUXEMBURGO
Equipo PJ GF GC Puntos
1 Fola Esch Fola Esch 30 89 35 68
2 F91 Dudelange Dudelange 30 70 29 66
3 Swift Hesperange Swift 30 72 30 65
4 Racing Union Racing Union 30 47 29 54
5 Progrès Niederkorn Progrès 30 48 30 53
6 Differdange 03 Differdange 30 51 48 45
7 Wiltz 71 Wiltz 71 30 45 42 44
8 Jeunesse d'Esch Jeunesse 30 41 43 43
9 US Hostert US Hostert 30 47 56 37
10 Una Strassen Strassen 30 44 65 35
11 US Mondorf les Bains Mondorf 30 33 56 28
12 FC Rodange 91 Rodange 30 27 52 28
13 Victoria Rosport Victoria 30 37 67 27
14 FC Luxembourg City Luxembourg 30 33 48 26
15 Etzella Ettelbruck Etzella 30 32 57 24
16 Union Titus Pétange Union Titus 30 23 52 21
TEMPORADA 2019/2020
LIGA LUXEMBURGO
Equipo PJ GF GC Puntos
1 Fola Esch Fola Esch 17 41 17 39
2 Progrès Niederkorn Progrès 17 43 17 37
3 Differdange 03 Differdange 17 36 25 35
4 Union Titus Pétange Union Titus 17 34 23 33
5 F91 Dudelange Dudelange 17 38 24 26
6 Una Strassen Strassen 17 30 26 26
7 Racing Union Racing Union 17 32 27 25
8 Jeunesse d'Esch Jeunesse 17 24 34 19
9 Victoria Rosport Victoria 17 23 35 18
10 Etzella Ettelbruck Etzella 17 22 34 17
11 US Hostert US Hostert 17 17 37 16
12 US Mondorf les Bains Mondorf 17 22 28 15
13 FC Rodange 91 Rodange 17 21 37 15
14 Blue Boys Muhlenbach Blue Boys M. 17 20 39 12
TEMPORADA 2018/2019
LIGA LUXEMBURGO
Equipo PJ GF GC Puntos
1 F91 Dudelange Dudelange 26 72 33 59
2 Fola Esch Fola Esch 26 65 28 50
3 Jeunesse d'Esch Jeunesse 26 46 30 48
4 Progrès Niederkorn Progrès 26 45 35 44
5 Differdange 03 Differdange 26 35 33 44
6 Racing Union Racing Union 26 42 31 39
7 Una Strassen Strassen 26 46 43 39
8 Union Titus Pétange Union Titus 26 38 43 37
9 US Mondorf les Bains Mondorf 26 39 39 35
10 Etzella Ettelbruck Etzella 26 31 44 28
11 Victoria Rosport Victoria 26 33 49 28
12 US Hostert US Hostert 26 37 58 25
13 FC Luxembourg City Luxembourg 26 29 50 19
14 Rumelange Rumelange 26 34 76 16
TEMPORADA 2017/2018
LIGA LUXEMBURGO
Equipo PJ GF GC Puntos
1 F91 Dudelange Dudelange 26 81 26 68
2 Progrès Niederkorn Progrès 26 72 28 63
3 Fola Esch Fola Esch 26 72 41 47
4 Jeunesse d'Esch Jeunesse 26 52 35 44
5 Differdange 03 Differdange 26 48 38 38
6 US Mondorf les Bains Mondorf 26 40 36 38
7 Racing Union Racing Union 26 41 40 35
8 US Hostert US Hostert 26 37 46 34
9 Union Titus Pétange Union Titus 26 43 51 31
10 FC Luxembourg City Luxembourg 26 30 45 30
11 Una Strassen Strassen 26 38 60 29
12 Victoria Rosport Victoria 26 37 59 26
13 FC Rodange 91 Rodange 26 27 55 22
14 US Esch US Esch 26 15 73 4
TEMPORADA 2016/2017
SEGUNDA LUXEMBURGO
Equipo PJ GF GC Puntos
1 US Esch US Esch 26 57 31 58
2 FC Rodange 91 Rodange 26 61 40 55
3 US Hostert US Hostert 26 64 31 50
4 Etzella Ettelbruck Etzella 26 56 30 48
5 Swift Hesperange Swift 26 49 41 42
6 Wiltz 71 Wiltz 71 26 41 34 42
7 US Sandweiler Sandweiler 26 46 45 38
8 Mamer Mamer 26 41 43 36
9 Norden Norden 26 41 44 34
10 Union Mertert Union 26 41 53 34
11 Grevenmacher Grevenmacher 26 31 36 27
12 Mondercange Mondercange 26 31 54 27
13 Atert Bissen Atert Bissen 26 29 55 18
14 Avenir Beggen Avenir 26 23 74 6
TEMPORADA 2015/2016
SEGUNDA LUXEMBURGO
Equipo PJ GF GC Puntos
1 Käerjéng 97 Käerjéng 26 58 26 59
2 Union Titus Pétange Union Titus 26 60 28 58
3 Jeunesse Canach Jeunesse 26 52 29 50
4 US Hostert US Hostert 26 47 29 43
5 FC Rodange 91 Rodange 26 39 37 42
6 Norden Norden 26 41 46 40
7 Mondercange Mondercange 26 48 52 36
8 Mamer Mamer 26 34 38 33
9 Swift Hesperange Swift 26 37 37 32
10 US Sandweiler Sandweiler 26 39 49 30
11 Avenir Beggen Avenir 26 39 49 28
12 Erpeldange Erpeldange 26 32 50 26
13 Union Kayl-Tétange Union 26 37 47 23
14 Union Remich / Bous Union Remich 26 20 66 11
TEMPORADA 2014/2015
LIGA LUXEMBURGO
Equipo PJ GF GC Puntos
1 Fola Esch Fola Esch 26 63 21 61
2 Differdange 03 Differdange 26 61 31 59
3 F91 Dudelange Dudelange 26 54 20 54
4 Progrès Niederkorn Progrès 26 51 29 50
5 Jeunesse d'Esch Jeunesse 26 46 34 44
6 Victoria Rosport Victoria 26 36 46 31
7 Etzella Ettelbruck Etzella 26 36 50 30
8 US Mondorf les Bains Mondorf 26 30 40 29
9 Grevenmacher Grevenmacher 26 24 48 29
10 Rumelange Rumelange 26 29 38 28
11 Wiltz 71 Wiltz 71 26 29 38 27
12 Käerjéng 97 Käerjéng 26 33 51 27
13 US Hostert US Hostert 26 35 52 23
14 Jeunesse Canach Jeunesse 26 16 45 15
TEMPORADA 2013/2014
SEGUNDA LUXEMBURGO
Equipo PJ GF GC Puntos
1 Victoria Rosport Victoria 26 78 24 67
2 US Hostert US Hostert 26 65 41 53
3 US Mondorf les Bains Mondorf 26 54 26 51
4 FC Rodange 91 Rodange 26 67 38 50
5 Union 05 Union 05 26 42 29 48
6 CS Muhlenbach Lusitanos Muhlenbach 26 45 52 38
7 CS Pétange CS Pétange 26 38 42 35
8 Una Strassen Strassen 26 60 51 33
9 US Sandweiler Sandweiler 26 51 49 33
10 Erpeldange Erpeldange 26 42 48 29
11 Jeunesse Junglinster Jeunesse 26 29 51 26
12 FC Alliance Aischdall HE Alliance 26 24 57 19
13 Norden Norden 26 35 79 19
14 Marisca Miersch Marisca 26 30 73 15
TEMPORADA 2012/2013
SEGUNDA LUXEMBURGO
Equipo PJ GF GC Puntos
1 Swift Hesperange Swift 26 67 19 60
2 Rumelange Rumelange 26 55 31 56
3 Una Strassen Strassen 26 57 30 55
4 Victoria Rosport Victoria 26 64 30 52
5 US Sandweiler Sandweiler 26 64 40 46
6 US Hostert US Hostert 26 48 42 44
7 Erpeldange Erpeldange 26 54 55 38
8 Norden Norden 26 38 49 33
9 FC Alliance Aischdall HE Alliance 26 34 49 29
10 US Mondorf les Bains Mondorf 26 43 37 28
11 Obercorn Obercorn 26 38 55 26
12 Mondercange Mondercange 26 29 56 23
13 Mamer Mamer 26 29 58 20
14 Young Boys Young Boys 26 18 87 3
TEMPORADA 2011/2012
LIGA LUXEMBURGO
Equipo PJ GF GC Puntos
1 F91 Dudelange Dudelange 26 67 20 54
2 Jeunesse d'Esch Jeunesse 26 56 37 51
3 Grevenmacher Grevenmacher 26 50 27 49
4 Differdange 03 Differdange 26 64 26 48
5 Käerjéng 97 Käerjéng 26 37 35 43
6 Fola Esch Fola Esch 26 41 30 38
7 FC Luxembourg City Luxembourg 26 54 47 38
8 CS Pétange CS Pétange 26 29 37 36
9 Progrès Niederkorn Progrès 26 32 35 33
10 Racing Union Racing Union 26 40 41 32
11 Union Kayl-Tétange Union 26 39 51 29
12 Swift Hesperange Swift 26 34 53 26
13 Rumelange Rumelange 26 27 71 19
14 US Hostert US Hostert 26 22 82 8
TEMPORADA 2010/2011
SEGUNDA LUXEMBURGO
Equipo PJ GF GC Puntos
1 Union Kayl-Tétange Union 26 59 31 62
2 Rumelange Rumelange 26 47 22 62
3 US Hostert US Hostert 26 50 32 52
4 Victoria Rosport Victoria 26 61 39 49
5 Obercorn Obercorn 26 50 30 47
6 Young Boys Young Boys 26 42 39 40
7 Erpeldange Erpeldange 26 57 46 37
8 Mondercange Mondercange 26 40 34 34
9 US Mondorf les Bains Mondorf 26 34 46 25
10 Koeppchen Koeppchen 26 32 46 25
11 Steinfort Steinfort 26 24 45 23
12 Green Boys Green Boys 26 31 67 21
13 Avenir Beggen Avenir 26 30 54 19
14 Minerva Lintgen Minerva 26 25 51 16
TEMPORADA 2009/2010
SEGUNDA LUXEMBURGO
Equipo PJ GF GC Puntos
1 Wiltz 71 Wiltz 71 26 66 39 55
2 Jeunesse Canach Jeunesse 26 53 29 51
3 Obercorn Obercorn 26 53 27 48
4 Steinfort Steinfort 26 53 32 46
5 Erpeldange Erpeldange 26 53 40 43
6 Victoria Rosport Victoria 26 48 40 39
7 Koeppchen Koeppchen 26 43 42 36
8 Young Boys Young Boys 26 52 50 35
9 Avenir Beggen Avenir 26 36 37 34
10 Union Kayl-Tétange Union 26 48 50 34
11 Minerva Lintgen Minerva 26 42 46 32
12 US Hostert US Hostert 26 41 57 30
13 Jeunesse Schieren Jeunesse 26 32 60 16
14 Colmarberg Colmarberg 26 15 86 10
TEMPORADA 2008/2009
SEGUNDA LUXEMBURGO
Equipo PJ GF GC Puntos
1 CS Pétange CS Pétange 26 44 22 51
2 Mondercange Mondercange 26 53 22 49
3 Erpeldange Erpeldange 26 39 30 45
4 US Hostert US Hostert 26 49 44 44
5 Minerva Lintgen Minerva 26 35 32 37
6 Wiltz 71 Wiltz 71 26 44 40 36
7 Jeunesse Canach Jeunesse 26 39 39 36
8 Victoria Rosport Victoria 26 39 48 35
9 Koeppchen Koeppchen 26 33 42 34
10 Colmarberg Colmarberg 26 31 45 34
11 Flaxweiler-Beyren Flaxweiler-B 26 45 44 33
12 Union Mertert Union 26 34 45 26
13 Sporting Mertzig Sporting 26 29 44 25
14 Atert Bissen Atert Bissen 26 34 51 22
TEMPORADA 2006/2007
SEGUNDA LUXEMBURGO
Equipo PJ GF GC Puntos
1 FC Luxembourg City Luxembourg 26 59 23 57
2 Avenir Beggen Avenir 26 52 23 50
3 Fola Esch Fola Esch 26 38 29 45
4 Rumelange Rumelange 26 49 37 43
5 Union Mertert Union 26 42 31 43
6 Steinfort Steinfort 26 43 39 42
7 Obercorn Obercorn 26 44 38 40
8 Erpeldange Erpeldange 26 47 51 36
9 Sporting Mertzig Sporting 26 42 41 35
10 Jeunesse Canach Jeunesse 26 34 50 35
11 Koeppchen Koeppchen 26 40 53 33
12 CeBra 01 CeBra 01 26 36 47 26
13 US Hostert US Hostert 26 38 59 18
14 Jeunesse Schieren Jeunesse 26 26 69 13

  USO DE MEMORIA  
7,037,784 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6445
Total Execution Time  0.6458
  CADENA URL  
/historico/Us-Hostert
  GET DATOS  
$_GET['/historico/Us-Hostert']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (40)  
0.0140  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 = 'Us-Hostert' 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.0128  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=12704 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128  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=12704 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130  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=12704 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0132  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=12704 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0277  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 = 72217
0.0131  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12704 AND type_rel = 2
0.0134  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 12704 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0136  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 (548131,708335) ORDER BY n.cover_points DESC, update_date DESC
0.0148  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 = '12704' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0135  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 = '12704' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0128  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 = 72217 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0132  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=12704 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0127  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 (73657,72217,71432,68175) 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.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 68175 AND teamId = 12704
0.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 72217 AND teamId = 12704
0.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 73657 AND teamId = 12704
0.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 12704
0.0134  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 = 72217 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0144  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 = 72217 WHERE rp.league_id = 72217 AND rp.teamId = 12704 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.0133  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 = 72217 WHERE rp.league_id = 72217 AND rp.teamId = 12704 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0131  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 = 72217 WHERE rp.league_id = 72217 AND rp.teamId = 12704 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0131  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 = 12704 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0131  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 = 72217 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 68175 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.0130  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 = 63247 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.0129  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 = 57007 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.0129  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 = 50102 AND t.round = 17 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 43573 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 38647 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 33790 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 15637 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 3896 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 2787 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 16223 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 10710 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 16225 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 16226 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 = 16227 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 16229 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC