3 ms·

select * from photos p inner join tags t where t.tag in('you','your wife','boat') and not in('toaster')