SELECT submission.id AS submission_id, submission.image_metadata_id AS submission_image_metadata_id, submission.title AS submission_title, submission.description AS submission_description, submission.description_parsed AS submission_description_parsed, submission.type AS submission_type, submission.discussion_id AS submission_discussion_id, submission.time AS submission_time, submission.status AS submission_status, submission.editlog_id AS submission_editlog_idFROM submission INNER JOIN submission_tag AS submission_tag_1 ON submission.id = submission_tag_1.submission_id AND submission_tag_1.tag_id = %s LEFT OUTER JOIN submission_tag AS submission_tag_2 ON submission.id = submission_tag_2.submission_id AND submission_tag_2.tag_id = %sWHERE submission_tag_2.tag_id IS NULL ORDER BY submission.id