]> git.ipfire.org Git - people/shoehn/ipfire.org.git/blobdiff - webapp/backend/fireinfo.py
fireinfo: Fix language map
[people/shoehn/ipfire.org.git] / 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)