4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Marchfeld
TEMPORADA 2023/2024
TERCERA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 Rapid Wien II Rapid Wien 25 55 23 53
2 Donaufeld Donaufeld 25 57 30 46
3 Leobendorf Leobendorf 25 48 30 45
4 Kremser SC Kremser SC 25 38 28 43
5 Marchfeld Marchfeld 25 39 36 40
6 SC Wiener Viktoria Wiener 25 45 38 39
7 Wiener SC Wiener SC 25 43 34 36
8 Austria Wien II Austria Wien 25 40 32 36
9 FCM Traiskirchen Traiskirchen 25 50 42 32
10 Oberwart / Rotenturm Oberwart 25 28 42 30
11 Elektra Elektra 25 26 34 29
12 Neusiedl Neusiedl 25 32 50 29
13 Favoritner AC Favoritner 25 28 43 27
14 Ardagger Ardagger 25 17 31 21
15 Mauerwerk Mauerwerk 25 22 51 19
16 Drassburg Drassburg 25 31 55 19
TEMPORADA 2022/2023
TERCERA AUSTRIA GRUPO 5
Equipo PJ GF GC Puntos
1 Stripfing Stripfing 30 86 20 72
2 Elektra Elektra 30 55 32 59
3 Donaufeld Donaufeld 30 56 41 52
4 Wiener SC Wiener SC 30 43 30 49
5 FCM Traiskirchen Traiskirchen 30 44 37 47
6 Marchfeld Marchfeld 30 56 52 47
7 Kremser SC Kremser SC 30 47 51 44
8 Leobendorf Leobendorf 30 38 39 42
9 Mauerwerk Mauerwerk 30 52 63 41
10 SC Wiener Viktoria Wiener 30 47 51 39
11 Drassburg Drassburg 30 40 49 39
12 Neusiedl Neusiedl 30 49 45 38
13 Siegendorf Siegendorf 30 35 43 36
14 Scheiblingkirchen-Warth Scheiblingki 30 44 48 34
15 Wiener Neustadt Wiener 30 37 67 22
16 Bruck/Leitha Bruck/Leitha 30 19 80 12
TEMPORADA 2021/2022
TERCERA AUSTRIA GRUPO 5
Equipo PJ GF GC Puntos
1 First Vienna First Vienna 26 52 18 58
2 Stripfing Stripfing 26 60 19 54
3 Wiener SC Wiener SC 26 48 32 46
4 Leobendorf Leobendorf 26 45 37 45
5 Neusiedl Neusiedl 26 39 37 41
6 Elektra Elektra 26 33 31 41
7 Marchfeld Marchfeld 26 44 41 40
8 SC Wiener Viktoria Wiener 26 36 36 38
9 FCM Traiskirchen Traiskirchen 26 41 42 35
10 Bruck/Leitha Bruck/Leitha 26 43 44 27
11 Mauerwerk Mauerwerk 26 29 56 23
12 Admira Wacker II Admira 26 33 53 19
13 Wiener Neustadt Wiener 26 31 55 19
14 Drassburg Drassburg 26 22 55 16
TEMPORADA 2020/2021
TERCERA AUSTRIA GRUPO 1
Equipo PJ GF GC Puntos
1 Wiener SC Wiener SC 8 13 4 19
2 Bruck/Leitha Bruck/Leitha 9 24 11 18
3 Leobendorf Leobendorf 7 16 9 18
4 FCM Traiskirchen Traiskirchen 9 20 9 16
5 Team Wiener Linien Team Wiener 8 14 7 15
6 Stripfing Stripfing 6 10 4 15
7 Marchfeld Marchfeld 8 13 12 11
8 Admira Wacker II Admira 7 10 9 11
9 SC Wiener Viktoria Wiener 10 8 21 7
10 Mauerwerk Mauerwerk 8 7 18 6
11 Neusiedl Neusiedl 8 6 17 6
12 Drassburg Drassburg 9 12 22 5
13 Wiener Neustadt Wiener 7 2 12 4
TEMPORADA 2019/2020
TERCERA AUSTRIA GRUPO 1
Equipo PJ GF GC Puntos
1 Marchfeld Marchfeld 18 34 15 42
2 Rapid Wien II Rapid Wien 18 32 13 37
3 Ebreichsdorf Ebreichsdorf 18 28 11 34
4 Wiener SC Wiener SC 18 37 27 30
5 Stripfing Stripfing 18 24 16 30
6 Team Wiener Linien Team Wiener 18 23 20 27
7 SC Wiener Viktoria Wiener 18 31 30 27
8 Mattersburg II Mattersburg 18 30 25 25
9 Drassburg Drassburg 18 25 30 25
10 Wiener Neustadt Wiener 18 29 34 23
11 Neusiedl Neusiedl 18 25 35 23
12 Mauerwerk Mauerwerk 18 25 32 20
13 Bruck/Leitha Bruck/Leitha 18 24 35 19
14 FCM Traiskirchen Traiskirchen 18 25 34 16
15 Admira Wacker II Admira 18 20 28 14
16 Leobendorf Leobendorf 18 11 38 9
TEMPORADA 2018/2019
TERCERA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 Ebreichsdorf Ebreichsdorf 30 90 20 72
2 Karabakh Wien Karabakh 30 64 29 65
3 Marchfeld Marchfeld 30 61 36 57
4 Wiener SC Wiener SC 30 57 47 55
5 Leobendorf Leobendorf 30 43 27 51
6 Rapid Wien II Rapid Wien 30 53 38 47
7 Neusiedl Neusiedl 30 52 55 42
8 FCM Traiskirchen Traiskirchen 30 52 56 40
9 Bruck/Leitha Bruck/Leitha 30 45 57 40
10 Mattersburg II Mattersburg 30 45 57 36
11 Admira Wacker II Admira 30 45 59 36
12 Team Wiener Linien Team Wiener 29 43 49 34
13 Parndorf Parndorf 30 43 52 32
14 St. Pölten II Pölten 29 34 56 26
15 Stadlau Stadlau 30 37 68 23
16 Schwechat Schwechat 30 22 80 10
TEMPORADA 2017/2018
TERCERA AUSTRIA GRUPO 1
Equipo PJ GF GC Puntos
1 Horn Horn 31 62 25 68
2 Ebreichsdorf Ebreichsdorf 31 58 27 63
3 SKU Amstetten Amstetten 31 69 30 62
4 Austria Wien II Austria Wien 31 61 36 60
5 Karabakh Wien Karabakh 31 65 46 59
6 Rapid Wien II Rapid Wien 31 58 48 49
7 Marchfeld Marchfeld 31 50 46 49
8 FCM Traiskirchen Traiskirchen 31 37 46 44
9 Bruck/Leitha Bruck/Leitha 31 49 57 40
10 Stadlau Stadlau 31 35 43 35
11 Admira Wacker II Admira 31 44 53 32
12 Neusiedl Neusiedl 30 38 58 32
13 Parndorf Parndorf 31 37 61 30
14 St. Pölten II Pölten 31 37 52 29
15 Wiener SC Wiener SC 31 40 63 29
16 Schwechat Schwechat 31 26 69 18
17 First Vienna First Vienna 15 17 23 13
TEMPORADA 2016/2017
TERCERA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 First Vienna First Vienna 28 61 20 65
2 Ritzing Ritzing 28 59 37 51
3 Austria Wien II Austria Wien 28 41 29 50
4 Stadlau Stadlau 28 39 24 44
5 Marchfeld Marchfeld 28 47 45 44
6 Ebreichsdorf Ebreichsdorf 28 51 53 41
7 SKU Amstetten Amstetten 28 42 32 39
8 FCM Traiskirchen Traiskirchen 28 39 40 38
9 Parndorf Parndorf 28 38 41 37
10 Rapid Wien II Rapid Wien 28 49 44 36
11 Admira Wacker II Admira 28 39 42 28
12 Wiener SC Wiener SC 28 30 33 28
13 Neusiedl Neusiedl 28 33 58 25
14 St. Pölten II Pölten 28 30 62 24
15 Schwechat Schwechat 28 25 63 20
TEMPORADA 2015/2016
CUARTA AUSTRIA GRUPO 4
Equipo PJ GF GC Puntos
1 Marchfeld Marchfeld 30 73 30 68
2 Leobendorf Leobendorf 30 84 28 59
3 Kremser SC Kremser SC 30 61 42 56
4 Kottingbrunn Kottingbrunn 30 63 43 55
5 Spratzern Spratzern 30 43 36 48
6 SC Retz SC Retz 30 42 34 46
7 Zwettl Zwettl 30 47 37 43
8 FCM Traiskirchen Traiskirchen 30 46 33 42
9 Langenrohr Langenrohr 30 53 47 33
10 Waidhofen / Thaya Waidhofen 30 42 58 33
11 Ardagger Ardagger 30 43 62 33
12 Würmla Würmla 30 46 60 32
13 St. Peter St. Peter 30 42 68 31
14 Gaflenz Gaflenz 30 34 65 27
15 SV Haitzendorf Haitzendorf 30 39 69 21
16 ATSV Ober-Grafendorf ATSV 30 7 53 20
TEMPORADA 2014/2015
CUARTA AUSTRIA GRUPO 4
Equipo PJ GF GC Puntos
1 Ebreichsdorf Ebreichsdorf 30 82 32 69
2 Kremser SC Kremser SC 30 95 30 68
3 Kottingbrunn Kottingbrunn 30 71 35 59
4 Leobendorf Leobendorf 30 71 45 48
5 St. Peter St. Peter 30 49 43 43
6 Langenrohr Langenrohr 30 45 57 43
7 Zwettl Zwettl 30 47 41 42
8 Marchfeld Marchfeld 30 58 55 42
9 Gaflenz Gaflenz 30 48 49 42
10 SC Retz SC Retz 30 50 52 42
11 Würmla Würmla 30 40 45 39
12 Ardagger Ardagger 30 42 65 35
13 Spratzern Spratzern 30 40 62 28
14 Waidhofen / Thaya Waidhofen 30 42 74 27
15 Ober-Grafendorf Ober-Grafend 30 45 102 26
16 Bad Vöslau Bad Vöslau 30 33 71 21
TEMPORADA 2013/2014
CUARTA AUSTRIA GRUPO 1
Equipo PJ GF GC Puntos
1 St. Pölten II Pölten 29 79 23 65
2 Leobendorf Leobendorf 29 66 28 62
3 Gaflenz Gaflenz 29 72 39 61
4 Kottingbrunn Kottingbrunn 29 64 31 61
5 Würmla Würmla 29 67 41 57
6 Ardagger Ardagger 29 58 36 50
7 Langenrohr Langenrohr 29 41 47 44
8 Marchfeld Marchfeld 29 53 52 39
9 Waidhofen / Thaya Waidhofen 29 48 56 38
10 St. Peter St. Peter 29 39 47 34
11 Zwettl Zwettl 29 43 54 34
12 Bad Vöslau Bad Vöslau 29 41 55 33
13 Spratzern Spratzern 29 40 61 28
14 Mistelbach Mistelbach 29 32 50 27
15 Schwadorf Schwadorf 29 19 65 13
16 Götzendorf Götzendorf 29 11 88 7
TEMPORADA 2012/2013
CUARTA AUSTRIA GRUPO 5
Equipo PJ GF GC Puntos
1 Ober-Grafendorf Ober-Grafend 30 66 36 65
2 Marchfeld Marchfeld 30 61 36 58
3 Bad Vöslau Bad Vöslau 30 46 27 58
4 Ardagger Ardagger 30 51 49 44
5 Zwettl Zwettl 30 50 52 44
6 St. Peter St. Peter 30 47 43 43
7 Langenrohr Langenrohr 30 40 34 42
8 Würmla Würmla 30 53 50 42
9 St. Pölten II Pölten 30 48 46 41
10 Kottingbrunn Kottingbrunn 30 33 27 40
11 Gaflenz Gaflenz 30 41 50 36
12 Waidhofen / Thaya Waidhofen 30 48 55 34
13 Leobendorf Leobendorf 30 34 48 31
14 Götzendorf Götzendorf 30 30 51 30
15 Schwadorf Schwadorf 30 33 57 30
16 SV Stockerau Stockerau 30 44 64 29

  USO DE MEMORIA  
