Career Search

string(1659) " SELECT SQL_CALC_FOUND_ROWS wp_posts.*, IFNULL( ( 6371 * acos( cos( radians(40.6548253) ) * cos( radians( locations.lat ) ) * cos( radians( locations.lng ) - radians(-73.6717969) ) + sin( radians(40.6548253) ) * sin( radians( locations.lat ) ) ) ), 99999) AS distance, meta_city.meta_value as city_name , meta_state.meta_value as state_name , meta_zip.meta_value as zip_code FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_postmeta meta_zip ON ( meta_zip.post_id = wp_posts.ID and meta_zip.meta_key = 'business_zip' ) INNER JOIN wp_postmeta meta_state ON ( meta_state.post_id = wp_posts.ID and meta_state.meta_key = 'business_state' ) INNER JOIN wp_career_locations locations ON ( locations.zip = meta_zip.meta_value AND locations.state = meta_state.meta_value ) INNER JOIN wp_postmeta meta_city ON ( meta_city.post_id = wp_posts.ID AND meta_city.meta_key = 'business_city' ) LEFT JOIN wp_postmeta meta_date ON ( meta_date.post_id = wp_posts.ID AND meta_date.meta_key = 'created_date' ) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (41) ) AND ( wp_postmeta.meta_key = 'created_date' ) AND ((wp_posts.post_type = 'careers' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled'))) GROUP BY wp_posts.ID HAVING (distance < 48 OR (city_name = "Lynbrook" AND state_name = "NY") ) ORDER BY distance ASC, meta_date.meta_value DESC, CASE WHEN city_name = "Lynbrook" THEN 0 ELSE 1 END LIMIT 9, 9 "

Lynbrook, NY USA Atria Senior Living