SELECT s.id, s.subscr_id, user_id FROM wp_mepr_subscriptions AS s WHERE id IN ( SELECT subscription_id FROM wp_mepr_transactions WHERE coupon_id = 430 AND subscription_id > 0 ) AND s.status = 'cancelled';

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top