Livestock and Others in Churchstow
F V Reeves & Partners Holditch Farm TQ7 3QR
D Reeves & Partners Home Farm TQ7 3QR
W J Walters-Symons & Sons Barnwell TQ7 3QU
D Reeves & Partners Home Farm TQ7 3QR
W J Walters-Symons & Sons Barnwell TQ7 3QU
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.29),2)+ pow(53*(abs(p.longitude--3.81)),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 != "Churchstow"
and u.address3extra != "Churchstow"
and u.address2extra != "Churchstow"
and p.name != "Churchstow"
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