15

08

2023

Find and Delete Users from WooCommerce

Kategorisi : Wordpress

DELETE FROM b_users
WHERE
b_users.ID NOT IN (SELECT
meta_value
FROM
b_postmeta

WHERE
    meta_key = '_customer_user')
AND b_users.ID NOT IN (SELECT DISTINCT
    (post_author)
FROM
    b_posts) LIMIT 100

;
DELETE FROM b_usermeta
WHERE
b_usermeta.user_id NOT IN (SELECT
ID
FROM
b_users);

---