4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Straßwalchen
TEMPORADA 2014/2015
CUARTA AUSTRIA GRUPO 8
Equipo PJ GF GC Puntos
1 USK Anif USK Anif 30 95 29 78
2 Grödig II Grödig II 30 86 48 55
3 Kuchl Kuchl 30 71 53 49
4 Altenmarkt Altenmarkt 30 66 63 49
5 Wals-Grünau Wals-Grünau 30 68 53 48
6 Straßwalchen Straßwalche 30 67 52 46
7 UFC Hallein UFC Hallein 30 57 45 46
8 Bergheim Bergheim 30 40 46 41
9 Puch Puch 30 48 57 41
10 Hallein Hallein 30 49 65 39
11 Bramberg Bramberg 30 40 50 35
12 Salzburger AK Salzburger 30 45 66 35
13 Zell am See Zell am See 30 57 75 34
14 Hallwang Hallwang 30 36 55 31
15 Berndorf Berndorf 30 27 55 24
16 Union Henndorf Union 30 30 70 13
TEMPORADA 2013/2014
CUARTA AUSTRIA GRUPO 8
Equipo PJ GF GC Puntos
1 Pinzgau Saalfelden Pinzgau 30 72 26 69
2 Grödig II Grödig II 30 86 40 66
3 Kuchl Kuchl 30 58 39 52
4 Straßwalchen Straßwalche 30 68 48 51
5 Salzburger AK Salzburger 30 52 46 48
6 Bergheim Bergheim 30 64 59 46
7 Altenmarkt Altenmarkt 30 52 47 46
8 Union Henndorf Union 30 43 55 39
9 Zell am See Zell am See 30 55 70 37
10 Puch Puch 30 48 53 35
11 Bramberg Bramberg 30 45 59 34
12 Hallwang Hallwang 30 51 69 33
13 Hallein Hallein 30 39 64 32
14 Berndorf Berndorf 30 47 69 30
15 Schwarzach Schwarzach 30 35 52 29
16 Anthering Anthering 30 43 62 28
TEMPORADA 2012/2013
CUARTA AUSTRIA GRUPO 6
Equipo PJ GF GC Puntos
1 USC Eugendorf Eugendorf 30 82 31 68
2 Hallein Hallein 30 57 34 61
3 Salzburger AK Salzburger 30 56 37 54
4 Altenmarkt Altenmarkt 30 54 35 51
5 Puch Puch 30 56 47 48
6 Straßwalchen Straßwalche 30 66 50 47
7 Bramberg Bramberg 30 54 63 42
8 Grödig II Grödig II 30 56 50 39
9 Kuchl Kuchl 30 54 51 39
10 Zell am See Zell am See 30 59 61 38
11 Hallwang Hallwang 30 34 39 37
12 Union Henndorf Union 30 43 60 35
13 Berndorf Berndorf 30 42 59 33
14 Schwarzach Schwarzach 30 38 62 29
15 SC Leogang SC Leogang 30 41 78 26
16 Golling Golling 30 31 66 25
TEMPORADA 2011/2012
CUARTA AUSTRIA GRUPO 7
Equipo PJ GF GC Puntos
1 Wals-Grünau Wals-Grünau 30 67 25 64
2 Salzburger AK Salzburger 30 59 25 62
3 Hallwang Hallwang 30 66 36 62
4 Grödig II Grödig II 30 69 35 60
5 USC Eugendorf Eugendorf 30 68 41 59
6 Kuchl Kuchl 30 55 49 44
7 Hallein Hallein 30 59 53 42
8 Straßwalchen Straßwalche 30 54 56 38
9 Puch Puch 30 54 56 37
10 Union Henndorf Union 30 54 61 33
11 SC Leogang SC Leogang 30 52 77 31
12 Altenmarkt Altenmarkt 30 40 65 31
13 Zell am See Zell am See 30 45 76 31
14 Golling Golling 30 53 72 29
15 Anthering Anthering 30 31 62 27
16 ASK PSV Salzburg Salzburg 30 38 75 24
TEMPORADA 2010/2011
CUARTA AUSTRIA GRUPO 2
Equipo PJ GF GC Puntos
1 Pinzgau Saalfelden Pinzgau 30 74 24 75
2 Puch Puch 30 75 43 61
3 USC Eugendorf Eugendorf 30 81 43 60
4 Straßwalchen Straßwalche 30 70 45 59
5 Hallwang Hallwang 30 69 45 57
6 Kuchl Kuchl 30 61 50 49
7 Hallein Hallein 30 62 52 47
8 Salzburger AK Salzburger 30 61 48 41
9 Wals-Grünau Wals-Grünau 30 48 53 40
10 Union Henndorf Union 30 53 62 36
11 ASK PSV Salzburg Salzburg 30 54 66 32
12 Zell am See Zell am See 30 54 77 26
13 Anthering Anthering 30 52 84 26
14 SC Leogang SC Leogang 30 44 77 26
15 Piesendorf Piesendorf 30 44 80 25
16 UFC Maria Alm Maria 30 38 91 22
TEMPORADA 2009/2010
CUARTA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 Austria Salzburg Austria 26 68 24 60
2 Hallwang Hallwang 26 50 26 55
3 USC Eugendorf Eugendorf 26 60 30 51
4 Pinzgau Saalfelden Pinzgau 26 56 29 50
5 Hallein Hallein 26 61 52 45
6 Salzburger AK Salzburger 26 54 36 40
7 Zell am See Zell am See 26 59 50 39
8 Straßwalchen Straßwalche 26 46 59 32
9 Piesendorf Piesendorf 26 39 58 26
10 Anthering Anthering 26 30 52 26
11 Puch Puch 26 32 51 25
12 Maria Saal Maria Saal 26 43 71 25
13 ASK PSV Salzburg Salzburg 26 29 61 23
14 Union Henndorf Union 26 44 72 19
TEMPORADA 2008/2009
CUARTA AUSTRIA GRUPO 1
Equipo PJ GF GC Puntos
1 TSV Neumarkt Neumarkt 26 62 26 57
2 USC Eugendorf Eugendorf 26 48 37 48
3 Hallwang Hallwang 26 65 33 47
4 Pinzgau Saalfelden Pinzgau 26 54 32 47
5 Puch Puch 26 51 39 41
6 Hallein Hallein 26 43 46 39
7 Salzburger AK Salzburger 26 43 42 38
8 Straßwalchen Straßwalche 26 39 52 32
9 Zell am See Zell am See 26 37 50 28
10 Union Henndorf Union 26 36 50 28
11 ASK PSV Salzburg Salzburg 26 32 50 27
12 Anthering Anthering 25 30 38 24
13 Piesendorf Piesendorf 26 34 55 22
14 Bischofshofen Bischofshofe 25 30 54 21

  USO DE MEMORIA  
5,526,808 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.4719
Total Execution Time  0.4731
  CADENA URL  
/historico/Strabwalchen/2015
  GET DATOS  
$_GET['/historico/Strabwalchen/2015']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (28)  
0.0139  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Strabwalchen' AND l.year = 2015 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0126  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=19417 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=19417 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0254  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 = 3942
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=19417 AND type_rel = 2
0.0132  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '19417' ORDER BY l.year DESC,cat.coefficient DESC
0.0132  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '19417' AND l.year = 2015 ORDER BY l.year DESC,cat.coefficient DESC
0.0129  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 = '19417' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126  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 = 3942 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0130  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=19417 AND l.year in (2014,2015,2016) ORDER BY l.id DESC, l.year DESC ;
0.0125  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 (27181) 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.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 27181 AND teamId = 19417
0.0135  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2015` 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 = 3942 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0127  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '19417' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '19417' and rp.type = 4
0.0127  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '19417' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0140  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 events2015 e ON e.player_id = p.id AND e.league_id = 3942 WHERE rp.league_id = 3942 AND rp.teamId = 19417 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.0135  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 events2015 e ON e.player_id = p.id AND e.league_id = 3942 WHERE rp.league_id = 3942 AND rp.teamId = 19417 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0136  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 events2015 e ON e.player_id = p.id AND e.league_id = 3942 WHERE rp.league_id = 3942 AND rp.teamId = 19417 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0130  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 = 19417 AND l.year <= 2015 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0132  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 `tables2015` 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 = 3942 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 `tables2014` 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 = 27181 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 `tables2013` 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 = 27175 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 `tables2012` 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 = 27212 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 `tables2011` 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 = 27206 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 `tables2010` 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 = 27237 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 `tables2009` 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 = 27255 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 3942 ORDER BY nameShow LIMIT 100