4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del St. Margarethen
TEMPORADA 2013/2014
CUARTA AUSTRIA GRUPO 2
Equipo PJ GF GC Puntos
1 Parndorf II Parndorf II 30 52 23 67
2 Neusiedl Neusiedl 30 67 42 54
3 Marz Marz 30 58 45 53
4 St. Georgen St. Georgen 30 46 37 49
5 Horitschon Horitschon 30 44 39 47
6 Klingenbach Klingenbach 30 46 40 45
7 Drassburg Drassburg 30 76 59 44
8 Purbach Purbach 30 50 38 44
9 Baumgarten Baumgarten 30 47 54 38
10 St. Margarethen Margarethen 30 45 56 37
11 Jennersdorf Jennersdorf 30 52 48 36
12 Pinkafeld Pinkafeld 30 52 68 36
13 Forchtenstein Forchtenstei 30 66 81 35
14 Stinatz Stinatz 30 29 50 33
15 Güssing Güssing 30 30 57 27
16 Sigleß Sigleß 30 38 61 24
TEMPORADA 2012/2013
CUARTA AUSTRIA GRUPO 4
Equipo PJ GF GC Puntos
1 Neuberg Neuberg 30 75 27 76
2 Purbach Purbach 30 59 40 53
3 Stinatz Stinatz 30 49 41 51
4 Horitschon Horitschon 30 52 40 49
5 Marz Marz 30 74 43 48
6 Drassburg Drassburg 30 76 57 47
7 Jennersdorf Jennersdorf 30 48 36 47
8 Neusiedl Neusiedl 30 48 38 47
9 Klingenbach Klingenbach 30 43 38 46
10 St. Margarethen Margarethen 30 49 49 45
11 Parndorf II Parndorf II 30 45 46 45
12 Baumgarten Baumgarten 30 55 51 41
13 Güssing Güssing 30 46 40 38
14 Sigleß Sigleß 30 39 50 27
15 Winden Winden 30 28 85 12
16 SC Buchschachen Buchschachen 30 24 129 9
TEMPORADA 2011/2012
CUARTA AUSTRIA GRUPO 4
Equipo PJ GF GC Puntos
1 Oberwart Oberwart 30 66 29 69
2 Neuberg Neuberg 30 78 37 59
3 Marz Marz 30 69 50 55
4 Baumgarten Baumgarten 30 71 46 53
5 Drassburg Drassburg 30 59 54 53
6 Horitschon Horitschon 30 65 50 51
7 Jennersdorf Jennersdorf 30 66 54 51
8 St. Margarethen Margarethen 30 50 46 42
9 Klingenbach Klingenbach 30 46 40 40
10 Parndorf II Parndorf II 30 52 65 37
11 Stinatz Stinatz 30 45 49 36
12 Güssing Güssing 30 43 57 33
13 Winden Winden 30 47 74 30
14 Kohfidisch Kohfidisch 30 34 62 24
15 SC Oberpullendorf Oberpullendo 30 30 68 22
16 USC Wallern USC Wallern 30 36 76 16
TEMPORADA 2008/2009
CUARTA AUSTRIA GRUPO 6
Equipo PJ GF GC Puntos
1 Baumgarten Baumgarten 30 74 25 61
2 Parndorf II Parndorf II 30 40 20 59
3 Oberwart Oberwart 30 50 30 55
4 Kohfidisch Kohfidisch 30 46 27 50
5 SC Oberpullendorf Oberpullendo 30 48 35 48
6 Güssing Güssing 30 42 37 46
7 Purbach Purbach 30 27 26 45
8 SC Neudörfl Neudörfl 30 42 43 44
9 Forchtenstein Forchtenstei 30 45 46 42
10 SV Schattendorf Schattendorf 30 35 43 36
11 Neuberg Neuberg 30 38 49 36
12 Horitschon Horitschon 30 40 49 35
13 Klingenbach Klingenbach 30 43 53 33
14 Jennersdorf Jennersdorf 30 42 65 26
15 St. Margarethen Margarethen 30 30 53 25
16 Tadten Tadten 30 19 60 20

  USO DE MEMORIA  
5,218,304 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.3252
Total Execution Time  0.3264
  CADENA URL  
/historico/St-Margarethen/2014
  GET DATOS  
$_GET['/historico/St-Margarethen/2014']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17534 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=584 AND type_rel = 3
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 = '17534' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0129  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=17534 AND l.year in (2013,2014,2015) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (27170,3804) 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.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 27170 AND teamId = 17534
0.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 3804 AND teamId = 17534
0.0126  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 = '17534' 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 = '17534' 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 = '17534' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0134  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 events2014 e ON e.player_id = p.id AND e.league_id = 3584 WHERE rp.league_id = 3584 AND rp.teamId = 17534 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.0134  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 events2014 e ON e.player_id = p.id AND e.league_id = 3584 WHERE rp.league_id = 3584 AND rp.teamId = 17534 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0138  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 events2014 e ON e.player_id = p.id AND e.league_id = 3584 WHERE rp.league_id = 3584 AND rp.teamId = 17534 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 = 17534 AND l.year <= 2014 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 = 3584 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 `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 = 27170 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 `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 = 27204 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 `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 = 27267 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC