4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Mattersburg II
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 4
Equipo PJ GF GC Puntos
1 Mattersburg II Mattersburg 30 95 27 70
2 Siegendorf Siegendorf 30 61 45 60
3 Drassburg Drassburg 30 62 31 59
4 Wimpassing Wimpassing 30 52 40 51
5 SV Eltendorf Eltendorf 30 73 55 50
6 St. Margarethen Margarethen 30 48 38 47
7 Bad Sauerbrunn Sauerbrunn 30 54 59 42
8 Pinkafeld Pinkafeld 30 49 49 39
9 SV Stegersbach Stegersbach 30 55 52 38
10 Markt Allhau Markt Allhau 30 47 59 37
11 Horitschon Horitschon 30 50 63 34
12 FC Deutschkreutz Deutschkreut 30 37 69 30
13 Parndorf II Parndorf II 30 37 52 29
14 Kohfidisch Kohfidisch 30 39 66 29
15 Klingenbach Klingenbach 30 33 54 25
16 Neuberg Neuberg 30 40 73 24
TEMPORADA 2016/2017
CUARTA AUSTRIA GRUPO 2
Equipo PJ GF GC Puntos
1 Mattersburg II Mattersburg 32 106 40 71
2 Neuberg Neuberg 32 71 45 60
3 SV Stegersbach Stegersbach 32 71 29 59
4 Drassburg Drassburg 32 74 38 59
5 Parndorf II Parndorf II 32 61 39 57
6 Klingenbach Klingenbach 32 56 44 56
7 Horitschon Horitschon 32 50 48 49
8 St. Margarethen Margarethen 32 45 44 46
9 FC Deutschkreutz Deutschkreut 32 47 62 45
10 Pinkafeld Pinkafeld 32 46 37 43
11 SV Eltendorf Eltendorf 32 68 85 43
12 Markt Allhau Markt Allhau 32 56 73 43
13 Wimpassing Wimpassing 32 46 65 40
14 SV Eberau SV Eberau 32 43 59 37
15 Oberwart Oberwart 32 40 64 26
16 Leithaprodersdorf Leithaproder 32 38 90 16
17 SV Schattendorf Schattendorf 32 29 85 14
TEMPORADA 2015/2016
CUARTA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 SV Eberau SV Eberau 32 63 40 63
2 Mattersburg II Mattersburg 32 84 42 62
3 Purbach Purbach 32 62 31 58
4 Drassburg Drassburg 32 69 45 57
5 SV Eltendorf Eltendorf 32 78 59 57
6 St. Margarethen Margarethen 32 56 43 56
7 Parndorf II Parndorf II 32 62 43 53
8 Horitschon Horitschon 32 59 46 47
9 Wimpassing Wimpassing 32 46 50 44
10 Pinkafeld Pinkafeld 32 46 49 39
11 Neuberg Neuberg 32 50 57 37
12 SV Stegersbach Stegersbach 32 45 56 33
13 Klingenbach Klingenbach 32 42 62 31
14 FC Deutschkreutz Deutschkreut 32 43 71 31
15 SC Neudörfl Neudörfl 32 31 71 27
16 Jennersdorf Jennersdorf 32 39 71 26
17 USC Wallern USC Wallern 32 42 81 26
TEMPORADA 2014/2015
TERCERA AUSTRIA GRUPO 1
Equipo PJ GF GC Puntos
1 Ritzing Ritzing 30 60 34 61
2 Parndorf Parndorf 30 64 36 55
3 SKU Amstetten Amstetten 30 60 38 48
4 First Vienna First Vienna 30 46 32 48
5 Neusiedl Neusiedl 30 43 46 45
6 Schwechat Schwechat 30 44 32 44
7 Admira Wacker II Admira 30 48 44 42
8 Sollenau Sollenau 30 50 49 42
9 Rapid Wien II Rapid Wien 30 50 42 39
10 Austria Wien II Austria Wien 30 52 46 39
11 St. Pölten II Pölten 30 46 51 38
12 Wiener SC Wiener SC 30 53 55 37
13 Mattersburg II Mattersburg 30 42 48 36
14 SV Stegersbach Stegersbach 30 33 49 36
15 Donaufeld Donaufeld 30 44 61 31
16 Neuberg Neuberg 30 23 95 9
TEMPORADA 2013/2014
TERCERA AUSTRIA GRUPO 1
Equipo PJ GF GC Puntos
1 FAC Wien FAC Wien 30 55 24 64
2 Austria Wien II Austria Wien 30 55 34 57
3 SKU Amstetten Amstetten 30 63 29 56
4 Ritzing Ritzing 30 47 36 53
5 Rapid Wien II Rapid Wien 30 63 46 51
6 Sollenau Sollenau 30 57 60 45
7 Mattersburg II Mattersburg 30 51 41 44
8 SV Stegersbach Stegersbach 30 43 46 42
9 Schwechat Schwechat 30 44 48 41
10 Admira Wacker II Admira 30 37 50 40
11 Wiener SC Wiener SC 30 48 55 38
12 Neuberg Neuberg 30 48 51 36
13 SC Wiener Viktoria Wiener 30 47 76 30
14 ATSV Ober-Grafendorf ATSV 30 37 61 29
15 Oberwart Oberwart 30 38 58 27
16 SC Retz SC Retz 30 36 54 23
TEMPORADA 2012/2013
TERCERA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 Parndorf Parndorf 30 66 31 67
2 Austria Wien II Austria Wien 30 69 39 64
3 FAC Wien FAC Wien 30 59 39 55
4 Admira Wacker II Admira 30 58 38 52
5 SKU Amstetten Amstetten 30 52 25 51
6 Mattersburg II Mattersburg 30 67 48 50
7 Rapid Wien II Rapid Wien 30 54 44 42
8 SV Stegersbach Stegersbach 30 45 51 42
9 Oberwart Oberwart 30 44 46 41
10 Sollenau Sollenau 30 42 48 39
11 SC Retz SC Retz 30 58 72 37
12 Wiener SC Wiener SC 30 51 51 36
13 Schwechat Schwechat 30 42 64 26
14 Ritzing Ritzing 30 30 72 25
15 Ostbahn XI Ostbahn XI 30 40 64 23
16 Simmeringer SC Simmeringer 30 16 61 10
TEMPORADA 2011/2012
TERCERA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 Horn Horn 30 70 23 64
2 Rapid Wien II Rapid Wien 30 58 25 62
3 Austria Wien II Austria Wien 30 60 38 49
4 Parndorf Parndorf 30 46 39 45
5 Wiener SC Wiener SC 30 48 51 43
6 SV Stegersbach Stegersbach 30 56 54 41
7 Ritzing Ritzing 30 37 53 41
8 Sollenau Sollenau 30 75 67 40
9 FAC Wien FAC Wien 30 36 29 40
10 SKU Amstetten Amstetten 30 43 54 39
11 Mattersburg II Mattersburg 30 46 49 38
12 Schwechat Schwechat 30 39 39 37
13 Simmeringer SC Simmeringer 30 40 48 37
14 Admira Wacker II Admira 30 45 58 37
15 Neusiedl Neusiedl 30 47 58 36
16 Columbia Floridsdorf Columbia 30 27 88 15
TEMPORADA 2010/2011
TERCERA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 Parndorf Parndorf 30 81 34 57
2 Horn Horn 30 64 39 56
3 Austria Wien II Austria Wien 30 52 29 56
4 Sollenau Sollenau 30 51 47 46
5 Ritzing Ritzing 30 47 52 46
6 Wiener SC Wiener SC 30 55 49 45
7 Rapid Wien II Rapid Wien 30 63 50 44
8 Neusiedl Neusiedl 30 49 45 43
9 FAC Wien FAC Wien 30 40 36 43
10 Mattersburg II Mattersburg 30 49 40 42
11 Waidhofen Waidhofen 30 43 45 42
12 Admira Wacker II Admira 30 45 60 40
13 Schwechat Schwechat 30 37 48 39
14 Columbia Floridsdorf Columbia 30 33 50 37
15 Ostbahn XI Ostbahn XI 30 32 79 17
16 Baumgarten Baumgarten 30 40 78 16
TEMPORADA 2009/2010
TERCERA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 Waidhofen Waidhofen 30 57 31 58
2 Admira Wacker II Admira 30 45 34 55
3 Parndorf Parndorf 30 63 32 54
4 Horn Horn 30 51 30 54
5 Rapid Wien II Rapid Wien 30 49 30 50
6 Ostbahn XI Ostbahn XI 30 44 32 48
7 Neusiedl Neusiedl 30 52 44 47
8 Wiener SC Wiener SC 30 59 50 46
9 Mattersburg II Mattersburg 30 51 46 41
10 Baumgarten Baumgarten 30 41 60 41
11 FAC Wien FAC Wien 30 49 53 40
12 Schwechat Schwechat 30 36 35 39
13 Wienerberg Wienerberg 30 46 49 39
14 Gaflenz Gaflenz 30 27 74 23
15 Würmla Würmla 30 33 66 17
16 Zwettl Zwettl 30 32 69 17
TEMPORADA 2008/2009
TERCERA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 First Vienna First Vienna 30 60 27 63
2 Horn Horn 30 51 26 60
3 Parndorf Parndorf 30 49 23 56
4 Wiener SC Wiener SC 30 53 42 54
5 Waidhofen Waidhofen 30 40 32 53
6 Rapid Wien II Rapid Wien 30 54 40 49
7 Wienerberg Wienerberg 30 45 47 43
8 Admira Wacker II Admira 30 51 47 41
9 FAC Wien FAC Wien 30 44 42 41
10 Mattersburg II Mattersburg 30 59 53 38
11 Zwettl Zwettl 30 36 62 31
12 Würmla Würmla 30 41 58 29
13 Neusiedl Neusiedl 30 37 50 27
14 Ostbahn XI Ostbahn XI 30 39 71 27
15 SKU Amstetten Amstetten 30 44 61 26
16 SV Stegersbach Stegersbach 30 43 65 26
TEMPORADA 2007/2008
TERCERA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 SKN St. Polten Polten 30 58 21 73
2 FAC Wien FAC Wien 30 59 31 65
3 Rapid Wien II Rapid Wien 30 60 34 57
4 Wiener SC Wiener SC 30 50 24 56
5 First Vienna First Vienna 30 43 34 49
6 Horn Horn 30 54 45 46
7 Würmla Würmla 30 48 49 46
8 Neusiedl Neusiedl 30 40 47 41
9 Admira Admira 30 50 43 40
10 Wienerberg Wienerberg 30 34 36 37
11 Waidhofen Waidhofen 30 39 44 37
12 Mattersburg II Mattersburg 30 43 46 34
13 Zwettl Zwettl 30 47 58 33
14 Schwechat Schwechat 30 32 47 32
15 Baumgarten Baumgarten 30 35 73 19
16 Eisenstadt SC Eisenstadt 30 13 73 11

  USO DE MEMORIA  
