4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 1965/1966
LIGA SUECA
Equipo PJ GF GC Puntos
1 Djurgårdens IF Djurgårdens 22 46 17 48
2 IFK Norrköping Norrköping 22 53 24 41
3 IFK Göteborg Göteborg 22 44 34 41
4 IF Elfsborg IF Elfsborg 22 40 26 40
5 AIK Solna AIK Solna 22 36 26 39
6 Örgryte Örgryte 22 45 40 31
7 Orebro SK Orebro SK 22 42 44 28
8 GAIS GAIS 22 19 27 27
9 Malmö FF Malmö FF 22 32 34 25
10 Helsingborgs IF Helsingborgs 22 28 46 21
11 IK Brage IK Brage 22 23 53 16
12 Degerfors IF Degerfors 22 21 58 9
TEMPORADA 1964/1965
LIGA SUECA
Equipo PJ GF GC Puntos
1 Malmö FF Malmö FF 22 64 24 49
2 IF Elfsborg IF Elfsborg 22 52 20 45
3 AIK Solna AIK Solna 22 40 29 42
4 IFK Norrköping Norrköping 22 41 25 37
5 IFK Göteborg Göteborg 22 31 35 34
6 Örgryte Örgryte 22 52 42 29
7 Orebro SK Orebro SK 22 23 27 28
8 Djurgårdens IF Djurgårdens 22 40 34 27
9 Degerfors IF Degerfors 22 29 41 22
10 Helsingborgs IF Helsingborgs 22 28 59 20
11 Hammarby IF Hammarby IF 22 36 48 18
12 GIF Sundsvall Sundsvall 22 19 71 7
TEMPORADA 1963/1964
LIGA SUECA
Equipo PJ GF GC Puntos
1 Örgryte Örgryte 22 54 36 45
2 Djurgårdens IF Djurgårdens 22 46 20 44
3 Malmö FF Malmö FF 22 45 20 44
4 IFK Norrköping Norrköping 22 55 28 39
5 IF Elfsborg IF Elfsborg 22 42 32 38
6 Degerfors IF Degerfors 22 40 47 31
7 AIK Solna AIK Solna 22 38 38 27
8 Orebro SK Orebro SK 22 24 35 26
9 IFK Göteborg Göteborg 22 31 46 26
10 Helsingborgs IF Helsingborgs 22 42 53 24
11 IFK Eskilstuna Eskilstuna 22 24 49 18
12 GAIS GAIS 22 21 58 10
TEMPORADA 1962/1963
LIGA SUECA
Equipo PJ GF GC Puntos
1 IFK Norrköping Norrköping 22 47 30 43
2 Degerfors IF Degerfors 22 48 32 43
3 AIK Solna AIK Solna 22 42 28 38
4 Malmö FF Malmö FF 22 43 31 38
5 IFK Göteborg Göteborg 22 52 31 37
6 Djurgårdens IF Djurgårdens 22 37 34 36
7 Örgryte Örgryte 22 36 34 31
8 Orebro SK Orebro SK 22 31 33 26
9 Helsingborgs IF Helsingborgs 22 33 47 26
10 IF Elfsborg IF Elfsborg 22 29 42 25
11 Hammarby IF Hammarby IF 22 43 60 19
12 Halmia Halmia 22 28 67 6
TEMPORADA 1961/1962
LIGA SUECA
Equipo PJ GF GC Puntos
1 IFK Norrköping Norrköping 22 39 19 46
2 Djurgårdens IF Djurgårdens 22 51 19 41
3 Helsingborgs IF Helsingborgs 22 37 38 35
4 IFK Göteborg Göteborg 22 46 32 34
5 Örgryte Örgryte 22 38 28 33
6 IF Elfsborg IF Elfsborg 22 37 37 31
7 Orebro SK Orebro SK 22 26 28 31
8 Malmö FF Malmö FF 22 32 40 31
9 Hammarby IF Hammarby IF 22 32 43 28
10 Degerfors IF Degerfors 22 33 35 25
11 IFK Malmö IFK Malmö 22 21 41 23
12 Hogadals IS Hogadals IS 22 24 56 12
TEMPORADA 1960/1961
LIGA SUECA
Equipo PJ GF GC Puntos
1 IF Elfsborg IF Elfsborg 22 54 37 44
2 IFK Norrköping Norrköping 22 50 30 37
3 IFK Göteborg Göteborg 22 62 47 37
4 Malmö FF Malmö FF 22 31 34 34
5 Orebro SK Orebro SK 22 39 33 32
6 IFK Malmö IFK Malmö 22 30 26 30
7 Örgryte Örgryte 22 41 39 29
8 Degerfors IF Degerfors 22 27 38 28
9 Helsingborgs IF Helsingborgs 22 44 44 27
10 Hammarby IF Hammarby IF 22 33 52 26
11 AIK Solna AIK Solna 22 29 42 24
12 Sandvikens IF Sandvikens 22 29 47 18
TEMPORADA 1953/1954
LIGA SUECA
Equipo PJ GF GC Puntos
1 Helsingborgs IF Helsingborgs 22 41 30 37
2 GAIS GAIS 22 46 39 37
3 Degerfors IF Degerfors 22 30 34 35
4 AIK Solna AIK Solna 22 47 31 34
5 IFK Norrköping Norrköping 22 33 28 30
6 Malmö FF Malmö FF 22 33 30 30
7 Kalmar FF Kalmar FF 22 32 42 30
8 Djurgårdens IF Djurgårdens 22 44 30 29
9 IFK Göteborg Göteborg 22 23 26 29
10 Sandvikens IF Sandvikens 22 29 37 26
11 Jönköpings Södra Jönköpings 22 34 41 23
12 IF Elfsborg IF Elfsborg 22 24 48 20
TEMPORADA 1952/1953
LIGA SUECA
Equipo PJ GF GC Puntos
1 Malmö FF Malmö FF 22 60 32 45
2 IFK Norrköping Norrköping 22 49 32 39
3 Djurgårdens IF Djurgårdens 22 41 34 37
4 GAIS GAIS 22 50 50 34
5 AIK Solna AIK Solna 22 36 36 34
6 Helsingborgs IF Helsingborgs 22 33 23 32
7 IFK Göteborg Göteborg 22 32 54 29
8 Degerfors IF Degerfors 22 41 36 28
9 Jönköpings Södra Jönköpings 22 40 43 28
10 IF Elfsborg IF Elfsborg 22 28 36 25
11 Orebro SK Orebro SK 22 23 40 22
12 IFK Malmö IFK Malmö 22 29 46 19
TEMPORADA 1951/1952
LIGA SUECA
Equipo PJ GF GC Puntos
1 IFK Norrköping Norrköping 22 50 21 50
2 Malmö FF Malmö FF 22 50 17 47
3 Helsingborgs IF Helsingborgs 22 40 24 37
4 IFK Göteborg Göteborg 22 46 37 35
5 GAIS GAIS 22 41 34 33
6 Djurgårdens IF Djurgårdens 22 39 42 33
7 Degerfors IF Degerfors 22 36 29 32
8 Orebro SK Orebro SK 22 40 45 32
9 Jönköpings Södra Jönköpings 22 34 40 24
10 IF Elfsborg IF Elfsborg 22 27 47 18
11 Råå IF Råå IF 22 22 58 16
12 Åtvidabergs Åtvidabergs 22 21 52 11
TEMPORADA 1950/1951
LIGA SUECA
Equipo PJ GF GC Puntos
1 Malmö FF Malmö FF 22 52 22 53
2 Råå IF Råå IF 22 44 27 40
3 Degerfors IF Degerfors 22 34 23 37
4 Helsingborgs IF Helsingborgs 22 43 29 36
5 IFK Norrköping Norrköping 22 38 29 36
6 Djurgårdens IF Djurgårdens 22 42 37 32
7 GAIS GAIS 22 33 40 27
8 Orebro SK Orebro SK 22 32 45 25
9 Jönköpings Södra Jönköpings 22 37 54 25
10 IF Elfsborg IF Elfsborg 22 31 41 23
11 AIK Solna AIK Solna 22 27 37 23
12 Kalmar FF Kalmar FF 22 25 54 12
TEMPORADA 1949/1950
LIGA SUECA
Equipo PJ GF GC Puntos
1 Malmö FF Malmö FF 22 82 21 62
2 Jönköpings Södra Jönköpings 22 50 37 39
3 Helsingborgs IF Helsingborgs 22 45 38 36
4 AIK Solna AIK Solna 22 34 31 36
5 IFK Norrköping Norrköping 22 36 45 29
6 GAIS GAIS 22 34 42 28
7 Djurgårdens IF Djurgårdens 22 34 39 26
8 IF Elfsborg IF Elfsborg 22 34 45 25
9 Degerfors IF Degerfors 22 26 35 24
10 Kalmar FF Kalmar FF 22 25 33 23
11 IFK Göteborg Göteborg 22 33 49 20
12 Halmia Halmia 22 28 46 20
TEMPORADA 1948/1949
LIGA SUECA
Equipo PJ GF GC Puntos
1 Malmö FF Malmö FF 22 72 29 41
2 Helsingborgs IF Helsingborgs 22 48 30 40
3 GAIS GAIS 22 41 29 39
4 AIK Solna AIK Solna 22 42 38 36
5 Degerfors IF Degerfors 22 45 33 35
6 IFK Göteborg Göteborg 22 36 33 32
7 IFK Norrköping Norrköping 22 38 33 30
8 Jönköpings Södra Jönköpings 22 34 52 28
9 Halmia Halmia 22 33 39 25
10 IF Elfsborg IF Elfsborg 22 28 47 25
11 Orebro SK Orebro SK 22 30 50 19
12 Landskrona BoIS Landskrona 22 26 60 14
TEMPORADA 1947/1948
LIGA SUECA
Equipo PJ GF GC Puntos
1 IFK Norrköping Norrköping 22 56 32 48
2 Malmö FF Malmö FF 22 60 33 41
3 AIK Solna AIK Solna 22 51 34 39
4 Helsingborgs IF Helsingborgs 22 46 46 33
5 IFK Göteborg Göteborg 22 40 33 31
6 GAIS GAIS 22 36 41 27
7 Halmia Halmia 22 34 41 25
8 Degerfors IF Degerfors 22 30 39 25
9 IF Elfsborg IF Elfsborg 22 40 51 25
10 Jönköpings Södra Jönköpings 22 31 53 25
11 Djurgårdens IF Djurgårdens 22 32 35 23
12 Halmstads Halmstads 22 38 56 23
TEMPORADA 1946/1947
LIGA SUECA
Equipo PJ GF GC Puntos
1 IFK Norrköping Norrköping 22 73 23 52
2 AIK Solna AIK Solna 22 59 32 43
3 Malmö FF Malmö FF 22 51 30 38
4 IF Elfsborg IF Elfsborg 22 55 42 38
5 IFK Göteborg Göteborg 22 52 48 33
6 Helsingborgs IF Helsingborgs 22 44 50 33
7 Degerfors IF Degerfors 22 35 33 30
8 Halmia Halmia 22 38 43 30
9 Djurgårdens IF Djurgårdens 22 40 46 28
10 GAIS GAIS 22 30 40 23
11 Orebro SK Orebro SK 22 40 74 18
12 Billingsfors IK Billingsfors 22 28 84 3
TEMPORADA 1945/1946
LIGA SUECA
Equipo PJ GF GC Puntos
1 IFK Norrköping Norrköping 22 67 22 51
2 Malmö FF Malmö FF 22 48 27 43
3 IFK Göteborg Göteborg 22 48 29 42
4 GAIS GAIS 22 36 28 39
5 Degerfors IF Degerfors 22 31 23 32
6 AIK Solna AIK Solna 22 44 45 30
7 IF Elfsborg IF Elfsborg 22 43 44 27
8 Helsingborgs IF Helsingborgs 22 45 57 24
9 Djurgårdens IF Djurgårdens 22 42 64 23
10 Halmia Halmia 22 40 49 22
11 Jönköpings Södra Jönköpings 22 31 60 21
12 Halmstads Halmstads 22 24 51 13
TEMPORADA 1944/1945
LIGA SUECA
Equipo PJ GF GC Puntos
1 IFK Norrköping Norrköping 22 71 23 54
2 IF Elfsborg IF Elfsborg 22 52 31 45
3 Malmö FF Malmö FF 22 58 31 40
4 IFK Göteborg Göteborg 22 57 43 39
5 Degerfors IF Degerfors 22 35 32 35
6 GAIS GAIS 22 35 38 30
7 AIK Solna AIK Solna 22 38 38 26
8 Halmstads Halmstads 22 33 58 26
9 Halmia Halmia 22 31 49 23
10 Ludvika Ludvika 22 30 56 20
11 Helsingborgs IF Helsingborgs 22 35 56 19
12 Landskrona BoIS Landskrona 22 38 58 17
TEMPORADA 1943/1944
LIGA SUECA
Equipo PJ GF GC Puntos
1 Malmö FF Malmö FF 22 54 22 54
2 AIK Solna AIK Solna 22 54 25 49
3 IF Elfsborg IF Elfsborg 22 63 30 47
4 IFK Norrköping Norrköping 22 53 31 43
5 IFK Göteborg Göteborg 22 69 42 39
6 Degerfors IF Degerfors 22 42 30 32
7 Halmia Halmia 22 47 56 31
8 Halmstads Halmstads 22 32 53 20
9 GAIS GAIS 22 20 48 20
10 IK Brage IK Brage 22 22 59 15
11 Helsingborgs IF Helsingborgs 22 26 50 14
12 Sandvikens IF Sandvikens 22 23 59 8
TEMPORADA 1942/1943
LIGA SUECA
Equipo PJ GF GC Puntos
1 IF Elfsborg IF Elfsborg 22 58 32 44
2 IFK Norrköping Norrköping 22 52 25 43
3 Helsingborgs IF Helsingborgs 22 46 28 42
4 Degerfors IF Degerfors 22 49 27 35
5 Malmö FF Malmö FF 22 44 30 35
6 AIK Solna AIK Solna 22 48 37 34
7 Halmstads Halmstads 22 38 50 34
8 IFK Göteborg Göteborg 22 46 40 31
9 Sandvikens IF Sandvikens 22 31 47 26
10 GAIS GAIS 22 38 47 21
11 Gårda BK Gårda BK 22 17 60 11
12 IFK Eskilstuna Eskilstuna 22 31 75 9
TEMPORADA 1941/1942
LIGA SUECA
Equipo PJ GF GC Puntos
1 IFK Göteborg Göteborg 22 48 29 45
2 IFK Norrköping Norrköping 22 50 35 38
3 GAIS GAIS 22 46 31 37
4 Helsingborgs IF Helsingborgs 22 42 27 37
5 Malmö FF Malmö FF 22 37 33 34
6 Degerfors IF Degerfors 22 43 35 32
7 Gårda BK Gårda BK 22 34 46 31
8 IF Elfsborg IF Elfsborg 22 35 29 30
9 AIK Solna AIK Solna 22 37 34 28
10 Sandvikens IF Sandvikens 22 27 45 21
11 Landskrona BoIS Landskrona 22 22 47 19
12 Reymersholms IK Reymersholms 22 27 57 16
TEMPORADA 1940/1941
LIGA SUECA
Equipo PJ GF GC Puntos
1 Helsingborgs IF Helsingborgs 22 46 26 45
2 Degerfors IF Degerfors 22 47 28 41
3 AIK Solna AIK Solna 22 45 36 37
4 IF Elfsborg IF Elfsborg 22 54 37 36
5 Landskrona BoIS Landskrona 22 36 36 33
6 IFK Göteborg Göteborg 22 42 36 30
7 IFK Norrköping Norrköping 22 35 32 30
8 Malmö FF Malmö FF 22 33 33 29
9 Gårda BK Gårda BK 22 31 42 25
10 Sandvikens IF Sandvikens 22 30 42 24
11 IK Brage IK Brage 22 39 53 22
12 Sleipner Sleipner 22 28 65 13

  USO DE MEMORIA  
