WHERE wpstbys_posts.post_type = 'estates' AND wpstbys_posts.post_status = 'publish' AND EXISTS (
SELECT 1 FROM wpstbys_postmeta pm1
WHERE pm1.post_id = wpstbys_posts.ID
AND pm1.meta_key = 'displaystatusid'
AND pm1.meta_value = '2'
) AND EXISTS (
SELECT 1 FROM wpstbys_postmeta pm6
WHERE pm6.post_id = wpstbys_posts.ID
AND pm6.meta_key = 'canhavechildren'
AND pm6.meta_value = '1'
) AND EXISTS (
SELECT 1 FROM wpstbys_term_relationships tr
INNER JOIN wpstbys_term_taxonomy tt ON tr.term_taxonomy_id = tt.term_taxonomy_id
INNER JOIN wpstbys_terms t ON tt.term_id = t.term_id
WHERE tr.object_id = wpstbys_posts.ID
AND tt.taxonomy = 'estate_status'
AND t.slug IN ('te-koop_nl')
)
By submitting this form, I agree that Sotheby's can contact me and I accept the Sotheby's privacy policy.