6,582,264 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.6757
Total Execution Time  0.6768
  CADENA URL  
/historico/Mannsdorf
  GET DATOS  
$_GET['/historico/Mannsdorf']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (40)  
0.0136  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 = 'Mannsdorf' 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.0126  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=17511 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=17511 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=17511 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=17511 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0255  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 = 72560
0.0134  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 = 72330
0.0127  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17511 AND type_rel = 2
0.0130  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=338 AND type_rel = 3
0.0135  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 338 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0142  SELECT /*53 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 (1268188,1267669,1162598,981042,744718) ORDER BY n.cover_points DESC, update_date DESC
0.0153  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 = '17511' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0149  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 = '17511' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0145  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 = 72330 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0132  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 = 72560 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0139  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=17511 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0130  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 (72560,72330,71432) 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.0135  SELECT count(id) as num_players from rel_players WHERE league_id = 72560 AND teamId = 17511
0.0140  SELECT count(id) as num_players from rel_players WHERE league_id = 72330 AND teamId = 17511
0.0139  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 17511
0.0138  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 = 72560 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0137  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 = '17511' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0130  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '17511' and rp.type = 4
0.0136  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 = '17511' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0194  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 = 72560 WHERE rp.league_id = 72560 AND rp.teamId = 17511 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.0179  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 = 72560 WHERE rp.league_id = 72560 AND rp.teamId = 17511 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0170  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 = 72560 WHERE rp.league_id = 72560 AND rp.teamId = 17511 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0147  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 = 17511 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0145  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 = 72560 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.0143  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 = 68180 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.0141  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 = 63404 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.0139  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 = 57018 AND t.round = 11 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143  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 = 50222 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0142  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 = 44212 AND t.round = 30 ORDER BY team.conference 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 `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 = 38882 AND t.round = 34 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 = 33374 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143  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 = 15768 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 = 3938 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 3583 AND t.round = 29 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 `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 = 27174 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC