Escudo del SV Lafnitz

SV Lafnitz

Entrenador: Robert Weinstabl

Temporada 2023/2024
TEMPORADA 2023/2024
SEGUNDA AUSTRIA
Equipo PJ GF GC Puntos
1 Grazer AK Grazer AK 23 40 21 52
2 SV Ried SV Ried 23 51 20 41
3 Leoben Leoben 23 38 22 41
4 Admira Admira 23 36 25 37
5 FAC Wien FAC Wien 23 34 25 37
6 SKN St. Polten Polten 23 38 37 35
7 Liefering Liefering 23 37 32 33
8 First Vienna First Vienna 23 36 34 33
9 SV Lafnitz SV Lafnitz 23 37 39 33
10 Horn Horn 23 31 37 33
11 SW Bregenz SW Bregenz 23 35 33 32
12 Kapfenberger SV Kapfenberger 23 29 36 29
13 Stripfing Stripfing 23 29 45 26
14 Dornbirn Dornbirn 23 20 40 22
15 Sturm Graz II Sturm Graz 23 28 52 17
16 SKU Amstetten Amstetten 23 21 42 11
TEMPORADA 2022/2023
SEGUNDA AUSTRIA
Equipo PJ GF GC Puntos
1 Blau-Weiß Linz Blau-Weiß 30 63 27 61
2 Grazer AK Grazer AK 30 52 29 60
3 SKN St. Polten Polten 30 51 27 56
4 Horn Horn 30 38 33 48
5 SKU Amstetten Amstetten 30 49 49 45
6 FAC Wien FAC Wien 30 41 30 45
7 First Vienna First Vienna 30 34 33 43
8 SV Lafnitz SV Lafnitz 30 48 46 41
9 Liefering Liefering 30 52 54 37
10 Admira Admira 30 39 42 36
11 Dornbirn Dornbirn 30 43 44 35
12 Kapfenberger SV Kapfenberger 30 40 56 34
13 Sturm Graz II Sturm Graz 30 43 56 34
14 Vorwarts Steyr Vorwarts 30 36 54 32
15 Rapid Wien II Rapid Wien 30 33 55 30
16 Austria Wien II Austria Wien 30 34 61 29
TEMPORADA 2021/2022
SEGUNDA AUSTRIA
Equipo PJ GF GC Puntos
1 Austria Lustenau Austria 30 69 26 70
2 FAC Wien FAC Wien 30 51 18 65
3 Blau-Weiß Linz Blau-Weiß 30 51 27 54
4 SV Lafnitz SV Lafnitz 30 53 42 52
5 SKU Amstetten Amstetten 30 59 35 51
6 Liefering Liefering 30 56 43 46
7 Grazer AK Grazer AK 30 47 39 46
8 SKN St. Polten Polten 30 43 38 42
9 Wacker Innsbruck Wacker 30 46 41 40
10 Vorwarts Steyr Vorwarts 30 39 52 37
11 Rapid Wien II Rapid Wien 30 45 62 33
12 Kapfenberger SV Kapfenberger 30 36 54 30
13 Horn Horn 30 34 55 28
14 Austria Wien II Austria Wien 30 31 56 25
15 FC Juniors OÖ Juniors 30 37 71 23
16 Dornbirn Dornbirn 30 35 73 22
TEMPORADA 2020/2021
SEGUNDA AUSTRIA
Equipo PJ GF GC Puntos
1 Blau-Weiß Linz Blau-Weiß 30 70 31 63
2 Liefering Liefering 30 69 31 63
3 Austria Klagenfurt Austria 30 64 32 59
4 Wacker Innsbruck Wacker 30 50 33 57
5 SV Lafnitz SV Lafnitz 30 56 35 55
6 Grazer AK Grazer AK 30 46 42 46
7 Dornbirn Dornbirn 30 40 53 38
8 FC Juniors OÖ Juniors 30 38 49 37
9 FAC Wien FAC Wien 30 39 41 36
10 Kapfenberger SV Kapfenberger 30 34 51 33
11 Austria Wien II Austria Wien 30 41 52 32
12 SKU Amstetten Amstetten 30 38 61 31
13 Austria Lustenau Austria 30 44 55 30
14 Rapid Wien II Rapid Wien 30 37 53 30
15 Horn Horn 30 40 62 30
16 Vorwarts Steyr Vorwarts 30 30 55 30
TEMPORADA 2019/2020
SEGUNDA AUSTRIA
Equipo PJ GF GC Puntos
1 SV Ried SV Ried 30 73 39 64
2 Austria Klagenfurt Austria 30 65 36 64
3 Liefering Liefering 30 73 47 53
4 Austria Wien II Austria Wien 30 62 44 48
5 SKU Amstetten Amstetten 30 51 47 45
6 Wacker Innsbruck Wacker 30 44 49 44
7 Vorwarts Steyr Vorwarts 30 42 36 41
8 SV Lafnitz SV Lafnitz 30 42 42 39
9 FC Juniors OÖ Juniors 30 50 63 38
10 Blau-Weiß Linz Blau-Weiß 30 51 57 37
11 Austria Lustenau Austria 30 57 58 35
12 Dornbirn Dornbirn 30 40 59 34
13 Horn Horn 30 58 67 32
14 FAC Wien FAC Wien 30 32 51 32
15 Grazer AK Grazer AK 30 40 50 31
16 Kapfenberger SV Kapfenberger 30 34 69 22
TEMPORADA 2018/2019
SEGUNDA AUSTRIA
Equipo PJ GF GC Puntos
1 WSG Tirol WSG Tirol 30 59 26 65
2 SV Ried SV Ried 30 61 21 63
3 Austria Lustenau Austria 30 55 34 50
4 Kapfenberger SV Kapfenberger 30 44 40 46
5 Blau-Weiß Linz Blau-Weiß 30 46 48 44
6 Wiener Neustadt Wiener 30 39 41 44
7 FC Juniors OÖ Juniors 30 52 55 42
8 Austria Klagenfurt Austria 30 43 35 41
9 FC Wacker Innsbruck II Wacker 30 40 44 41
10 FAC Wien FAC Wien 30 35 41 41
11 SKU Amstetten Amstetten 30 45 43 36
12 Liefering Liefering 30 50 54 35
13 Austria Wien II Austria Wien 30 46 62 34
14 SV Lafnitz SV Lafnitz 30 36 42 33
15 Horn Horn 30 33 62 25
16 Vorwarts Steyr Vorwarts 30 32 68 21
TEMPORADA 2017/2018
TERCERA AUSTRIA GRUPO 2
Equipo PJ GF GC Puntos
1 SV Lafnitz SV Lafnitz 30 70 16 67
2 Gleisdorf Gleisdorf 30 60 33 57
3 Vorwarts Steyr Vorwarts 30 70 38 55
4 FC Juniors OÖ Juniors 30 54 46 52
5 Austria Klagenfurt Austria 30 57 48 48
6 Allerheiligen Allerheilige 30 59 41 47
7 Vöcklamarkt Vöcklamarkt 30 52 43 47
8 Deutschlandsberger Deutschlands 30 50 43 47
9 Sturm Graz II Sturm Graz 30 45 48 42
10 TUS Bad Gleichenberg Gleichenberg 30 44 54 39
11 Gurten Gurten 30 45 46 37
12 Wolfsberger AC II Wolfsberger 30 41 63 33
13 Weiz Weiz 30 43 58 32
14 Kalsdorf Kalsdorf 30 36 52 29
15 Stadl-Paura Stadl-Paura 30 32 67 27
16 Union St. Florian Union 30 14 76 13
TEMPORADA 2016/2017
TERCERA AUSTRIA GRUPO 1
Equipo PJ GF GC Puntos
1 TSV Hartberg Hartberg 30 74 38 62
2 SV Lafnitz SV Lafnitz 30 54 27 60
3 Gleisdorf Gleisdorf 30 53 35 59
4 Stadl-Paura Stadl-Paura 30 75 53 51
5 Deutschlandsberger Deutschlands 30 65 45 46
6 Vorwarts Steyr Vorwarts 30 56 49 44
7 Kalsdorf Kalsdorf 30 38 35 44
8 Gurten Gurten 30 39 43 42
9 Union St. Florian Union 30 36 46 39
10 Sturm Graz II Sturm Graz 30 42 51 38
11 Weiz Weiz 30 40 52 38
12 Austria Klagenfurt Austria 30 43 61 35
13 Allerheiligen Allerheilige 30 46 60 33
14 SV Pasching SV Pasching 30 43 49 31
15 Grieskirchen Grieskirchen 30 44 64 23
16 ATSV Wolfsberg ATSV 30 25 65 19
TEMPORADA 2015/2016
TERCERA AUSTRIA GRUPO 1
Equipo PJ GF GC Puntos
1 Blau-Weiß Linz Blau-Weiß 30 89 25 70
2 TSV Hartberg Hartberg 30 64 38 60
3 Union St. Florian Union 30 53 35 52
4 Kalsdorf Kalsdorf 30 56 43 51
5 SV Pasching SV Pasching 30 59 46 50
6 SV Lafnitz SV Lafnitz 30 62 52 49
7 Stadl-Paura Stadl-Paura 30 58 49 48
8 Allerheiligen Allerheilige 30 50 43 48
9 Deutschlandsberger Deutschlands 30 49 43 43
10 Gurten Gurten 30 51 44 40
11 Sturm Graz II Sturm Graz 30 48 48 38
12 Vorwarts Steyr Vorwarts 30 36 49 34
13 Weiz Weiz 30 33 66 26
14 Wolfsberger AC II Wolfsberger 30 34 64 23
15 SV Wallern SV Wallern 30 35 70 22
16 Annabichler Austria Annabichler 30 24 86 19
TEMPORADA 2014/2015
TERCERA AUSTRIA GRUPO 2
Equipo PJ GF GC Puntos
1 Austria Klagenfurt Austria 29 66 24 64
2 Vorwarts Steyr Vorwarts 29 43 29 56
3 Weiz Weiz 29 55 39 53
4 SV Lafnitz SV Lafnitz 29 54 27 52
5 Blau-Weiß Linz Blau-Weiß 29 49 34 51
6 Allerheiligen Allerheilige 29 52 42 48
7 Sturm Graz II Sturm Graz 29 50 41 43
8 Kalsdorf Kalsdorf 29 51 49 40
9 Wolfsberger AC II Wolfsberger 29 39 42 40
10 SV Pasching SV Pasching 29 45 49 40
11 Gurten Gurten 29 36 45 37
12 SV Wallern SV Wallern 29 35 46 34
13 Union St. Florian Union 29 32 54 30
14 SAK Klagenfurt Klagenfurt 29 29 61 24
15 Vöcklamarkt Vöcklamarkt 29 25 44 21
16 ATSV Wolfsberg ATSV 29 21 56 16
TEMPORADA 2013/2014
TERCERA AUSTRIA GRUPO 2
Equipo PJ GF GC Puntos
1 LASK LASK 30 80 19 76
2 SV Pasching SV Pasching 30 79 20 69
3 SV Lafnitz SV Lafnitz 30 68 55 55
4 SV Wallern SV Wallern 30 52 46 47
5 Austria Klagenfurt Austria 30 56 68 44
6 Blau-Weiß Linz Blau-Weiß 30 40 52 42
7 Union St. Florian Union 30 36 36 41
8 Sturm Graz II Sturm Graz 30 54 55 41
9 Kalsdorf Kalsdorf 30 53 55 39
10 Allerheiligen Allerheilige 30 49 46 37
11 SAK Klagenfurt Klagenfurt 30 57 65 37
12 Vorwarts Steyr Vorwarts 30 37 47 37
13 Vöcklamarkt Vöcklamarkt 30 38 63 34
14 Wolfsberger AC II Wolfsberger 30 35 57 27
15 SV Villach SV Villach 30 37 62 26
16 Kapfenberger SV KM II Kapfenberger 30 35 60 25
TEMPORADA 2012/2013
CUARTA AUSTRIA GRUPO 2
Equipo PJ GF GC Puntos
1 SV Lafnitz SV Lafnitz 30 80 36 63
2 Weiz Weiz 30 60 33 60
3 SV Gleinstätten Gleinstätte 30 61 41 53
4 Deutschlandsberger Deutschlands 30 58 49 51
5 Gleisdorf Gleisdorf 30 63 44 47
6 Frohnleiten Frohnleiten 30 47 48 47
7 SC Fürstenfeld Fürstenfeld 30 52 44 45
8 Voitsberg Voitsberg 30 50 39 42
9 Liezen Liezen 30 44 42 40
10 Wildon Wildon 30 43 62 38
11 TUS Heiligenkreuz Heiligenkreu 30 45 59 35
12 SV ADA Anger Anger 30 38 52 34
13 SV Pachern SV Pachern 30 50 60 32
14 Gratkorn II Gratkorn II 30 37 65 30
15 SVA Kindberg Kindberg 30 29 55 29
16 Zeltweg Zeltweg 30 33 61 25
TEMPORADA 2011/2012
CUARTA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 Kalsdorf Kalsdorf 30 74 38 64
2 Weiz Weiz 30 67 36 55
3 Liezen Liezen 30 57 33 54
4 Gleisdorf Gleisdorf 30 62 32 51
5 Voitsberg Voitsberg 30 57 42 46
6 SC Fürstenfeld Fürstenfeld 30 51 54 46
7 SV Lafnitz SV Lafnitz 30 64 59 44
8 SVA Kindberg Kindberg 30 50 47 43
9 SV ADA Anger Anger 30 60 56 42
10 Frohnleiten Frohnleiten 30 41 44 39
11 SV Pachern SV Pachern 30 43 65 35
12 Wildon Wildon 30 56 62 34
13 Gratkorn II Gratkorn II 30 42 73 33
14 Irdning Irdning 30 32 69 28
15 Grossklein Grossklein 30 49 68 26
16 Mürzhofen/Allerheiligen Mürzhofen/A 30 36 63 26

  USO DE MEMORIA  
