DELETE um FROM wp_usermeta um LEFT JOIN wp_users u ON u.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_users u ON u.ID = um.user_id WHERE u.ID IS NULL