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_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 2,479 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

Scale

Product Type

Manufacturer

Added Within

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
Model Maker Decals MD48169
Avro Lancaster in Polish service part II
Aircraft decals (military)
Future Releases
£TBA
£TBA
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
HMH-Publications HMHDH-032
LTV A-7 Corsair. 140 page book on the LTV A-7 Corsair II. It holds every detail of the Corsair II: cockpit, fuselage, air intake, wings, pylons, landing gear, speed brake, vertical and horizontal tail and a lot of action photographs. While a lot of photos were taken from Greek Corsairs IIs, other versions, such as the A-7A, B, D and E are included. Fantastic photos of colourful US Navy A, B and E Corsairs are included, as well...
Aircraft books
Future Releases
£25.50
£22.95
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
HMH-Publications HMHDH-033
No Scale
BAE Hawk 116 page book on the BAE Systems Hawk T.1 and T.2. This book is the result of some extensive visits to RAF Valley and includes every part of the aircraft, combined with truly spectacular action photography of the different versions of the jet trainer. The cockpit chapter includes the prototype version, T.1 and T.2 and a very close look at the ejection seat out of the aircraft. An impressive 20 page chapter shows every...
Aircraft books
Future Releases
£25.50
£22.95
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
HMH-Publications HMHDH-C003
Hawker Hurricane. 116 page book on the Hawker Hurricane. This third book in our Classic series brings a complete look at the Hurricane, from Mk.I, Mk.II, Mk.IV to the Canadian built Mk.XII. We also bring a closer look at the Sea Hurricane. There's a 10 page chapter on the cockpit and a huge 18-page chapter on maintaining the Hurricane, showing the engine, structure, and many panels taken off the aircraft. Every part of the air...
Aircraft books
Future Releases
£25.50
£22.95
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
Dead Design Models DDMUC48040
Lockheed F-94A/F-94B undercarriage wheel bay paint mask (designed to be used with Hobbycraft kits)
Aircraft paint masks (self adhesive)
Future Releases
£6.30
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 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 HGW132644
Boeing B-17F/B-17G (WHITE) - SEATBELTS Textile seat belts in white colour designed for aircraft B-17 Flying Fortress produced by HK Models. 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. (designed to be used with Hong Kong Models kits)
Aircraft detailing sets (etched and textile)
Future Releases
£19.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 HGW148590
Boeing B-17F/B-17G (WHITE) - SEATBELTS Harnesses designed for aircraft B-17 Flying Fortress in white colour. Belts are made from 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 Hong Kong Models, Monogram and Revell kits)
Aircraft detailing sets (etched and textile)
Future Releases
£8.99
£8.09
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 HGW232089
Messerschmitt Bf-109E-7 S9+FS - 1/32 Suitable for Dragon, Hasegawa, HGW, Hobby 2000 kits.
Aircraft decals (military)
Future Releases
£18.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 HGW232090
Messerschmitt Bf-109E-7 TROP S9+CS - 1/32 Suitable for Dragon, Hasegawa, HGW, Hobby 2000 kits. The preparation of the surface prior to the application of the HGW Wet Transfer: The HGW Wet Transfer technology has been tested on Gunze brand paints and preparations. Carry out the test (not on the model), if you are applying to paint made by a different manufacturer. We recommend to spray the surface with a glossy varnish in o...
Aircraft decals (military)
Future Releases
£17.30
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 HGW532083
ALBATROS D.V - LASER-CUT DECAL Decal set designed for model Albatros D.V in 1/32 scale from Wingnut Wings. This is light wood (natural) imitation. Decal is transparent so it is necessary to apply it to painted surface.
Aircraft decals (military)
Future Releases
£19.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 HGW532084
ALBATROS D.V - LASER-CUT DECAL Decal set designed for model Albatros D.V in 1/32 scale from Wingnut Wings. This is plywood imitation. Decal is transparent so it is necessary to apply it on painted surface.
Aircraft decals (military)
Future Releases
£19.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
Linear-A LA066
THE ROMAN LEGION OF ANTONIUS IN EGYPT SERVICE
Figures (injection)
Future Releases
£13.99
£12.59
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
Linear-A LA069
The Roman Army 3rd Century AD.é Set 2é INFANTRY
Figures (injection)
Future Releases
£13.99
£12.59
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
Hobby Boss HB80155
Russian BMD-2 The BMD-2 is an airborne tracked armored IFV Infantry Fighting Vehicle designed by the Russian defense Company Arkadyi Shabalin. The first prototype of the BMD-2 was completed in 1985 and was first seen in 1988. Production of vehicles started in 1989. Production of the BMD-2 was undertaken at the Volgograd Tractor Plant. The vehicle has been designed to be airdropped by parachutes thanks to a very light hull and ...
Military vehicle kits (injection)
Future Releases
£34.99
£31.49
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
Hobby Boss HB81783
Douglas TBD-1 Devastator The Douglas TBD Devastator was a torpedo bomber of the United States Navy, ordered in 1934, it first flew in 1935 and entered service in 1937. At that point, it was the most advanced aircraft flying for the USN and possibly for any navy in the world. However, the fast pace of aircraft development caught up with it, and by the time of the Japanese attack on Pearl Harbor the TBD was already outdated. It ...
Aircraft kits (injection)
Future Releases
£46.99
£42.29
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
Dead Design Models DDMUC32018
Messerschmitt Bf-108 Taifun undercarriage wheel bay paint mask (designed to be used with Eduard kits)
Aircraft paint masks (self adhesive)
Future Releases
£6.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
Dead Design Models DDMUC48031
McDonnell F-4E/F-4J/F-4G Phantom II undercarriage wheel bay paint mask (designed to be used with Zoukei-Mura kits)
Aircraft paint masks (self adhesive)
Future Releases
£6.30
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
Dead Design Models DDMUC48032
McDonnell F-4E/McDonnell F-4J/McDonnell F-4G Phantom II undercarriage wheel bay paint mask (designed to be used with Hasegawa kits)
Aircraft paint masks (self adhesive)
Future Releases
£6.30
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
Dead Design Models DDMUC48033
McDonnell F-4BCDJS Phantom II undercarriage wheel bay paint mask (designed to be used with Zoukei-Mura kits)
Aircraft paint masks (self adhesive)
Future Releases
£6.30
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
Dead Design Models DDMUC48034
Republic F-105 Thunderchief undercarriage wheel bay paint mask (designed to be used with Monogram kits)
Aircraft paint masks (self adhesive)
Future Releases
£6.30
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
Dead Design Models DDMUC48035
Republic F-105D/F015G Thunderchief undercarriage wheel bay paint mask (designed to be used with Hobby Boss kits)
Aircraft paint masks (self adhesive)
Future Releases
£6.30
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
Dead Design Models DDMUC48036
LTV A-7A/A-7B/A-7D/A-7E Corsair II undercarriage wheel bay paint mask (designed to be used with Hobby Boss kits)
Aircraft paint masks (self adhesive)
Future Releases
£6.30
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
Dead Design Models DDMUC48038
LTV A-7D/A-7E Corsair II undercarriage wheel bay paint mask (designed to be used with Esci and Italeri kits)
Aircraft paint masks (self adhesive)
Future Releases
£6.30
Out of Stock
0

[1]   «      54   |   55   |   56   |   57   |   58      »      [100]
-50 -20 -10 | +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