Query Not working Checklo

select
distinct m.id as memberid,
co.comment as comment,
sum(p.amount) as amount,
date(r.occupy_start_at + interval '8' hour) as day,
timestampdiff(minute,r.start_at, r.end_at)/60 as ridelength,
TIMESTAMPDIFF(minute,r.start_at + interval '8' hour,r.end_at + interval '8' hour) as ridelengthinminutes,
weekday(r.occupy_start_at + interval '8' hour) as startingday,
hour(r.occupy_start_at + interval '8' hour) as startingtime,
r.state as state,
r.car_id as carid

from members m

left outer join reservations r
on m.id = r.member_id

left outer join payments p
on p.reservation_id = r.id

left outer join coupons co
on co.member_id = m.id

where CONVERT_TZ(r.start_at, '+00:00', '+8:00') >= '2019-3-1 00:00'
and CONVERT_TZ(r.start_at, '+00:00', '+8:00') < '2019-5-1'
and m.imaginary = 'normal'
and m.state = 'normal'
and r.state IN ('completed','inuse','reserved')
and p.state = 'normal'
and p.paid_type = 'card'

group by m.id,r.id
order by amount desc