]> git.ipfire.org Git - ipfire.org.git/commitdiff
fireinfo: Fix language map
authorMichael Tremer <michael.tremer@ipfire.org>
Wed, 18 Mar 2015 01:03:08 +0000 (02:03 +0100)
committerMichael Tremer <michael.tremer@ipfire.org>
Wed, 18 Mar 2015 01:03:08 +0000 (02:03 +0100)
webapp/backend/fireinfo.py

index 6c5b317785285fbdb65f533a706519797244e5f9..beeced8a474c98a6103d3ed4901940bedc917061 100644 (file)
@@ -1668,7 +1668,7 @@ class Fireinfo(Object):
                return ((r.location, r.count) for r in res)
 
        def get_language_map(self, when=None):
-               res = self.db.query("WITH profiles AS (SELECT fireinfo_profiles_at(%s) AS id) \
+               res = self.db.query("WITH profiles AS (SELECT fireinfo_profiles_with_data_at(%s) AS id) \
                        SELECT language, COUNT(language)::float / (SELECT COUNT(*) FROM profiles) AS count FROM profiles \
                        LEFT JOIN fireinfo_profiles_languages ON profiles.id = fireinfo_profiles_languages.profile_id \
                        WHERE fireinfo_profiles_languages.language IS NOT NULL GROUP BY language ORDER BY count DESC", when)