4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Rohrbach
TEMPORADA 2023/2024
CUARTA AUSTRIA GRUPO 7
Equipo PJ GF GC Puntos
1 Gloggnitz Gloggnitz 24 45 19 54
2 Marathon Korneuburg Marathon 24 50 20 53
3 Schrems Schrems 24 49 25 46
4 Wiener Neustadt Wiener 24 38 33 40
5 Kilb Kilb 24 37 29 36
6 SC Retz SC Retz 24 33 22 35
7 Ortmann Ortmann 24 42 35 35
8 Zwettl Zwettl 24 41 40 35
9 St. Pölten II Pölten 23 36 39 32
10 Scheiblingkirchen-Warth Scheiblingki 24 30 34 31
11 St. Peter St. Peter 24 39 34 30
12 Rohrbach Rohrbach 24 28 35 28
13 Langenrohr Langenrohr 23 32 47 26
14 Kottingbrunn Kottingbrunn 24 24 32 23
15 SV Haitzendorf Haitzendorf 24 26 48 17
16 Waidhofen / Thaya Waidhofen 24 16 74 10
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 2004/2005
TERCERA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 Austria Wien II Austria Wien 30 81 31 68
2 Parndorf Parndorf 30 69 23 64
3 First Vienna First Vienna 30 59 20 64
4 Kottingbrunn Kottingbrunn 30 61 37 58
5 Wiener SC Wiener SC 30 57 36 57
6 SKN St. Polten Polten 30 62 26 56
7 Eisenstadt SC Eisenstadt 30 51 27 56
8 Waidhofen Waidhofen 30 45 43 42
9 Kremser SC Kremser SC 30 44 44 35
10 PSV Wien PSV Wien 30 46 56 34
11 Ritzing Ritzing 30 47 55 31
12 Admira Wacker II Admira 30 39 48 31
13 Würmla Würmla 30 37 75 25
14 Schwechat Schwechat 30 24 51 21
15 Fortuna 05 Fortuna 05 30 32 98 18
16 Rohrbach Rohrbach 30 20 104 8
TEMPORADA 2003/2004
TERCERA AUSTRIA GRUPO 2
Equipo PJ GF GC Puntos
1 Parndorf Parndorf 30 49 27 57
2 Waidhofen Waidhofen 30 50 37 50
3 First Vienna First Vienna 30 42 34 48
4 SKN St. Polten Polten 30 60 36 47
5 Austria Wien II Austria Wien 30 50 34 47
6 Kottingbrunn Kottingbrunn 30 41 28 46
7 Eisenstadt SC Eisenstadt 30 43 40 44
8 Rohrbach Rohrbach 30 46 47 44
9 Schwechat Schwechat 30 43 41 41
10 Kremser SC Kremser SC 30 42 51 41
11 Admira Wacker II Admira 30 49 40 38
12 Wiener SC Wiener SC 30 39 43 34
13 Fortuna 05 Fortuna 05 30 36 60 32
14 Neuberg Neuberg 30 40 66 30
15 Columbia Floridsdorf Columbia 30 38 64 29
16 Oberwart Oberwart 30 37 57 27
TEMPORADA 2002/2003
TERCERA AUSTRIA GRUPO 2
Equipo PJ GF GC Puntos
1 Schwechat Schwechat 30 64 23 69
2 FAC Wien FAC Wien 30 54 30 61
3 First Vienna First Vienna 30 66 46 51
4 Kremser SC Kremser SC 30 63 41 47
5 Waidhofen Waidhofen 30 49 40 47
6 Rohrbach Rohrbach 30 50 43 46
7 Eisenstadt SC Eisenstadt 30 44 33 44
8 Austria Wien II Austria Wien 30 37 36 42
9 Neuberg Neuberg 30 48 56 40
10 SKN St. Polten Polten 30 42 55 38
11 Oberwart Oberwart 30 41 46 37
12 Kottingbrunn Kottingbrunn 30 34 35 32
13 Stadlau Stadlau 30 42 46 31
14 Simmeringer SC Simmeringer 30 31 61 29
15 Klingenbach Klingenbach 30 30 56 25
16 Hundsheim Hundsheim 30 27 75 17
TEMPORADA 2001/2002
TERCERA AUSTRIA GRUPO 1
Equipo PJ GF GC Puntos
1 Wiener SC Wiener SC 30 50 31 62
2 FAC Wien FAC Wien 30 46 30 52
3 Kottingbrunn Kottingbrunn 30 43 25 49
4 Klingenbach Klingenbach 30 54 43 47
5 Schwechat Schwechat 30 43 34 47
6 Eisenstadt SC Eisenstadt 30 42 27 45
7 Waidhofen Waidhofen 30 43 37 45
8 Hundsheim Hundsheim 30 35 25 43
9 Neuberg Neuberg 30 43 39 41
10 Rohrbach Rohrbach 30 47 48 39
11 First Vienna First Vienna 30 40 43 37
12 Stadlau Stadlau 30 34 55 31
13 Austria Wien II Austria Wien 30 20 38 30
14 Kremser SC Kremser SC 30 37 46 29
15 Zwettl Zwettl 30 31 63 28
16 Baumgarten Baumgarten 30 31 55 25

  USO DE MEMORIA  
6,088,200 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.5749
Total Execution Time  0.5762
  CADENA URL  
/historico/Svr-Rohrbach
  GET DATOS  
$_GET['/historico/Svr-Rohrbach']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0294  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 = 73019
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=88126 AND type_rel = 2
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=584 AND type_rel = 3
0.0146  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 584 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0152  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 (809215,467932,467907,348427) ORDER BY n.cover_points DESC, update_date DESC
0.0149  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 = '88126' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0147  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 = 73019 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0151  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=88126 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0147  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 (73019) 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.0158  SELECT count(id) as num_players from rel_players WHERE league_id = 73019 AND teamId = 88126
0.0151  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2024` 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 = 73019 AND t.round = 24 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0146  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 = '88126' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0146  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '88126' and rp.type = 4
0.0147  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 = '88126' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0155  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 = 73019 WHERE rp.league_id = 73019 AND rp.teamId = 88126 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.0152  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 = 73019 WHERE rp.league_id = 73019 AND rp.teamId = 88126 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0150  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 = 73019 WHERE rp.league_id = 73019 AND rp.teamId = 88126 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0153  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 = 88126 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0151  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 `tables2024` 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 = 73019 AND t.round = 24 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154  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.0153  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.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 `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.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 `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.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 `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.0152  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.0154  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 `tables2005` 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 = 27584 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `tables2004` 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 = 27572 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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 `tables2003` 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 = 44522 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `tables2002` 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 = 27562 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 73019 ORDER BY nameShow LIMIT 100