diff options
| -rw-r--r-- | src/database.rs | 7 |
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()) |