SELECT b.voucher_value, CONCAT(b.prefix, b.voucher_no) AS voucher_no, c.channel_description, b.issue_time, b.expiry_time, d.status_description FROM voucher_action a, voucher b, voucher_lkup_channel c, voucher_lkup_status d WHERE action_time BETWEEN '2016-01-01 00:00:00' AND '2017-01-01 00:00:00' AND action_id = 6 AND a.voucher_id = b.voucher_id AND b.transfer_channel = c.channel_id AND b.status_id = d.status_id