Zone cords - Cordinates

set @startdate = date_sub(CURDATE(), interval 1 day);
set @startdate2 = date_sub(@startdate, interval 1 month);

select Date(members.created_at + interval '8' hour) as date, members.id, x(domain_location), y(domain_location)
from members
left join member_appendixes on member_appendixes.member_id = members.id
where member_appendixes.domain_location is not null
and members.created_at + interval 8 hour <= @startdate
and members.created_at + interval 8 hour >= @startdate2
order by members.id desc;

select z.id, z.region, x(coords),y(coords)
from zones z