Skip to content

Instantly share code, notes, and snippets.

@hamedmoody

hamedmoody/delete-orphans-usermeta.sql

Last active November 10, 2017 17:06
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 hamedmoody/a438b329bf5349f0225465a28766cedf to your computer and use it in GitHub Desktop.
Save hamedmoody/a438b329bf5349f0225465a28766cedf to your computer and use it in GitHub Desktop.
Download ZIP
Delete all orphans user meta in WordPress Raw
Raw
delete-orphans-usermeta.sql
DELETE FROM wp_usermeta
WHERE NOT EXISTS (
SELECT * FROM wp_users
WHERE wp_usermeta.user_id = wp_users.ID
)
DELETE FROM wp_postmeta
WHERE NOT EXISTS (
SELECT * FROM wp_posts
WHERE wp_postmeta.post_id = wp_posts.ID
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment