Skip to content

Instantly share code, notes, and snippets.

@techskilled

techskilled/Deleteusers.sql

Created August 22, 2016 16:12
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 techskilled/310d97df00e3e24764ecd666b5923d67 to your computer and use it in GitHub Desktop.
Save techskilled/310d97df00e3e24764ecd666b5923d67 to your computer and use it in GitHub Desktop.
Download ZIP
WooCommerce SQL to delete users who have no orders or posts
Raw
Deleteusers.sql
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