4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 1934/1935
Equipo PJ GF GC Puntos
1 IFK Göteborg Göteborg 22 48 22 48
2 IF Elfsborg IF Elfsborg 22 59 43 41
3 Sandvikens IF Sandvikens 22 46 46 40
4 AIK Solna AIK Solna 22 59 28 39
5 GAIS GAIS 22 44 49 34
6 Landskrona BoIS Landskrona 22 47 47 32
7 Sleipner Sleipner 22 55 49 30
8 Örgryte Örgryte 22 40 42 29
9 Halmstads Halmstads 22 33 39 26
10 IFK Eskilstuna Eskilstuna 22 37 52 25
11 Helsingborgs IF Helsingborgs 22 40 49 20
12 Gefle Gefle 22 37 79 10
Ver
TEMPORADA 1933/1934
Equipo PJ GF GC Puntos
1 Helsingborgs IF Helsingborgs 20 49 35 40
2 GAIS GAIS 20 54 34 38
3 IFK Göteborg Göteborg 20 52 38 36
4 Halmstads Halmstads 20 43 38 31
5 Örgryte Örgryte 20 38 35 30
6 IF Elfsborg IF Elfsborg 20 45 44 27
7 AIK Solna AIK Solna 20 40 42 24
8 Sandvikens IF Sandvikens 20 49 57 24
9 IFK Eskilstuna Eskilstuna 20 42 52 24
10 Gefle Gefle 20 37 56 22
11 Halmia Halmia 20 23 41 14
Ver
TEMPORADA 1932/1933
Equipo PJ GF GC Puntos
1 Helsingborgs IF Helsingborgs 22 68 38 51
2 GAIS GAIS 22 70 30 50
3 IFK Göteborg Göteborg 22 58 42 36
4 AIK Solna AIK Solna 22 60 40 35
5 Örgryte Örgryte 22 40 43 29
6 IFK Eskilstuna Eskilstuna 22 47 55 29
7 IF Elfsborg IF Elfsborg 22 44 54 27
8 Malmö FF Malmö FF 22 42 66 27
9 Sandvikens IF Sandvikens 22 43 48 26
10 Halmia Halmia 22 34 50 24
11 Sleipner Sleipner 22 34 52 24
12 Landskrona BoIS Landskrona 22 38 60 21
Ver
TEMPORADA 1931/1932
Equipo PJ GF GC Puntos
1 AIK Solna AIK Solna 22 58 33 45
2 Örgryte Örgryte 22 67 37 44
3 GAIS GAIS 22 45 29 41
4 IFK Göteborg Göteborg 22 47 34 37
5 IFK Eskilstuna Eskilstuna 22 50 44 32
6 Sleipner Sleipner 22 41 35 30
7 IF Elfsborg IF Elfsborg 22 38 35 30
8 Helsingborgs IF Helsingborgs 22 45 44 30
9 Malmö FF Malmö FF 22 48 68 22
10 Landskrona BoIS Landskrona 22 35 58 20
11 IFK Malmö IFK Malmö 22 32 55 18
12 Hallstahammar SK Hallstahamma 22 29 63 12
Ver
TEMPORADA 1930/1931
Equipo PJ GF GC Puntos
1 GAIS GAIS 22 70 34 52
2 IFK Göteborg Göteborg 22 45 31 44
3 AIK Solna AIK Solna 22 67 41 42
4 Helsingborgs IF Helsingborgs 22 55 43 38
5 Landskrona BoIS Landskrona 22 47 49 34
6 IFK Malmö IFK Malmö 22 42 55 31
7 Örgryte Örgryte 22 45 46 29
8 Sleipner Sleipner 22 53 54 24
9 IFK Eskilstuna Eskilstuna 22 45 58 21
10 IF Elfsborg IF Elfsborg 22 39 59 21
11 Redbergslids IK Redbergslids 22 35 60 20
12 Sandvikens IF Sandvikens 22 39 52 18
Ver
TEMPORADA 1929/1930
Equipo PJ GF GC Puntos
1 Helsingborgs IF Helsingborgs 22 78 33 44
2 IFK Göteborg Göteborg 22 67 28 42
3 Sleipner Sleipner 22 48 37 41
4 GAIS GAIS 22 46 31 39
5 Örgryte Örgryte 22 59 43 38
6 AIK Solna AIK Solna 22 52 35 36
7 Landskrona BoIS Landskrona 22 54 56 28
8 IF Elfsborg IF Elfsborg 22 45 49 28
9 Sandvikens IF Sandvikens 22 39 56 25
10 IFK Malmö IFK Malmö 22 37 59 22
11 IFK Norrköping Norrköping 22 32 77 17
12 Stattena IF Stattena IF 22 28 81 12
Ver
TEMPORADA 1928/1929
Equipo PJ GF GC Puntos
1 Helsingborgs IF Helsingborgs 22 89 35 51
2 Örgryte Örgryte 22 72 42 48
3 IFK Göteborg Göteborg 22 56 34 46
4 Sleipner Sleipner 22 54 49 36
5 GAIS GAIS 22 47 43 31
6 IF Elfsborg IF Elfsborg 22 41 54 27
7 Landskrona BoIS Landskrona 22 37 47 26
8 IFK Malmö IFK Malmö 22 32 47 26
9 AIK Solna AIK Solna 22 47 55 24
10 IFK Eskilstuna Eskilstuna 22 41 74 23
11 IFK Norrköping Norrköping 22 25 33 20
12 Westermalms IF Westermalms 22 34 62 18
Ver
TEMPORADA 1927/1928
Equipo PJ GF GC Puntos
1 Örgryte Örgryte 22 69 29 47
2 Helsingborgs IF Helsingborgs 22 64 27 47
3 GAIS GAIS 22 45 29 39
4 IFK Göteborg Göteborg 22 39 33 36
5 IF Elfsborg IF Elfsborg 22 48 35 33
6 Sleipner Sleipner 22 50 44 29
7 AIK Solna AIK Solna 22 49 47 28
8 Landskrona BoIS Landskrona 22 49 52 26
9 IFK Eskilstuna Eskilstuna 22 42 65 25
10 IFK Norrköping Norrköping 22 36 63 25
11 Djurgårdens IF Djurgårdens 22 43 66 18
12 Stattena IF Stattena IF 22 30 74 16
Ver
TEMPORADA 1926/1927
Equipo PJ GF GC Puntos
1 GAIS GAIS 22 70 25 52
2 IFK Göteborg Göteborg 22 58 27 49
3 Helsingborgs IF Helsingborgs 22 74 34 48
4 Örgryte Örgryte 22 43 30 42
5 AIK Solna AIK Solna 22 38 36 33
6 Sleipner Sleipner 22 44 42 29
7 IFK Eskilstuna Eskilstuna 22 51 61 26
8 IFK Norrköping Norrköping 22 35 50 24
9 Landskrona BoIS Landskrona 22 36 56 23
10 IF Elfsborg IF Elfsborg 22 33 60 22
11 Westermalms IF Westermalms 22 35 58 19
12 Uddevalla Uddevalla 22 27 65 10
Ver
TEMPORADA 1925/1926
Equipo PJ GF GC Puntos
1 GAIS GAIS 22 67 20 50
2 Örgryte Örgryte 22 75 33 50
3 Helsingborgs IF Helsingborgs 22 75 36 47
4 IFK Göteborg Göteborg 22 65 27 46
5 IFK Norrköping Norrköping 22 47 57 29
6 AIK Solna AIK Solna 22 45 50 28
7 Sleipner Sleipner 22 40 52 26
8 Landskrona BoIS Landskrona 22 56 67 25
9 IFK Eskilstuna Eskilstuna 22 40 63 23
10 Uddevalla Uddevalla 22 31 49 20
11 IFK Malmö IFK Malmö 22 30 66 18
12 Eskilstuna City Eskilstuna 22 32 83 7
Ver
TEMPORADA 1924/1925
Equipo PJ GF GC Puntos
1 GAIS GAIS 22 63 16 55
2 IFK Göteborg Göteborg 22 87 30 52
3 Örgryte Örgryte 22 67 17 50
4 Helsingborgs IF Helsingborgs 22 50 29 40
5 AIK Solna AIK Solna 22 57 38 36
6 Landskrona BoIS Landskrona 22 30 52 27
7 Sleipner Sleipner 22 37 49 25
8 IFK Norrköping Norrköping 22 27 49 25
9 IFK Eskilstuna Eskilstuna 22 41 58 22
10 IFK Malmö IFK Malmö 22 39 55 20
11 Västerås IK Västerås 22 21 66 11
12 Hammarby IF Hammarby IF 22 23 83 10

  USO DE MEMORIA  
