WordPress: get all posts with no audio files attached

Created September 27, 2015 by Nirbhasa Magee

Useful SQL query for wordpress:

SELECT p.post_title, p.guid FROM wp_posts p WHERE p.post_type = 'post' AND NOT EXISTS (SELECT * FROM wp_posts a WHERE p.ID = a.post_parent AND a.post_mime_type LIKE '%audio%');