SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts WHERE 1=1 AND ((wp_posts.post_type = 'test' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled' OR wp_posts.post_status = 'booked_wc_awaiting'))) ORDER BY wp_posts.menu_order, wp_posts.post_date DESC LIMIT 0, 10

Test