4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 1932/1933
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 First Vienna First Vienna 22 52 26 51
2 Rapid Wien Rapid Wien 22 65 35 47
3 Admira Admira 22 63 42 36
4 Wiener AC Wiener AC 22 46 41 33
5 FC Wien FC Wien 22 39 37 32
6 Austria Wien Austria Wien 22 37 45 30
7 Wacker Wien Wacker Wien 22 49 58 30
8 Hakoah Wien Hakoah Wien 22 30 41 28
9 Wiener SC Wiener SC 22 36 42 25
10 FAC Wien FAC Wien 22 35 47 23
11 Libertas Wien Libertas 22 23 34 22
12 Brigittenauer Brigittenaue 22 28 55 20
TEMPORADA 1931/1932
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Rapid Wien Rapid Wien 23 72 40 49
2 Admira Admira 22 58 26 47
3 First Vienna First Vienna 22 57 27 44
4 Austria Wien Austria Wien 23 67 42 43
5 Wiener AC Wiener AC 23 47 43 34
6 Brigittenauer Brigittenaue 22 28 43 29
7 Wacker Wien Wacker Wien 22 32 42 28
8 FC Wien FC Wien 22 36 43 25
9 Wiener SC Wiener SC 23 42 58 21
10 Hakoah Wien Hakoah Wien 22 26 62 19
11 FAC Wien FAC Wien 22 44 56 18
12 Slovan-Hütteldorfer Slovan-Hütt 22 20 47 14
TEMPORADA 1930/1931
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 First Vienna First Vienna 18 53 25 41
2 Admira Admira 18 68 37 39
3 Rapid Wien Rapid Wien 18 64 33 38
4 Austria Wien Austria Wien 18 51 40 28
5 FC Wien FC Wien 18 38 38 24
6 Wiener AC Wiener AC 18 44 47 21
7 Wacker Wien Wacker Wien 18 37 51 21
8 Wiener SC Wiener SC 18 48 65 18
9 FAC Wien FAC Wien 18 31 59 16
10 Slovan-Hütteldorfer Slovan-Hütt 18 21 60 8
TEMPORADA 1929/1930
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Rapid Wien Rapid Wien 20 67 29 43
2 Admira Admira 20 56 34 41
3 First Vienna First Vienna 20 51 31 40
4 Wiener AC Wiener AC 20 39 29 35
5 Austria Wien Austria Wien 20 56 43 29
6 FAC Wien FAC Wien 20 35 45 24
7 Wacker Wien Wacker Wien 20 34 47 24
8 FC Wien FC Wien 20 28 45 24
9 Wiener SC Wiener SC 20 33 47 21
10 Hakoah Wien Hakoah Wien 20 31 61 14
11 Hertha Wien Hertha Wien 20 33 52 13
TEMPORADA 1928/1929
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Rapid Wien Rapid Wien 22 57 31 48
2 Admira Admira 22 63 30 43
3 Wiener AC Wiener AC 22 49 28 41
4 Wiener SC Wiener SC 22 50 43 36
5 FAC Wien FAC Wien 22 51 42 35
6 FC Wien FC Wien 22 47 45 34
7 First Vienna First Vienna 22 43 35 30
8 Austria Wien Austria Wien 22 40 42 28
9 Hertha Wien Hertha Wien 22 28 53 27
10 Wacker Wien Wacker Wien 22 36 41 25
11 Slovan-Hütteldorfer Slovan-Hütt 22 37 71 13
12 Brigittenauer Brigittenaue 22 26 66 13
TEMPORADA 1927/1928
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Admira Admira 24 69 30 57
2 Rapid Wien Rapid Wien 24 82 46 54
3 First Vienna First Vienna 24 69 44 46
4 Wacker Wien Wacker Wien 24 53 32 45
5 FAC Wien FAC Wien 24 59 55 36
6 Hertha Wien Hertha Wien 24 46 52 33
7 Slovan-Hütteldorfer Slovan-Hütt 24 42 45 28
8 Austria Wien Austria Wien 24 45 52 28
9 Wiener AC Wiener AC 24 50 50 25
10 Wiener SC Wiener SC 24 37 57 25
11 Brigittenauer Brigittenaue 24 37 71 23
12 Hakoah Wien Hakoah Wien 24 24 54 21
13 Simmeringer SC Simmeringer 24 42 67 18
TEMPORADA 1926/1927
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Admira Admira 24 81 41 53
2 Brigittenauer Brigittenaue 25 46 25 50
3 Rapid Wien Rapid Wien 25 84 46 47
4 First Vienna First Vienna 25 69 47 40
5 FAC Wien FAC Wien 24 48 54 38
6 Simmeringer SC Simmeringer 24 44 52 37
7 Austria Wien Austria Wien 24 46 42 34
8 Wacker Wien Wacker Wien 24 43 48 30
9 Hakoah Wien Hakoah Wien 24 38 43 29
10 Wiener AC Wiener AC 25 55 66 29
11 Wiener SC Wiener SC 24 46 52 28
12 Slovan-Hütteldorfer Slovan-Hütt 24 35 52 26
13 Rudolfshügel Rudolfshüge 24 29 96 5
TEMPORADA 1925/1926
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Austria Wien Austria Wien 24 73 39 50
2 First Vienna First Vienna 24 61 45 45
3 Simmeringer SC Simmeringer 24 64 52 41
4 Admira Admira 24 49 42 39
5 Rapid Wien Rapid Wien 24 61 57 39
6 Slovan-Hütteldorfer Slovan-Hütt 24 56 47 37
7 Hakoah Wien Hakoah Wien 24 56 50 35
8 Wiener SC Wiener SC 24 45 57 35
9 Wacker Wien Wacker Wien 24 51 53 32
10 Wiener AC Wiener AC 24 42 47 29
11 FAC Wien FAC Wien 24 43 53 26
12 Rudolfshügel Rudolfshüge 24 38 68 15
13 Hertha Wien Hertha Wien 24 35 64 14
TEMPORADA 1924/1925
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Hakoah Wien Hakoah Wien 20 43 30 36
2 Austria Wien Austria Wien 20 36 28 34
3 Rapid Wien Rapid Wien 20 49 39 32
4 First Vienna First Vienna 20 41 32 32
5 Wiener AC Wiener AC 20 42 37 31
6 Admira Admira 20 39 30 30
7 Wacker Wien Wacker Wien 20 34 36 26
8 Simmeringer SC Simmeringer 20 43 44 25
9 Wiener SC Wiener SC 20 32 35 23
10 Slovan-Hütteldorfer Slovan-Hütt 20 31 42 22
11 Rudolfshügel Rudolfshüge 20 21 58 9
TEMPORADA 1923/1924
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Austria Wien Austria Wien 22 53 19 52
2 First Vienna First Vienna 22 54 30 46
3 Wiener SC Wiener SC 22 40 17 41
4 Rapid Wien Rapid Wien 22 55 48 38
5 Simmeringer SC Simmeringer 22 46 32 34
6 Hakoah Wien Hakoah Wien 22 41 34 30
7 Admira Admira 22 36 34 28
8 Wacker Wien Wacker Wien 22 33 34 26
9 Slovan-Hütteldorfer Slovan-Hütt 22 36 46 25
10 Hertha Wien Hertha Wien 22 22 33 21
11 Brigittenauer Brigittenaue 22 17 64 11
12 WAF WAF 22 26 68 8
TEMPORADA 1922/1923
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Rapid Wien Rapid Wien 24 78 42 51
2 Austria Wien Austria Wien 24 65 35 46
3 Admira Admira 24 60 52 39
4 First Vienna First Vienna 24 46 52 35
5 Wiener SC Wiener SC 24 40 34 34
6 Hakoah Wien Hakoah Wien 24 44 33 33
7 Wacker Wien Wacker Wien 24 42 40 33
8 Hertha Wien Hertha Wien 24 40 41 31
9 Simmeringer SC Simmeringer 24 36 43 31
10 WAF WAF 24 34 53 29
11 FAC Wien FAC Wien 24 42 54 24
12 Wiener AC Wiener AC 24 36 58 22
13 Rudolfshügel Rudolfshüge 24 30 56 21
TEMPORADA 1921/1922
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Wiener SC Wiener SC 24 45 24 49
2 Rapid Wien Rapid Wien 24 72 46 45
3 Hakoah Wien Hakoah Wien 24 48 32 44
4 Austria Wien Austria Wien 24 59 39 42
5 Wacker Wien Wacker Wien 24 38 35 37
6 Hertha Wien Hertha Wien 24 34 41 32
7 WAF WAF 24 38 52 30
8 First Vienna First Vienna 24 44 47 28
9 Admira Admira 24 45 62 28
10 FAC Wien FAC Wien 24 47 52 27
11 Rudolfshügel Rudolfshüge 24 33 37 26
12 Simmeringer SC Simmeringer 24 38 52 26
13 Brigittenauer Brigittenaue 24 32 54 23
TEMPORADA 1920/1921
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Rapid Wien Rapid Wien 24 86 39 57
2 Austria Wien Austria Wien 24 66 30 49
3 Rudolfshügel Rudolfshüge 24 44 41 35
4 Hakoah Wien Hakoah Wien 24 34 28 33
5 Hertha Wien Hertha Wien 24 44 41 32
6 WAF WAF 24 37 36 32
7 Wiener SC Wiener SC 24 41 42 30
8 FAC Wien FAC Wien 24 44 47 29
9 Simmeringer SC Simmeringer 24 38 56 29
10 First Vienna First Vienna 24 33 47 28
11 Wacker Wien Wacker Wien 24 27 41 26
12 Admira Admira 24 40 56 23
13 Wiener AC Wiener AC 24 37 67 23
TEMPORADA 1919/1920
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Rapid Wien Rapid Wien 22 71 29 48
2 Austria Wien Austria Wien 22 55 24 47
3 Wiener SC Wiener SC 22 37 28 43
4 FAC Wien FAC Wien 22 36 24 39
5 Rudolfshügel Rudolfshüge 22 42 30 36
6 Wiener AC Wiener AC 22 31 36 30
7 Simmeringer SC Simmeringer 22 39 44 29
8 Wacker Wien Wacker Wien 22 27 48 23
9 Hertha Wien Hertha Wien 22 24 33 22
10 First Vienna First Vienna 22 36 47 19
11 WAF WAF 22 30 43 17
12 Admira Admira 22 25 67 14
TEMPORADA 1918/1919
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Rapid Wien Rapid Wien 18 67 15 46
2 Rudolfshügel Rudolfshüge 18 51 32 34
3 Wiener AC Wiener AC 18 42 26 31
4 WAF WAF 18 32 26 28
5 Wiener SC Wiener SC 18 25 38 27
6 FAC Wien FAC Wien 19 46 35 25
7 Austria Wien Austria Wien 19 29 39 21
8 Hertha Wien Hertha Wien 18 34 52 17
9 Simmeringer SC Simmeringer 18 29 63 16
10 Wacker Wien Wacker Wien 18 20 49 10
TEMPORADA 1917/1918
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 FAC Wien FAC Wien 18 47 16 33
2 Rapid Wien Rapid Wien 18 46 23 33
3 WAF WAF 18 52 41 32
4 Rudolfshügel Rudolfshüge 18 45 31 31
5 Wacker Wien Wacker Wien 19 28 36 27
6 Wiener AC Wiener AC 18 33 24 23
7 Wiener SC Wiener SC 18 35 50 21
8 Simmeringer SC Simmeringer 19 31 49 20
9 Austria Wien Austria Wien 18 23 33 19
10 Hertha Wien Hertha Wien 18 24 61 10
TEMPORADA 1916/1917
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Rapid Wien Rapid Wien 18 64 28 42
2 FAC Wien FAC Wien 18 55 17 39
3 Rudolfshügel Rudolfshüge 18 49 30 39
4 WAF WAF 18 61 32 36
5 Wacker Wien Wacker Wien 18 36 38 25
6 Wiener AC Wiener AC 18 34 40 25
7 Wiener SC Wiener SC 18 36 42 20
8 Austria Wien Austria Wien 18 34 47 12
9 Simmeringer SC Simmeringer 18 25 64 10
10 Hertha Wien Hertha Wien 18 20 76 7
TEMPORADA 1915/1916
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Rapid Wien Rapid Wien 18 87 26 46
2 FAC Wien FAC Wien 18 51 18 43
3 WAF WAF 18 65 24 38
4 Wiener AC Wiener AC 18 64 35 38
5 Rudolfshügel Rudolfshüge 18 54 39 32
6 Wacker Wien Wacker Wien 18 28 34 24
7 Austria Wien Austria Wien 18 23 46 20
8 Wiener SC Wiener SC 18 28 49 13
9 Hertha Wien Hertha Wien 18 12 68 4
10 Simmeringer SC Simmeringer 18 18 91 3
TEMPORADA 1914/1915
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Wiener AC Wiener AC 9 46 9 24
2 WAF WAF 9 30 14 22
3 Rapid Wien Rapid Wien 9 23 16 14
4 Austria Wien Austria Wien 9 15 11 13
5 FAC Wien FAC Wien 9 22 22 12
6 Rudolfshügel Rudolfshüge 9 21 26 12
7 Hertha Wien Hertha Wien 9 15 22 11
8 Wiener SC Wiener SC 9 13 26 9
9 Wacker Wien Wacker Wien 9 13 22 6
10 Simmeringer SC Simmeringer 9 15 45 4
TEMPORADA 1913/1914
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Rapid Wien Rapid Wien 18 51 26 27
2 WAF WAF 18 54 34 25
3 Wiener SC Wiener SC 18 40 29 24
4 Wiener AC Wiener AC 18 51 27 23
5 Austria Wien Austria Wien 18 34 43 17
6 Simmeringer SC Simmeringer 18 38 42 16
7 Rudolfshügel Rudolfshüge 18 25 36 16
8 FAC Wien FAC Wien 18 32 43 13
9 Hertha Wien Hertha Wien 18 27 44 11
10 First Vienna First Vienna 18 21 49 8

  USO DE MEMORIA  
