One way trip - Retention Cohort - Time Diff BTW Reser - 29/7

set @startdate1 = '2019-01-01';
select
B.mid as memberid,A.age as age,P.rid as rid, P.way as way, P.zone_name,P.reservationdate as res_date,Date(A.MFTDate) as MFTdate,date(A.lastactivedate) as lastactivedate
from
(select
m.id as mid,
r.id as rid,
r.way as way,
z.name as zone_name,
Date(r.start_at + interval '8' hour) as reservationdate
from  members m
left outer join reservations r on m.id = r.member_id
join zones z on r.start_zone_id = z.id
Where r.start_at != 0
and m.imaginary = 'normal'
and r.state = 'completed'
group by m.id,r.id) P
left join
(select FB.rid2 as rid, FB.mid, FB.way, FB.date from
(select r.id as rid2 ,r.start_zone_id as stid, r.end_zone_id as edid,
date(r.start_at + interval '8' hour) as date,
fbo.mid as mid,fbo.rid,fbo.way as way from
reservations r
join
(select
fbi.mid as mid,fbi.rid as rid,fbi.way as way from
(select
distinct r.member_id as mid, min(r.id) as rid, r.way as way
from reservations r join members m on m.id = r.member_id
where r.state = 'completed' and m.imaginary = 'normal' and m.email not like '%socar.my%' group by r.member_id) fbi
where fbi.way in ('oneway','onewayReturn') ) fbo on fbo.rid = r.id
where r.start_zone_id in ('244','245') or r.end_zone_id in ('244','245') )FB
where date(FB.date + interval '8' hour) >= @startdate1) B
on P.mid = B.mid
join
(select
m.id as mid,
TIMESTAMPDIFF(YEAR, str_to_date(m.birthday, '%Y%m%d'), r.start_at) AS age,
r.id as rid, min(r.start_at + interval 8 hour) as MFTdate,Max(r.start_at + interval 8 hour) as lastactivedate
from  members m
left outer join reservations r on m.id = r.member_id
join charges c on m.id = c.member_id
Where r.start_at != 0 and m.imaginary = 'normal' and c.kind = 'subscriptionFee' and date(c.created_at + interval '8' hour) >= @startdate1
group by m.id) A
on A.mid = B.mid