UK Days Out and Activity Finder
A comprehensive directory for finding days out, activities, events and attractions around the UK.

Golf Courses & Clubs in Boat of Garten, Inverness-Shire
Content Ad
-
Boat Of Garten Golf & Tennis Club
Tel: 01479 831282Nethybridge RoadFax: 01479 831523Boat of GartenInverness-ShirePH24 3BQ

Golf Courses & Clubs near Boat of Garten
SELECT
sqrt((abs(p.x - t2.x) * abs(p.x - t2.x)) + (abs(p.y-t2.y) * abs(p.y-t2.y))) as distance,
b.*, t.nameTown, c.nameCounty, p.* from businesses_daygo b
join towns t on b.idTown = t.idTown
join counties c on t.idCounty = c.idCounty
join postcodes p on b.shortPostCode = p.postcode
join towns t2
where
b.idBusinessType = 169334 and
t.idTown <> 3146 and
t2.idTown = 3146
order by (abs(p.x - t2.x) * abs(p.x - t2.x)) + (abs(p.y-t2.y) * abs(p.y-t2.y))
limit 8BIGINT UNSIGNED value is out of range in '(`vpsdaygo_ukbuisness`.`p`.`y` - `vpsdaygo_ukbuisness`.`t2`.`y`)'