6,693,880 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1399
Total Execution Time  0.1411
  CADENA URL  
/historico/Rapid-Wien/1933
  GET DATOS  
$_GET['/historico/Rapid-Wien/1933']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (42)  
0.0046  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 = 'Rapid-Wien' AND l.year = 1933 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.0019  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=9774 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=9774 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=9774 AND type_rel = 2
0.0022  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 9774 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0022  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 (2898,4250,4425,4889,5084) ORDER BY n.cover_points DESC, update_date DESC
0.0048  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 = '9774' AND l.year = 1933 ORDER BY l.year DESC,cat.coefficient DESC
0.0054  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 = '9774' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = 26241 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0045  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=9774 AND l.year in (1932,1933,1934) 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 (26791,26243) 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.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 26243 AND teamId = 9774
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 26791 AND teamId = 9774
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 FROM `tables1933` 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 = 26241 AND t.round = 22 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021  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 = '9774' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0017  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '9774' and rp.type = 4
0.0019  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 = '9774' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0019  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 events1933 e ON e.player_id = p.id AND e.league_id = 26241 WHERE rp.league_id = 26241 AND rp.teamId = 9774 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.0019  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 events1933 e ON e.player_id = p.id AND e.league_id = 26241 WHERE rp.league_id = 26241 AND rp.teamId = 9774 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019  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 events1933 e ON e.player_id = p.id AND e.league_id = 26241 WHERE rp.league_id = 26241 AND rp.teamId = 9774 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0036  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 = 9774 AND l.year <= 1933 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 `tables1933` 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 = 26241 AND t.round = 22 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 `tables1932` 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 = 26243 AND t.round = 22 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 `tables1931` 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 = 26276 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0043  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 `tables1930` 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 = 26277 AND t.round = 22 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 `tables1929` 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 = 26281 AND t.round = 22 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 `tables1928` 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 = 26282 AND t.round = 26 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 `tables1927` 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 = 26284 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 `tables1926` 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 = 26286 AND t.round = 26 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 `tables1925` 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 = 26287 AND t.round = 22 ORDER BY team.conference 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 `tables1924` 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 = 26291 AND t.round = 22 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 `tables1923` 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 = 26299 AND t.round = 26 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 `tables1922` 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 = 26300 AND t.round = 26 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 `tables1921` 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 = 26303 AND t.round = 26 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 `tables1920` 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 = 26305 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 `tables1919` 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 = 26307 AND t.round = 18 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 `tables1918` 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 = 26308 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 `tables1917` 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 = 26309 AND t.round = 18 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 `tables1916` 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 = 26312 AND t.round = 18 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 `tables1915` 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 = 26313 AND t.round = 9 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 `tables1914` 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 = 26314 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  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 = 26241 ORDER BY nameShow LIMIT 100