5,727,168 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.0892
Total Execution Time  0.0911
  CADENA URL  
/suecia1935/grupo1/historico
  GET DATOS  
$_GET['/suecia1935/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (25)  
0.0017  SELECT type FROM routes WHERE alias = 'suecia1935'
0.0041  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'suecia' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1935 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0022  SELECT id,name,alias,stepParent FROM categories WHERE parentId=22 ORDER BY order_id ASC
0.0021  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 = 23030 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 22 AND group_code = 1 and tables = 1 AND year <= 1935 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `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 = 23030 AND t.round = 8 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 `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 = 23031 AND t.round = 7 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 `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 = 23032 AND t.round = 22 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 `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 = 23035 AND t.round = 7 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 `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 = 23036 AND t.round = 7 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 `tables1930` 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 = 23041 AND t.round = 7 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 `tables1929` 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 = 23037 AND t.round = 8 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 `tables1928` 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 = 23038 AND t.round = 7 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 `tables1927` 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 = 23042 AND t.round = 7 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 `tables1926` 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 = 23039 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `tables1925` 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 = 23040 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-08 14:25:57' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-08 14:25:57' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-08 14:25:57' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-08 14:25:57' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'suecia' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1935 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0021  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 events1935 e ON e.player_id = p.id AND e.league_id = 23030 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 23030 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.0020  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 events1935 e ON e.player_id = p.id AND e.league_id = 23030 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 23030 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0020  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 events1935 e ON e.player_id = p.id AND e.league_id = 23030 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 23030 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0038  SELECT *,(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 = 23030 AND t.round = 8 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC