50% off Code - Rahil for MFTs

set @start := '2019-12-09';
Select A.mid as mid, A.date as date, A.state as state,
IFNULL(B.resv,0) as resv from
(select distinct dl.member_id as mid, dl.state as state, m.display_name as name, m.email as email,
Date(dl.updated_at + interval 8 hour) as Date
from driver_licenses dl
left join members m on dl.member_id = m.id
where dl.state = 'approved'
and dl.created_at + interval '8' hour >= @start
and m.imaginary in ('sofam', 'normal')) A
left join
(Select r.member_id as mid, count(r.id) as resv
from reservations r
left join members m on r.member_id = m.id
where r.state in ('completed', 'inuse','reserved')
and r.start_at + interval 8 hour >= @start
and m.imaginary in ('sofam', 'normal')
group by 1) B
on A.mid = B.mid
where B.resv is null
order by 1 desc