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'Clench Common') AND (vw_RetailPromos.school_id <> 1638) ORDER BY price
#23350 Microlight Lesson Package at Clench Common, Wiltshire Southwest |
1 hours, with 30 minutes in the air. |
#35463 30 minute Gyrocopter (gyroplane) flight at Clench Common, Wiltshire Southwest |
45 minutes, with 30 minutes in the air. |
#22934 Microlight Experience Flight for Two at Clench Common, Wiltshire Southwest |
40 minutes, with 20 minutes in the air. |
#39608 First lesson in a 3-axis Microlight Aircraft at Clench Common, Wiltshire Southwest |
2 hours, with 1 hour in the air. |
#39609 First lesson in a 3-axis Microlight Aircraft at Clench Common, Wiltshire Southwest |
2 hours, with 1 hour in the air. |
#39610 First lesson in a Microlight (C42 or weightshift) at Clench Common, Wiltshire Southwest |
2 hours, with 1 hour in the air. |
#35462 1 hour Gyrocopter(gyroplane) flight at Clench Common, Wiltshire Southwest |
75 minutes, with 1 hour in the air. |