4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 1954/1955
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Benfica Benfica 26 61 20 39
2 Os Belenenses Belenenses 26 63 28 39
3 Sporting CP Sporting CP 26 73 27 37
4 Porto Porto 26 51 34 30
5 Sporting Braga Sporting 26 52 42 29
6 Académica Académica 26 53 52 25
7 Fabril Barreiro Fabril 26 45 51 25
8 Vitória Setúbal Vitória 26 37 52 22
9 Atlético CP Atlético 26 42 52 22
10 Lusitano GC Évora Lusitano 26 40 70 21
11 FC Barreirense Barreirense 26 24 38 20
12 SC Covilha SC Covilha 26 32 53 20
13 Boavista Boavista 26 33 71 18
14 Vitória Guimarães Vitória 26 33 49 17
TEMPORADA 1953/1954
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Sporting CP Sporting CP 26 80 25 43
2 Porto Porto 26 83 35 36
3 Benfica Benfica 26 62 40 32
4 Os Belenenses Belenenses 26 43 39 31
5 Sporting Braga Sporting 26 54 36 28
6 Atlético CP Atlético 26 49 43 28
7 SC Covilha SC Covilha 26 43 39 28
8 Vitória Guimarães Vitória 26 44 64 25
9 FC Barreirense Barreirense 26 34 47 22
10 Lusitano GC Évora Lusitano 26 47 66 21
11 Boavista Boavista 26 29 66 19
12 Vitória Setúbal Vitória 26 51 66 18
13 Académica Académica 26 29 50 18
14 Oriental Lisboa Oriental 26 35 67 15
TEMPORADA 1952/1953
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Sporting CP Sporting CP 26 77 22 43
2 Benfica Benfica 26 75 27 39
3 Os Belenenses Belenenses 26 60 29 36
4 Porto Porto 26 58 35 36
5 FC Barreirense Barreirense 26 44 40 28
6 Vitória Setúbal Vitória 26 40 33 27
7 Lusitano GC Évora Lusitano 26 31 44 25
8 Vitória Guimarães Vitória 26 28 54 20
9 Boavista Boavista 26 35 54 20
10 SC Covilha SC Covilha 26 38 54 20
11 Académica Académica 26 39 57 19
12 Atlético CP Atlético 26 33 52 19
13 Sporting Braga Sporting 26 37 58 18
14 Estoril Estoril 26 28 64 14
TEMPORADA 1951/1952
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Sporting CP Sporting CP 26 91 32 41
2 Benfica Benfica 26 76 26 40
3 Porto Porto 26 68 33 36
4 Os Belenenses Belenenses 26 60 28 36
5 Boavista Boavista 26 47 55 25
6 SC Covilha SC Covilha 26 35 52 25
7 Académica Académica 26 39 47 22
8 Sporting Braga Sporting 26 32 49 21
9 Estoril Estoril 26 49 61 21
10 Vitória Guimarães Vitória 26 28 47 21
11 FC Barreirense Barreirense 26 47 65 21
12 Atlético CP Atlético 26 53 48 20
13 Oriental Lisboa Oriental 26 48 72 18
14 SC Salgueiros Salgueiros 26 33 91 17
TEMPORADA 1950/1951
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Sporting CP Sporting CP 26 91 28 45
2 Porto Porto 26 67 32 34
3 Benfica Benfica 26 81 43 30
4 Atlético CP Atlético 26 62 49 30
5 Oriental Lisboa Oriental 26 37 57 27
6 SC Covilha SC Covilha 26 62 53 26
7 Sporting Braga Sporting 26 42 57 25
8 Académica Académica 26 40 53 24
9 Os Belenenses Belenenses 26 45 48 24
10 Boavista Boavista 26 50 62 23
11 Estoril Estoril 26 53 58 21
12 Vitória Setúbal Vitória 26 31 58 20
13 Vitória Guimarães Vitória 26 40 57 18
14 Olhanense Olhanense 26 31 77 17
TEMPORADA 1949/1950
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Benfica Benfica 26 86 33 45
2 Sporting CP Sporting CP 26 91 35 39
3 Atlético CP Atlético 26 53 42 30
4 Os Belenenses Belenenses 26 36 41 27
5 Porto Porto 26 61 52 26
6 SC Covilha SC Covilha 26 55 70 25
7 Académica Académica 26 56 57 24
8 Sporting Braga Sporting 26 52 53 24
9 Olhanense Olhanense 26 48 57 24
10 Vitória Setúbal Vitória 26 50 70 23
11 Vitória Guimarães Vitória 26 45 59 21
12 Estoril Estoril 26 50 59 21
13 O Elvas O Elvas 26 48 65 19
14 Lusitano VRSA Lusitano 26 42 80 16
TEMPORADA 1948/1949
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Sporting CP Sporting CP 26 100 35 42
2 Benfica Benfica 26 72 34 37
3 Os Belenenses Belenenses 26 68 36 35
4 Porto Porto 26 55 37 33
5 Estoril Estoril 26 76 54 29
6 Vitória Guimarães Vitória 26 47 50 26
7 Olhanense Olhanense 26 51 55 24
8 Sporting Braga Sporting 26 39 54 24
9 O Elvas O Elvas 26 46 61 21
10 Atlético CP Atlético 26 44 68 21
11 SC Covilha SC Covilha 26 50 59 20
12 Vitória Setúbal Vitória 26 39 61 20
13 Lusitano VRSA Lusitano 26 23 52 18
14 Boavista Boavista 26 35 89 14
TEMPORADA 1947/1948
LIGA PORTUGUESA
Equipo PJ GF GC Puntos
1 Sporting CP Sporting CP 26 92 40 41
2 Benfica Benfica 26 84 35 41
3 Os Belenenses Belenenses 26 76 30 37
4 Estoril Estoril 26 91 49 36
5 Porto Porto 26 73 42 36
6 Atlético CP Atlético 26 69 62 26
7 Vitória Guimarães Vitória 26 44 56 24
8 O Elvas O Elvas 26 66 63 24
9 Boavista Boavista 26 40 65 20
10 Vitória Setúbal Vitória 26 38 64 19
11 Olhanense Olhanense 26 48 66 17
12 Lusitano VRSA Lusitano 26 29 78 17
13 Sporting Braga Sporting 26 47 69 16
14 Académica Académica 26 35 113 10

  USO DE MEMORIA  
