Zone Coordinates and Member coordinates _ Rahil

select 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.imaginary in ('sofam', 'normal')
order by members.id desc;

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