butlerblog
8/25/2017 - 7:35 PM

Delete all orphans user meta in WordPress

Delete all orphans user meta in WordPress

DELETE FROM wp_usermeta
WHERE NOT EXISTS (
  SELECT * FROM wp_users
	WHERE wp_usermeta.user_id = wp_users.ID
)