4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
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
TEMPORADA 1939/1940
LIGA SUECA
Equipo PJ GF GC Puntos
1 IFK Göteborg Göteborg 22 49 27 47
2 IF Elfsborg IF Elfsborg 22 66 31 45
3 Helsingborgs IF Helsingborgs 22 49 32 39
4 IK Brage IK Brage 22 42 38 36
5 Sandvikens IF Sandvikens 22 38 37 32
6 AIK Solna AIK Solna 22 38 38 29
7 Sleipner Sleipner 22 33 49 29
8 Landskrona BoIS Landskrona 22 42 50 28
9 Gårda BK Gårda BK 22 27 39 25
10 Malmö FF Malmö FF 22 25 28 22
11 Örgryte Örgryte 22 28 44 17
12 Hammarby IF Hammarby IF 22 34 58 13
TEMPORADA 1938/1939
LIGA SUECA
Equipo PJ GF GC Puntos
1 IF Elfsborg IF Elfsborg 22 65 26 49
2 AIK Solna AIK Solna 22 49 34 36
3 Malmö FF Malmö FF 22 30 29 34
4 Landskrona BoIS Landskrona 22 29 36 34
5 Gårda BK Gårda BK 22 38 37 29
6 Sandvikens IF Sandvikens 22 34 36 29
7 Sleipner Sleipner 22 43 44 28
8 Degerfors IF Degerfors 22 43 52 28
9 Örgryte Örgryte 22 39 43 27
10 Helsingborgs IF Helsingborgs 22 29 33 27
11 IK Brage IK Brage 22 33 38 27
12 Hallstahammar SK Hallstahamma 22 27 51 18
TEMPORADA 1937/1938
LIGA SUECA
Equipo PJ GF GC Puntos
1 Sleipner Sleipner 22 46 28 42
2 Helsingborgs IF Helsingborgs 22 36 27 38
3 IF Elfsborg IF Elfsborg 22 44 37 38
4 Landskrona BoIS Landskrona 22 40 31 36
5 AIK Solna AIK Solna 22 44 37 33
6 Gårda BK Gårda BK 22 29 28 33
7 IK Brage IK Brage 22 45 44 30
8 Sandvikens IF Sandvikens 22 29 32 29
9 Örgryte Örgryte 22 33 37 26
10 Malmö FF Malmö FF 22 20 30 26
11 IFK Göteborg Göteborg 22 28 35 22
12 GAIS GAIS 22 19 47 13
TEMPORADA 1936/1937
LIGA SUECA
Equipo PJ GF GC Puntos
1 AIK Solna AIK Solna 22 59 24 53
2 Sleipner Sleipner 22 45 41 39
3 Sandvikens IF Sandvikens 22 46 34 37
4 Örgryte Örgryte 22 45 32 35
5 IF Elfsborg IF Elfsborg 22 41 33 34
6 Malmö FF Malmö FF 22 39 45 30
7 GAIS GAIS 22 27 36 30
8 IFK Göteborg Göteborg 22 34 40 29
9 Landskrona BoIS Landskrona 22 33 42 28
10 Gårda BK Gårda BK 22 30 44 24
11 Djurgårdens IF Djurgårdens 22 39 52 20
12 IFK Norrköping Norrköping 22 31 46 18
TEMPORADA 1935/1936
LIGA SUECA
Equipo PJ GF GC Puntos
1 IF Elfsborg IF Elfsborg 22 71 33 49
2 AIK Solna AIK Solna 22 58 39 43
3 Sandvikens IF Sandvikens 22 40 32 38
4 Landskrona BoIS Landskrona 22 46 34 34
5 IFK Göteborg Göteborg 22 36 28 34
6 Gårda BK Gårda BK 22 27 28 33
7 Örgryte Örgryte 22 38 41 30
8 Sleipner Sleipner 22 51 48 27
9 GAIS GAIS 22 29 44 24
10 IFK Norrköping Norrköping 22 40 51 23
11 Halmstads Halmstads 22 31 46 22
12 IFK Eskilstuna Eskilstuna 22 24 67 8
TEMPORADA 1934/1935
LIGA SUECA
Equipo PJ GF GC Puntos
1 IFK Göteborg Göteborg 22 48 22 48
2 IF Elfsborg IF Elfsborg 22 59 43 41
3 Sandvikens IF Sandvikens 22 46 46 40
4 AIK Solna AIK Solna 22 59 28 39
5 GAIS GAIS 22 44 49 34
6 Landskrona BoIS Landskrona 22 47 47 32
7 Sleipner Sleipner 22 55 49 30
8 Örgryte Örgryte 22 40 42 29
9 Halmstads Halmstads 22 33 39 26
10 IFK Eskilstuna Eskilstuna 22 37 52 25
11 Helsingborgs IF Helsingborgs 22 40 49 20
12 Gefle Gefle 22 37 79 10
TEMPORADA 1933/1934
LIGA SUECA
Equipo PJ GF GC Puntos
1 Helsingborgs IF Helsingborgs 20 49 35 40
2 GAIS GAIS 20 54 34 38
3 IFK Göteborg Göteborg 20 52 38 36
4 Halmstads Halmstads 20 43 38 31
5 Örgryte Örgryte 20 38 35 30
6 IF Elfsborg IF Elfsborg 20 45 44 27
7 AIK Solna AIK Solna 20 40 42 24
8 Sandvikens IF Sandvikens 20 49 57 24
9 IFK Eskilstuna Eskilstuna 20 42 52 24
10 Gefle Gefle 20 37 56 22
11 Halmia Halmia 20 23 41 14
TEMPORADA 1932/1933
LIGA SUECA
Equipo PJ GF GC Puntos
1 Helsingborgs IF Helsingborgs 22 68 38 51
2 GAIS GAIS 22 70 30 50
3 IFK Göteborg Göteborg 22 58 42 36
4 AIK Solna AIK Solna 22 60 40 35
5 Örgryte Örgryte 22 40 43 29
6 IFK Eskilstuna Eskilstuna 22 47 55 29
7 IF Elfsborg IF Elfsborg 22 44 54 27
8 Malmö FF Malmö FF 22 42 66 27
9 Sandvikens IF Sandvikens 22 43 48 26
10 Halmia Halmia 22 34 50 24
11 Sleipner Sleipner 22 34 52 24
12 Landskrona BoIS Landskrona 22 38 60 21
TEMPORADA 1931/1932
LIGA SUECA
Equipo PJ GF GC Puntos
1 AIK Solna AIK Solna 22 58 33 45
2 Örgryte Örgryte 22 67 37 44
3 GAIS GAIS 22 45 29 41
4 IFK Göteborg Göteborg 22 47 34 37
5 IFK Eskilstuna Eskilstuna 22 50 44 32
6 Sleipner Sleipner 22 41 35 30
7 IF Elfsborg IF Elfsborg 22 38 35 30
8 Helsingborgs IF Helsingborgs 22 45 44 30
9 Malmö FF Malmö FF 22 48 68 22
10 Landskrona BoIS Landskrona 22 35 58 20
11 IFK Malmö IFK Malmö 22 32 55 18
12 Hallstahammar SK Hallstahamma 22 29 63 12
TEMPORADA 1930/1931
LIGA SUECA
Equipo PJ GF GC Puntos
1 GAIS GAIS 22 70 34 52
2 IFK Göteborg Göteborg 22 45 31 44
3 AIK Solna AIK Solna 22 67 41 42
4 Helsingborgs IF Helsingborgs 22 55 43 38
5 Landskrona BoIS Landskrona 22 47 49 34
6 IFK Malmö IFK Malmö 22 42 55 31
7 Örgryte Örgryte 22 45 46 29
8 Sleipner Sleipner 22 53 54 24
9 IFK Eskilstuna Eskilstuna 22 45 58 21
10 IF Elfsborg IF Elfsborg 22 39 59 21
11 Redbergslids IK Redbergslids 22 35 60 20
12 Sandvikens IF Sandvikens 22 39 52 18
TEMPORADA 1929/1930
LIGA SUECA
Equipo PJ GF GC Puntos
1 Helsingborgs IF Helsingborgs 22 78 33 44
2 IFK Göteborg Göteborg 22 67 28 42
3 Sleipner Sleipner 22 48 37 41
4 GAIS GAIS 22 46 31 39
5 Örgryte Örgryte 22 59 43 38
6 AIK Solna AIK Solna 22 52 35 36
7 Landskrona BoIS Landskrona 22 54 56 28
8 IF Elfsborg IF Elfsborg 22 45 49 28
9 Sandvikens IF Sandvikens 22 39 56 25
10 IFK Malmö IFK Malmö 22 37 59 22
11 IFK Norrköping Norrköping 22 32 77 17
12 Stattena IF Stattena IF 22 28 81 12
TEMPORADA 1928/1929
LIGA SUECA
Equipo PJ GF GC Puntos
1 Helsingborgs IF Helsingborgs 22 89 35 51
2 Örgryte Örgryte 22 72 42 48
3 IFK Göteborg Göteborg 22 56 34 46
4 Sleipner Sleipner 22 54 49 36
5 GAIS GAIS 22 47 43 31
6 IF Elfsborg IF Elfsborg 22 41 54 27
7 Landskrona BoIS Landskrona 22 37 47 26
8 IFK Malmö IFK Malmö 22 32 47 26
9 AIK Solna AIK Solna 22 47 55 24
10 IFK Eskilstuna Eskilstuna 22 41 74 23
11 IFK Norrköping Norrköping 22 25 33 20
12 Westermalms IF Westermalms 22 34 62 18
TEMPORADA 1927/1928
LIGA SUECA
Equipo PJ GF GC Puntos
1 Örgryte Örgryte 22 69 29 47
2 Helsingborgs IF Helsingborgs 22 64 27 47
3 GAIS GAIS 22 45 29 39
4 IFK Göteborg Göteborg 22 39 33 36
5 IF Elfsborg IF Elfsborg 22 48 35 33
6 Sleipner Sleipner 22 50 44 29
7 AIK Solna AIK Solna 22 49 47 28
8 Landskrona BoIS Landskrona 22 49 52 26
9 IFK Eskilstuna Eskilstuna 22 42 65 25
10 IFK Norrköping Norrköping 22 36 63 25
11 Djurgårdens IF Djurgårdens 22 43 66 18
12 Stattena IF Stattena IF 22 30 74 16

  USO DE MEMORIA  
