4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 1936/1937
LIGA PROFESIONAL ARGENTINA
Equipo PJ GF GC Puntos
1 River Plate River Plate 34 106 43 58
2 Independiente Independient 34 106 54 52
3 Boca Juniors Boca Juniors 34 101 57 45
4 Racing Club Racing Club 34 87 65 40
5 Vélez Sarsfield Vélez 34 63 58 40
6 San Lorenzo San Lorenzo 34 70 62 39
7 CA Huracán CA Huracán 34 82 62 38
8 Gimnasia La Plata Gimnasia 34 68 60 37
9 Ferro Carril Oeste Ferro Carril 34 78 79 35
10 Estudiantes La Plata Estudiantes 34 63 64 34
11 Atlanta Atlanta 34 61 66 31
12 Platense Platense 34 61 67 31
13 Lanús Lanús 34 68 79 31
14 Chacarita Juniors Chacarita 34 63 76 29
15 Talleres R. Escalada Talleres 34 60 88 26
16 Tigre Tigre 34 62 84 25
17 Argentinos Juniors Argentinos 34 44 111 11
18 Quilmes Quilmes 34 42 110 10
TEMPORADA 1935/1936
LIGA PROFESIONAL ARGENTINA
Equipo PJ GF GC Puntos
1 River Plate River Plate 17 49 19 28
2 San Lorenzo San Lorenzo 17 41 24 24
3 Racing Club Racing Club 17 43 27 23
4 Independiente Independient 17 32 29 21
5 Boca Juniors Boca Juniors 17 39 19 20
6 Atlanta Atlanta 17 39 30 19
7 Platense Platense 17 26 29 19
8 CA Huracán CA Huracán 17 32 22 18
9 Argentinos Juniors Argentinos 17 26 32 18
10 Ferro Carril Oeste Ferro Carril 17 30 36 17
11 Estudiantes La Plata Estudiantes 17 32 32 16
12 Chacarita Juniors Chacarita 17 36 42 16
13 Vélez Sarsfield Vélez 17 45 35 15
14 Gimnasia La Plata Gimnasia 17 31 48 14
15 Lanús Lanús 17 27 43 12
16 Quilmes Quilmes 17 24 39 11
17 Tigre Tigre 17 21 43 8
18 Talleres R. Escalada Talleres 17 19 43 7
TEMPORADA 1934/1935
LIGA PROFESIONAL ARGENTINA
Equipo PJ GF GC Puntos
1 Boca Juniors Boca Juniors 34 98 31 58
2 Independiente Independient 34 101 38 55
3 San Lorenzo San Lorenzo 34 92 45 49
4 Vélez Sarsfield Vélez 34 77 46 46
5 River Plate River Plate 34 71 47 44
6 CA Huracán CA Huracán 34 59 38 39
7 Estudiantes La Plata Estudiantes 34 78 52 37
8 Ferro Carril Oeste Ferro Carril 34 60 66 36
9 Racing Club Racing Club 34 55 58 31
10 Talleres R. Escalada Talleres 34 60 70 30
11 Lanús Lanús 34 56 79 30
12 Platense Platense 34 49 61 29
13 Gimnasia La Plata Gimnasia 34 52 75 29
14 Chacarita Juniors Chacarita 34 49 57 26
15 Atlanta Atlanta 34 48 89 25
16 Argentinos Juniors Argentinos 34 42 89 20
17 Quilmes Quilmes 34 23 82 16
18 Tigre Tigre 34 38 85 12
TEMPORADA 1933/1934
LIGA PROFESIONAL ARGENTINA
Equipo PJ GF GC Puntos
1 Boca Juniors Boca Juniors 39 101 62 55
2 Independiente Independient 39 73 41 54
3 San Lorenzo San Lorenzo 39 84 63 51
4 River Plate River Plate 39 91 44 50
5 Estudiantes La Plata Estudiantes 39 69 59 44
6 Racing Club Racing Club 39 83 64 43
7 Platense Platense 39 70 74 43
8 Vélez Sarsfield Vélez 39 80 70 41
9 Gimnasia La Plata Gimnasia 39 85 85 38
10 CA Huracán CA Huracán 39 59 67 37
11 Chacarita Juniors Chacarita 39 63 74 34
12 Lanús Lanús 39 50 81 27
13 Ferro Carril Oeste Ferro Carril 39 51 100 20
14 Argentinos Juniors Argentinos 39 38 113 9
TEMPORADA 1932/1933
LIGA PROFESIONAL ARGENTINA
Equipo PJ GF GC Puntos
1 San Lorenzo San Lorenzo 34 81 48 50
2 Boca Juniors Boca Juniors 34 86 47 49
3 Racing Club Racing Club 34 76 33 48
4 Gimnasia La Plata Gimnasia 34 90 55 46
5 River Plate River Plate 34 71 36 46
6 Independiente Independient 34 54 39 41
7 Vélez Sarsfield Vélez 34 60 43 38
8 Chacarita Juniors Chacarita 34 55 61 35
9 Platense Platense 34 61 74 31
10 Estudiantes La Plata Estudiantes 34 60 65 30
11 Ferro Carril Oeste Ferro Carril 34 43 56 28
12 CA Huracán CA Huracán 34 49 60 27
13 Quilmes Quilmes 34 41 61 26
14 Argentinos Juniors Argentinos 34 45 71 25
15 Lanús Lanús 34 52 76 24
16 Talleres R. Escalada Talleres 34 61 84 23
17 Atlanta Atlanta 34 46 70 23
18 Tigre Tigre 34 44 96 22
TEMPORADA 1931/1932
LIGA PROFESIONAL ARGENTINA
Equipo PJ GF GC Puntos
1 River Plate River Plate 34 81 43 50
2 Independiente Independient 34 72 40 50
3 Racing Club Racing Club 34 59 26 49
4 Boca Juniors Boca Juniors 34 82 47 46
5 San Lorenzo San Lorenzo 34 83 44 45
6 Estudiantes La Plata Estudiantes 34 80 62 40
7 Gimnasia La Plata Gimnasia 34 78 62 37
8 Vélez Sarsfield Vélez 34 50 52 37
9 CA Huracán CA Huracán 34 58 62 35
10 Platense Platense 34 58 63 35
11 Ferro Carril Oeste Ferro Carril 34 64 59 33
12 Quilmes Quilmes 34 50 67 32
13 Chacarita Juniors Chacarita 34 74 73 31
14 Argentinos Juniors Argentinos 34 40 65 23
15 Lanús Lanús 34 37 76 18
16 Talleres Córdoba Talleres 34 44 74 17
17 Tigre Tigre 34 49 94 17
18 Atlanta Atlanta 34 32 82 17
TEMPORADA 1930/1931
LIGA PROFESIONAL ARGENTINA
Equipo PJ GF GC Puntos
1 Boca Juniors Boca Juniors 34 86 50 49
2 San Lorenzo San Lorenzo 34 81 52 45
3 River Plate River Plate 34 64 40 45
4 Racing Club Racing Club 34 82 52 44
5 Estudiantes La Plata Estudiantes 34 104 52 43
6 Independiente Independient 34 69 60 43
7 Chacarita Juniors Chacarita 34 63 58 42
8 CA Huracán CA Huracán 34 58 49 33
9 Vélez Sarsfield Vélez 34 63 68 33
10 Ferro Carril Oeste Ferro Carril 34 60 74 32
11 Argentinos Juniors Argentinos 34 49 61 31
12 Platense Platense 34 53 55 30
13 Gimnasia La Plata Gimnasia 34 42 64 30
14 Quilmes Quilmes 34 53 62 29
15 Talleres R. Escalada Talleres 34 48 68 24
16 Tigre Tigre 34 49 70 23
17 Lanús Lanús 34 44 83 21
18 Atlanta Atlanta 34 33 83 15

  USO DE MEMORIA  