6,403,840 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0015
Controller Execution Time ( Home / Category )  0.1450
Total Execution Time  0.1465
  CADENA URL  
/historico/Mattersburg-Ii/2020
  GET DATOS  
$_GET['/historico/Mattersburg-Ii/2020']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (32)  
0.0040  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 = 'Mattersburg-Ii' 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.0021  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=12393 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021  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=12393 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12393 AND type_rel = 2
0.0034  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 = '12393' ORDER BY l.year DESC,cat.coefficient DESC
0.0032  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 = '12393' AND l.year = 2020 ORDER BY l.year DESC,cat.coefficient DESC
0.0030  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 = '12393' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0035  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 = '12393' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0030  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 = 50222 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0033  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=12393 AND l.year in (2019,2020,2021) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (50222) 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.0030  SELECT count(id) as num_players from rel_players WHERE league_id = 50222 AND teamId = 12393
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 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0025  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 = '12393' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0026  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 = '12393' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0059  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 = 50222 WHERE rp.league_id = 50222 AND rp.teamId = 12393 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.0049  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 = 50222 WHERE rp.league_id = 50222 AND rp.teamId = 12393 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0031  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 = 50222 WHERE rp.league_id = 50222 AND rp.teamId = 12393 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0030  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 = 12393 AND l.year <= 2020 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0030  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.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 `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 = 38910 AND t.round = 30 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 `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 = 33427 AND t.round = 34 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 `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 = 15766 AND t.round = 34 ORDER BY team.conference 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 `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 = 4154 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0035  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 = 2766 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0059  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 = 24527 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032  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 = 24530 AND t.round = 30 ORDER BY team.conference 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 `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 = 24533 AND t.round = 30 ORDER BY team.conference 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 `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 = 24536 AND t.round = 30 ORDER BY team.conference 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 `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 = 24539 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 24542 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 50222 ORDER BY nameShow LIMIT 100