Livestock and Others in Arkleby
Nearest Livestock in Cumbria
select distinct p.place_id,p.county_id,p.name,round(min(sqrt(pow(69.2*(p.latitude-54.73),2)+ pow(53*(abs(p.longitude--3.33)),2))),1) as dist
from places p,ukinfo u, county c, subcategory s where s.name like 'Livestock%' and u.category =s.name
and u.county = "Cumbria"
and u.town != "Arkleby"
and u.address3extra != "Arkleby"
and u.address2extra != "Arkleby"
and p.name != "Arkleby"
and (p.name = u.town or p.name = u.address2extra or p.name = u.address3extra)
and c.county_id = p.county_id
and u.county = c.name
group by p.place_id,p.county_id,p.name
order by dist
Server shutdown in progress
Error
Server shutdown in progress
Error