5,879,200 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1328
Total Execution Time  0.1340
  CADENA URL  
/historico/Ca-Huracan/1937
  GET DATOS  
$_GET['/historico/Ca-Huracan/1937']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0069  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 = 1937 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.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=585 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022  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.0044  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 = 26425
0.0020  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=585 AND type_rel = 2
0.0041  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.0032  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 (558377,928,2073,8452,8656) ORDER BY n.cover_points DESC, update_date DESC
0.0070  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 = 1937 ORDER BY l.year DESC,cat.coefficient DESC
0.0065  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.0026  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 = 26425 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0109  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 (1936,1937,1938) 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 (26436) 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.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 26436 AND teamId = 585
0.0034  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 26425 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0022  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 events1937 e ON e.player_id = p.id AND e.league_id = 26425 WHERE rp.league_id = 26425 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.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 events1937 e ON e.player_id = p.id AND e.league_id = 26425 WHERE rp.league_id = 26425 AND rp.teamId = 585 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022  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 events1937 e ON e.player_id = p.id AND e.league_id = 26425 WHERE rp.league_id = 26425 AND rp.teamId = 585 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0062  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 <= 1937 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 `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 = 26425 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033  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 = 26424 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 26423 AND t.round = 34 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 `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 = 26421 AND t.round = 39 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 `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 = 26418 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 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 = 26409 AND t.round = 34 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 `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 = 26405 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 26425 ORDER BY nameShow LIMIT 100