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=362403 AND ps.id = 952 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
Catalogue | Hannants
Hannants News Feed Subscribe To This Search | Create Search Alert Create Search Notification

Catalogue



Found 31 results
| View per page
Refine your search

Deprecated: Creation of dynamic property Hannants\SearchFilters::$searchDirection is deprecated in /mnt/vault/Sync/Dessol/Sites/hannants.co.uk/php_includes/classes/SearchFilters.php on line 115
Manufacturer & Catalogue No ASC DESC
Scale ASC DESC
Description ASC DESC
Type ASC DESC
Department ASC DESC
Price ASC DESC
Watch
Stock ASC DESC
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

No Image
Airscale ASPE24MK1X
Supermarine Spitfire Mk.lXc Cockpit upgrade set (designed to be used with Airfix kits) Upgraded high fidelity etched Nickel Silver Instrument panel & ancilliaries to suit the Airfix 1/24 Supermarine Spitfire Mk. lXc Includes: Instrument Panel upgrade Seat Bulkhead & Armour Plate Seat mounts U/C selector correction & upgrade Rudder pedal treads Compass mount & missing fuel selector lever Enhanced riveted strips for ...
Aircraft decals (military)
Catalogue
£20.95
-
In Stock
1

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

No Image
Airscale AS24RAFA
Full Colour RAF Instruments Remastered. Remastered in Full Colour Each set includes: Instrumentation as found in the Spitfire, Hurricane, Mosquito and common to most RAF types Instruments for flight control, navigation, engine, oxygen and ancillary management Each instrument is separate on the decal sheet with a minimum of carrier film Includes a small sheet of optically clear replacement simulated instrument glas...
Aircraft decals (military)
Catalogue
£8.25
-
In Stock
5+

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

No Image
Airscale AS24PROP
Propeller Blade Logos for Allied and Luftwaffe aircraft with manufacturers Hamilton Standard, Rotol, De Havilland, Curtiss, Aeroproducts and VDM.
Aircraft decals (military)
Catalogue
£10.95
-
In Stock
5+

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

No Image
Airscale AS24DATA
Metallic Placards & Data plates Allied and Axis WWII
Aircraft decals (military)
Catalogue
£8.95
-
In Stock
5

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

No Image
Airscale PE24VTOL
Hawker-Siddeley Harrier GR.1/3 Instrument Panel [GR.1/McDonnell-Douglas AV-8A GR.3]
Aircraft decals (military)
Catalogue
£11.95
-
In Stock
5+

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

No Image
Airscale SB24LFT
Luftwaffe seatbelts WWII
Aircraft decals (military)
Catalogue
£8.25
-
In Stock
5+

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

No Image
Airscale SB24QK
RAF seatbelts WWII (Sutton Harness)
Aircraft decals (military)
Catalogue
£8.25
-
In Stock
5

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

No Image
Airscale SB24US
USAAF seatbelts WWII
Aircraft decals (military)
Catalogue
£7.25
-
In Stock
5+

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

Airscale ASPE24CAT
1:24
Grumman F6F-5 Hellcat Photo-etch & decal cockpit upgrade (designed to be used with Airfix kits) Each set includes: Fully detailed Etched Nickel Silver Instrument Panel, bulkhead & side console parts. Panels have holes for the addition of switches, knobs & levers (not included) High quality, one-piece, full colour Instrument panel decals & placards for all components Includes a small sheet of optically clear replac...
Aircraft detailing sets (etched)
Catalogue
£18.95
-
In Stock
5+

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

Airscale AS24GER
1:24
Luftwaffe/German WWII generic instruments 120+
Aircraft decals (military)
Catalogue
£8.25
-
In Stock
5+

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

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
-
In Stock
5+

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

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
-
In Stock
5+

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

Airscale AS24JPN
1:24
WWII Japanese Cockpit Instrument Decals Full colour cockpit instrumentation representing key flight instruments found in Imperial Japanese Army and Navy Aircraft Separate coloured switchgear panels Each instrument is separate on the decal sheet with a minimum of carrier film Includes a small sheet of optically clear replacement simulated instrument glass Fully illustrated instructions setting out which are Army ...
Aircraft decals (military)
Catalogue
£8.25
-
In Stock
5+

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

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
-
In Stock
5+

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

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
-
In Stock
5+

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

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
-
In Stock
5+

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

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
-
In Stock
5+

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

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
-
In Stock
5+

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

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
-
In Stock
4

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

Airscale AS24TIFF
Hawker Typhoon Mk.Ib Instrument & Placard Upgrade Set (designed to be used with Airfix kits)
Aircraft decals (military)
Catalogue
£10.95
-
In Stock
5

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

Airscale ASPE24BEZ
Instrument Bezels. German, RAF, U.S. instrument bezels Covers most eras - WWI to Jets Fine relief etching for mounting studs and knobs / switches Different diameters for each design to suit your build or kit part Single, dual and triple mounted instrument bezels supplied [Focke-Wulf Fw-190A / Fw-190F / Fw-190A-6 / Fw-190A-8/ Fw-190D-9] [Junkers Ju-87B-2 / Ju-87D 'Stuka' ] [Messerschmitt Bf-109E / Bf-109G-1...
Aircraft detailing sets (etched)
Catalogue
£17.95
-
In Stock
5+

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

Airscale ASPE24DET
Cockpit Details. German, RAF, and U.S. components but suitable for most aircraft from any country Radio faces and equipment including German FuG 10 and RAF R1155 Transmitters & Receivers Switches, dial knobs and levers Circuit breakers and electrical components Fine relief etching for three dimensional effect [Focke-Wulf Fw-190A / Fw-190F / Fw-190A-6 / Fw-190A-8/ Fw-190D-9] [Junkers Ju-87B-2 'Stuka' / Ju-87D 'Stuka'...
Aircraft detailing sets (etched)
Catalogue
£17.95
-
In Stock
5+

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

Airscale AS24SCH
1:24
WWII Luftwaffe/German Cockpit Placards
Aircraft decals (military)
Catalogue
£8.75
-
In Stock
5+

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

Airscale AS24PLA
1:24
Cockpit Placards & Dataplates (x334)
Aircraft decals (military)
Catalogue
£8.75
-
In Stock
5+

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

Airscale AS24FWA
Focke-Wulf Fw-190A Full Instrument Panel (designed to be used with Airfix kits)
Aircraft decals (military)
Catalogue
£4.25
-
In Stock
5

   1   |   2      »      [2]

Search Area Manufacturer Item Type Search

Part Number Scale Keywords Results per Page
Exact Match
Sort by:
Sort Direction:
Added Within last week
last 2 weeks
last month
last 6 months
last year