Skip to content

Instantly share code, notes, and snippets.

@avillegasn

avillegasn/detect-unused-images.sql

Last active September 23, 2019 12:58
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save avillegasn/c89720b210e98d949fe27128ffdb58f4 to your computer and use it in GitHub Desktop.
Save avillegasn/c89720b210e98d949fe27128ffdb58f4 to your computer and use it in GitHub Desktop.
Download ZIP
Detect and remove unused images in WordPress
Raw
detect-unused-images.sql
SELECT
*
FROM
wp_posts i
WHERE
i.post_type = 'attachment'
AND
NOT EXISTS (SELECT * FROM wp_posts p WHERE p.ID = i.post_parent)
AND
NOT EXISTS (SELECT * FROM wp_postmeta pm WHERE pm.meta_key = '_thumbnail_id' AND pm.meta_value = i.ID)
AND
NOT EXISTS (SELECT * FROM wp_posts p WHERE p.post_type <> 'attachment' AND p.post_content LIKE CONCAT('%',i.guid,'%'))
AND
NOT EXISTS (SELECT * FROM wp_postmeta pm WHERE pm.meta_value LIKE CONCAT('%',i.guid,'%'))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment