get a list of stories that are between a certain date range, and that are in a certain list of categories

stories-by-category-and-date.sql

SELECT ID, post_date, post_title
FROM wp_posts p
INNER JOIN wp_postmeta m ON p.ID = m.post_id
LEFT JOIN wp_term_relationships r ON (p.ID = r.object_id)
LEFT JOIN wp_term_taxonomy tax ON (r.term_taxonomy_id = tax.term_taxonomy_id)
WHERE post_date >= '2019-06-01' AND post_date < '2020-06-01' AND post_status = 'publish' AND tax.term_id IN (72513, 72511, 72514, 3003, 55565, 55831, 55634, 8389)
GROUP BY p.ID
ORDER BY post_date DESC
;