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 113

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
HMH-Publications HMHDH-034
Boeing AH-64 Apache. DH-034 is a 140 page book that brings a complete portrait of the Apache Attack helicopter. It shows the AH-64A, D and E in detail and in action. Fuselage, landing gear, wings, rotors, tail, the different cockpits and a huge 24-page maintenance chapter. The Apaches photographed are from many different countries: USA, UK, Greece, The Netherlands, Israel, India, Japan, Indonesia and South Korea.
Aircraft books
Future Releases
£26.90
£24.21
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-035
Sikorsky/Westland Sea King with 180 page and over 400 photos, no detail of the Sea King is overlooked in this book. Many different versions of the Sea King are included, from the Belgian Mk.48, German Mk.41, Norwegian Mk.43B, RAF HAR.3, Royal Navy HC4, HAS.6, ASaC.7, Canadian CH-124, and many others, including Marine One ! A really close-up look at the fuselage, cockpit, cargo bay, landing gear, main and tail rotor, a lot of a...
Aircraft books
Future Releases
£31.00
£27.90
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 LEK-200
Westland Sea King HAS.1/HAS.5/HU.5 limited edition collectors gift set which will include: - DH-035, the Duke Hawkins 180 page book on the Sea King - Airfix's 1/48 scale Sea King kit - XtraDecal 1/48 scale decal set, including the Belgian AF markings - 1/48 scale 3D-Printed upgrade set for the Belgian Sea King - 1/48 scale double sided masks - luxury print of RS05, the final Sea King in the Belgian Air Force to fly, i...
Aircraft kits (injection)
Future Releases
£124.00
£111.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
Syhart Decal SY48127
Dassault-Rafale M #5 "70 years Flottille 12F" 2018 The Flottille 12F was created in 1948, heir to the AC2 Squadron of which it kept the badge, it took part in many conflicts such as Indochina, or in North Africa from the aircraft carriers Arromanches and Bois-Belleau, but also from land bases. The Flottille 12F, was successively equipped with Seafire, Hellcat, Corsair, then was converted on F-8 Crusader from 1964 after a y...
Aircraft decals and paint masks (military)
Future Releases
£12.00
£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
Syhart Decal SY48128
1:48
Dassault Rafale M #30 "100 years arrested landing" CEPA 10S 2020 On October 20, 1920 in Toulon harbor, Lieutenant de Vaisseau Teste, experimented the first arrested deck landing, on the battleship Bƒ©arn aboard a Hanriot HD2 equipped with hooks, To mark the centenary of this event which will mark the beginning of modern naval aviation, the CEPA 10S (practical experimentation Center naval aviation) based on Hyƒ"res NAS deco...
Aircraft decals and paint masks (military)
Future Releases
£12.00
£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
Syhart Decal SY48150
1:48
Lockheed-Martin F-16AM Falcon FA-87 "Tigermeet 2011-2012" "31 Tigers" Belgian AF
Aircraft decals (military)
Future Releases
£25.00
£22.50
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
Syhart Decal SY72127
1:72
Dassault-Rafale M #5 "70 years Flottille 12F" 2018 The Flottille 12F was created in 1948, heir to the AC2 Squadron of which it kept the badge, it took part in many conflicts such as Indochina, or in North Africa from the aircraft carriers Arromanches and Bois-Belleau, but also from land bases. The Flottille 12F, was successively equipped with Seafire, Hellcat, Corsair, then was converted on F-8 Crusader from 1964 after a y...
Aircraft decals and paint masks (military)
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
Syhart Decal SY72128
Dassault Rafale M #30 "100 years arrested landing" CEPA 10S 2020 On October 20, 1920 in Toulon harbor, Lieutenant de Vaisseau Teste, experimented the first arrested deck landing, on the battleship Bƒ©arn aboard a Hanriot HD2 equipped with hooks, To mark the centenary of this event which will mark the beginning of modern naval aviation, the CEPA 10S (practical experimentation Center naval aviation) based on Hyƒ"res NAS deco...
Aircraft decals and paint masks (military)
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
Syhart Decal SY72150
Lockheed-Martin F-16AM Falcon FA-87 "Tigermeet 2011-2012" "31 Tigers" Belgian AF
Aircraft decals (military)
Future Releases
£18.00
£16.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
AMP AMP48026
Supermarine S-6A
Aircraft kits (injection)
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
Syhart Decal SY48135
1:48
McDonnell F-4F Phantom II 37+16 & Panavia Tornado IDS 45+03 "50 Jahre WTD-61" 2007 This decals set contains all markings to complete two aircrafts Faced with the need to evaluate the aircraft of the future Luftwaffe, Wehrtechnische Dienststelle 61 (WTD 61) , literally "military technical center" was created in 1957. It is the dedicated flight test and development center for all German military aircraft, based in Manching...
Aircraft decals (military)
Future Releases
£16.00
£14.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
Syhart Decal SY48149
1:48
Dassault-Mirage 2000N 4-BA "La Fayette tail art" EC 2/4 "La Fayette" 1998
Aircraft decals (military)
Future Releases
£13.00
£11.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
Syhart Decal SY72149
Dassault-Mirage 2000N 4-BA "La Fayette tail art" EC 2/4 "La Fayette" 1998
Aircraft decals (military)
Future Releases
£10.00
£9.00
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
Furball Aero-Design FBD48092
Growler Anthology Part V
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
Das Werk DASDW16006
Sd.Kfz.234/2 aâé-l"PUMAaâé- Commander figure included as a bonus aâé-¢ Highly detailed static plastic model aâé-¢ Two different suspension options aâé-¢ Metal barrel included aâé-¢ Buildable as normal or command version aâé-¢ 4 marking options aâé-¢ Hatches can be built open/closed aâé-¢ Steering angle possible aâé-¢ Photo-etched parts included
Military vehicle kits (injection)
Future Releases
£119.00
£107.10
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
Quinta Studio QD72128
Sukhoi Su-34 3D-Printed & coloured Interior on decal paper (designed to be used with Italeri and Zvezda kits)
3D printed decal
Future Releases
£8.60
£7.74
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
Tamiya TA12694
Leopard 2 A7V Metal Barrel
Military vehicle gun barrels
Future Releases
£21.99
£19.79
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
Tamiya TA14142
Honda Dax125 Tamiya Edition
Motorbike kits (injection)
Future Releases
£29.99
£26.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
Tamiya TA24366
Full-View Mercedes Benz 300SL
Car kits (injection)
Future Releases
£49.99
£44.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
Tamiya TA35384
1:35
Zƒ¼ndapp KS600 & Sidecar
Military vehicle kits (injection)
Future Releases
£19.99
£17.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
Tamiya TA35386
German MG Team Mid-WWII
Figure kits (injection)
Future Releases
£17.99
£16.19
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
Tamiya TA35387
Leopard 2 A7V
Military vehicle kits (injection)
Future Releases
£59.99
£53.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
Dream Model DM720020
Bell AH-1W 'Super Cobra' early version
Aircraft kits (injection)
Future Releases
£29.99
£26.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 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

[1]   «      41   |   42   |   43   |   44   |   45      »      [100]
-20 -10 | +10 +20 +50

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