Skip to content

Instantly share code, notes, and snippets.

@mikejolley
Created April 26, 2016 09:37
Show Gist options
  • Save mikejolley/34a32fbda7ccb8029a19ab1e1d2b1dbc to your computer and use it in GitHub Desktop.
Save mikejolley/34a32fbda7ccb8029a19ab1e1d2b1dbc to your computer and use it in GitHub Desktop.
WooCommerce - SQL to Delete users with no orders or posts
DELETE from wp_users where wp_users.ID not in (
SELECT meta_value FROM wp_postmeta WHERE meta_key = '_customer_user'
) AND wp_users.ID not in (
select distinct(post_author) from wp_posts
);
delete from wp_usermeta where wp_usermeta.user_id not in (select ID from wp_users);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment