Browse Care Homes

SELECT SQL_CALC_FOUND_ROWS wp_posts.*, ( 3959 * acos( cos(radians(54.5705497)) * cos(radians(CAST(lat_meta.meta_value AS DECIMAL(10,6)))) * cos(radians(CAST(lng_meta.meta_value AS DECIMAL(10,6))) - radians(-1.2148674)) + sin(radians(54.5705497)) * sin(radians(CAST(lat_meta.meta_value AS DECIMAL(10,6)))) ) ) AS distance FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) LEFT JOIN wp_postmeta AS lat_meta ON (wp_posts.ID = lat_meta.post_id AND lat_meta.meta_key = '_latitude') LEFT JOIN wp_postmeta AS lng_meta ON (wp_posts.ID = lng_meta.post_id AND lng_meta.meta_key = '_longitude') LEFT JOIN wp_postmeta AS pack_meta ON (wp_posts.ID = pack_meta.post_id AND pack_meta.meta_key = '_package_id') LEFT JOIN wp_posts AS product ON pack_meta.meta_value = product.ID WHERE 1=1 AND ( ( wp_postmeta.meta_key = '_case27_listing_type' AND wp_postmeta.meta_value = 'care-home' ) ) AND ((wp_posts.post_type = 'job_listing' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled' OR wp_posts.post_status = 'case27_full'))) AND ( lat_meta.meta_value IS NOT NULL AND lng_meta.meta_value IS NOT NULL AND ( 3959 * acos( cos(radians(54.5705497)) * cos(radians(CAST(lat_meta.meta_value AS DECIMAL(10,6)))) * cos(radians(CAST(lng_meta.meta_value AS DECIMAL(10,6))) - radians(-1.2148674)) + sin(radians(54.5705497)) * sin(radians(CAST(lat_meta.meta_value AS DECIMAL(10,6)))) ) ) <= 10 ) GROUP BY wp_posts.ID ORDER BY ( 3959 * acos( cos(radians(54.5705497)) * cos(radians(CAST(lat_meta.meta_value AS DECIMAL(10,6)))) * cos(radians(CAST(lng_meta.meta_value AS DECIMAL(10,6))) - radians(-1.2148674)) + sin(radians(54.5705497)) * sin(radians(CAST(lat_meta.meta_value AS DECIMAL(10,6)))) ) ) ASC, FIELD( product.post_name, 'free', 'monthly-subscription', 'premium' ) ASC LIMIT 100, 20