4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 1969/1970
LIGA PROFESIONAL ARGENTINA GRUPO 4
Equipo PJ GF GC Puntos
1 Estudiantes La Plata Estudiantes 3 4 3 5
2 Chacarita Juniors Chacarita 3 3 2 5
3 Quilmes Quilmes 3 2 1 5
4 CA Huracán CA Huracán 3 2 5 0
TEMPORADA 1968/1969
LIGA PROFESIONAL ARGENTINA GRUPO 2
Equipo PJ GF GC Puntos
1 Chacarita Juniors Chacarita 22 33 26 43
2 Boca Juniors Boca Juniors 22 34 11 42
3 Vélez Sarsfield Vélez 22 36 24 35
4 Independiente Independient 22 28 25 35
5 San Lorenzo San Lorenzo 22 37 27 33
6 Gimnasia La Plata Gimnasia 22 28 27 33
7 Lanús Lanús 22 37 34 31
8 Rosario Central Rosario 22 18 24 27
9 Banfield Banfield 22 24 36 26
10 Colón Colón 22 22 46 18
11 Atlanta Atlanta 22 18 37 11
12 Racing Club Racing Club 22 45 16 49
13 River Plate River Plate 22 35 21 43
14 Estudiantes La Plata Estudiantes 22 33 24 38
15 CA Huracán CA Huracán 22 38 29 32
16 Platense Platense 22 33 32 31
17 Quilmes Quilmes 22 28 34 30
18 Unión Santa Fe Unión Santa 22 25 26 26
19 Newell's Old Boys Newell's 22 24 28 26
20 Deportivo Morón Deportivo 22 16 38 18
21 Argentinos Juniors Argentinos 22 17 29 15
22 Los Andes Los Andes 22 24 39 13
TEMPORADA 1967/1968
LIGA PROFESIONAL ARGENTINA GRUPO 3
Equipo PJ GF GC Puntos
1 San Lorenzo San Lorenzo 22 44 10 50
2 Estudiantes La Plata Estudiantes 22 39 27 33
3 Lanús Lanús 21 20 21 30
4 Colón Colón 22 26 25 28
5 Racing Club Racing Club 22 28 29 28
6 Boca Juniors Boca Juniors 22 15 17 28
7 Newell's Old Boys Newell's 21 24 22 26
8 Banfield Banfield 22 23 27 26
9 Atlanta Atlanta 22 20 25 23
10 Ferro Carril Oeste Ferro Carril 22 20 38 21
11 Platense Platense 22 15 27 17
12 Vélez Sarsfield Vélez 22 40 20 44
13 River Plate River Plate 22 31 16 43
14 Rosario Central Rosario 22 29 17 37
15 CA Huracán CA Huracán 22 29 18 36
16 Independiente Independient 22 34 19 35
17 Chacarita Juniors Chacarita 22 28 29 33
18 Los Andes Los Andes 22 30 28 31
19 Argentinos Juniors Argentinos 22 23 29 25
20 Quilmes Quilmes 22 27 34 24
21 Gimnasia La Plata Gimnasia 22 20 52 14
22 Tigre Tigre 22 12 47 10
TEMPORADA 1966/1967
LIGA PROFESIONAL ARGENTINA GRUPO 4
Equipo PJ GF GC Puntos
1 Gimnasia La Plata Gimnasia 14 35 11 22
2 CA Huracán CA Huracán 14 36 15 21
3 Colón Colón 14 23 17 18
4 Banfield Banfield 14 37 18 17
5 Sportivo Guzmán Sportivo 14 20 24 13
6 Racing Córdoba Racing 14 16 30 8
7 Olimpo Olimpo 14 17 39 8
8 Juventud Alianza Juventud 14 18 48 5
TEMPORADA 1965/1966
LIGA PROFESIONAL ARGENTINA
Equipo PJ GF GC Puntos
1 Racing Club Racing Club 38 70 24 61
2 River Plate River Plate 38 66 26 56
3 Boca Juniors Boca Juniors 38 51 32 48
4 San Lorenzo San Lorenzo 38 48 34 46
5 Vélez Sarsfield Vélez 38 49 38 46
6 Independiente Independient 38 54 34 44
7 Estudiantes La Plata Estudiantes 38 44 37 41
8 Gimnasia La Plata Gimnasia 38 49 41 39
9 Argentinos Juniors Argentinos 38 40 44 39
10 Atlanta Atlanta 38 45 39 38
11 Newell's Old Boys Newell's 38 45 51 38
12 Rosario Central Rosario 38 31 30 37
13 Banfield Banfield 38 45 48 37
14 Lanús Lanús 38 43 55 31
15 CA Huracán CA Huracán 38 41 62 29
16 Colón Colón 38 30 53 27
17 Platense Platense 38 25 51 27
18 Ferro Carril Oeste Ferro Carril 38 37 64 27
19 Quilmes Quilmes 38 39 59 26
20 Chacarita Juniors Chacarita 38 36 66 23
TEMPORADA 1964/1965
LIGA PROFESIONAL ARGENTINA
Equipo PJ GF GC Puntos
1 Boca Juniors Boca Juniors 34 55 30 50
2 River Plate River Plate 34 55 24 49
3 Vélez Sarsfield Vélez 34 48 32 40
4 Ferro Carril Oeste Ferro Carril 34 41 33 37
5 Racing Club Racing Club 34 39 35 36
6 Estudiantes La Plata Estudiantes 34 41 39 36
7 Platense Platense 34 37 30 35
8 San Lorenzo San Lorenzo 34 41 35 34
9 Banfield Banfield 34 34 32 34
10 Rosario Central Rosario 34 37 39 32
11 Newell's Old Boys Newell's 34 29 40 32
12 Independiente Independient 34 30 31 31
13 CA Huracán CA Huracán 34 45 54 31
14 Atlanta Atlanta 34 33 42 29
15 Lanús Lanús 34 31 43 29
16 Argentinos Juniors Argentinos 34 41 51 28
17 Gimnasia La Plata Gimnasia 34 31 57 25
18 Chacarita Juniors Chacarita 34 32 53 24
TEMPORADA 1963/1964
LIGA PROFESIONAL ARGENTINA
Equipo PJ GF GC Puntos
1 Boca Juniors Boca Juniors 30 35 15 44
2 Independiente Independient 30 44 26 38
3 River Plate River Plate 30 42 30 37
4 San Lorenzo San Lorenzo 30 46 31 36
5 Atlanta Atlanta 30 46 42 35
6 Racing Club Racing Club 30 45 37 32
7 Banfield Banfield 30 34 32 32
8 Vélez Sarsfield Vélez 30 43 36 31
9 CA Huracán CA Huracán 30 38 36 29
10 Ferro Carril Oeste Ferro Carril 30 33 33 29
11 Rosario Central Rosario 30 37 38 28
12 Chacarita Juniors Chacarita 30 32 48 27
13 Gimnasia La Plata Gimnasia 30 27 36 25
14 Estudiantes La Plata Estudiantes 30 36 47 24
15 Argentinos Juniors Argentinos 30 26 45 17
16 Newell's Old Boys Newell's 30 19 51 16
TEMPORADA 1962/1963
LIGA PROFESIONAL ARGENTINA
Equipo PJ GF GC Puntos
1 Independiente Independient 26 53 25 37
2 River Plate River Plate 26 48 23 35
3 Racing Club Racing Club 26 43 32 30
4 Boca Juniors Boca Juniors 26 30 29 30
5 Atlanta Atlanta 26 35 37 28
6 CA Huracán CA Huracán 26 36 31 27
7 Banfield Banfield 26 36 27 25
8 San Lorenzo San Lorenzo 26 37 46 25
9 Estudiantes La Plata Estudiantes 26 37 43 24
10 Rosario Central Rosario 26 34 43 22
11 Argentinos Juniors Argentinos 26 28 43 22
12 Gimnasia La Plata Gimnasia 26 33 41 21
13 Vélez Sarsfield Vélez 26 32 44 20
14 Chacarita Juniors Chacarita 26 25 43 18
TEMPORADA 1961/1962
LIGA PROFESIONAL ARGENTINA
Equipo PJ GF GC Puntos
1 Boca Juniors Boca Juniors 28 45 18 61
2 River Plate River Plate 28 61 28 59
3 Gimnasia La Plata Gimnasia 28 47 28 54
4 Independiente Independient 28 41 27 47
5 Chacarita Juniors Chacarita 28 51 44 42
6 Rosario Central Rosario 28 38 31 40
7 Atlanta Atlanta 28 34 28 39
8 CA Huracán CA Huracán 28 36 35 38
9 Racing Club Racing Club 28 39 41 34
10 Argentinos Juniors Argentinos 28 46 53 31
11 San Lorenzo San Lorenzo 28 39 51 29
12 Ferro Carril Oeste Ferro Carril 28 34 52 28
13 Vélez Sarsfield Vélez 28 35 55 26
14 Estudiantes La Plata Estudiantes 28 34 53 25
15 Quilmes Quilmes 28 26 62 16
TEMPORADA 1960/1961
LIGA PROFESIONAL ARGENTINA
Equipo PJ GF GC Puntos
1 Racing Club Racing Club 30 68 39 47
2 San Lorenzo San Lorenzo 30 56 35 40
3 River Plate River Plate 30 53 30 38
4 Atlanta Atlanta 30 49 34 37
5 Boca Juniors Boca Juniors 30 57 33 35
6 Independiente Independient 30 46 40 33
7 Vélez Sarsfield Vélez 30 43 38 31
8 Chacarita Juniors Chacarita 30 49 53 31
9 Gimnasia La Plata Gimnasia 30 56 53 28
10 CA Huracán CA Huracán 30 43 51 25
11 Argentinos Juniors Argentinos 30 42 56 24
12 Lanús Lanús 30 36 59 24
13 Rosario Central Rosario 30 54 69 23
14 Estudiantes La Plata Estudiantes 30 29 47 22
15 Ferro Carril Oeste Ferro Carril 30 38 55 21
16 Los Andes Los Andes 30 38 65 21
TEMPORADA 1959/1960
LIGA PROFESIONAL ARGENTINA
Equipo PJ GF GC Puntos
1 Independiente Independient 30 49 33 41
2 Argentinos Juniors Argentinos 30 68 48 39
3 River Plate River Plate 30 46 29 39
4 Racing Club Racing Club 30 72 43 37
5 Boca Juniors Boca Juniors 30 58 36 37
6 San Lorenzo San Lorenzo 30 71 45 36
7 Vélez Sarsfield Vélez 30 48 46 33
8 Rosario Central Rosario 30 55 71 29
9 CA Huracán CA Huracán 30 48 45 28
10 Chacarita Juniors Chacarita 30 50 53 28
11 Atlanta Atlanta 30 49 56 27
12 Gimnasia La Plata Gimnasia 30 50 60 25
13 Estudiantes La Plata Estudiantes 30 44 69 23
14 Lanús Lanús 30 38 54 21
15 Ferro Carril Oeste Ferro Carril 30 28 58 19
16 Newell's Old Boys Newell's 30 38 66 18
TEMPORADA 1958/1959
LIGA PROFESIONAL ARGENTINA
Equipo PJ GF GC Puntos
1 San Lorenzo San Lorenzo 30 75 42 45
2 Racing Club Racing Club 30 80 48 38
3 Independiente Independient 30 44 37 33
4 Ferro Carril Oeste Ferro Carril 30 47 41 33
5 Newell's Old Boys Newell's 30 35 36 33
6 River Plate River Plate 30 49 45 32
7 Atlanta Atlanta 30 34 35 32
8 Boca Juniors Boca Juniors 30 51 44 30
9 CA Huracán CA Huracán 30 46 57 29
10 Estudiantes La Plata Estudiantes 30 51 61 28
11 Lanús Lanús 30 54 59 27
12 Vélez Sarsfield Vélez 30 43 46 26
13 Argentinos Juniors Argentinos 30 46 45 25
14 Gimnasia La Plata Gimnasia 30 48 61 25
15 Rosario Central Rosario 30 38 50 23
16 Central Córdoba Central 30 32 66 21
TEMPORADA 1957/1958
LIGA PROFESIONAL ARGENTINA
Equipo PJ GF GC Puntos
1 Racing Club Racing Club 30 69 38 41
2 Boca Juniors Boca Juniors 30 70 48 38
3 San Lorenzo San Lorenzo 30 66 47 38
4 River Plate River Plate 30 62 48 37
5 Atlanta Atlanta 30 47 33 36
6 Rosario Central Rosario 30 50 43 35
7 Vélez Sarsfield Vélez 30 50 47 34
8 Independiente Independient 30 58 47 33
9 Estudiantes La Plata Estudiantes 30 60 56 31
10 CA Huracán CA Huracán 30 49 51 27
11 Central Córdoba Central 30 57 65 27
12 Argentinos Juniors Argentinos 30 58 68 25
13 Lanús Lanús 30 58 70 25
14 Gimnasia La Plata Gimnasia 30 55 68 24
15 Newell's Old Boys Newell's 30 29 56 17
16 Tigre Tigre 30 29 82 12
TEMPORADA 1956/1957
LIGA PROFESIONAL ARGENTINA
Equipo PJ GF GC Puntos
1 River Plate River Plate 30 75 34 46
2 San Lorenzo San Lorenzo 30 66 42 38
3 Racing Club Racing Club 30 59 41 36
4 Boca Juniors Boca Juniors 30 45 34 34
5 Vélez Sarsfield Vélez 30 42 43 34
6 CA Huracán CA Huracán 30 46 39 33
7 Estudiantes La Plata Estudiantes 30 46 50 33
8 Independiente Independient 30 35 31 31
9 Newell's Old Boys Newell's 30 38 39 31
10 Argentinos Juniors Argentinos 30 49 57 28
11 Rosario Central Rosario 30 40 37 27
12 Atlanta Atlanta 30 37 53 24
13 Tigre Tigre 30 37 49 23
14 Gimnasia La Plata Gimnasia 30 37 62 23
15 Lanús Lanús 30 44 57 22
16 Ferro Carril Oeste Ferro Carril 30 33 61 17
TEMPORADA 1955/1956
LIGA PROFESIONAL ARGENTINA
Equipo PJ GF GC Puntos
1 River Plate River Plate 30 61 32 43
2 Lanús Lanús 30 59 37 41
3 Boca Juniors Boca Juniors 30 56 39 40
4 Racing Club Racing Club 30 53 32 39
5 Vélez Sarsfield Vélez 30 48 44 37
6 Rosario Central Rosario 30 49 46 30
7 Independiente Independient 30 44 42 30
8 San Lorenzo San Lorenzo 30 41 45 29
9 Ferro Carril Oeste Ferro Carril 30 44 49 27
10 Newell's Old Boys Newell's 30 44 48 26
11 Gimnasia La Plata Gimnasia 30 50 59 26
12 Estudiantes La Plata Estudiantes 30 38 46 23
13 CA Huracán CA Huracán 30 45 59 23
14 Argentinos Juniors Argentinos 30 45 60 22
15 Tigre Tigre 30 44 61 22
16 Chacarita Juniors Chacarita 30 32 54 22

  USO DE MEMORIA  
