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'Harrogate') AND (vw_RetailPromos.school_id <> 1638) AND (vw_RetailPromos.experience = N'Flight simulator') ORDER BY price
#39863 20 minute Boeing 737 simulator experience at Harrogate, Yorkshire Northeast |
50 minutes, with 20 minutes in the air. |
#39863 20 minute Boeing 737 simulator experience at Harrogate, Yorkshire Northeast |
50 minutes, with 20 minutes in the air. |