4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del US Sandweiler
TEMPORADA 2023/2024
TERCERA LUXEMBURGO GRUPO 2
Equipo PJ GF GC Puntos
1 US Sandweiler Sandweiler 27 78 22 69
2 Jeunesse Junglinster Jeunesse 26 71 41 52
3 FC Luxembourg City Luxembourg 26 78 41 51
4 Syra Mensdorf Syra 26 57 42 47
5 Kehlen Kehlen 26 67 51 44
6 Red Star Merl-Belair Star 26 40 35 43
7 The Belval Belvaux Belval 26 51 45 41
8 Schengen Schengen 26 46 41 37
9 Blo Weiss Itzig Weiss Itzig 25 38 43 34
10 Munsbach Munsbach 26 45 51 34
11 Union Kayl-Tétange Union 27 54 64 28
12 Red Black Egalité Black 26 42 64 26
13 Union Remich / Bous Union Remich 26 32 55 25
14 AS Luxembourg Luxembourg 26 36 61 24
15 Kopstal 33 Kopstal 33 25 28 60 20
16 Luna Obercorn Luna 26 40 87 10
TEMPORADA 2022/2023
TERCERA LUXEMBURGO GRUPO 2
Equipo PJ GF GC Puntos
1 Résidence Walferdange Résidence 30 86 36 74
2 Koeppchen Koeppchen 30 72 30 63
3 The Belval Belvaux Belval 30 83 42 62
4 Union Kayl-Tétange Union 30 75 60 59
5 US Sandweiler Sandweiler 30 69 47 56
6 Schengen Schengen 30 66 56 54
7 Syra Mensdorf Syra 30 63 49 53
8 CeBra 01 CeBra 01 30 71 60 47
9 Red Black Egalité Black 30 51 57 38
10 Union Remich / Bous Union Remich 30 55 62 35
11 Red Star Merl-Belair Star 30 49 57 35
12 Blo Weiss Itzig Weiss Itzig 30 35 53 35
13 Sporting Bertrange Sporting 30 44 71 22
14 Sanem Sanem 30 33 68 22
15 US Esch US Esch 30 32 69 20
16 Union Mertert Union 30 39 106 11
TEMPORADA 2021/2022
TERCERA LUXEMBURGO GRUPO 2
Equipo PJ GF GC Puntos
1 Grevenmacher Grevenmacher 30 100 28 72
2 CeBra 01 CeBra 01 30 66 25 63
3 Résidence Walferdange Résidence 30 72 34 61
4 Sporting Bertrange Sporting 30 60 40 54
5 Avenir Beggen Avenir 30 64 34 50
6 Union Kayl-Tétange Union 30 47 51 49
7 Syra Mensdorf Syra 30 59 53 47
8 Koeppchen Koeppchen 30 67 59 46
9 Sanem Sanem 30 58 49 44
10 Red Black Egalité Black 30 49 50 40
11 Blo Weiss Itzig Weiss Itzig 30 47 54 38
12 Union Remich / Bous Union Remich 30 59 69 33
13 Obercorn Obercorn 30 66 77 31
14 US Sandweiler Sandweiler 30 36 73 27
15 Stengefort Stengefort 30 30 86 21
16 Luna Obercorn Luna 30 25 123 8
TEMPORADA 2020/2021
TERCERA LUXEMBURGO GRUPO 2
Equipo PJ GF GC Puntos
1 Blo Weiss Itzig Weiss Itzig 8 15 7 19
2 Sporting Bertrange Sporting 8 19 9 18
3 Avenir Beggen Avenir 8 19 9 16
4 Steinfort Steinfort 8 14 9 15
5 Résidence Walferdange Résidence 8 14 11 12
6 Grevenmacher Grevenmacher 8 10 10 12
7 CeBra 01 CeBra 01 8 14 10 11
8 Sanem Sanem 8 15 12 11
9 Obercorn Obercorn 8 9 13 11
10 Luna Obercorn Luna 8 14 17 10
11 Red Black Egalité Black 8 15 14 9
12 Syra Mensdorf Syra 8 12 17 8
13 Koeppchen Koeppchen 8 12 19 7
14 US Sandweiler Sandweiler 8 14 22 7
15 Union Kayl-Tétange Union 8 7 13 6
16 Union Remich / Bous Union Remich 8 7 18 4
TEMPORADA 2019/2020
TERCERA LUXEMBURGO GRUPO 2
Equipo PJ GF GC Puntos
1 Bettembourg Bettembourg 15 52 14 37
2 Schifflangen Schifflangen 15 42 21 35
3 Berdenia Berbourg Berdenia 15 39 18 32
4 Grevenmacher Grevenmacher 15 45 18 30
5 Union Remich / Bous Union Remich 15 24 24 26
6 Koeppchen Koeppchen 15 32 22 24
7 Sanem Sanem 15 19 27 22
8 Union Kayl-Tétange Union 15 31 37 21
9 Steinfort Steinfort 15 28 27 19
10 Résidence Walferdange Résidence 15 29 42 17
11 Red Black Egalité Black 15 16 32 15
12 Avenir Beggen Avenir 15 16 26 13
13 Syra Mensdorf Syra 15 17 38 8
14 US Sandweiler Sandweiler 15 22 66 3
TEMPORADA 2018/2019
SEGUNDA LUXEMBURGO
Equipo PJ GF GC Puntos
1 FC Rodange 91 Rodange 26 58 18 61
2 Blue Boys Muhlenbach Blue Boys M. 26 55 25 59
3 Swift Hesperange Swift 26 73 27 55
4 US Esch US Esch 26 47 28 52
5 Käerjéng 97 Käerjéng 26 47 31 44
6 Wiltz 71 Wiltz 71 26 45 34 39
7 Union Mertert Union 26 41 41 35
8 Mamer Mamer 26 41 59 30
9 Jeunesse Junglinster Jeunesse 26 25 42 27
10 Jeunesse Canach Jeunesse 26 42 45 26
11 Erpeldange Erpeldange 26 42 63 26
12 Atert Bissen Atert Bissen 26 31 52 25
13 Koeppchen Koeppchen 26 24 65 15
14 US Sandweiler Sandweiler 26 31 72 14
TEMPORADA 2017/2018
SEGUNDA LUXEMBURGO
Equipo PJ GF GC Puntos
1 Etzella Ettelbruck Etzella 26 63 24 64
2 Rumelange Rumelange 26 57 28 62
3 Käerjéng 97 Käerjéng 26 71 38 53
4 Swift Hesperange Swift 26 55 46 44
5 Wiltz 71 Wiltz 71 26 62 35 42
6 Union Mertert Union 26 42 37 39
7 Blue Boys Muhlenbach Blue Boys M. 26 39 47 35
8 Jeunesse Canach Jeunesse 26 45 57 34
9 US Sandweiler Sandweiler 26 36 42 32
10 Erpeldange Erpeldange 26 39 50 30
11 Mamer Mamer 26 42 56 25
12 Norden Norden 26 38 62 24
13 Grevenmacher Grevenmacher 26 24 50 23
14 Union Kayl-Tétange Union 26 33 74 14
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
SEGUNDA LUXEMBURGO
Equipo PJ GF GC Puntos
1 FC Luxembourg City Luxembourg 26 90 17 68
2 Racing Union Racing Union 26 62 23 65
3 Una Strassen Strassen 26 72 32 61
4 FC Rodange 91 Rodange 26 48 40 46
5 Mamer Mamer 26 50 49 35
6 Swift Hesperange Swift 26 42 49 35
7 CS Pétange CS Pétange 26 35 45 35
8 Union Kayl-Tétange Union 26 35 38 33
9 Erpeldange Erpeldange 26 45 54 32
10 US Sandweiler Sandweiler 26 37 54 30
11 Titus Lamadelaine Titus 26 30 55 25
12 Mondercange Mondercange 26 31 54 21
13 CS Muhlenbach Lusitanos Muhlenbach 26 35 60 16
14 Minerva Lintgen Minerva 26 22 64 16
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
TERCERA LUXEMBURGO GRUPO 2
Equipo PJ GF GC Puntos
1 US Sandweiler Sandweiler 26 79 21 62
2 Steinfort Steinfort 26 47 28 53
3 US Esch US Esch 26 49 34 46
4 Avenir Beggen Avenir 26 48 31 39
5 Jeunesse Junglinster Jeunesse 26 43 41 38
6 Flaxweiler-Beyren Flaxweiler-B 26 47 46 38
7 Berdenia Berbourg Berdenia 26 41 38 37
8 The Belval Belvaux Belval 26 35 40 36
9 Yellow Boys Weiler Yellow Boys 26 28 30 33
10 CeBra 01 CeBra 01 26 38 56 31
11 Munsbach Munsbach 26 38 46 28
12 Clemency Clemency 26 25 49 26
13 Union Mertert Union 26 34 55 25
14 Schifflangen Schifflangen 26 25 62 15
TEMPORADA 2010/2011
TERCERA LUXEMBURGO GRUPO 2
Equipo PJ GF GC Puntos
1 Una Strassen Strassen 26 51 22 61
2 Mamer Mamer 26 46 18 52
3 Flaxweiler-Beyren Flaxweiler-B 26 47 22 48
4 US Sandweiler Sandweiler 26 46 31 46
5 CeBra 01 CeBra 01 26 37 46 40
6 US Esch US Esch 26 59 46 39
7 Clemency Clemency 26 47 42 35
8 The Belval Belvaux Belval 26 50 50 35
9 Union Mertert Union 26 44 35 34
10 Schifflangen Schifflangen 26 42 63 30
11 Munsbach Munsbach 26 31 48 26
12 Tricolore Gasperich Tricolore 26 39 58 25
13 Bettembourg Bettembourg 26 38 52 21
14 Sporting Bertrange Sporting 26 33 77 20
TEMPORADA 2009/2010
TERCERA LUXEMBURGO GRUPO 2
Equipo PJ GF GC Puntos
1 US Mondorf les Bains Mondorf 26 63 15 62
2 US Sandweiler Sandweiler 26 70 23 57
3 Una Strassen Strassen 26 54 24 57
4 Union Mertert Union 26 44 31 42
5 Flaxweiler-Beyren Flaxweiler-B 26 48 44 38
6 Munsbach Munsbach 26 44 38 35
7 CeBra 01 CeBra 01 26 39 56 33
8 Sporting Bertrange Sporting 26 36 48 31
9 Tricolore Gasperich Tricolore 26 41 50 30
10 Clemency Clemency 26 39 53 29
11 Bettembourg Bettembourg 26 32 44 27
12 FC Rodange 91 Rodange 26 41 58 27
13 Ehlerange Ehlerange 26 30 57 22
14 Sanem Sanem 26 25 65 14
TEMPORADA 2008/2009
TERCERA LUXEMBURGO GRUPO 2
Equipo PJ GF GC Puntos
1 Obercorn Obercorn 26 60 13 58
2 Union Kayl-Tétange Union 26 76 26 56
3 CeBra 01 CeBra 01 26 60 36 50
4 Una Strassen Strassen 26 51 39 44
5 US Mondorf les Bains Mondorf 26 43 27 42
6 FC Rodange 91 Rodange 26 47 43 40
7 US Sandweiler Sandweiler 26 42 41 37
8 Munsbach Munsbach 26 42 47 32
9 Ehlerange Ehlerange 26 35 47 32
10 Sporting Bertrange Sporting 26 37 52 32
11 Bettembourg Bettembourg 25 38 37 29
12 US Esch US Esch 25 23 38 28
13 Syra Mensdorf Syra 26 30 84 22
14 Union Remich / Bous Union Remich 26 28 82 13

  USO DE MEMORIA  