7,031,400 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.6596
Total Execution Time  0.6615
  CADENA URL  
/historico/Ca-Huracan/1970
  GET DATOS  
$_GET['/historico/Ca-Huracan/1970']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (40)  
0.0196  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 = 'Ca-Huracan' AND l.year = 1970 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.0126  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=585 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=585 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=585 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=585 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0252  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 = 26707
0.0130  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 = 26710
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=585 AND type_rel = 2
0.0136  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 585 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0129  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 (928,2073,8452,8656,11182) ORDER BY n.cover_points DESC, update_date DESC
0.0147  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 = '585' AND l.year = 1970 ORDER BY l.year DESC,cat.coefficient DESC
0.0147  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 = '585' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126  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 = 26707 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0137  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=585 AND l.year in (1969,1970,1971) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (26756) 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.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 26756 AND teamId = 585
0.0126  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 events1970 e ON e.player_id = p.id AND e.league_id = 26704 WHERE rp.league_id = 26704 AND rp.teamId = 585 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.0126  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 events1970 e ON e.player_id = p.id AND e.league_id = 26704 WHERE rp.league_id = 26704 AND rp.teamId = 585 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0126  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 events1970 e ON e.player_id = p.id AND e.league_id = 26704 WHERE rp.league_id = 26704 AND rp.teamId = 585 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0137  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 = 585 AND l.year <= 1970 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0129  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 `tables1970` 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 = 26704 AND t.round = 21 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 `tables1970` 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 = 26707 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 `tables1970` 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 = 26710 AND t.round = 3 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 `tables1969` 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 = 26751 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 `tables1969` 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 = 26756 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 `tables1968` 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 = 26741 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136  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 `tables1968` 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 = 26744 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145  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 `tables1967` 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 = 26730 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 `tables1967` 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 = 26736 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 26470 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0139  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 = 26469 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 26468 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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 = 26467 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 26701 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 26466 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 `tables1960` 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 = 26465 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0137  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 `tables1959` 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 = 26464 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0138  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 `tables1958` 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 = 26463 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143  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 `tables1957` 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 = 26699 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145  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 `tables1956` 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 = 26698 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC