tagliatelle

commit 7bdc6df1ac1c8f20265892d834ed0a4db2d637e4
parent 7cc254b81cc47800d375fdcfa034112cf5ca30b3
Author: breadcat <breadcat@users.noreply.github.com>
Date:   Mon, 23 Mar 2026 14:46:56 +0000

Stop stale properties being visible in menus

Diffstat:
M
include-properties.go
 | 
9
+++++----

1 file changed, 5 insertions(+), 4 deletions(-)
diff --git a/include-properties.go b/include-properties.go
@@ -154,10 +154,11 @@ func computeMissingProperties() (int, error) {
 
 func getPropertyNav() (map[string][]PropertyDisplay, error) {
 	rows, err := db.Query(`
-		SELECT key, value, COUNT(*) as cnt
-		FROM file_properties
-		GROUP BY key, value
-		ORDER BY key, value
+		SELECT fp.key, fp.value, COUNT(*) as cnt
+		FROM file_properties fp
+		JOIN files f ON f.id = fp.file_id
+		GROUP BY fp.key, fp.value
+		ORDER BY fp.key, fp.value
 	`)
 	if err != nil {
 		return nil, err