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=362428 AND ps.id = 953 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 420 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

German WWI 5 colour lozenge FADED pattern for upper AND lower surfaces (designed to be used with Wingnut Wings kits)
Aircraft decals (military)
Catalogue
£9.30
-
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

1:32
German WWI 4 colour FADED lozenge pattern for upper AND lower surfaces (designed to be used with Wingnut Wings kits)
Aircraft decals (military)
Catalogue
£9.30
-
In Stock
3

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
1:32
MASKING STRIPS - 3mm
Aircraft paint masks (self adhesive)
Catalogue
£5.60
-
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
1:32
Messerschmitt Bf-109E - BASIC LINE 1/32 Basic Line contains: 1x Seatbelts 1/32 - 132613 1x Masks 1/32 - 632871 Recommended for Dragon, Cyber Hobby, Hobby 2000 kits.
Aircraft detailing sets (etched, textile and mask)
Catalogue
£13.50
-
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
Messerschmitt Bf-109E-4/7 - BASIC LINE Basic Line contains: 1x Seatbelts 1/32 - 132613 1x Masks 1/32 - 632432 Recommended for Dragon, Cyber Hobby, Hobby 2000 kits.
Aircraft detailing sets (etched, textile and mask)
Catalogue
£16.50
-
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
1:32
Dornier Do-335A-10 canopy frame paint masks (inside and outside) (designed to be used with Hong Kong Models kits)
Aircraft paint masks (self adhesive)
Catalogue
£8.50
-
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
1:32
Douglas A-20G HAVOC - SEATBELTS (designed to be used with Hong Kong Models kits) Textile seat belts designed for aircraft A-20G Havoc for HK Models kit. Belts are made from real microfibre and in combination with included photo etched buckles they look highly realistic. This product is available in 1/32 scale.
Aircraft detailing sets (etched and textile)
Catalogue
£13.40
-
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
Republic P-47D THUNDERBOLT RAZORBACK - BASIC LINE 1/32 - 132847 Basic Line contains: 1x Seatbelts 1/32 - 132532 1x Masks 1/32 - 632869 (designed to0 be used with Trumpeter kits)
Aircraft detailing sets (etched, textile and mask)
Catalogue
£17.99
-
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

No Image
1:32
FOCKE-WULF FW-190A/F-8 - SEATBELTS x 2 textile seat belts designed for aircraft Focke-Wulf Fw190A/F-8. Belts are made from real microfibre and in combination with included photo etched buckles they look highly realistic.
Aircraft detailing sets (etched and textile)
Catalogue
£12.99
-
In Stock
3

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
1:32
Supermarine SPITFIRE MK.IA - SEATBELT (designed to be used with Kotare Models kits) Textile seat belts designed for aircraft Spitfire Mk.Ia. Belts are made from real microfibre and in combination with included photo etched buckles they look highly realistic. [Mk.I]
Aircraft detailing sets (etched and metal)
Catalogue
£12.40
-
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
Aichi D3A1 Val - SEATBELTS (designed to be used with Infinity Models kits) Textile seat belts designed for aircraft D3A1 VAL. Belts are made from real microfibre and in combination with included photo etched buckles they look highly realistic.
Aircraft detailing sets (etched and textile)
Catalogue
£10.99
-
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
de Havilland DH-100 Vampire - BASIC LINE 1/32 - 132841 Basic Line contains: 1x Seatbelts 1/32 - 132830 1x Masks 1/32 - 632860 (designed to be used with Infinity Models kits)
Aircraft detailing sets (etched, textile and mask)
Catalogue
£15.80
-
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
Supermarine SPITFIRE MK.IA - BASIC LINE Basic Line contains: 1x Seatbelts 1/32 - 132639 1x Masks 1/32 (designed to be used with Kotare Models kits).
Aircraft detailing sets (etched, metal and resin)
Catalogue
£16.15
-
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
Aichi D3A1 Val (OPENED CANOPY) - BASIC LINE Basic Line contains: 1x Seatbelts 1/32 - 132640 1x Masks 1/32 - 632869 (designed to be used with Infinity Models kits) Recommended for Infinity Models.
Aircraft detailing sets (etched, textile and mask)
Catalogue
£16.40
-
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

No Image
Aichi D3A1 Val (CLOSED CANOPY) - BASIC LINE Basic Line contains: 1x Seatbelts 1/32 - 132640 1x Masks 1/32 - 632870 (designed to be used with Infinity Models kits) Recommended for Infinity Models.
Aircraft detailing sets (etched, textile and mask)
Catalogue
£16.40
-
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
HAWKER HURRICANE MK.IIB (designed to be used with REVELL kits) - SEATBELTS 1/32 - Textile seat belts designed for aircraft Hawker Hurricane Mk.IIb (designed to be used with Revell kits) . Belts are made from real microfibre and in combination with included photo etched buckles they look highly realistic. This product is available in 1/32
Aircraft detailing sets (etched and textile)
Catalogue
£9.99
-
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
Douglas A-1D/A-1H/A-1J Skyraider - SEATBELTS (designed to be used with Trumpeter kits) Textile seat belts designed for aircraft A1 Skyraider. Belts are made from real microfibre and in combination with included photo etched buckles they look highly realistic
Aircraft detailing sets (etched and textile)
Catalogue
£10.99
-
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
MESSERSCHMITT BF-110C/D (DRAGON, CYBERHOBBY, (designed to be used with Revell kits) ) Double-sided HGW's masking patterns, for clear parts . Printed number on each part - for better orientation during application Inside and outside canopy masks and clear parts Designed for Dragon, CyberHobby, Revell Easy solution, 1/32 scale
Aircraft paint masks (self adhesive)
Catalogue
£11.99
-
In Stock
3

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
de Havilland DH-100 VAMPIRE - SEATBELTS Textile seat belts designed for aircraft DH-100 VAMPIRE - (designed to be used with Infinity Models kits) 1/32 . Belts are made from real microfibre and in combination with included photo etched buckles they look highly realistic.
Aircraft detailing sets (etched and textile)
Catalogue
£9.99
-
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
MESSERSCHMITT Bf-110C/D - BASIC LINE 1/32 Basic Line contains: 1x Seatbelts 1/32 - 132588 1x Masks 1/32 - 632853 Recommended for Dragon, Revell.
Aircraft detailing sets (etched, textile and mask)
Catalogue
£17.20
Out of Stock
0

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
1:32
HAWKER HURRICANE MK.IIB - BASIC LINE (designed to be used with Revell kits) Basic Line contains: 1x Seatbelts 1/32 - 132636 1x Masks 1/32 - 632865
Aircraft detailing sets (etched, textile and mask)
Catalogue
£15.80
-
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
Mikoyan MIG-23 STENCILS
Aircraft decals (military)
Catalogue
£14.10
-
In Stock
3

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

Focke-Wulf Fw-190A-8 (designed to be used with Hasegawa and Hobby 2000 kits) Complete pack of positive rivets for Focke-Wulf Fw-190D-9 190A-8 in 1/32 scale. Riveting sets from HGW Models give to surfaces of plastic kits highly realistic look. We recommend to apply them under the paint and when your model is painted just polish the surface to make the accessory visible.
Aircraft riveting decals (military)
Catalogue
£26.30
-
In Stock
2

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

1:32
Luftwaffe fighters late version seat-belt 'pre-cut [laser] seatbelts '. AZ Models AZM32002 Avia C-2 Best Choice BEST1002 'Heinkel He-162 FLY YLF32002 'Bachem Ba-349A 'Natter' (M-52, T2-1011) FLY YLF32001 'Bachem Ba-349V Natter (M-17, M-22, M-23) Hasegawa,HA08223 Focke-Wulf Fw-190D-9 Jabo Hasegawa,HA08217 Focke-Wulf Fw-190A-7 JG1 Red Stripe Hasegawa,HAST021 Focke-Wulf Fw-190A-8 Hasegawa,HAST019 'Focke-Wulf Fw-190D-9. ...
Aircraft detailing sets (fabric)
Catalogue
£8.60
-
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

No Image
Hawker Tempest Mk.II pre-cut (laser) Seatbelts
Aircraft detailing sets (etched and textile)
Catalogue
£9.30
-
In Stock
5+