Memories::Photo->set_sql(sorted_by_tag => q/
SELECT photo.id as id, title, uploader, uploaded, x, y
-FROM photo, tag, tagging
+FROM photo, tagging
WHERE tagging.photo = photo.id
- AND tagging.tag = tag.id
- AND tag.id = ?
+ AND tagging.tag = ?
ORDER BY photo.uploaded DESC
/
);