JOIN optimization.

[memories.git] / Memories / SystemTag.pm

diff --git a/Memories/SystemTag.pm b/Memories/SystemTag.pm
index cdb8e14169bb9d360f57977a3f92ccb86a994f50..3a9fbbf1de72f6ee1d9d8f2ea272bddb6ddcfe5d 100644 (file)
--- 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
 /
 );