subscribers-not-stripe-customers.sql

SELECT * FROM wp_users 
	LEFT JOIN wp_usermeta as stripe_meta on stripe_meta.user_id = wp_users.ID && stripe_meta.meta_key = 'stripe_customer_id'
	LEFT JOIN wp_usermeta as role_meta on role_meta.user_id = wp_users.ID && role_meta.meta_key = 'wp_capabilities'
WHERE 
	1=1
	AND stripe_meta.meta_value IS NULL
	AND role_meta.meta_value LIKE '%subscriber%'