DELETE um FROM wp_usermeta um LEFT JOIN wp_posts u ON wp.ID = um.user_id WHERE u.ID IS NULL
Delete orphaned user meta
This post brought to you by RocketGeek, ButlerBlog, and the following:
A curated collection of code snippets for WordPress
A curated collection of code snippets for WordPress
This post brought to you by RocketGeek, ButlerBlog, and the following:
DELETE um FROM wp_usermeta um LEFT JOIN wp_posts u ON wp.ID = um.user_id WHERE u.ID IS NULL