6,631,976 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1258
Total Execution Time  0.1270
  CADENA URL  
/historico/If-Elfsborg-Boras/1947
  GET DATOS  
$_GET['/historico/If-Elfsborg-Boras/1947']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
0.0035  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 = 1947 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=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.0040  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 = 23016
0.0051  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 = 1947 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.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 = 23016 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0028  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 (1946,1947,1948) 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 (23020) 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.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 23020 AND teamId = 1357
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 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 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 events1947 e ON e.player_id = p.id AND e.league_id = 23016 WHERE rp.league_id = 23016 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.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 events1947 e ON e.player_id = p.id AND e.league_id = 23016 WHERE rp.league_id = 23016 AND rp.teamId = 1357 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021  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 events1947 e ON e.player_id = p.id AND e.league_id = 23016 WHERE rp.league_id = 23016 AND rp.teamId = 1357 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0032  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 <= 1947 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0029  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.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 `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.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 `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.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 `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.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 `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.0026  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.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 `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
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 `tables1940` 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 = 23026 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 `tables1939` 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 = 23027 AND t.round = 8 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 `tables1938` 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 = 23028 AND t.round = 6 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 `tables1937` 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 = 23034 AND t.round = 7 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 `tables1936` 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 = 23029 AND t.round = 8 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 `tables1935` 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 = 23030 AND t.round = 8 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 `tables1934` 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 = 23031 AND t.round = 7 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 `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 = 23032 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 = 23035 AND t.round = 7 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 `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 = 23036 AND t.round = 7 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 `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 = 23041 AND t.round = 7 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 `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 = 23037 AND t.round = 8 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 `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 = 23038 AND t.round = 7 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 = 23016 ORDER BY nameShow LIMIT 100