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
/
);