X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=Memories%2FSystemTag.pm;h=3a9fbbf1de72f6ee1d9d8f2ea272bddb6ddcfe5d;hb=01f2c0cb6a5be655072e5bdf519189b2305f9059;hp=cdb8e14169bb9d360f57977a3f92ccb86a994f50;hpb=3c50d5c471334d3753df8b553e9622be5096ed80;p=memories.git

diff --git a/Memories/SystemTag.pm b/Memories/SystemTag.pm
index cdb8e14..3a9fbbf 100644
--- a/Memories/SystemTag.pm
+++ b/Memories/SystemTag.pm
@@ -6,10 +6,9 @@ __PACKAGE__->table("system_tag");
 
 Memories::Photo->set_sql(sorted_by_system_tag => q/
 SELECT photo.id as id, title, uploader, uploaded, x, y
-FROM photo, system_tag, system_tagging
+FROM photo, system_tagging
 WHERE system_tagging.photo = photo.id
-    AND system_tagging.tag = system_tag.id
-    AND system_tag.id = ?
+    AND system_tagging.tag = ?
 ORDER BY photo.uploaded DESC
 /
 );