SELECT DISTINCT p.ID FROM wp669cf8posts p, wp669cf8postmeta pmFacility WHERE p.post_status = 'publish' AND post_type = 'room' AND col_f = 1 AND pmFacility.post_id = p.ID AND (pmFacility.meta_value LIKE '%:530;%' OR pmFacility.meta_value LIKE '%:"530";%' OR pmFacility.meta_value = 530) AND (pmFacility.meta_key = 'facility' OR pmFacility.meta_key = 'facilityWP')
