All pastes #81811 Raw Edit

naderman

public text v1 · immutable
·published 2006-07-07 22:06 UTC
rendered paste body
# "+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