Scott Cariss

SELECT `ID`
FROM (

SELECT `wp_posts`.`ID` , MAX(
CASE WHEN `wp_postmeta`.`meta_key` = 'property_region'
THEN `wp_postmeta`.`meta_value`
END ) AS `property_region` , MAX(
CASE WHEN `wp_postmeta`.`meta_key` = 'property_bedrooms'
THEN `wp_postmeta`.`meta_value`
END ) AS `property_bedrooms`
FROM `wp_posts`
LEFT JOIN `wp_postmeta` ON ( `wp_posts`.`ID` = `wp_postmeta`.`post_id` )
WHERE `wp_posts`.`post_status` = 'publish'
AND `wp_posts`.`post_type` = 'property'
GROUP BY `wp_posts`.`ID`
ORDER BY `wp_posts`.`post_date` DESC
) AS `t`
WHERE 1 =1
AND `t`.`property_region` = 'england-east'
AND `t`.`property_bedrooms` = '4'