DELETE FROM wp_usermeta WHERE meta_key = 'admin_color' AND user_id IN ( SELECT user_id FROM wp_usermeta WHERE meta_key = 'wp_capabilities' AND ( meta_value LIKE '%"subscriber"%' OR meta_value LIKE '%"customer"%' ) );
SELECT meta_key, COUNT(*) as count FROM wp2_usermeta GROUP BY meta_key ORDER BY count DESC;