4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 1973/1974
LIGA PROFESIONAL ARGENTINA GRUPO 3
Equipo PJ GF GC Puntos
1 Boca Juniors Boca Juniors 18 46 10 47
2 Rosario Central Rosario 18 36 8 43
3 Banfield Banfield 18 42 25 31
4 Estudiantes La Plata Estudiantes 18 25 20 28
5 Belgrano Belgrano 18 30 21 27
6 Sportivo Desamparados Sportivo 18 32 35 20
7 Central Norte Central 18 22 31 19
8 All Boys All Boys 18 20 36 11
9 Puerto Comercial Puerto 18 14 75 6
10 Talleres Córdoba Talleres 18 25 12 35
11 Gimnasia La Plata Gimnasia 18 29 22 30
12 Newell's Old Boys Newell's 18 27 20 29
13 Altos Hornos Zapla Altos Hornos 18 30 27 28
14 River Plate River Plate 18 33 20 26
15 Argentinos Juniors Argentinos 18 29 31 24
16 Colón Colón 18 20 22 18
17 Jorge Newbery Junín Jorge 18 9 18 15
18 Huracán San Rafael Huracán 18 12 48 7
TEMPORADA 1972/1973
LIGA PROFESIONAL ARGENTINA GRUPO 3
Equipo PJ GF GC Puntos
1 Rosario Central Rosario 3 6 3 7
2 River Plate River Plate 3 6 7 4
3 Atlanta Atlanta 3 3 4 2
4 San Lorenzo San Lorenzo 3 3 4 2
TEMPORADA 1971/1972
LIGA PROFESIONAL ARGENTINA GRUPO 3
Equipo PJ GF GC Puntos
1 San Lorenzo San Lorenzo 13 29 6 33
2 River Plate River Plate 13 50 23 32
3 San Martín Tucumán Martín 26 37 46 32
4 Vélez Sarsfield Vélez 13 31 19 26
5 Atlanta Atlanta 13 31 15 22
6 Rosario Central Rosario 13 28 18 19
7 Independiente Independient 13 24 20 17
8 San Lorenzo Mar del Plata Lorenzo 13 24 28 17
9 Lanús Lanús 13 17 23 14
10 Gimnasia La Plata Gimnasia 14 15 26 13
11 Club Atlético Bartolomé Mit Club 13 11 36 5
12 Independiente Tandil Independient 13 10 46 3
13 Boca Juniors Boca Juniors 13 31 15 32
14 Colón Colón 13 21 16 26
15 Argentinos Juniors Argentinos 13 26 16 24
16 CA Huracán CA Huracán 12 24 19 19
17 Racing Club Racing Club 13 20 18 19
18 Banfield Banfield 12 23 24 18
19 Belgrano Belgrano 13 19 18 17
20 Ferro Carril Oeste Ferro Carril 13 20 20 16
21 Sportivo Desamparados Sportivo 13 15 25 16
22 Chacarita Juniors Chacarita 12 16 18 11
23 Gimnasia Mendoza Gimnasia 12 16 21 11
24 Estudiantes La Plata Estudiantes 13 12 25 10
25 Newell's Old Boys Newell's 12 17 26 7
TEMPORADA 1970/1971
LIGA PROFESIONAL ARGENTINA GRUPO 2
Equipo PJ GF GC Puntos
1 Independiente Independient 14 31 13 34
2 Newell's Old Boys Newell's 14 37 10 32
3 Belgrano Belgrano 14 28 13 30
4 River Plate River Plate 14 26 13 29
5 Argentinos Juniors Argentinos 14 22 22 22
6 Ferro Carril Oeste Ferro Carril 14 22 20 18
7 Banfield Banfield 14 23 22 17
8 Kimberley Mar del Plata Kimberley 14 22 21 17
9 San Martín Mendoza Martín 14 20 20 15
10 Gimnasia La Plata Gimnasia 14 22 30 12
11 CA Huracán CA Huracán 14 19 27 12
12 Don Orione Don Orione 14 16 34 12
13 Juventud Antoniana Juventud 14 23 30 11
14 Huracán de Comodoro Huracán 14 11 55 4
15 Rosario Central Rosario 14 27 13 30
16 San Lorenzo San Lorenzo 14 37 19 28
17 Gimnasia Mendoza Gimnasia 14 28 21 26
18 Boca Juniors Boca Juniors 13 33 17 25
19 Atlanta Atlanta 14 25 17 22
20 Vélez Sarsfield Vélez 14 21 20 21
21 Chacarita Juniors Chacarita 14 16 20 17
22 Estudiantes La Plata Estudiantes 14 22 19 16
23 Racing Club Racing Club 14 20 21 16
24 San Martín Tucumán Martín 14 22 30 16
25 Colón Colón 14 21 26 15
26 Guaraní A. Franco Guaraní 14 18 26 13
27 Central Córdoba Central 14 17 33 12
28 Huracán Bahía Blanca Huracán 13 7 24 10
TEMPORADA 1969/1970
LIGA PROFESIONAL ARGENTINA GRUPO 5
Equipo PJ GF GC Puntos
1 San Martín San Juan Martín Juan 20 27 47 13
2 Gimnasia La Plata Gimnasia 20 46 31 27
3 Chacarita Juniors Chacarita 19 24 19 27
4 River Plate River Plate 20 30 20 26
5 San Lorenzo San Lorenzo 20 45 26 24
6 Gimnasia Mendoza Gimnasia 20 33 32 23
7 Racing Club Racing Club 20 35 30 17
8 Newell's Old Boys Newell's 20 29 36 15
9 Talleres Córdoba Talleres 20 27 42 15
10 San Martín Tucumán Martín 19 19 36 14
11 Platense Platense 20 21 46 10
12 Rosario Central Rosario 20 42 26 29
13 Boca Juniors Boca Juniors 20 36 20 29
14 Vélez Sarsfield Vélez 20 39 24 25
15 Independiente Independient 20 37 35 21
16 Estudiantes La Plata Estudiantes 20 31 22 20
17 Banfield Banfield 19 23 28 16
18 Atlanta Atlanta 20 17 22 16
19 Kimberley Mar del Plata Kimberley 19 32 35 15
20 Gimnasia Jujuy Gimnasia 20 27 43 14
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 1
Equipo PJ GF GC Puntos
1 Independiente Independient 15 43 14 26
2 Estudiantes La Plata Estudiantes 15 19 8 24
3 Vélez Sarsfield Vélez 15 28 14 20
4 Rosario Central Rosario 15 26 13 20
5 River Plate River Plate 15 33 15 19
6 San Lorenzo San Lorenzo 15 32 15 18
7 Boca Juniors Boca Juniors 15 21 20 16
8 Lanús Lanús 15 23 26 16
9 Ferro Carril Oeste Ferro Carril 15 21 22 15
10 Platense Platense 15 19 20 15
11 Quilmes Quilmes 15 16 19 13
12 Racing Club Racing Club 15 11 23 10
13 San Martín Mendoza Martín 15 17 31 10
14 Central Córdoba Central 15 11 25 9
15 San Lorenzo Mar del Plata Lorenzo 15 11 33 6
16 Chaco For Ever Chaco Ever 15 11 44 3
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

  USO DE MEMORIA  
6,845,904 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5697
Total Execution Time  0.5709
  CADENA URL  
/historico/Ca-River-Plate/1974
  GET DATOS  
$_GET['/historico/Ca-River-Plate/1974']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (45)  
0.0291  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-River-Plate' AND l.year = 1974 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=593 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=593 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=593 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0026  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 = 26598
0.0024  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 = 26600
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=593 AND type_rel = 2
0.0237  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 593 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0034  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 (1313710,1312626,1312473,1312204,1311981) ORDER BY n.cover_points DESC, update_date DESC
0.0386  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 = '593' AND l.year = 1974 ORDER BY l.year DESC,cat.coefficient DESC
0.0553  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 = '593' 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 = 26600 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0444  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=593 AND l.year in (1973,1974,1975) ORDER BY l.id DESC, l.year DESC ;
0.0020  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (26621,11438) 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.0036  SELECT count(id) as num_players from rel_players WHERE league_id = 26621 AND teamId = 593
0.0042  SELECT count(id) as num_players from rel_players WHERE league_id = 11438 AND teamId = 593
0.0658  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables1974` 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 = 26598 AND t.round = 19 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0057  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 = '593' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0037  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '593' and rp.type = 4
0.0196  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 = '593' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0021  SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '593' and rp.type = 4
0.0037  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 events1974 e ON e.player_id = p.id AND e.league_id = 26598 WHERE rp.league_id = 26598 AND rp.teamId = 593 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.0033  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 events1974 e ON e.player_id = p.id AND e.league_id = 26598 WHERE rp.league_id = 26598 AND rp.teamId = 593 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0041  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 events1974 e ON e.player_id = p.id AND e.league_id = 26598 WHERE rp.league_id = 26598 AND rp.teamId = 593 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0537  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 = 593 AND l.year <= 1974 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0055  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 `tables1974` 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 = 26598 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0070  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 `tables1974` 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 = 26600 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0066  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 `tables1973` 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 = 26613 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0088  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 `tables1973` 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 = 26615 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0069  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 `tables1973` 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 = 26621 AND t.round = 3 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0068  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 `tables1972` 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 = 26627 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0051  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 `tables1972` 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 = 26633 AND t.round = 13 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0061  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 `tables1971` 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 = 26672 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0052  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 `tables1971` 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 = 26676 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0049  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.0060  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 = 26713 AND t.round = 20 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0086  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.0081  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.0067  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.0055  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 = 26743 AND t.round = 3 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0061  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.0065  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.0045  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 = 26726 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0046  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.0072  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