MySQL support is not available in this PHP configuration
SELECT DISTINCT resources.resource_id FROM resources INNER JOIN resources_subjects as r_s1 ON resources.resource_id = r_s1.resource_id WHERE ( (title LIKE '%snug harbor%' OR subtitle LIKE '%snug harbor%') AND r_s1.borough = 'Staten Island' ) AND (type = 'Designation Report')