4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del River Plate

River Plate

Entrenador: Martín Demichelis

Temporada 1987/1988
TEMPORADA 1987/1988
LIGA PROFESIONAL ARGENTINA
Equipo PJ GF GC Puntos
1 Newell's Old Boys Newell's 38 68 22 76
2 San Lorenzo San Lorenzo 38 49 28 65
3 Racing Club Racing Club 38 51 33 63
4 River Plate River Plate 38 51 40 63
5 Vélez Sarsfield Vélez 38 51 41 55
6 Argentinos Juniors Argentinos 38 49 44 55
7 Gimnasia La Plata Gimnasia 38 44 36 54
8 Rosario Central Rosario 38 53 41 52
9 Dep. Español Dep. 38 49 47 51
10 Platense Platense 38 42 45 50
11 Independiente Independient 38 37 44 49
12 Boca Juniors Boca Juniors 38 40 55 47
13 Instituto Instituto 38 43 53 45
14 Dep. Armenio Dep. Armenio 38 37 45 42
15 Racing Córdoba Racing 38 31 44 41
16 Ferro Carril Oeste Ferro Carril 38 27 35 40
17 Estudiantes La Plata Estudiantes 38 31 43 38
18 Unión Santa Fe Unión Santa 38 39 52 36
19 Banfield Banfield 38 36 56 35
20 Talleres Córdoba Talleres 38 40 64 33
TEMPORADA 1986/1987
LIGA PROFESIONAL ARGENTINA
Equipo PJ GF GC Puntos
1 Rosario Central Rosario 38 64 45 49
2 Newell's Old Boys Newell's 38 57 38 48
3 Independiente Independient 38 70 47 47
4 Boca Juniors Boca Juniors 38 62 49 46
5 Racing Club Racing Club 38 50 41 44
6 Ferro Carril Oeste Ferro Carril 38 40 32 44
7 San Lorenzo San Lorenzo 38 45 38 44
8 Instituto Instituto 38 54 46 41
9 Vélez Sarsfield Vélez 38 50 43 41
10 River Plate River Plate 38 54 49 39
11 Talleres Córdoba Talleres 38 54 61 38
12 Estudiantes La Plata Estudiantes 38 40 45 37
13 Gimnasia La Plata Gimnasia 38 33 41 37
14 Dep. Español Dep. 38 29 31 36
15 Racing Córdoba Racing 38 43 56 33
16 Unión Santa Fe Unión Santa 38 30 38 31
17 Argentinos Juniors Argentinos 38 45 47 28
18 Temperley Temperley 38 28 48 27
19 Platense Platense 38 40 63 27
20 Sportivo Italiano Sportivo 38 29 59 23
TEMPORADA 1985/1986
LIGA PROFESIONAL ARGENTINA
Equipo PJ GF GC Puntos
1 River Plate River Plate 36 74 26 79
2 Dep. Español Dep. 36 41 35 64
3 Newell's Old Boys Newell's 36 46 30 61
4 Argentinos Juniors Argentinos 36 47 39 60
5 Boca Juniors Boca Juniors 36 57 47 55
6 San Lorenzo San Lorenzo 36 43 33 54
7 Ferro Carril Oeste Ferro Carril 36 45 33 52
8 Independiente Independient 36 38 36 51
9 Talleres Córdoba Talleres 36 43 37 47
10 Instituto Instituto 36 33 33 46
11 Vélez Sarsfield Vélez 36 48 48 45
12 Gimnasia La Plata Gimnasia 36 29 35 45
13 CA Huracán CA Huracán 36 44 47 42
14 Unión Santa Fe Unión Santa 36 27 38 40
15 Estudiantes La Plata Estudiantes 36 33 47 37
16 Temperley Temperley 36 44 60 37
17 Platense Platense 36 37 55 34
18 Racing Córdoba Racing 36 31 52 32
19 Chacarita Juniors Chacarita 36 24 53 26
TEMPORADA 1984/1985
LIGA PROFESIONAL ARGENTINA GRUPO 4
Equipo PJ GF GC Puntos
TEMPORADA 1983/1984
LIGA PROFESIONAL ARGENTINA GRUPO 1
Equipo PJ GF GC Puntos
1 Argentinos Juniors Argentinos 36 69 36 51
2 Ferro Carril Oeste Ferro Carril 36 46 18 50
3 Estudiantes La Plata Estudiantes 36 49 27 48
4 River Plate River Plate 36 51 38 43
5 Racing Córdoba Racing 36 42 31 43
6 Vélez Sarsfield Vélez 36 43 32 42
7 Newell's Old Boys Newell's 36 36 39 38
8 San Lorenzo San Lorenzo 36 47 46 37
9 Talleres Córdoba Talleres 36 56 55 34
10 Chacarita Juniors Chacarita 36 30 37 34
11 Instituto Instituto 36 46 47 33
12 Platense Platense 36 34 45 33
13 Temperley Temperley 36 23 28 31
14 Independiente Independient 36 45 59 31
15 Unión Santa Fe Unión Santa 36 43 46 30
16 Boca Juniors Boca Juniors 36 34 49 30
17 CA Huracán CA Huracán 36 36 55 27
18 Rosario Central Rosario 36 28 41 25
19 Atlanta Atlanta 36 32 61 24
TEMPORADA 1982/1983
LIGA PROFESIONAL ARGENTINA GRUPO 10
Equipo PJ GF GC Puntos
1 River Plate River Plate 6 5 2 11
2 Platense Platense 6 8 13 9
3 Ferro Carril Oeste Ferro Carril 6 7 6 8
4 CA Huracán CA Huracán 6 6 8 7
5 Unión Santa Fe Unión Santa 6 7 4 6
6 San Lorenzo San Lorenzo 6 2 2 6
TEMPORADA 1981/1982
LIGA PROFESIONAL ARGENTINA GRUPO 3
Equipo PJ GF GC Puntos
1 Estudiantes La Plata Estudiantes 36 50 18 75
2 Independiente Independient 36 64 30 71
3 Boca Juniors Boca Juniors 36 60 36 65
4 Newell's Old Boys Newell's 36 60 34 59
5 Vélez Sarsfield Vélez 36 45 37 58
6 CA Huracán CA Huracán 36 44 37 56
7 Racing Córdoba Racing 36 62 47 52
8 Rosario Central Rosario 36 55 49 50
9 Ferro Carril Oeste Ferro Carril 36 36 39 48
10 River Plate River Plate 36 43 46 46
11 Talleres Córdoba Talleres 36 55 59 45
12 Instituto Instituto 36 39 56 44
13 Racing Club Racing Club 36 36 58 38
14 Platense Platense 36 41 55 37
15 Nueva Chicago Nueva 36 33 50 36
16 Quilmes Quilmes 36 30 53 36
17 Argentinos Juniors Argentinos 36 49 58 35
18 Unión Santa Fe Unión Santa 36 36 57 34
19 Sarmiento Sarmiento 36 32 51 29
TEMPORADA 1980/1981
LIGA PROFESIONAL ARGENTINA GRUPO 3
Equipo PJ GF GC Puntos
1 Boca Juniors Boca Juniors 34 60 27 50
2 Ferro Carril Oeste Ferro Carril 34 50 20 49
3 Newell's Old Boys Newell's 34 58 44 39
4 River Plate River Plate 34 62 50 39
5 Racing Club Racing Club 33 46 29 38
6 Independiente Independient 34 43 35 37
7 Rosario Central Rosario 34 36 39 34
8 CA Huracán CA Huracán 34 41 50 33
9 Instituto Instituto 34 56 54 32
10 Unión Santa Fe Unión Santa 34 39 37 32
11 Vélez Sarsfield Vélez 34 39 48 31
12 Platense Platense 34 39 49 31
13 Sarmiento Sarmiento 34 46 52 30
14 Talleres Córdoba Talleres 33 36 44 29
15 Argentinos Juniors Argentinos 34 44 57 29
16 Estudiantes La Plata Estudiantes 33 34 43 28
17 San Lorenzo San Lorenzo 33 30 48 26
18 Colón Colón 34 26 59 21

  USO DE MEMORIA  
6,446,744 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1771
Total Execution Time  0.1783
  CADENA URL  
/historico/Ca-River-Plate/1988
  GET DATOS  
$_GET['/historico/Ca-River-Plate/1988']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (47)  
0.0038  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 = 22518
0.0027  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 = 74506
0.0028  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 = 56546
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=593 AND type_rel = 2
0.0099  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.0027  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 (1312626,1312473,1312204,1311981,1311966) ORDER BY n.cover_points DESC, update_date DESC
0.0087  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 = 74506 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 22518 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 56546 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0061  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 (1987,1988,1989) 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 (74506,56546,22520,11923,11560) 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.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 22520 AND teamId = 593
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 74506 AND teamId = 593
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 11560 AND teamId = 593
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 56546 AND teamId = 593
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 11923 AND teamId = 593
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 FROM `tables1988` 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 = 22518 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0028  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.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '593' and rp.type = 4
0.0031  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.0020  SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '593' and rp.type = 4
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 events1988 e ON e.player_id = p.id AND e.league_id = 22518 WHERE rp.league_id = 22518 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.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 events1988 e ON e.player_id = p.id AND e.league_id = 22518 WHERE rp.league_id = 22518 AND rp.teamId = 593 AND (e.action = 4 or e.action = 5) 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 events1988 e ON e.player_id = p.id AND e.league_id = 22518 WHERE rp.league_id = 22518 AND rp.teamId = 593 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0066  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 <= 1988 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0031  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 `tables1988` 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 = 22518 AND t.round = 38 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 `tables1987` 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 = 22514 AND t.round = 38 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 `tables1986` 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 = 22504 AND t.round = 38 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 `tables1985` 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 = 26422 AND t.round = 1 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 `tables1985` 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 = 26426 AND t.round = 1 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1985` 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 = 26427 AND t.round = 1 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  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 `tables1985` 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 = 26428 AND t.round = 1 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 `tables1985` 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 = 26430 AND t.round = 2 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 `tables1985` 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 = 26431 AND t.round = 1 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1985` 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 = 26432 AND t.round = 1 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  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 `tables1985` 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 = 26410 AND t.round = 6 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 `tables1984` 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 = 26446 AND t.round = 6 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 `tables1984` 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 = 26438 AND t.round = 38 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 `tables1983` 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 = 26683 AND t.round = 38 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 `tables1983` 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 = 26534 AND t.round = 3 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 `tables1983` 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 = 26537 AND t.round = 6 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 `tables1982` 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 = 26545 AND t.round = 16 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 `tables1982` 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 = 26673 AND t.round = 38 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 `tables1981` 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 = 26553 AND t.round = 14 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 `tables1981` 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 = 26554 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 675 AND l.year = 1988 ORDER BY l.group_code ASC