Future Releases

SELECT /* MAIN SEARCH QUERY */ pm.name AS manufacturer, pm.name AS manufacturer_name, P.id, P.id AS product_id, P.code, P.cost_price, P.vat_enabled, P.description, P.sold_retail, P.sold_trade, P.sold_wholesale, P.country_origin_code, P.commodity_code, P.price_set, P.width, P.height, P.length, P.product_scale_id, P.reorder_level, P.release_date, P.weight, P.restriction, P.restriction_bit, P.active, P.minimum_level, P.second_hand, P.limited_availability, P.can_reorder, P.warehouse_zone_id, P.wholesale_customers, P.new_price, P.big_postage, P.disable_min_order_amount, P.last_updated, P.notes, P.old_product_scale_txt, P.has_image_200, P.has_image_400, P.last_purchase_order_stock, P.last_purchase_order_date, P.first_delivered_date, P.last_moved, P.scale_string, P.keywords, P.finished_date, P.availability, P.sold, P.sold_total, P.sold_retail, P.sold_trade, P.sold_wholesale, P.base_price, P.base_export_price, P.retail_discount, P.eu_price, P.export_price, P.trade_price, P.trade_export, P.wholesale_price, P.wholesale_export, P.discount, P.backorder_retail_discount, P.backorder_discount, P.trade_discount, P.wholesale_discount, P.product_category_id, P.product_division_id, P.product_type_id, P.product_manufacturer_id, GROUP_CONCAT(DISTINCT ps.scale ORDER BY ps.scale ASC SEPARATOR ', ') AS scale, UNIX_TIMESTAMP(P.date_added) AS date_added, UNIX_TIMESTAMP(P.arrival_date) AS arrival_date , DATE(P.arrival_date) AS real_arrival_date , pt.name AS product_type, pt.name AS type_name, media.filename, IF (pp.id is null,0,1) as pending, if( coalesce( (coalesce(sl.count , 0) - coalesce(sc.product_quantity , 0 ) ) , 0 ) >= 0 , if( coalesce( (coalesce(sl.count , 0) - coalesce(sc.product_quantity , 0 ) - coalesce(bv.backorders, 0 ) - coalesce(bv.free_backorders, 0 ) ) , 0 ) >= P.show_stock, P.show_stock , coalesce( (coalesce(sl.count , 0) - coalesce(sc.product_quantity , 0 ) - coalesce(bv.backorders, 0 ) - coalesce(bv.free_backorders, 0 ) ) , 0 ) ) , 0 ) as available, COALESCE(sl.count,0) as stock_level, COALESCE(sc.product_quantity,0) AS stock_committed, COALESCE(bv.backorders,0) AS backorders, COALESCE(bv.free_backorders,0) AS free_backorders, pc.id as department_id, pc.name as department, pc.name as department_name, P.show_stock, if( pc.name = 'Future Releases', true, false ) AS future, unix_timestamp(media.date_uploaded) as unixtime FROM product P LEFT JOIN stock_level sl on P.id = sl.product_id LEFT JOIN stock_committed sc on sc.product_id = P.id LEFT JOIN backorder_values bv ON bv.product_id = P.id LEFT JOIN product_category pc on P.product_category_id = pc.id LEFT JOIN product_manufacturer pm ON P.product_manufacturer_id = pm.id LEFT JOIN product_media media ON P.id = media.product_id AND `media`.`order` = 0 JOIN product_scale_map AS psm ON (psm.product_id = P.id) LEFT JOIN product_scale ps ON (psm.scale_id = ps.id) LEFT JOIN product_type pt ON P.product_type_id = pt.id LEFT JOIN pending_product pp ON P.id = pp.id WHERE 1 AND P.restriction_bit & 1 = 1 AND P.product_manufacturer_id=362929 AND ps.id = 89514 AND P.product_category_id = 103 AND pc.show_in_search = 1 AND (P.product_category_id = 103 OR P.price_set) GROUP BY P.id ORDER BY DATE_FORMAT(P.arrival_date,'%Y-%m-%d %H') DESC ,P.code asc

