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

US Mondorf les Bains

Entrenador: Manuel Correia

Temporada 2019/2020
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
LIGA LUXEMBURGO
Equipo PJ GF GC Puntos
1 F91 Dudelange Dudelange 26 68 14 65
2 Differdange 03 Differdange 26 65 21 65
3 Fola Esch Fola Esch 26 69 34 56
4 Progrès Niederkorn Progrès 26 57 38 44
5 Una Strassen Strassen 26 39 47 37
6 Union Titus Pétange Union Titus 26 38 33 35
7 US Mondorf les Bains Mondorf 26 29 45 30
8 Jeunesse d'Esch Jeunesse 26 38 49 29
9 Victoria Rosport Victoria 26 38 54 28
10 Racing Union Racing Union 26 38 52 27
11 FC Luxembourg City Luxembourg 26 29 47 26
12 Jeunesse Canach Jeunesse 26 30 54 23
13 Rumelange Rumelange 26 29 53 23
14 Käerjéng 97 Käerjéng 26 37 63 22
TEMPORADA 2015/2016
LIGA LUXEMBURGO
Equipo PJ GF GC Puntos
1 F91 Dudelange Dudelange 26 65 21 62
2 Fola Esch Fola Esch 26 61 23 62
3 Differdange 03 Differdange 26 63 32 55
4 Jeunesse d'Esch Jeunesse 26 48 30 46
5 Una Strassen Strassen 26 50 50 38
6 Progrès Niederkorn Progrès 26 41 30 36
7 US Mondorf les Bains Mondorf 26 36 34 36
8 Racing Union Racing Union 26 45 54 35
9 FC Luxembourg City Luxembourg 26 52 49 34
10 Rumelange Rumelange 26 38 52 28
11 Victoria Rosport Victoria 26 46 49 26
12 Wiltz 71 Wiltz 71 26 22 60 21
13 Etzella Ettelbruck Etzella 26 25 70 17
14 Grevenmacher Grevenmacher 26 15 53 13
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
SEGUNDA LUXEMBURGO
Equipo PJ GF GC Puntos
1 Jeunesse Canach Jeunesse 26 57 19 57
2 Etzella Ettelbruck Etzella 26 76 26 56
3 Wiltz 71 Wiltz 71 26 67 37 52
4 Victoria Rosport Victoria 26 60 48 39
5 Mondercange Mondercange 26 51 49 38
6 Norden Norden 26 37 36 37
7 US Mondorf les Bains Mondorf 26 35 43 37
8 Mamer Mamer 26 33 41 34
9 Una Strassen Strassen 26 43 44 33
10 Erpeldange Erpeldange 26 43 47 33
11 Obercorn Obercorn 26 44 50 29
12 Young Boys Young Boys 26 26 61 26
13 CS Muhlenbach Lusitanos Muhlenbach 26 23 55 19
14 Koeppchen Koeppchen 26 25 64 19
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
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,246,312 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1139
Total Execution Time  0.1151
  CADENA URL  
/historico/Us-Mondorf-Les-Bains/2020
  GET DATOS  
$_GET['/historico/Us-Mondorf-Les-Bains/2020']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (32)  
0.0033  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-Mondorf-Les-Bains' AND l.year = 2020 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=12709 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=12709 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=12709 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0039  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 = 50102
0.0025  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 = 51122
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12709 AND type_rel = 2
0.0022  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 12709 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0021  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 (734448) ORDER BY n.cover_points DESC, update_date DESC
0.0033  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 = '12709' AND l.year = 2020 ORDER BY l.year DESC,cat.coefficient DESC
0.0031  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 = '12709' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = 50102 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  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 = 51122 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0034  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=12709 AND l.year in (2019,2020,2021) 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 (58622,57007) 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.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 57007 AND teamId = 12709
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 58622 AND teamId = 12709
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 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0039  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 events2020 e ON e.player_id = p.id AND e.league_id = 50102 WHERE rp.league_id = 50102 AND rp.teamId = 12709 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 events2020 e ON e.player_id = p.id AND e.league_id = 50102 WHERE rp.league_id = 50102 AND rp.teamId = 12709 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 events2020 e ON e.player_id = p.id AND e.league_id = 50102 WHERE rp.league_id = 50102 AND rp.teamId = 12709 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  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 = 12709 AND l.year <= 2020 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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.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 `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.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 `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.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 = 33540 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 `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 = 15496 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 = 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.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 `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.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 `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.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 `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 = 16224 AND t.round = 26 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 `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