Pickupp coupon code track

set @startdate1 = date_sub(CURDATE(), interval 20 day);
set @startdate2 = date_add(CURDATE(), interval 20 day);
use socar_malaysia;
select
distinct r.id as rid2, r.member_id as mid, z.region, z.city, cc.car_name,IFNULL(co.comment,"") as coupon,co.promo_code_id as pcid,
round(sum(timestampdiff(minute, r.start_at, r.end_at)/60),2) as dur,
round(sum(floor(timestampdiff(minute, r.start_at, r.end_at)/60/24)*12+if(mod(timestampdiff(hour, r.start_at, r.end_at),24)>=12,12,mod(timestampdiff(minute, r.start_at, r.end_at)/60,24))),2) as ad_sdur,
IFNULL(sum(ra.mileage),0) as distance,
Date(r.return_at + interval '8' hour) as return_Date,
hour(r.created_at + interval '8' hour) as created_hour,
Date(r.start_at + interval '8' hour) as start_Date,
hour(r.start_at + interval '8' hour) as resv_hour,
hour(r.occupy_start_at + interval '8' hour) as occupy_start_hour,
(YEAR(r.start_at) - YEAR(m.birthday)) as age
from reservations r left join members m on r.member_id = m.id
left join zones z on z.id = r.start_zone_id
left join cars cr on cr.id = r.car_id
left join car_classes cc on cc.id = cr.car_class_id
left join coupons co on co.reservation_id = r.id
left join reservation_appendixes ra on ra.reservation_id = r.id
where r.state in ('completed')
and r.return_at + interval 8 hour >= @startdate1
and r.return_at + interval 8 hour <= @startdate2
and m.imaginary in ('sofam', 'normal')
and r.member_id not in ('125', '127')
and (YEAR(r.start_at) - YEAR(m.birthday)) < 100
and r.member_id in ('653489', '424523','653497','165831','653488','653633')
group by rid2