Fix `tags_for_image`.

The function wasn't filtering for the given `image_id`.

1 files changed, 3 insertions, 4 deletions

diff --git a/src/database.rs b/src/database.rs
index 54f511f..b83fc9b 100644
--- a/src/database.rs
+++ b/src/database.rs
@@ -170,11 +170,10 @@ impl TagDatabase {
         Ok(self
             .0
             .prepare(
-                "SELECT tags.name, COUNT(mapping.tag) as tag_count
+                "SELECT tags.name
                  FROM mapping
-                 INNER JOIN images ON images.id = ?
-                 INNER JOIN tags
-                 GROUP BY tags.name;",
+                 INNER JOIN tags ON mapping.tag = tags.id
+                 WHERE mapping.image = ?;",
             )?
             .query_map(params![image_id], |row| row.get(0))?
             .filter_map(|tag| tag.ok())