Skip to content

Instantly share code, notes, and snippets.

@markbain

markbain/no-thumb

Created March 18, 2015 15:22
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save markbain/dc3e2af56f4852afe620 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save markbain/dc3e2af56f4852afe620 to your computer and use it in GitHub Desktop.
Download ZIP
Finds WP posts without featured
Raw
no-thumb
SELECT DISTINCT(p.ID), p.post_title, p.post_content FROM `wp_posts` p
LEFT JOIN wp_posts im ON p.ID = im.post_parent AND im.post_type = "attachment"
WHERE p.post_status ='publish'
AND p.post_type = "post"
AND im.ID IS NULL
AND p.post_content NOT REGEXP 'src=".*"'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment