Enjoy ! 😄
Download iTerm2 here.
DELETE FROM wp_usermeta WHERE NOT EXISTS ( | |
SELECT * FROM wp_users | |
WHERE wp_usermeta.user_id = wp_users.ID | |
) |
DELETE wp_users, wp_usermeta FROM wp_users | |
INNER JOIN wp_usermeta ON wp_users.ID = wp_usermeta.user_id | |
WHERE meta_key = 'wp_capabilities' AND meta_value LIKE '%subscriber%'; |
Enjoy ! 😄
Download iTerm2 here.