Retention chart - With coupon Vs Non Coupon Bookings

select
A.memberid as memberid,
A.MFT_rid,
IFnull(B.coupon,0) as coupon_used,
Date(A.MFTDate) as MFTdate,
date(A.lastactivedate) as lastactivedate
from
(select
distinct m.id as memberid,
min(r.id) as MFT_rid,
min(r.return_at + interval 8 hour) as MFTdate,
Max(r.return_at + interval 8 hour ) as lastactivedate
from  members m
left join reservations r on m.id = r.member_id
Where r.id != 0
and m.imaginary in ('sofam', 'normal')
and r.state = 'completed'
group by m.id) A
left join
(select
r.id as rid,
c.comment as coupon
from reservations r
left outer join coupons c on c.reservation_id = r.id
group by r.id) B
on A.MFT_rid = B.rid