4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Spratzern
TEMPORADA 2022/2023
CUARTA AUSTRIA GRUPO 9
Equipo PJ GF GC Puntos
1 Ardagger Ardagger 28 43 17 60
2 Kottingbrunn Kottingbrunn 27 40 21 54
3 Gloggnitz Gloggnitz 27 55 33 51
4 Zwettl Zwettl 27 36 21 49
5 Langenrohr Langenrohr 28 45 26 48
6 Schrems Schrems 28 44 38 40
7 Ortmann Ortmann 28 30 30 40
8 SC Retz SC Retz 27 33 33 36
9 Rohrbach Rohrbach 28 28 35 32
10 SV Haitzendorf Haitzendorf 28 48 45 31
11 St. Pölten II Pölten 27 34 36 31
12 Waidhofen / Thaya Waidhofen 27 26 36 30
13 Kilb Kilb 27 28 39 30
14 Spratzern Spratzern 28 24 47 25
15 Mannersdorf Mannersdorf 27 9 66 19
TEMPORADA 2021/2022
CUARTA AUSTRIA GRUPO 8
Equipo PJ GF GC Puntos
1 Scheiblingkirchen-Warth Scheiblingki 28 65 21 76
2 Kremser SC Kremser SC 28 75 30 65
3 SC Retz SC Retz 28 47 31 50
4 Ardagger Ardagger 28 39 17 49
5 St. Pölten II Pölten 28 61 37 40
6 Kottingbrunn Kottingbrunn 28 35 29 37
7 Ortmann Ortmann 28 36 36 37
8 Langenrohr Langenrohr 28 40 45 37
9 Waidhofen / Thaya Waidhofen 28 23 37 34
10 Kilb Kilb 28 39 49 32
11 Rohrbach Rohrbach 28 31 51 29
12 Spratzern Spratzern 28 36 56 27
13 Zwettl Zwettl 28 30 54 27
14 Schrems Schrems 28 34 52 26
15 Mannersdorf Mannersdorf 28 16 62 12
TEMPORADA 2020/2021
CUARTA AUSTRIA GRUPO 7
Equipo PJ GF GC Puntos
1 Mannersdorf Mannersdorf 0 0 0 0
2 Spratzern Spratzern 0 0 0 0
3 Scheiblingkirchen-Warth Scheiblingki 0 0 0 0
4 Kilb Kilb 0 0 0 0
5 SC Retz SC Retz 0 0 0 0
6 Zwettl Zwettl 0 0 0 0
7 Ardagger Ardagger 0 0 0 0
8 Waidhofen / Thaya Waidhofen 0 0 0 0
9 Schrems Schrems 0 0 0 0
10 Langenrohr Langenrohr 0 0 0 0
11 Ortmann Ortmann 0 0 0 0
12 Kottingbrunn Kottingbrunn 0 0 0 0
13 Kremser SC Kremser SC 0 0 0 0
14 Rohrbach Rohrbach 0 0 0 0
15 St. Pölten II Pölten 0 0 0 0
TEMPORADA 2019/2020
CUARTA AUSTRIA GRUPO 4
Equipo PJ GF GC Puntos
1 SC Retz SC Retz 16 33 18 34
2 Kottingbrunn Kottingbrunn 15 30 8 33
3 Rohrbach Rohrbach 16 37 20 33
4 Scheiblingkirchen-Warth Scheiblingki 17 33 19 31
5 St. Pölten II Pölten 16 33 20 31
6 Kremser SC Kremser SC 16 36 14 29
7 Ardagger Ardagger 16 20 14 23
8 Gaflenz Gaflenz 15 26 29 21
9 Kilb Kilb 17 23 31 20
10 Schrems Schrems 16 23 29 19
11 Zwettl Zwettl 16 22 28 15
12 Langenrohr Langenrohr 16 20 30 13
13 Mannersdorf Mannersdorf 16 17 31 12
14 Waidhofen / Thaya Waidhofen 16 17 37 12
15 Ortmann Ortmann 16 24 44 11
16 Spratzern Spratzern 16 18 40 9
TEMPORADA 2018/2019
CUARTA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 Stripfing Stripfing 30 68 21 72
2 Kremser SC Kremser SC 30 66 44 59
3 SC Retz SC Retz 30 52 36 55
4 Kottingbrunn Kottingbrunn 30 47 33 52
5 Waidhofen / Thaya Waidhofen 30 55 40 51
6 Scheiblingkirchen-Warth Scheiblingki 30 57 51 46
7 Gaflenz Gaflenz 30 44 48 44
8 Ardagger Ardagger 30 36 32 40
9 Zwettl Zwettl 30 41 58 39
10 Langenrohr Langenrohr 30 42 43 36
11 Rohrbach Rohrbach 30 37 45 36
12 Kilb Kilb 30 40 54 36
13 Ortmann Ortmann 30 42 53 33
14 Spratzern Spratzern 30 32 57 29
15 St. Peter St. Peter 30 29 52 25
16 Rohrendorf Rohrendorf 30 43 64 22
TEMPORADA 2017/2018
CUARTA AUSTRIA GRUPO 6
Equipo PJ GF GC Puntos
1 Leobendorf Leobendorf 30 57 13 65
2 Stripfing Stripfing 30 60 22 65
3 SC Retz SC Retz 30 54 29 62
4 Kremser SC Kremser SC 30 58 30 60
5 Scheiblingkirchen-Warth Scheiblingki 30 55 41 53
6 Kottingbrunn Kottingbrunn 30 46 27 52
7 Gaflenz Gaflenz 30 62 55 45
8 Langenrohr Langenrohr 30 44 48 36
9 Waidhofen / Thaya Waidhofen 30 40 54 34
10 St. Peter St. Peter 30 43 56 30
11 Ardagger Ardagger 30 28 41 30
12 Zwettl Zwettl 30 32 61 27
13 Rohrendorf Rohrendorf 30 38 51 26
14 Spratzern Spratzern 30 21 52 26
15 Rohrbach Rohrbach 30 30 53 25
16 SV Haitzendorf Haitzendorf 30 23 58 23
TEMPORADA 2016/2017
CUARTA AUSTRIA GRUPO 1
Equipo PJ GF GC Puntos
1 Bruck/Leitha Bruck/Leitha 30 78 34 65
2 Leobendorf Leobendorf 30 77 35 65
3 SC Retz SC Retz 30 58 32 58
4 Kremser SC Kremser SC 30 61 30 57
5 Stripfing Stripfing 30 60 49 45
6 Kottingbrunn Kottingbrunn 30 49 39 43
7 Ardagger Ardagger 30 41 53 40
8 SV Haitzendorf Haitzendorf 30 53 63 36
9 Spratzern Spratzern 30 41 52 34
10 Rohrendorf Rohrendorf 30 40 60 34
11 Zwettl Zwettl 30 41 49 33
12 Langenrohr Langenrohr 30 39 52 33
13 Gaflenz Gaflenz 30 38 57 33
14 Waidhofen / Thaya Waidhofen 30 47 72 33
15 St. Peter St. Peter 30 37 59 31
16 Würmla Würmla 30 33 57 24
TEMPORADA 2015/2016
CUARTA AUSTRIA GRUPO 4
Equipo PJ GF GC Puntos
1 Marchfeld Marchfeld 30 73 30 68
2 Leobendorf Leobendorf 30 84 28 59
3 Kremser SC Kremser SC 30 61 42 56
4 Kottingbrunn Kottingbrunn 30 63 43 55
5 Spratzern Spratzern 30 43 36 48
6 SC Retz SC Retz 30 42 34 46
7 Zwettl Zwettl 30 47 37 43
8 FCM Traiskirchen Traiskirchen 30 46 33 42
9 Langenrohr Langenrohr 30 53 47 33
10 Waidhofen / Thaya Waidhofen 30 42 58 33
11 Ardagger Ardagger 30 43 62 33
12 Würmla Würmla 30 46 60 32
13 St. Peter St. Peter 30 42 68 31
14 Gaflenz Gaflenz 30 34 65 27
15 SV Haitzendorf Haitzendorf 30 39 69 21
16 ATSV Ober-Grafendorf ATSV 30 7 53 20
TEMPORADA 2014/2015
CUARTA AUSTRIA GRUPO 4
Equipo PJ GF GC Puntos
1 Ebreichsdorf Ebreichsdorf 30 82 32 69
2 Kremser SC Kremser SC 30 95 30 68
3 Kottingbrunn Kottingbrunn 30 71 35 59
4 Leobendorf Leobendorf 30 71 45 48
5 St. Peter St. Peter 30 49 43 43
6 Langenrohr Langenrohr 30 45 57 43
7 Zwettl Zwettl 30 47 41 42
8 Marchfeld Marchfeld 30 58 55 42
9 Gaflenz Gaflenz 30 48 49 42
10 SC Retz SC Retz 30 50 52 42
11 Würmla Würmla 30 40 45 39
12 Ardagger Ardagger 30 42 65 35
13 Spratzern Spratzern 30 40 62 28
14 Waidhofen / Thaya Waidhofen 30 42 74 27
15 Ober-Grafendorf Ober-Grafend 30 45 102 26
16 Bad Vöslau Bad Vöslau 30 33 71 21
TEMPORADA 2013/2014
CUARTA AUSTRIA GRUPO 1
Equipo PJ GF GC Puntos
1 St. Pölten II Pölten 29 79 23 65
2 Leobendorf Leobendorf 29 66 28 62
3 Gaflenz Gaflenz 29 72 39 61
4 Kottingbrunn Kottingbrunn 29 64 31 61
5 Würmla Würmla 29 67 41 57
6 Ardagger Ardagger 29 58 36 50
7 Langenrohr Langenrohr 29 41 47 44
8 Marchfeld Marchfeld 29 53 52 39
9 Waidhofen / Thaya Waidhofen 29 48 56 38
10 St. Peter St. Peter 29 39 47 34
11 Zwettl Zwettl 29 43 54 34
12 Bad Vöslau Bad Vöslau 29 41 55 33
13 Spratzern Spratzern 29 40 61 28
14 Mistelbach Mistelbach 29 32 50 27
15 Schwadorf Schwadorf 29 19 65 13
16 Götzendorf Götzendorf 29 11 88 7

  USO DE MEMORIA  
5,867,432 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.1005
Total Execution Time  0.1019
  CADENA URL  
/historico/Spratzern
  GET DATOS  
$_GET['/historico/Spratzern']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (28)  
0.0038  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 = 'Spratzern' AND l.year = 2024 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.0019  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=17514 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=17514 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17514 AND type_rel = 2
0.0026  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 = '17514' ORDER BY l.year DESC,cat.coefficient DESC
0.0025  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 = '17514' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0023  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 = '17514' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022  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 = '17514' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0023  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=17514 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (71432,68332) 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.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 68332 AND teamId = 17514
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 17514
0.0021  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 = '17514' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '17514' and rp.type = 4
0.0021  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 = '17514' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0024  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 events2024 e ON e.player_id = p.id AND e.league_id = 71432 WHERE rp.league_id = 71432 AND rp.teamId = 17514 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.0022  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 events2024 e ON e.player_id = p.id AND e.league_id = 71432 WHERE rp.league_id = 71432 AND rp.teamId = 17514 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021  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 events2024 e ON e.player_id = p.id AND e.league_id = 71432 WHERE rp.league_id = 71432 AND rp.teamId = 17514 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027  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 = 17514 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `tables2023` 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 = 68332 AND t.round = 30 ORDER BY team.conference ASC,t.position 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 `tables2022` 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 = 63697 AND t.round = 30 ORDER BY team.conference ASC,t.position 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 `tables2021` 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 = 57783 AND t.round = 30 ORDER BY team.conference ASC,t.position 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 `tables2020` 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 = 50450 AND t.round = 16 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 `tables2019` 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 = 44307 AND t.round = 30 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 `tables2018` 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 = 38912 AND t.round = 30 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 `tables2016` 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 = 15768 AND t.round = 30 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 `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 = 3938 AND t.round = 30 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 `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 = 3583 AND t.round = 29 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC