Catalogue

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 pt.id=3245 AND P.price_set = 1 AND P.product_category_id = 102 AND pc.show_in_search = 1 AND (P.product_category_id = 103 OR P.price_set) GROUP BY P.id ORDER BY DATE(P.arrival_date) desc, P.code

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

Airscale ASPE32LANC

Avro Lancaster B Mk.I. Upgraded high fidelity etched brass Interior set to suit the HK Models Avro Lancaster B Mk.I kit. Each set includes: Fully detailed Etched Brass Instrument Panel, Flight Engineer's Panel, Navigator's Panel, Circuit Breaker Panel & Direction Finding Indicators (designed to be used with Hong Kong Models kits) Panels have holes for the addition of switches, knobs & levers (not included) High quality, ...

Aircraft detailing sets (decal and etched)

Catalogue

£18.95

Airscale ASPE32LIB

1:32

Consolidated B-24D/B-24J Liberator replacement nickel silver panel with full colour instrument decals (designed to be used with Hobby Boss kits)

Aircraft detailing sets (decal and etched)

Catalogue

£18.95

Airscale ASPE24GUS

1:24

Messerschmitt Bf-109G-2/Bf-109G-6 multi-media Instrument panel (designed to be used with Trumpeter kits)

Aircraft detailing sets (decal and etched)

Catalogue

£11.95

Airscale ASPE24FOC

1:24

Focke-Wulf Fw-190A multi-media Instrument panel (designed to be used with Airfix kits) Upgraded high fidelity etched brass Instrument Panel set to suit the Airfix Focke-Wulf Fw190 kit. Each set includes: Fully detailed Etched Brass Instrument Panel component for upper & lower panel Optional bezels for Early & Late Artificial Horizon types Panels have holes for the addition of switches, knobs & levers (not included)...

Aircraft detailing sets (decal and etched)

Catalogue

£11.95

Airscale ASPE24HUR

Hawker Hurricane Mk.I multi-media Instrument panel (designed to be used with Airfix kits)

Aircraft detailing sets (decal and etched)

Catalogue

£11.95

Airscale ASPE24MES

1:24

Messerschmitt Bf-109E multi-media Instrument panel (designed to be used with Airfix kits)

Aircraft detailing sets (decal and etched)

Catalogue

£11.95

Airscale ASPE24MUS

1:24

North-American P-51D Mustang multi-media Instrument panel (designed to be used with Airfix kits) Upgraded high fidelity etched brass Instrument Panel set to suit the Airfix P51D Mustang kit. Each set includes: Fully detailed Etched Brass Instrument Panel & Centre Console components Panels have holes for the addition of switches, knobs & levers (not included) High quality, one-piece, full colour Instrument panel dec...

Aircraft detailing sets (decal and etched)

Catalogue

£11.95

Airscale ASPE24SPIT

Supermarine Spitfire Mk.Ia/Mk.Vb multi-media Instrument panel (designed to be used with Airfix kits) Upgraded high fidelity etched brass Instrument Panel set to suit the Airfix 1/24 Spitfire kits. Each set includes: Fully detailed Etched Brass Instrument Panel components Choice of Blind Flying Panel styles Square & Rounded Panels have holes for the addition of switches, knobs & levers (not included) High quality...

Aircraft detailing sets (decal and etched)

Catalogue

£11.95

Airscale ASPE24STU

Junkers Ju-87B-2 'Stuka' multi-media Instrument panel (designed to be used with Airfix kits) Upgraded high fidelity etched brass Instrument Panel set to suit the Airfix Junkers Ju87B 'Stuka' kit. Each set includes: Fully detailed Etched Brass Instrument Panel components Panels have holes for the addition of switches, knobs & levers (not included) High quality, one-piece, full colour Instrument panel decals Inclu...

Aircraft detailing sets (decal and etched)

Catalogue

£11.95

Airscale ASPE24TBT

1:24

Republic P-47D Thunderbolts multi-media Instrument panel (designed to be used with Kinetic Model kits) Upgraded high fidelity etched brass Instrument Panel set to suit the Kinetic P47 Thunderbolt kits. Each set includes: Fully detailed Etched Brass Instrument Panel & Auxiliary panel components Kit panel replacement and true scale replacement sizes Suits both Kinetic P-47 'Bubbletop' and 'Razorback' kits Panels h...

Aircraft detailing sets (decal and etched)

Catalogue

£11.95

HGW HGW132109

1:32

Sopwith SNIPE (Early version) SUPER DETAIL SET. Contains HGW132108 HGW132520 and HGW632021 (designed to be used with Wingnut Wings kits)

Aircraft detailing sets (decal and etched)

Catalogue

£21.30

HGW HGW132110

1:32

Sopwith SNIPE (Late version) SUPER DETAIL SET. Contains HGW132108 HGW132521 and HGW632021 (designed to be used with Wingnut Wings kits)

Aircraft detailing sets (decal and etched)

Catalogue

£21.30

HGW HGW132111

1:32

Hannover Cl.II SUPER DETAIL SET. Contains 5 HGW sets (designed to be used with Wingnut Wings kits)

Aircraft detailing sets (decal and etched)

Catalogue

£30.50

HGW HGW132112

1:32

Fokker D.VII SUPER DETAIL SET. Contains 6 HGW sets (designed to be used with Wingnut Wings kits)

Aircraft detailing sets (decal and etched)

Catalogue

~~£33.70~~
£30.33

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