Query 1:
Select distinct c0.sub_id
from subscriber_preferences as c0
inner join subscriber_preferences as c1 ON c0.sub_id=c1.sub_id
inner join subscriber_preferences as c2 ON c0.sub_id=c2.sub_id
inner join subscriber_preferences as c3 ON c0.sub_id=c3.sub_id
Where c0.site_id='154d661bcd0731701910881e5d387007' AND c1.site_id='154d661bcd0731701910881e5d387007'
AND c2.site_id='154d661bcd0731701910881e5d387007' AND c3.site_id='154d661bcd0731701910881e5d387007'
and (c1.attribute_id='5644' and c1.value='0')
and (c2.attribute_id='6084' and c2.value='0')
and (c3.attribute_id='6106' and c3.value='0');
Query 2:
SELECT sub_id FROM subscriber_preferences WHERE site_id = '154d661bcd0731701910881e5d387007' AND ((attribute_id = 5644 AND value = 0) OR (attribute_id= 6084 AND value = 0) OR (attribute_id = 6106 AND value = 0)) GROUP BY sub_id;