One way Zones in Weekends - Rahil for Bala

set @start := '2019-8-1';
select distinct r.start_zone_id, z.name as name ,z.region as region
from reservations r join zones z on z.id = r.start_zone_id
where r.return_at + interval 8 hour >= @start
and r.way in ('oneway','onewayRetrun')
and DAYNAME(convert_tz(r.start_at, '+00:00', '+8:00')) in ('Saturday', 'Sunday')