6,643,440 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1261
Total Execution Time  0.1274
  CADENA URL  
/historico/If-Elfsborg-Boras/1966
  GET DATOS  
$_GET['/historico/If-Elfsborg-Boras/1966']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0033  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 = 'If-Elfsborg-Boras' AND l.year = 1966 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=1357 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=1357 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0042  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 = 22998
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1357 AND type_rel = 2
0.0019  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1357 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 (43778,57042,132514,1145240,1277727) ORDER BY n.cover_points DESC, update_date DESC
0.0033  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 = '1357' AND l.year = 1966 ORDER BY l.year DESC,cat.coefficient DESC
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 = '1357' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  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 = 22998 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0029  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=1357 AND l.year in (1965,1966,1967) ORDER BY l.id DESC, l.year DESC ;
0.0018  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 (22999) 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.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 22999 AND teamId = 1357
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 FROM `tables1966` 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 = 22998 AND t.round = 22 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020  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 events1966 e ON e.player_id = p.id AND e.league_id = 22998 WHERE rp.league_id = 22998 AND rp.teamId = 1357 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.0020  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 events1966 e ON e.player_id = p.id AND e.league_id = 22998 WHERE rp.league_id = 22998 AND rp.teamId = 1357 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 events1966 e ON e.player_id = p.id AND e.league_id = 22998 WHERE rp.league_id = 22998 AND rp.teamId = 1357 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028  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 = 1357 AND l.year <= 1966 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `tables1966` 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 = 22998 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 `tables1965` 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 = 22999 AND t.round = 22 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 `tables1964` 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 = 23002 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 `tables1963` 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 = 23003 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 `tables1962` 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 = 23004 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 `tables1961` 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 = 23005 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 `tables1954` 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 = 23011 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 `tables1953` 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 = 23018 AND t.round = 22 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 `tables1952` 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 = 23019 AND t.round = 22 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 `tables1951` 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 = 23012 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 `tables1950` 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 = 23013 AND t.round = 22 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 `tables1949` 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 = 23014 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 `tables1948` 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 = 23015 AND t.round = 22 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 `tables1947` 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 = 23016 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 `tables1946` 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 = 23020 AND t.round = 22 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 `tables1945` 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 = 23021 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 `tables1944` 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 = 23022 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 `tables1943` 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 = 23023 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 `tables1942` 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 = 23024 AND t.round = 22 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 `tables1941` 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 = 23025 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC