4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Mils
TEMPORADA 2022/2023
CUARTA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 Völs Völs 29 67 38 52
2 Innsbrucker AC Innsbrucker 29 71 46 52
3 Volders Volders 29 66 50 52
4 Ebbs Ebbs 29 58 45 50
5 SK St. Johann Johann 29 66 54 48
6 Kematen Kematen 29 56 46 48
7 Wacker Innsbruck Wacker 29 47 42 45
8 Mils Mils 29 72 72 43
9 SPG Sprutz / Serfaus Sprutz 29 59 56 41
10 Oberperfuss Oberperfuss 29 56 62 38
11 Mayrhofen Mayrhofen 29 69 67 36
12 Union Innsbruck Union 29 59 82 34
13 Natters Natters 29 50 61 32
14 SC Münster SC Münster 29 39 61 30
15 Kirchbichl Kirchbichl 29 47 64 27
16 SV Innsbruck Innsbruck 29 30 66 22
TEMPORADA 2021/2022
CUARTA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 Kundl Kundl 30 58 34 63
2 Mötz / Silz Mötz Silz 30 85 41 62
3 Mils Mils 30 89 48 57
4 Kematen Kematen 30 66 43 56
5 Innsbrucker AC Innsbrucker 30 72 43 52
6 Völs Völs 30 54 35 52
7 Ebbs Ebbs 30 57 40 51
8 SPG Sprutz / Serfaus Sprutz 30 53 49 44
9 Union Innsbruck Union 29 60 66 41
10 SC Münster SC Münster 30 58 56 40
11 SK St. Johann Johann 30 47 49 37
12 Kirchbichl Kirchbichl 30 42 54 37
13 Natters Natters 30 44 61 35
14 Volders Volders 30 38 54 32
15 Zirl Zirl 29 18 100 14
16 Zams Zams 30 14 82 5
TEMPORADA 2020/2021
CUARTA AUSTRIA GRUPO 2
Equipo PJ GF GC Puntos
1 Fügen Fügen 15 43 21 34
2 SV Innsbruck Innsbruck 15 38 23 34
3 Mötz / Silz Mötz Silz 15 42 21 32
4 Kundl Kundl 15 29 17 28
5 Volders Volders 15 34 27 26
6 SK St. Johann Johann 15 30 27 23
7 Mils Mils 15 41 36 21
8 Völs Völs 15 26 25 21
9 Natters Natters 14 32 28 20
10 Ebbs Ebbs 14 27 20 19
11 Kematen Kematen 15 26 36 19
12 Kirchbichl Kirchbichl 15 36 41 17
13 Zams Zams 15 25 41 15
14 Zirl Zirl 15 14 21 13
15 Union Innsbruck Union 14 19 37 8
16 FC Söll FC Söll 14 12 53 4
TEMPORADA 2019/2020
CUARTA AUSTRIA GRUPO 7
Equipo PJ GF GC Puntos
1 SV Innsbruck Innsbruck 15 41 20 37
2 Fügen Fügen 15 37 24 30
3 Swarovski Tirol II Swarovski 15 41 18 29
4 Kirchbichl Kirchbichl 15 36 23 29
5 Mötz / Silz Mötz Silz 15 35 22 26
6 Kematen Kematen 15 39 28 25
7 Kundl Kundl 15 38 26 23
8 Ebbs Ebbs 15 31 21 23
9 Volders Volders 15 24 30 19
10 Natters Natters 15 27 29 18
11 Mils Mils 15 28 36 18
12 Völs Völs 15 22 32 16
13 Zams Zams 15 21 41 15
14 SK St. Johann Johann 15 22 29 14
15 FC Söll FC Söll 15 12 40 7
16 Union Innsbruck Union 15 18 53 7

  USO DE MEMORIA  
5,074,504 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0719
Total Execution Time  0.0731
  CADENA URL  
/historico/Sc-Mils
  GET DATOS  
$_GET['/historico/Sc-Mils']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=110158 AND type_rel = 2
0.0023  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 = '110158' ORDER BY l.year DESC,cat.coefficient DESC
0.0020  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 = '110158' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = '110158' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021  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=110158 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018  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,68326) 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.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 68326 AND teamId = 110158
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 110158
0.0020  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 = '110158' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '110158' and rp.type = 4
0.0020  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 = '110158' 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 = 110158 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 = 110158 AND (e.action = 4 or e.action = 5) 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 = 110158 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023  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 = 110158 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 68326 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.0026  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 = 63464 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.0029  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 = 57778 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.0029  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 = 50453 AND t.round = 15 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC