4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
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,162,536 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.0689
Total Execution Time  0.0711
  CADENA URL  
/suecia1929/grupo1/historico
  GET DATOS  
$_GET['/suecia1929/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0018  SELECT type FROM routes WHERE alias = 'suecia1929'
0.0040  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 = 1929 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=22 ORDER BY order_id ASC
0.0019  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 = 23037 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 22 AND group_code = 1 and tables = 1 AND year <= 1929 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0021  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.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 `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.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 `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.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 `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.0021  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.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 06:19:50' 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-04-27 06:19:50' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 06:19:50' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 06:19:50' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  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 = 1929 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0019  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 events1929 e ON e.player_id = p.id AND e.league_id = 23037 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 23037 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.0019  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 events1929 e ON e.player_id = p.id AND e.league_id = 23037 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 23037 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0019  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 events1929 e ON e.player_id = p.id AND e.league_id = 23037 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 23037 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0030  SELECT *,(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