select group_concat(a_id) as voucher_ids from ( select a.voucher_id as a_id, b.voucher_id as b_id from voucher_campaign_issue a left join voucher_action b on (b.action_id = 6 and a.voucher_id = b.voucher_id and b.action_time between '2016-12-01' and '2017-12-01') where a.issue_date between '2016-12-01' and '2017-12-01' having b.voucher_id is NULL ) x