5,847,432 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5176
Total Execution Time  0.5188
  CADENA URL  
/historico/Sporting-Braga/1955
  GET DATOS  
$_GET['/historico/Sporting-Braga/1955']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (25)  
0.0293  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 = 5722
0.0155  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 = 22960
0.0147  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2386 AND type_rel = 2
0.0205  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2386 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0161  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 (1312903,439,579,886,1200) ORDER BY n.cover_points DESC, update_date DESC
0.0185  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 = '2386' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0146  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 = 5722 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0146  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 = 22960 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0161  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=2386 AND l.year in (1954,1955,1956) ORDER BY l.id DESC, l.year DESC ;
0.0145  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 (22961,5723) 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.0152  SELECT count(id) as num_players from rel_players WHERE league_id = 5723 AND teamId = 2386
0.0149  SELECT count(id) as num_players from rel_players WHERE league_id = 22961 AND teamId = 2386
0.0151  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables1955` 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 = 5722 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0165  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 events1955 e ON e.player_id = p.id AND e.league_id = 5722 WHERE rp.league_id = 5722 AND rp.teamId = 2386 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.0161  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 events1955 e ON e.player_id = p.id AND e.league_id = 5722 WHERE rp.league_id = 5722 AND rp.teamId = 2386 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0165  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 events1955 e ON e.player_id = p.id AND e.league_id = 5722 WHERE rp.league_id = 5722 AND rp.teamId = 2386 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0160  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 = 2386 AND l.year <= 1955 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0150  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 `tables1955` 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 = 5722 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 `tables1954` 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 = 5721 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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 `tables1953` 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 = 5720 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0165  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 `tables1952` 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 = 5719 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0161  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 `tables1951` 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 = 5718 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0160  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 `tables1950` 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 = 5717 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 `tables1949` 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 = 5716 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 `tables1948` 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 = 5715 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC