Delete all orphans user meta in WordPress

delete-orphans-usermeta.sql

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

Thanks, this is very useful

@nuklearwintr you're welcome

Excellent! It works with almost any WP version. Very thanks!

Thanks very much. Easy but get rid of 6000 rows of spam users. Works on 4.7.3.

Excellent

Thanks - helped me get rid of 900k rows of usermeta after removing customers from a Woocommerce site for export 👍

This is very useful. Thank you @carlosleopoldo

It was Great! worked for me.

Bravo!

Found a shorter one:

DELETE FROM wp_usermeta WHERE user_id NOT IN (SELECT ID FROM wp_users);

Deleted my admin user for some reason. Dev site so I'm safe.

nice