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.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
Future Releases | Hannants
Hannants News Feed Subscribe To This Search | Create Search Alert Create Search Notification

Future Releases



Found 38 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

No Image
HGW HGW124518
ALBATROS D.III OEFFAG - SEATBELTS Belts are made from real microfibre and in combination with included photo etched buckles they look highly realistic. This product is available in 1/24 scale and is designed for Lukgraph kit.
Car detailing sets (etched)
Future Releases
£10.70
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 HGW132643
ALBATROS D.III OEFFAG - SEATBELTS Textile seat belts designed for aircraft Albatros D.III OEFFAG produced by Lukgraph. 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)
Future Releases
£9.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 HGW132645
USAF / USN EARLY WWII (NATURAL FABRIC) - SEATBELTS Textile seat belts type USAF / USN (Fabric). Belts are made from real microfibre and in combination with included photo etched buckles they look highly realistic.
Aircraft detailing sets (etched and textile)
Future Releases
£9.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 HGW132646
USAF / USN EARLY WWII (GREEN) - SEATBELTS Textile seat belts type USAF / USN (Green). Belts are made from real microfibre and in combination with included photo etched buckles they look highly realistic.
Aircraft detailing sets (etched and textile)
Future Releases
£9.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 HGW132655
Messerschmitt Ta-152 - SEATBELTS Textile seat belts in white colour designed for aircraft Ta152. Belts are made from real microfibre and in combination with included photo etched buckles they look highly realistic.
Aircraft detailing sets (etched and textile)
Future Releases
£10.70
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 HGW132656
Focke-Wulf Fw-190A-4 - SEATBELTS Textile seat belts in white colour designed for aircraft Focke Wulf Fw190A-4 by Zoukei Mura. Belts are made from real microfibre and in combination with included photo etched buckles they look highly realistic. (designed to be used with Zoukei-Mura kits)
Aircraft detailing sets (etched and textile)
Future Releases
£10.70
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 HGW132657
GOTHA G.IV - SEATBELTS Textile seat belts designed for aircraft Gotha G.IV. Belts are made from real microfibre and in combination with included photo etched buckles they look highly realistic (designed to be used with Wingnut Wings kits)
Aircraft detailing sets (etched and textile)
Future Releases
£12.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 HGW132658
NAKAJIMA B5N2 KATE - SEATBELTS (designed to be used with HPH Models kits) Textile seat belts designed for aircraft B5N2 KATE. Belts are made from real microfibre and in combination with included photo etched buckles they look highly realistic.
Aircraft detailing sets (etched and textile)
Future Releases
£12.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 HGW132661
Dornier Do-335B-6/Do-335A-10 'Pfeil' (2 SEATS) - SEATBELTS Textile seat belts designed for aircraft Dornier Do335 Pfeil (2 Seats). Belts are made from real microfibre and in combination with included photo etched buckles they look highly realistic (designed to be used with Hong Kong Models kits)
Aircraft detailing sets (etched and textile)
Future Releases
£10.80
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 HGW132662
Douglas A-20J/K Havoc / Boston Mk.IV - SEATBELTS Textile seat belts designed for aircraft A20 J/K Havoc (Boston IV). Belts are made from real microfibre and in combination with included photo etched buckles they look highly realistic. (designed to be used with Hong Kong Models kits)
Aircraft detailing sets (etched and textile)
Future Releases
£12.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
HGW HGW132850
Northrop P-61B Black Widow - BASIC LINE 1Basic Line contains: 1x Seatbelts 1/32 - 132525 1x Masks 1/32 - 632862 Recommended for Hobby Boss kits.
Aircraft detailing sets (etched, textile and mask)
Future Releases
£21.60
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 HGW132851
Dornier Do-335B-2 PFEIL - BASIC LINE 1 Basic Line contains: 1x Seatbelts 1/32 - 132546 1x Masks 1/32 - 632855 (designed to be used with Hong Kong Models kits)
Aircraft detailing sets (etched, textile and mask)
Future Releases
£15.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 HGW132852
1:32
Dornier Do-335A PFEIL - BASIC LINE Basic Line contains: 1x Seatbelts 1/32 - 132546 1x Masks 1/32 - 632854 (designed to be used with Hong Kong Models kits)
Aircraft detailing sets (etched, textile and mask)
Future Releases
£15.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 HGW132855
Nakajima B5N2 Kate (OPENED CANOPY) - BASIC LINE Basic Line contains: 1x Seatbelts 1/32 - HGW132658 1x Masks 1/32 - HGW632872 (designed to be used with HpH Models and Infinity Models kits)
Aircraft detailing sets (etched, textile and mask)
Future Releases
£16.40
£14.76
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 HGW132856
1:32
Nakajima B5N2 Kate (CLOSED CANOPY) - BASIC LINE Basic Line contains: 1x Seatbelts 1/32 - HGW132658 1x Masks 1/32 - HGW632871 (designed to be used with HpH Models and Infinity Models kits)
Aircraft detailing sets (etched, textile and mask)
Future Releases
£16.40
£14.76
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 HGW135511
Bell/Boeing AH-64 Apache. The set contains microfibre seatbelts, dark PE parts, 3D print details and decals. Contains micro-fabric and photo-etched highly detailed parts belts are fully functional - modeler can leave them un/fastened made from printed micro-fabric material which behaves like a piece of rag textile parts are prepared for using filters and other agents (they are waterproof and resistant to common nonaggres...
Aircraft detailing sets (etched and textile)
Future Releases
£14.60
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 HGW135514
NAKAJIMA B5N-2 KATE - SEATBELTS Textile seat belts designed for aircraft NAKAJIMA B5N-2 KATE (designed to be used with Border Models 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)
Future Releases
£12.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 HGW148409
LUFTWAFFE BOMBER - SEATBELTS Brand new HGW seatbelts in 1/48 scale. Special technology allows printing seatbelts of an appropriate scale including thickness and a transfer without the carrier film. Simply soak the seatbelts in the water, detach them from the paper, and set them on the pilot seat.
Aircraft decals (military)
Future Releases
£3.80
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 HGW148591
Grumman F3F-3/F3F-5 WILDCAT - SEATBELTS Harnesses designed for Wildcat. Belts are made from microfibre and in combination with included photo etched buckles they look highly realistic. (designed to be used with Eduard kits, Monogram and Tamiya kits)
Aircraft detailing sets (etched and textile)
Future Releases
£7.80
£7.02
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 HGW172010
IJA (LATE - CANVAS) - SEATBELTS 1/72 - Brand new HGW seatbelts in 1/72 scale. Special technology allows printing seatbelts of an appropriate scale including thickness and a transfer without the carrier film. Simply soak the seatbelts in the water, detach them from the paper, and set them on the pilot seat. That is it!
Aircraft decals (military)
Future Releases
£3.80
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 HGW172012
Republic P-47D RAZORBACK seatbelts (designed to be used with TAMIYA kits) New HGW seatbelts in 1/72 scale. Special technology allows printing seatbelts of an appropriate scale including thickness and a transfer without the carrier film. Simply soak the seatbelts in the water, detach them from the paper, and set them on the pilot seat.
Aircraft decals (military)
Future Releases
£3.80
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 HGW172021
B-17 FLYING FORTRESS (GREEN) - SEATBELTS Brand new HGW seatbelts in 1/72 scale. Special technology allows printing seatbelts of an appropriate scale including thickness and a transfer without the carrier film. Simply soak the seatbelts in the water, detach them from the paper, and set them on the pilot seat. That is it!
Aircraft decals (military)
Future Releases
£3.80
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 HGW172022
B-17 FLYING FORTRESS (FABRIC) - SEATBELTS Brand new HGW seatbelts in 1/72 scale. Special technology allows printing seatbelts of an appropriate scale including thickness and a transfer without the carrier film. Simply soak the seatbelts in the water, detach them from the paper, and set them on the pilot seat. That is it!
Aircraft decals (military)
Future Releases
£3.80
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 HGW532070
Republic P-47D Thunderbolt RAZORBACK STENCILS
Aircraft decals (military)
Future Releases
£10.80
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 HGW632862
Northrop P-61B Black Widow - MASKS 1/32 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 to be used with Hobby Boss kits)
Aircraft paint masks (self adhesive)
Future Releases
£12.99
£11.69
Out of Stock
0

   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