Livestock and Others in Teigngrace
A W & A R Gale Twelve Oaks TQ12 6QT
Nearest Livestock And Others in Devon
select distinct p.place_id,p.county_id,p.name,round(min(sqrt(pow(69.2*(p.latitude-50.54),2)+ pow(53*(abs(p.longitude--3.63)),2))),1) as dist
from places p,ukinfo u, county c, subcategory s where s.name = 'Livestock And Others' and u.category =s.name
and u.county = "Devon"
and u.town != "Teigngrace"
and u.address3extra != "Teigngrace"
and u.address2extra != "Teigngrace"
and p.name != "Teigngrace"
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