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'Mildenhall Simulator') AND (vw_RetailPromos.school_id <> 1638) AND (vw_RetailPromos.experience = N'Flight simulator') ORDER BY price
#39838 60-Min Boeing Flight Simulator Experience at Mildenhall Simulator, Suffolk East Anglia |
60 minutes, with 30 minutes in the air. |
#39840 60-Min Helicopter Simulator Experience at Mildenhall Simulator, Suffolk East Anglia |
60 minutes, with 45 minutes in the air. |
#39839 90-Min Boeing Flight Simulator Experience at Mildenhall Simulator, Suffolk East Anglia |
90 minutes, with 60 minutes in the air. |
#39841 90-Min Helicopter Simulator Experience at Mildenhall Simulator, Suffolk East Anglia |
90 minutes, with 75 minutes in the air. |
#39842 120-Min Boeing Flight Simulator Experience at Mildenhall Simulator, Suffolk East Anglia |
120 minutes, with 90 minutes in the air. |
#39843 VALENTINE Boeing Flight Simulator Experience for 2 at Mildenhall Simulator, Suffolk East Anglia |
90 minutes, with 60 minutes in the air. |