/nas/content/live/sunc/community_amenities_export.csvSELECT DISTINCT wp_posts.ID, wp_postmeta.meta_value as code FROM wp_posts, wp_postmeta WHERE meta_key = 'sun_community_code' AND wp_posts.ID = wp_postmeta.post_id AND wp_posts.post_status = 'publish'