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'Blackpool') AND (vw_RetailPromos.school_id <> 1638) ORDER BY price
#43000 6 Mile Blackpool Pleasure Beach Buzz at Blackpool, Lancashire Northwest |
5 minutes, with 5 minutes in the air. |
#42792 A View of Blackpool Pleasure Beach and Tower at Blackpool, Lancashire Northwest |
10 minutes, with 10 minutes in the air. |
#43127 Blackpool Town, Beaches and Tower Tour at Blackpool, Lancashire Northwest |
15 minutes, with 15 minutes in the air. |
#42913 Extended Blackpool Beach and Morecambe Bay at Blackpool, Lancashire Northwest |
45 minutes, with 30 minutes in the air. |
#43192 30 minute flying lesson in a 2-seater at Blackpool, Lancashire Northwest |
40 minutes, with 30 minutes in the air. |
#43196 30 min flying lesson in a Diamond DA40 at Blackpool, Lancashire Northwest |
40 minutes, with 30 minutes in the air. |
#43193 30 minute flying lesson in a 4-seater at Blackpool, Lancashire Northwest |
45 minutes, with 30 minutes in the air. |
#43194 60 minute flying lesson in a 2-seater at Blackpool, Lancashire Northwest |
80 minutes, with 60 minutes in the air. |
#43195 60 minute flying lesson in a 4-seater at Blackpool, Lancashire Northwest |
80 minutes, with 60 minutes in the air. |
#43197 60 min flying lesson in a Diamond DA40 at Blackpool, Lancashire Northwest |
90 minutes, with 60 minutes in the air. |