Archive for September, 2015
-
WordPress: get all posts with no audio files attached
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%’);
Read more »