# "+1 -(2|4)" SELECT m0.post_id FROM search_match m0 LEFT JOIN search_match m1 ON m1.word_id = 2 AND m1.post_id = m0.post_id LEFT JOIN search_match m2 ON m2.word_id = 4 AND m2.post_id = m0.post_id WHERE m0.word_id = 1 AND (m1.word_id IS NULL OR m2.word_id IS NULL) GROUP BY m0.post_id