Payment Failed - Grabp - Less than 30 Mins - Rahil and Shiva

select
rid,
Date(start_Date) date,
state,
mid,
Date((select min(created_at)+interval 8 hour from reservations where state = 'completed' and mid =member_id and convert_tz(created_at, '+00:00', '+8:00') between start_Date and date_add(start_Date, interval 30 minute))) as came_back
from (
select
distinct r.id as rid, r.member_id as mid, r.state as state, p.paid_type as type, pm.provider as provider,
Date(r.created_at + interval '8' hour) as start_Date, p.paygate as provider_2
from reservations r left join members m on r.member_id = m.id
LEFT JOIN payment_methods pm ON r.payment_method_id = pm.id
left join payments p on p.reservation_id = r.id
where r.created_at + interval 8 hour >= @startdate1
and r.created_at + interval 8 hour <= @startdate2
and r.member_id not in ('125', '127')
and m.imaginary in ('sofam', 'normal')
and r.state in ('fail')
and pm.provider in ('grabpay')
group by rid, type) temp