Cookie name	Description
existing_user	Stores the email address used to previously log into the site, used to prefill forms like on the reset password screen
authchallenge	Authentication security checks
hcart	Stores the anonymous customer\'s cart token. If items are added to the card while not logged in, if you log in the items will be added to the customer\'s existing cart
hannants	Stores the session information while you remain on the site
pricer	Stores if the export or eu prices is selected on the catalogue page
hidefilter	Stores if the search filter panel is hidden or shown
AWSELB	Stores which server you\'re connected to so to access the same server while you navigate around the site
__utma __utmb __utmc __utmz	Google analytics related cookies

Scale

Description

Type

Department

Price

Watch

Stock

Buy

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

HMH-Publications HMHDH-032

LTV A-7 Corsair. 140 page book on the LTV A-7 Corsair II. It holds every detail of the Corsair II: cockpit, fuselage, air intake, wings, pylons, landing gear, speed brake, vertical and horizontal tail and a lot of action photographs. While a lot of photos were taken from Greek Corsairs IIs, other versions, such as the A-7A, B, D and E are included. Fantastic photos of colourful US Navy A, B and E Corsairs are included, as well...

Aircraft books

Future Releases

~~£25.50~~
£22.95

Add to watchlist

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

HMH-Publications HMHDH-033

No Scale

BAE Hawk 116 page book on the BAE Systems Hawk T.1 and T.2. This book is the result of some extensive visits to RAF Valley and includes every part of the aircraft, combined with truly spectacular action photography of the different versions of the jet trainer. The cockpit chapter includes the prototype version, T.1 and T.2 and a very close look at the ejection seat out of the aircraft. An impressive 20 page chapter shows every...

Aircraft books

Future Releases

~~£25.50~~
£22.95

Add to watchlist

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

HMH-Publications HMHDH-034

Boeing AH-64 Apache. DH-034 is a 140 page book that brings a complete portrait of the Apache Attack helicopter. It shows the AH-64A, D and E in detail and in action. Fuselage, landing gear, wings, rotors, tail, the different cockpits and a huge 24-page maintenance chapter. The Apaches photographed are from many different countries: USA, UK, Greece, The Netherlands, Israel, India, Japan, Indonesia and South Korea.

Aircraft books

Future Releases

~~£26.90~~
£24.21

Add to watchlist

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

HMH-Publications HMHDH-035

Sikorsky/Westland Sea King with 180 page and over 400 photos, no detail of the Sea King is overlooked in this book. Many different versions of the Sea King are included, from the Belgian Mk.48, German Mk.41, Norwegian Mk.43B, RAF HAR.3, Royal Navy HC4, HAS.6, ASaC.7, Canadian CH-124, and many others, including Marine One ! A really close-up look at the fuselage, cockpit, cargo bay, landing gear, main and tail rotor, a lot of a...

Aircraft books

Future Releases

~~£31.00~~
£27.90

Add to watchlist

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

HMH-Publications HMHDH-C003

Hawker Hurricane. 116 page book on the Hawker Hurricane. This third book in our Classic series brings a complete look at the Hurricane, from Mk.I, Mk.II, Mk.IV to the Canadian built Mk.XII. We also bring a closer look at the Sea Hurricane. There's a 10 page chapter on the cockpit and a huge 18-page chapter on maintaining the Hurricane, showing the engine, structure, and many panels taken off the aircraft. Every part of the air...

Aircraft books

Future Releases

~~£25.50~~
£22.95

Add to watchlist

Search Area	Manufacturer		Item Type

Part Number	Scale	Keywords	Results per Page	Only discounted retail price
		Exact Match
Only Show Items In Stock	Only Show Items With Pictures	Sort by: Sort Direction:

Cookies