SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts JOIN wp_realworks_wonen rw ON rw.wordpress_id = wp_posts.ID
WHERE 1=1 AND ((wp_posts.post_type = 'realworks_wonen' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled')))
ORDER BY rw.publicatiedatum DESC
LIMIT 0, 12