6,791,776 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5011
Total Execution Time  0.5023
  CADENA URL  
/historico/Sv-Lafnitz
  GET DATOS  
$_GET['/historico/Sv-Lafnitz']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0228  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 = 72086
0.0110  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12414 AND type_rel = 2
0.0113  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=337 AND type_rel = 3
0.0120  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 337 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0122  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 (1217055,1213703,1054642,1053655,1020782) ORDER BY n.cover_points DESC, update_date DESC
0.0132  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 = '12414' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0117  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 = 72086 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0109  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=12414 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0107  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 (72330,72086,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.0112  SELECT count(id) as num_players from rel_players WHERE league_id = 72086 AND teamId = 12414
0.0110  SELECT count(id) as num_players from rel_players WHERE league_id = 72330 AND teamId = 12414
0.0113  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 12414
0.0112  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 = 72086 AND t.round = 24 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0114  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 = '12414' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0109  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '12414' and rp.type = 4
0.0117  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 = '12414' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0176  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 = 72086 WHERE rp.league_id = 72086 AND rp.teamId = 12414 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.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 = 72086 WHERE rp.league_id = 72086 AND rp.teamId = 12414 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0186  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 = 72086 WHERE rp.league_id = 72086 AND rp.teamId = 12414 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0119  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 = 12414 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0115  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 = 72086 AND t.round = 24 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0115  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 = 68052 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.0116  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 = 63139 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.0119  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 = 58548 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.0126  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 = 50149 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.0126  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 = 44020 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 38883 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 33372 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 = 15759 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 4155 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 2767 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113  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 = 27164 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0115  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 = 27202 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC