4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Leobendorf
TEMPORADA 2023/2024
TERCERA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 Rapid Wien II Rapid Wien 26 59 23 56
2 Donaufeld Donaufeld 26 61 32 49
3 Kremser SC Kremser SC 26 40 28 46
4 Leobendorf Leobendorf 26 49 32 45
5 SC Wiener Viktoria Wiener 26 45 38 40
6 Marchfeld Marchfeld 26 40 39 40
7 Austria Wien II Austria Wien 26 42 36 36
8 Wiener SC Wiener SC 26 43 38 36
9 FCM Traiskirchen Traiskirchen 26 55 44 35
10 Elektra Elektra 26 29 35 32
11 Neusiedl Neusiedl 26 35 51 32
12 Oberwart / Rotenturm Oberwart 26 30 47 30
13 Favoritner AC Favoritner 26 28 43 28
14 Mauerwerk Mauerwerk 26 24 52 22
15 Ardagger Ardagger 26 17 33 21
16 Drassburg Drassburg 26 32 58 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
CUARTA AUSTRIA GRUPO 6
Equipo PJ GF GC Puntos
1 Leobendorf Leobendorf 30 57 13 65
2 Stripfing Stripfing 30 60 22 65
3 SC Retz SC Retz 30 54 29 62
4 Kremser SC Kremser SC 30 58 30 60
5 Scheiblingkirchen-Warth Scheiblingki 30 55 41 53
6 Kottingbrunn Kottingbrunn 30 46 27 52
7 Gaflenz Gaflenz 30 62 55 45
8 Langenrohr Langenrohr 30 44 48 36
9 Waidhofen / Thaya Waidhofen 30 40 54 34
10 St. Peter St. Peter 30 43 56 30
11 Ardagger Ardagger 30 28 41 30
12 Zwettl Zwettl 30 32 61 27
13 Rohrendorf Rohrendorf 30 38 51 26
14 Spratzern Spratzern 30 21 52 26
15 Rohrbach Rohrbach 30 30 53 25
16 SV Haitzendorf Haitzendorf 30 23 58 23
TEMPORADA 2016/2017
CUARTA AUSTRIA GRUPO 1
Equipo PJ GF GC Puntos
1 Bruck/Leitha Bruck/Leitha 30 78 34 65
2 Leobendorf Leobendorf 30 77 35 65
3 SC Retz SC Retz 30 58 32 58
4 Kremser SC Kremser SC 30 61 30 57
5 Stripfing Stripfing 30 60 49 45
6 Kottingbrunn Kottingbrunn 30 49 39 43
7 Ardagger Ardagger 30 41 53 40
8 SV Haitzendorf Haitzendorf 30 53 63 36
9 Spratzern Spratzern 30 41 52 34
10 Rohrendorf Rohrendorf 30 40 60 34
11 Zwettl Zwettl 30 41 49 33
12 Langenrohr Langenrohr 30 39 52 33
13 Gaflenz Gaflenz 30 38 57 33
14 Waidhofen / Thaya Waidhofen 30 47 72 33
15 St. Peter St. Peter 30 37 59 31
16 Würmla Würmla 30 33 57 24
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
TEMPORADA 2011/2012
CUARTA AUSTRIA GRUPO 6
Equipo PJ GF GC Puntos
1 SC Retz SC Retz 30 72 39 61
2 Gaflenz Gaflenz 30 71 40 60
3 Bad Vöslau Bad Vöslau 30 64 38 55
4 Ardagger Ardagger 30 54 40 53
5 Kottingbrunn Kottingbrunn 30 65 44 50
6 St. Pölten II Pölten 30 54 43 47
7 Zwettl Zwettl 30 59 54 45
8 Langenrohr Langenrohr 30 50 54 44
9 Leobendorf Leobendorf 30 65 58 42
10 Götzendorf Götzendorf 30 54 54 39
11 St. Peter St. Peter 30 42 44 34
12 Würmla Würmla 30 54 67 34
13 Schwadorf Schwadorf 30 31 52 29
14 Waidhofen / Thaya Waidhofen 30 39 67 26
15 SV Stockerau Stockerau 30 28 66 25
16 Mistelbach Mistelbach 30 34 76 19
TEMPORADA 2009/2010
CUARTA AUSTRIA GRUPO 6
Equipo PJ GF GC Puntos
1 Sollenau Sollenau 30 75 37 64
2 SKU Amstetten Amstetten 30 65 26 62
3 Mistelbach Mistelbach 30 58 30 53
4 SC Retz SC Retz 30 54 37 52
5 Langenrohr Langenrohr 30 48 44 48
6 St. Pölten II Pölten 30 53 47 45
7 Ardagger Ardagger 30 35 38 36
8 SV Stockerau Stockerau 30 40 51 36
9 Vösendorf Vösendorf 30 44 56 36
10 Bad Vöslau Bad Vöslau 30 36 45 35
11 Kottingbrunn Kottingbrunn 30 40 43 34
12 Götzendorf Götzendorf 30 37 51 34
13 SV Haitzendorf Haitzendorf 30 31 48 34
14 Schrems Schrems 30 44 63 34
15 Leobendorf Leobendorf 30 35 51 28
16 Herzogenburg Herzogenburg 30 45 73 25
TEMPORADA 2008/2009
CUARTA AUSTRIA GRUPO 4
Equipo PJ GF GC Puntos
1 Gaflenz Gaflenz 30 59 34 61
2 Sollenau Sollenau 30 66 41 56
3 Kottingbrunn Kottingbrunn 30 63 43 56
4 Schrems Schrems 30 58 45 53
5 Leobendorf Leobendorf 30 43 30 52
6 Vösendorf Vösendorf 30 41 35 43
7 Langenrohr Langenrohr 30 52 50 43
8 Ardagger Ardagger 30 40 41 43
9 Mistelbach Mistelbach 30 40 40 41
10 Götzendorf Götzendorf 30 42 46 41
11 SC Retz SC Retz 30 41 45 39
12 SV Haitzendorf Haitzendorf 30 36 42 32
13 Herzogenburg Herzogenburg 30 40 61 29
14 SV Stockerau Stockerau 30 33 47 28
15 Kremser SC Kremser SC 30 33 52 24
16 Ortmann Ortmann 30 23 58 19

  USO DE MEMORIA  
6,908,952 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.3049
Total Execution Time  0.3062
  CADENA URL  
/historico/Leobendorf
  GET DATOS  
$_GET['/historico/Leobendorf']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.1510  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 = 'Leobendorf' 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=17510 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=17510 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=17510 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=17510 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17510 AND type_rel = 2
0.0028  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 17510 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0020  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 (112701) ORDER BY n.cover_points DESC, update_date DESC
0.0037  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 = '17510' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0044  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 = '17510' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0053  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=17510 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0021  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.0046  SELECT count(id) as num_players from rel_players WHERE league_id = 72560 AND teamId = 17510
0.0050  SELECT count(id) as num_players from rel_players WHERE league_id = 72330 AND teamId = 17510
0.0040  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 17510
0.0024  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 = '17510' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0024  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '17510' and rp.type = 4
0.0020  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 = '17510' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0068  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 = 17510 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.0079  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 = 17510 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0061  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 = 17510 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0047  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 = 17510 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 27 ORDER BY team.conference ASC,t.position 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 `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.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 `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.0027  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.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 = 38912 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033  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 = 33426 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0042  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.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 `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.0029  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.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 `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
0.0047  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 = 27210 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0040  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 = 27243 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 `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 = 27260 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC