across the UK with
YOU in the cockpit!
//SELECT DISTINCT vw_RetailPromos.advert_id, vw_RetailPromos.county, vw_RetailPromos.cost, COALESCE (vw_ActiveDiscounts.elb_disc, 0) AS elb_disc, vw_RetailPromos.cost - COALESCE (vw_ActiveDiscounts.elb_disc, 0) AS price, vw_ActiveDiscounts.expires, vw_RetailPromos.duration, vw_RetailPromos.tot_duration, vw_RetailPromos.school_id, tblSchools.name FROM vw_RetailPromos INNER JOIN tblSchools ON vw_RetailPromos.school_id = tblSchools.school_id LEFT OUTER JOIN vw_ActiveDiscounts ON vw_RetailPromos.advert_id = vw_ActiveDiscounts.promo WHERE (vw_RetailPromos.venue = N'Dunkeswell') AND (vw_RetailPromos.school_id <> 1638) ORDER BY price
#42984 6 Mile Helicopter Buzz Flight at Dunkeswell, Devon Southwest |
5 minutes, with 5 minutes in the air. |
#42777 A View of Blackdown Hills and East Devon at Dunkeswell, Devon Southwest |
10 minutes, with 10 minutes in the air. |
#43111 Views over Devonshire Countryside at Dunkeswell, Devon Southwest |
15 minutes, with 15 minutes in the air. |
#42897 Extended Jurassic Coast and English Riviera Tour at Dunkeswell, Devon Southwest |
45 minutes, with 30 minutes in the air. |
#43056 Views over Devonshire Countryside at Dunkeswell, Devon Southwest |
45 minutes, with 20 minutes in the air. |