SELECT * FROM tags LEFT JOIN interests ON tags.id = interests.tag_id AND interests.user_id = 1 WHERE interests.tag_id IS NULL AND tags.category_id = 3
Pastie
Support Pastie
or read my
Pastie << self
blog
SELECT * FROM tags LEFT JOIN interests ON tags.id = interests.tag_id AND interests.user_id = 1 WHERE interests.tag_id IS NULL AND tags.category_id = 3
