4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
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,379,408 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.4692
Total Execution Time  0.4711
  CADENA URL  
/suecia1931/grupo1/historico
  GET DATOS  
$_GET['/suecia1931/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0144  SELECT type FROM routes WHERE alias = 'suecia1931'
0.0294  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 = 1931 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0147  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=22 AND type_rel = 3
0.0178  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 22 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0161  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 (1313442,1312381,1311197,1300414,1300338) ORDER BY n.cover_points DESC, update_date DESC
0.0156  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 = 23036 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0151  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 22 AND group_code = 1 and tables = 1 AND year <= 1931 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `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.0148  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.0147  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.0148  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.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 `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.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 `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.0148  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.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-04 12:13:52' 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 12:13:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-04 12:13:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0148  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-04 12:13:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0162  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 = 1931 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0156  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 events1931 e ON e.player_id = p.id AND e.league_id = 23036 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 23036 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.0154  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 events1931 e ON e.player_id = p.id AND e.league_id = 23036 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 23036 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0145  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 events1931 e ON e.player_id = p.id AND e.league_id = 23036 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 23036 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0157  SELECT *,(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