4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del SV Ried

SV Ried

Entrenador: Maximilian Senft

Temporada 2023/2024
TEMPORADA 2023/2024
SEGUNDA AUSTRIA
Equipo PJ GF GC Puntos
1 Grazer AK Grazer AK 25 46 22 58
2 SV Ried SV Ried 25 56 20 47
3 Leoben Leoben 25 42 26 44
4 FAC Wien FAC Wien 25 37 25 43
5 Admira Admira 25 37 25 41
6 Liefering Liefering 25 39 33 37
7 First Vienna First Vienna 25 38 35 36
8 Horn Horn 25 34 40 36
9 SKN St. Polten Polten 25 40 42 35
10 SV Lafnitz SV Lafnitz 25 39 44 33
11 SW Bregenz SW Bregenz 25 35 38 32
12 Stripfing Stripfing 25 33 48 30
13 Kapfenberger SV Kapfenberger 25 30 40 29
14 Dornbirn Dornbirn 25 25 44 26
15 Sturm Graz II Sturm Graz 25 34 56 20
16 SKU Amstetten Amstetten 25 22 49 11
TEMPORADA 2022/2023
BUNDESLIGA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 Wolfsberger AC Wolfsberger 32 51 51 31
2 Austria Lustenau Austria 32 50 54 29
3 WSG Tirol WSG Tirol 32 44 53 24
4 TSV Hartberg Hartberg 32 39 56 24
5 SCR Altach SCR Altach 32 29 53 19
6 SV Ried SV Ried 32 27 50 14
TEMPORADA 2021/2022
BUNDESLIGA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 WSG Tirol WSG Tirol 10 16 16 28
2 LASK LASK 10 16 13 26
3 SCR Altach SCR Altach 10 14 11 22
4 TSV Hartberg Hartberg 10 14 12 22
5 SV Ried SV Ried 10 9 13 22
6 Admira Admira 10 11 15 21
TEMPORADA 2020/2021
BUNDESLIGA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 TSV Hartberg Hartberg 32 38 48 32
2 Austria Wien Austria Wien 32 47 43 29
3 SV Ried SV Ried 32 34 57 25
4 SCR Altach SCR Altach 32 33 55 23
5 Admira Admira 32 27 58 19
6 SKN St. Polten Polten 32 39 57 13
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
SEGUNDA AUSTRIA
Equipo PJ GF GC Puntos
1 Wacker Innsbruck Wacker 36 60 31 71
2 TSV Hartberg Hartberg 36 63 34 68
3 Wiener Neustadt Wiener 36 53 37 62
4 SV Ried SV Ried 36 68 41 61
5 Liefering Liefering 36 58 44 55
6 Austria Lustenau Austria 36 48 52 45
7 WSG Tirol WSG Tirol 36 45 56 40
8 Kapfenberger SV Kapfenberger 36 40 68 35
9 FAC Wien FAC Wien 36 37 75 30
10 Blau-Weiß Linz Blau-Weiß 36 35 69 26
TEMPORADA 2016/2017
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Salzburg Salzburg 36 74 24 81
2 Austria Wien Austria Wien 36 72 50 63
3 Sturm Graz Sturm Graz 36 55 39 60
4 SCR Altach SCR Altach 36 46 49 53
5 Rapid Wien Rapid Wien 36 52 42 46
6 Admira Admira 36 36 55 46
7 Mattersburg Mattersburg 36 39 54 43
8 Wolfsberger AC Wolfsberger 36 40 59 42
9 SKN St. Polten Polten 36 41 60 37
10 SV Ried SV Ried 36 33 56 35
TEMPORADA 2015/2016
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Salzburg Salzburg 36 71 33 74
2 Rapid Wien Rapid Wien 36 66 42 65
3 Austria Wien Austria Wien 36 65 48 59
4 Admira Admira 36 45 51 50
5 Sturm Graz Sturm Graz 36 40 40 48
6 Wolfsberger AC Wolfsberger 36 33 36 43
7 SV Ried SV Ried 36 36 52 42
8 SCR Altach SCR Altach 36 39 49 40
9 Mattersburg Mattersburg 36 40 70 39
10 Grödig Grödig 36 42 56 35
TEMPORADA 2014/2015
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Salzburg Salzburg 36 99 42 73
2 Rapid Wien Rapid Wien 36 68 38 67
3 SCR Altach SCR Altach 36 50 49 59
4 Sturm Graz Sturm Graz 36 57 41 58
5 Wolfsberger AC Wolfsberger 36 44 50 52
6 SV Ried SV Ried 36 49 51 44
7 Austria Wien Austria Wien 36 45 51 43
8 Grödig Grödig 36 46 65 37
9 Admira Admira 36 32 61 34
10 Wiener Neustadt Wiener 36 37 79 29
TEMPORADA 2013/2014
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Salzburg Salzburg 36 110 35 80
2 Rapid Wien Rapid Wien 36 63 40 62
3 Grödig Grödig 36 68 71 54
4 Austria Wien Austria Wien 36 58 44 53
5 Sturm Graz Sturm Graz 36 55 55 48
6 SV Ried SV Ried 36 55 66 43
7 Admira Admira 36 51 67 42
8 Wolfsberger AC Wolfsberger 36 50 63 41
9 Wiener Neustadt Wiener 36 43 84 39
10 Wacker Innsbruck Wacker 36 42 70 29
TEMPORADA 2012/2013
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Austria Wien Austria Wien 36 84 31 82
2 Salzburg Salzburg 36 91 39 77
3 Rapid Wien Rapid Wien 36 57 39 57
4 Sturm Graz Sturm Graz 36 47 56 48
5 Wolfsberger AC Wolfsberger 36 53 56 47
6 SV Ried SV Ried 36 60 59 46
7 Wiener Neustadt Wiener 36 32 60 36
8 Wacker Innsbruck Wacker 36 41 73 36
9 Admira Admira 36 47 68 35
10 Mattersburg Mattersburg 36 36 67 35
TEMPORADA 2011/2012
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Salzburg Salzburg 36 60 30 68
2 Rapid Wien Rapid Wien 36 52 30 62
3 Admira Admira 36 59 52 55
4 Austria Wien Austria Wien 36 52 44 54
5 Sturm Graz Sturm Graz 36 47 41 51
6 SV Ried SV Ried 36 44 38 48
7 Wacker Innsbruck Wacker 36 36 45 45
8 Mattersburg Mattersburg 36 41 43 38
9 Wiener Neustadt Wiener 36 26 51 33
10 Kapfenberger SV Kapfenberger 36 21 64 23
TEMPORADA 2010/2011
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Sturm Graz Sturm Graz 36 66 33 66
2 Salzburg Salzburg 36 53 31 63
3 Austria Wien Austria Wien 36 64 37 61
4 SV Ried SV Ried 36 51 38 58
5 Rapid Wien Rapid Wien 36 52 41 53
6 Wacker Innsbruck Wacker 36 43 42 50
7 Wiener Neustadt Wiener 36 44 52 50
8 Kapfenberger SV Kapfenberger 36 42 61 38
9 Mattersburg Mattersburg 36 29 56 31
10 LASK LASK 36 22 75 19
TEMPORADA 2009/2010
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Salzburg Salzburg 36 68 27 76
2 Austria Wien Austria Wien 36 60 34 75
3 Rapid Wien Rapid Wien 36 80 38 73
4 Sturm Graz Sturm Graz 36 50 36 58
5 Wiener Neustadt Wiener 36 54 58 47
6 Mattersburg Mattersburg 36 45 71 41
7 LASK LASK 36 59 70 40
8 SV Ried SV Ried 36 39 47 38
9 Kapfenberger SV Kapfenberger 36 44 67 33
10 Austria Karnten Austria 36 29 80 15
TEMPORADA 2008/2009
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Salzburg Salzburg 36 86 50 74
2 Rapid Wien Rapid Wien 36 89 43 70
3 Austria Wien Austria Wien 36 59 46 62
4 Sturm Graz Sturm Graz 36 68 45 60
5 SV Ried SV Ried 36 58 38 60
6 Austria Karnten Austria 36 47 57 41
7 LASK LASK 36 35 67 37
8 Kapfenberger SV Kapfenberger 36 48 81 36
9 Mattersburg Mattersburg 36 42 71 33
10 SCR Altach SCR Altach 36 56 90 30
TEMPORADA 2007/2008
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Rapid Wien Rapid Wien 36 69 36 69
2 Salzburg Salzburg 36 63 42 63
3 Austria Wien Austria Wien 36 46 33 58
4 Sturm Graz Sturm Graz 36 60 41 56
5 Mattersburg Mattersburg 36 55 43 53
6 LASK LASK 36 54 47 53
7 SV Ried SV Ried 36 38 53 38
8 SCR Altach SCR Altach 36 37 64 36
9 Austria Karnten Austria 36 26 58 33
10 Wacker Innsbruck Wacker 36 32 63 29

  USO DE MEMORIA  
6,608,984 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1195
Total Execution Time  0.1207
  CADENA URL  
/historico/Ried
  GET DATOS  
$_GET['/historico/Ried']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=9776 AND type_rel = 2
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 9776 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 (30731,95566,116858,868217,1056649) ORDER BY n.cover_points DESC, update_date DESC
0.0029  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 = '9776' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0031  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=9776 AND l.year in (2023,2024,2025) 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 (72330,72086,71432,71333) 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.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 71333 AND teamId = 9776
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 72086 AND teamId = 9776
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 72330 AND teamId = 9776
0.0028  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 9776
0.0045  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 = 9776 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.0037  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 = 9776 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029  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 = 9776 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0033  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 = 9776 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 = 72086 AND t.round = 25 ORDER BY team.conference ASC,t.position 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 `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 = 67768 AND t.round = 22 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 `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 = 71333 AND t.round = 10 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 = 63138 AND t.round = 22 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 = 66906 AND t.round = 10 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 = 58504 AND t.round = 22 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 `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 = 61919 AND t.round = 10 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 `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.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 `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.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 = 38776 AND t.round = 36 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 `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 = 29662 AND t.round = 36 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 = 15404 AND t.round = 36 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 `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 = 3813 AND t.round = 36 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 = 2482 AND t.round = 36 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 `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 = 2014 AND t.round = 36 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 = 1364 AND t.round = 36 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 `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 = 1093 AND t.round = 36 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 `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 = 870 AND t.round = 36 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 `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 = 321 AND t.round = 36 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 `tables2008` 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 = 67 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC