4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 1992/1993
CLAUSURA ARGENTINA
Equipo PJ GF GC Puntos
1 Vélez Sarsfield Vélez 19 23 7 37
2 River Plate River Plate 19 33 21 33
3 Dep. Español Dep. 19 24 18 31
4 Independiente Independient 19 23 14 30
5 San Lorenzo San Lorenzo 19 27 19 30
6 Racing Club Racing Club 19 22 17 30
7 CA Huracán CA Huracán 19 24 23 28
8 Rosario Central Rosario 19 25 19 27
9 Boca Juniors Boca Juniors 19 23 18 27
10 Gimnasia La Plata Gimnasia 19 14 15 24
11 CD Mandiyú CD Mandiyú 19 19 22 24
12 Estudiantes La Plata Estudiantes 19 23 20 23
13 Argentinos Juniors Argentinos 19 12 12 22
14 Belgrano Belgrano 19 13 22 22
15 Ferro Carril Oeste Ferro Carril 19 15 21 21
16 Lanús Lanús 19 12 15 20
17 Newell's Old Boys Newell's 19 13 19 19
18 Platense Platense 19 14 26 17
19 San Martín Tucumán Martín 19 17 30 16
20 Talleres Córdoba Talleres 19 13 31 13
TEMPORADA 1991/1992
CLAUSURA ARGENTINA
Equipo PJ GF GC Puntos
1 Newell's Old Boys Newell's 19 27 8 40
2 Vélez Sarsfield Vélez 19 29 16 37
3 Dep. Español Dep. 19 24 11 36
4 Boca Juniors Boca Juniors 19 20 11 36
5 River Plate River Plate 19 31 22 32
6 Platense Platense 19 23 16 30
7 Gimnasia La Plata Gimnasia 19 25 20 26
8 Racing Club Racing Club 19 12 9 26
9 Rosario Central Rosario 19 19 24 25
10 Belgrano Belgrano 19 18 18 24
11 CA Huracán CA Huracán 19 18 19 24
12 Ferro Carril Oeste Ferro Carril 19 13 14 23
13 Independiente Independient 19 16 16 21
14 Argentinos Juniors Argentinos 19 16 19 21
15 Talleres Córdoba Talleres 19 14 17 21
16 CD Mandiyú CD Mandiyú 19 16 30 16
17 Unión Santa Fe Unión Santa 19 11 18 15
18 Estudiantes La Plata Estudiantes 19 14 26 15
19 San Lorenzo San Lorenzo 19 11 25 15
20 Quilmes Quilmes 19 14 32 15
TEMPORADA 1990/1991
CLAUSURA ARGENTINA
Equipo PJ GF GC Puntos
1 Boca Juniors Boca Juniors 19 32 6 45
2 San Lorenzo San Lorenzo 19 29 18 38
3 Racing Club Racing Club 19 23 22 32
4 CD Mandiyú CD Mandiyú 19 20 13 31
5 Independiente Independient 19 22 15 28
6 Vélez Sarsfield Vélez 19 25 22 28
7 CA Huracán CA Huracán 19 16 16 28
8 Newell's Old Boys Newell's 19 21 14 26
9 Estudiantes La Plata Estudiantes 19 18 15 25
10 Lanús Lanús 19 15 15 24
11 River Plate River Plate 19 19 19 23
12 Platense Platense 19 10 16 22
13 Unión Santa Fe Unión Santa 19 21 26 21
14 Gimnasia La Plata Gimnasia 19 16 22 21
15 Rosario Central Rosario 19 15 23 20
16 Dep. Español Dep. 19 22 25 18
17 Ferro Carril Oeste Ferro Carril 19 15 20 17
18 Argentinos Juniors Argentinos 19 19 30 16
19 Talleres Córdoba Talleres 19 24 34 15
20 Chaco For Ever Chaco Ever 19 15 26 13
TEMPORADA 1989/1990
LIGA PROFESIONAL ARGENTINA
Equipo PJ GF GC Puntos
1 River Plate River Plate 38 48 20 53
2 Rosario Central Rosario 38 46 35 47
3 Independiente Independient 38 54 36 46
4 Boca Juniors Boca Juniors 38 49 36 43
5 Vélez Sarsfield Vélez 38 46 32 42
6 Ferro Carril Oeste Ferro Carril 38 24 20 39
7 Gimnasia La Plata Gimnasia 38 34 31 39
8 Racing Club Racing Club 38 34 34 39
9 Argentinos Juniors Argentinos 38 42 40 38
10 Talleres Córdoba Talleres 38 45 46 36
11 CD Mandiyú CD Mandiyú 38 39 40 36
12 Newell's Old Boys Newell's 38 41 43 36
13 Unión Santa Fe Unión Santa 38 40 43 36
14 Platense Platense 38 35 39 36
15 San Lorenzo San Lorenzo 38 44 50 35
16 Estudiantes La Plata Estudiantes 38 34 39 34
17 Chaco For Ever Chaco Ever 38 40 56 32
18 Racing Córdoba Racing 38 32 48 32
19 Dep. Español Dep. 38 39 53 31
20 Instituto Instituto 38 31 56 26
TEMPORADA 1988/1989
LIGA PROFESIONAL ARGENTINA
Equipo PJ GF GC Puntos
1 Independiente Independient 38 58 32 84
2 Boca Juniors Boca Juniors 38 56 38 76
3 Dep. Español Dep. 38 44 30 68
4 River Plate River Plate 38 61 36 67
5 San Lorenzo San Lorenzo 38 58 44 66
6 Talleres Córdoba Talleres 38 48 43 65
7 Argentinos Juniors Argentinos 38 55 39 61
8 Estudiantes La Plata Estudiantes 38 53 41 61
9 Racing Club Racing Club 38 47 41 59
10 Gimnasia La Plata Gimnasia 38 31 30 57
11 Vélez Sarsfield Vélez 38 37 54 53
12 Newell's Old Boys Newell's 38 41 43 51
13 Rosario Central Rosario 38 50 54 51
14 CD Mandiyú CD Mandiyú 38 35 44 51
15 Platense Platense 38 36 51 50
16 Racing Córdoba Racing 38 38 54 50
17 San Martín Tucumán Martín 38 38 50 46
18 Ferro Carril Oeste Ferro Carril 38 36 43 45
19 Dep. Armenio Dep. Armenio 38 29 57 37
20 Instituto Instituto 38 38 65 31
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 7
Equipo PJ GF GC Puntos
TEMPORADA 1983/1984
LIGA PROFESIONAL ARGENTINA GRUPO 4
Equipo PJ GF GC Puntos
1 Belgrano Belgrano 6 8 4 13
2 Rosario Central Rosario 6 9 6 11
3 Vélez Sarsfield Vélez 5 7 6 5
4 Central Norte Central 5 2 10 1
TEMPORADA 1982/1983
LIGA PROFESIONAL ARGENTINA GRUPO 9
Equipo PJ GF GC Puntos
1 Estudiantes La Plata Estudiantes 6 7 3 12
2 Vélez Sarsfield Vélez 6 5 6 10
3 Instituto Instituto 6 8 11 4
4 Independiente Independient 6 12 6 11
5 Temperley Temperley 6 8 5 10
6 Nueva Chicago Nueva 6 3 12 2

  USO DE MEMORIA  
6,493,304 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1865
Total Execution Time  0.1876
  CADENA URL  
/historico/Ca-Velez-Sarsfield/1993
  GET DATOS  
$_GET['/historico/Ca-Velez-Sarsfield/1993']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (50)  
0.0125  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-Velez-Sarsfield' AND l.year = 1993 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.0025  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=600 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0025  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=600 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0026  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=600 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0049  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 = 8420
0.0052  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 = 8415
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=600 AND type_rel = 2
0.0030  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 600 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 (6125,9693,10832,11236,20213) ORDER BY n.cover_points DESC, update_date DESC
0.0065  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 = '600' ORDER BY l.year DESC,cat.coefficient DESC
0.0041  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 = '600' AND l.year = 1993 ORDER BY l.year DESC,cat.coefficient DESC
0.0075  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 = '600' 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 = 8415 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 8420 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0038  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=600 AND l.year in (1992,1993,1994) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (11416,8421,8418) 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 = 8421 AND teamId = 600
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 11416 AND teamId = 600
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 8418 AND teamId = 600
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 FROM `tables1993` 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 = 8420 AND t.round = 19 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0022  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 = '600' 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 = '600' and rp.type = 4
0.0023  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 = '600' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0018  SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '600' and rp.type = 4
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 events1993 e ON e.player_id = p.id AND e.league_id = 8420 WHERE rp.league_id = 8420 AND rp.teamId = 600 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 events1993 e ON e.player_id = p.id AND e.league_id = 8420 WHERE rp.league_id = 8420 AND rp.teamId = 600 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 events1993 e ON e.player_id = p.id AND e.league_id = 8420 WHERE rp.league_id = 8420 AND rp.teamId = 600 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0035  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 = 600 AND l.year <= 1993 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `tables1993` 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 = 8420 AND t.round = 19 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 `tables1992` 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 = 8421 AND t.round = 19 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 `tables1991` 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 = 8422 AND t.round = 19 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 `tables1990` 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 = 22523 AND t.round = 38 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 `tables1989` 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 = 22520 AND t.round = 38 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 `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.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 `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.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 = 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.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 = 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.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 = 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.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 = 26433 AND t.round = 2 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 = 26434 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 = 26413 AND t.round = 6 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 `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.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 `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 = 26444 AND t.round = 6 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 `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 = 26525 AND t.round = 3 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 `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 = 26536 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 8420 ORDER BY nameShow LIMIT 100
0.0020  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 118 AND l.year = 1993 ORDER BY l.group_code ASC