4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 1949/1950
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
Ver
TEMPORADA 1948/1949
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
Ver
TEMPORADA 1947/1948
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
Ver
TEMPORADA 1946/1947
Equipo PJ GF GC Puntos
1 Sporting CP Sporting CP 26 123 40 47
2 Benfica Benfica 26 99 47 41
3 Porto Porto 26 73 45 33
4 Os Belenenses Belenenses 26 66 31 33
5 Estoril Estoril 26 96 55 33
6 Olhanense Olhanense 26 69 73 26
7 Atlético CP Atlético 26 56 61 25
8 Vitória Guimarães Vitória 26 54 54 24
9 Boavista Boavista 26 52 74 20
10 Elvas SL Elvas SL 26 65 89 20
11 Académica Académica 26 49 96 20
12 Vitória Setúbal Vitória 26 45 50 20
13 Famalicão Famalicão 26 60 100 17
14 AD Sanjoanense Sanjoanense 26 26 118 5
Ver
TEMPORADA 1945/1946
Equipo PJ GF GC Puntos
1 Os Belenenses Belenenses 22 74 24 38
2 Benfica Benfica 22 82 29 37
3 Sporting CP Sporting CP 22 73 36 32
4 Olhanense Olhanense 22 65 39 27
5 Atlético CP Atlético 22 38 55 21
6 Porto Porto 22 65 44 20
7 Vitória Setúbal Vitória 22 47 59 18
8 Vitória Guimarães Vitória 22 39 52 18
9 Elvas SL Elvas SL 22 43 78 17
10 Académica Académica 22 51 76 16
11 Boavista Boavista 22 39 73 12
12 UD Oliveirense Oliveirense 22 22 73 8
Ver
TEMPORADA 1944/1945
Equipo PJ GF GC Puntos
1 Benfica Benfica 18 79 26 30
2 Sporting CP Sporting CP 18 57 37 27
3 Os Belenenses Belenenses 18 72 29 27
4 Porto Porto 18 64 48 20
5 Vitória Setúbal Vitória 18 44 49 19
6 Olhanense Olhanense 18 41 41 16
7 Estoril Estoril 18 44 34 16
8 Vitória Guimarães Vitória 18 32 57 11
9 Académica Académica 18 33 65 9
10 SC Salgueiros Salgueiros 18 30 110 5
Ver
TEMPORADA 1943/1944
Equipo PJ GF GC Puntos
1 Sporting CP Sporting CP 18 61 22 31
2 Benfica Benfica 18 57 34 26
3 Atlético CP Atlético 18 51 28 24
4 Porto Porto 18 46 36 23
5 Olhanense Olhanense 18 65 34 22
6 Os Belenenses Belenenses 18 41 32 21
7 Vitória Setúbal Vitória 18 52 50 17
8 Vitória Guimarães Vitória 18 25 68 7
9 Académica Académica 18 35 68 6
10 SC Salgueiros Salgueiros 18 23 84 3
Ver
TEMPORADA 1942/1943
Equipo PJ GF GC Puntos
1 Benfica Benfica 18 74 38 30
2 Sporting CP Sporting CP 18 66 37 29
3 Os Belenenses Belenenses 18 78 20 28
4 Os Unidos CF Unidos 18 70 46 20
5 Olhanense Olhanense 18 44 48 18
6 Académica Académica 18 54 60 14
7 Porto Porto 18 40 56 14
8 Vitória Guimarães Vitória 18 48 76 14
9 Fabril Barreiro Fabril 18 46 77 11
10 Leixões Leixões 18 19 81 2
Ver
TEMPORADA 1941/1942
Equipo PJ GF GC Puntos
1 Benfica Benfica 22 74 34 38
2 Sporting CP Sporting CP 22 93 31 34
3 Os Belenenses Belenenses 22 66 32 30
4 Porto Porto 22 77 48 28
5 Académica Académica 22 77 51 26
6 FC Barreirense Barreirense 22 58 55 25
7 Os Unidos CF Unidos 22 53 49 18
8 Olhanense Olhanense 22 42 83 14
9 Carcavelinhos Carcavelinho 22 35 73 14
10 Academico do Porto Academico 22 48 81 13
11 Vitória Guimarães Vitória 22 43 76 13
12 Leça FC Leça FC 22 29 82 11
Ver
TEMPORADA 1940/1941
Equipo PJ GF GC Puntos
1 Sporting CP Sporting CP 14 58 23 23
2 Porto Porto 14 47 27 20
3 Os Belenenses Belenenses 14 59 22 19
4 Benfica Benfica 14 39 28 18
5 Académica Académica 14 32 41 11
6 FC Barreirense Barreirense 14 17 38 10
7 Os Unidos CF Unidos 14 28 50 6
8 Boavista Boavista 14 12 63 5
Ver
TEMPORADA 1939/1940
Equipo PJ GF GC Puntos
1 Porto Porto 18 76 21 34
2 Sporting CP Sporting CP 18 87 23 32
3 Os Belenenses Belenenses 18 58 21 25
4 Benfica Benfica 18 58 34 23
5 FC Barreirense Barreirense 18 27 39 19
6 Académica Académica 18 42 54 17
7 Carcavelinhos Carcavelinho 18 26 49 10
8 Academico do Porto Academico 18 24 53 8
9 Leixões Leixões 18 26 70 7
10 Vitória Setúbal Vitória 18 7 67 5
Ver
TEMPORADA 1938/1939
Equipo PJ GF GC Puntos
1 Porto Porto 14 57 20 23
2 Sporting CP Sporting CP 14 44 17 22
3 Benfica Benfica 14 44 24 21
4 Os Belenenses Belenenses 14 38 29 13
5 Académica Académica 14 27 39 11
6 FC Barreirense Barreirense 14 21 27 10
7 Academico do Porto Academico 14 30 61 10
8 Casa Pia AC Casa Pia AC 14 12 56 2
Ver
TEMPORADA 1937/1938
Equipo PJ GF GC Puntos
1 Benfica Benfica 14 34 16 23
2 Porto Porto 14 43 22 23
3 Sporting CP Sporting CP 14 67 23 22
4 Carcavelinhos Carcavelinho 14 18 36 11
5 Os Belenenses Belenenses 14 29 28 10
6 Académica Académica 14 23 37 10
7 FC Barreirense Barreirense 14 18 34 8
8 Academico do Porto Academico 14 15 51 5
Ver
TEMPORADA 1936/1937
Equipo PJ GF GC Puntos
1 Benfica Benfica 14 57 13 24
2 Os Belenenses Belenenses 14 46 17 23
3 Sporting CP Sporting CP 14 54 25 20
4 Porto Porto 14 31 31 14
5 Académica Académica 14 24 30 11
6 Carcavelinhos Carcavelinho 14 16 35 9
7 Vitória Setúbal Vitória 14 18 45 7
8 Leixões Leixões 14 19 69 4
Ver
TEMPORADA 1935/1936
Equipo PJ GF GC Puntos
1 Benfica Benfica 14 44 23 21
2 Porto Porto 14 50 18 20
3 Sporting CP Sporting CP 14 41 31 18
4 Os Belenenses Belenenses 14 28 22 17
5 Vitória Setúbal Vitória 14 32 26 16
6 Boavista Boavista 14 24 39 11
7 Carcavelinhos Carcavelinho 14 8 30 6
8 Académica Académica 14 13 51 3
Ver
TEMPORADA 1934/1935
Equipo PJ GF GC Puntos
1 Porto Porto 14 43 19 22
2 Sporting CP Sporting CP 14 39 20 20
3 Benfica Benfica 14 41 23 19
4 Os Belenenses Belenenses 14 45 20 18
5 Vitória Setúbal Vitória 14 26 24 16
6 Uniao Lisboa FB Uniao Lisboa 14 30 49 8
7 Academico do Porto Academico 14 20 54 6
8 Académica Académica 14 14 49 3

  USO DE MEMORIA  
6,241,624 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.6540
Total Execution Time  0.6559
  CADENA URL  
/portugal1950/grupo1/historico
  GET DATOS  
$_GET['/portugal1950/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0144  SELECT type FROM routes WHERE alias = 'portugal1950'
0.0293  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'portugal' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1950 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=19 AND type_rel = 3
0.0285  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 19 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0151  SELECT /*53 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 (1313733,1313315,1313212,1313082,1313074) ORDER BY n.cover_points DESC, update_date DESC
0.0145  SELECT id,name,alias,stepParent FROM categories WHERE parentId=19 ORDER BY order_id ASC
0.0146  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 5717 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0147  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 19 AND group_code = 1 and tables = 1 AND year <= 1950 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0149  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.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 `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.0164  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
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 `tables1947` 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 = 5714 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 `tables1946` 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 = 5713 AND t.round = 22 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 `tables1945` 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 = 5712 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0156  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 `tables1944` 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 = 5711 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0167  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 `tables1943` 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 = 5710 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163  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 `tables1942` 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 = 5709 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0162  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 `tables1941` 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 = 5708 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0157  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 `tables1940` 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 = 5707 AND t.round = 18 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 `tables1939` 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 = 5706 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154  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 `tables1938` 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 = 5705 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163  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 = 5704 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0162  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 = 5703 AND t.round = 14 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 `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 = 5702 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0144  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-04 01:43:02' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-04 01:43:02' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-04 01:43:02' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-04 01:43:02' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0150  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'portugal' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1950 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0230  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events1950 e ON e.player_id = p.id AND e.league_id = 5717 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 5717 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0152  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events1950 e ON e.player_id = p.id AND e.league_id = 5717 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 5717 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0153  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events1950 e ON e.player_id = p.id AND e.league_id = 5717 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 5717 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0155  SELECT *,(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