Shiva Query for - Location Cordinates

select members.id, x(domain_location), y(domain_location), IFNULL(r.srid,0) as srid
from members
left join (
			select reservations.member_id as mid, COUNT(reservations.id) as srid
			from reservations
            where reservations.state = 'completed'
            group by reservations.member_id
		) as r on r.mid = members.id
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')
and DATE(CONVERT_TZ(members.created_at,'+00:00','+8:00')) >= "2019-04-01"
and r.srid IS NULL
order by members.id desc