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 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 739 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 113
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

HGW HGW532029
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

HGW HGW532030
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
HGW HGW648412
1:48
Hawker Sea Fury FB.II (designed to be used with Airfix kits)
Aircraft paint masks (self adhesive)
Catalogue
£6.40
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
HGW HGW632834
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
HGW HGW124512
FOKKER DR.I SEATBELTS 1/24 - Textile seat belts designed for aircraft Fokker Dr.I (Meng). Belts are made from real microfibre and in combination with included photo etched buckles look very realistic. (designed to be used with Meng Model kits)
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
HGW HGW124802
FOKKER DR.I (designed to be used with Meng Model kits) - BASIC LINE 1/24 - Basic Line contains: 1x Fokker Dr.I - Seatbelts 1/24 - HGW124512 1x Fokker Dr.I - Masks - 1/24 - HGW624003
Aircraft detailing (decal, etched and textile)
Catalogue
£14.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

No Image
HGW HGW132849
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
HGW HGW148588
1:48
HAWKER HURRICANE Mk.IIC - SEATBELTS 1/48 - Textile seat belts designed for aircraft Hawker Hurricane (designed to be used with Arma Hobby kits). 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.30
-
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
HGW HGW672009
Mitsubishi A6M2 ZERO (designed to be used with Tamiya kits) HGW's masking patterns, for clear parts and wheels. Printed number on each part - for better orientation during application designed for Tamiya
Aircraft paint masks (self adhesive)
Catalogue
£7.70
-
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
HGW HGW132848
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
HGW HGW132839
Messerschmitt Bf-109G-2/4 BASIC LINE: seatbelts + masks (designed to be used with Revell kits)
Aircraft detailing sets (etched, textile and mask)
Catalogue
£15.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
HGW HGW148579
Zlin Z-126 Trener pre-cut (laser) Seatbelts (designed to be used with Eduard kits)
Aircraft detailing sets (etched and textile)
Catalogue
£11.20
-
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
HGW HGW632857
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
HGW HGW124516
Supermarine Spitfire Mk.IXc Sutton "QK" Harness ( (designed to be used with Airfix kits) ) Textile seat belts designed for aircraft SPITFIRE Mk.IX (designed to be used with Airfix kits) . Belts are made from real microfibre and in combination with included photo etched buckles + 3D-Printed components they look highly realistic
Aircraft detailing sets (etched and textile)
Catalogue
£22.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
HGW HGW132641
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
HGW HGW132847
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
HGW HGW135513
Focke-Wulf Fw-190A-6 - SEATBELTS (designed to be used with Border Models kits) Textile seat belts designed for aircraft Focke-Wulf Fw-190A-6 for Border 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/35 scale.
Aircraft detailing sets (etched and textile)
Catalogue
£9.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
HGW HGW148587
Messerschmitt Bf-109K-4 ORLON (ERSATZ) - SEATBELTS 1/48 Textile seat belts designed for aircraft Messerschmitt Bf-109K-4 Orlon (Ersatz). Belts are made from real microfibre and in combination with included photo etched buckles they look highly realistic. This product is available in 1/48 scale (designed to be used with Academy, Fujimi, Hasegawa, Hobbycraft, ICM, Italeri and Revell kits)
Aircraft detailing sets (etched and textile)
Catalogue
£10.50
-
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
HGW HGW124803
HAWKER TYPHOON MK.IB (designed to be used with Airfix kits) - BASIC LINE 1/24
Aircraft detailing (decal, etched and textile)
Catalogue
£16.99
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
HGW HGW124804
Grumman F6F-5 HELLCAT (designed to be used with Airfix kits) - BASIC LINE 1/24
Aircraft detailing (decal, etched and textile)
Catalogue
£18.25
-
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
HGW HGW132637
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
HGW HGW132639
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
HGW HGW132640
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
HGW HGW132841
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
HGW HGW132844
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

   1   |   2   |   3   |   4   |   5      »      [30]
| +10 +20

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