active-subscriber-ids.sql

active-subscribers.sql

/*
 * MySQL query to run site running WooCommerce Subscriptions.
 * Selects all user ids for customers with an active subscriptions.
 */
select
	meta.meta_value as user_id
from
	wp_qftw_posts posts
	left join wp_qftw_postmeta meta ON meta.post_ID = posts.ID
where
	posts.post_type = 'shop_subscription'
	and posts.post_status = 'wc-active'
	and meta.meta_key = '_customer_user';