seems to be: fields:SELECT wp_posts.*
FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id)
WHERE 1=1 AND (
wp_term_relationships.term_taxonomy_id IN (9)
) AND ((wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled')))
GROUP BY wp_posts.ID
ORDER BY wp_posts.post_date DESC
/* From [www.shattucklabs.com/intranet-careers/] in [/nas/content/live/shattucklabs/wp-content/themes/shattuck/page-templates/careers-remote.php:55] */