WIP - Oneway Trips - MFTs - weekly - For Jason

Select Weekofyear(A.date) as week, Count(A.rid) as oneway_MFT from
(select FB.rid2 as rid, FB.mid as mid, FB.way as way, FB.date as 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) >= '2019-01-01') A group by week order by week desc