6,773,032 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1425
Total Execution Time  0.1437
  CADENA URL  
/historico/Us-Sandweiler
  GET DATOS  
$_GET['/historico/Us-Sandweiler']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (40)  
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 = 'Us-Sandweiler' 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.0018  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=12711 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=12711 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=12711 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0040  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 = 72501
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12711 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1643 AND type_rel = 3
0.0029  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 = '12711' ORDER BY l.year DESC,cat.coefficient DESC
0.0027  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 = '12711' 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 = '12711' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  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 = 72501 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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=12711 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0026  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,72501) 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.0030  SELECT count(id) as num_players from rel_players WHERE league_id = 72501 AND teamId = 12711
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 73657 AND teamId = 12711
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 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 = 72501 AND t.round = 27 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020  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 = '12711' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '12711' and rp.type = 4
0.0024  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 = '12711' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0023  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 = 72501 WHERE rp.league_id = 72501 AND rp.teamId = 12711 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.0019  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 = 72501 WHERE rp.league_id = 72501 AND rp.teamId = 12711 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0020  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 = 72501 WHERE rp.league_id = 72501 AND rp.teamId = 12711 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 = 12711 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72501 AND t.round = 27 ORDER BY team.conference ASC,t.position 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 `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 = 69250 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.0021  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 = 63504 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.0021  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 = 58343 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.0021  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 = 50625 AND t.round = 15 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 44303 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 38948 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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.0022  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.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 `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 = 9524 AND t.round = 26 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 `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.0022  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.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 `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 = 24758 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 24756 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 24754 AND t.round = 26 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 `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 = 24751 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 72501 ORDER BY nameShow LIMIT 100