Bronze After Registration – WordPress Site

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';