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 ps.id = 953
		 AND P.product_category_id = 108 
		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
Limited Availability | Hannants
Hannants News Feed Subscribe To This Search | Create Search Alert Create Search Notification

Limited Availability



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

1:32
Boeing F/A-18E Super Hornet (designed to be used with Revell kits) This BiG-Ed set includes all these Eduard sets.... EDJX231 F/ A-18E ED32439F/ A-18E exterior ED32948F/ A-18E interior ED33220F/ A-18E seatbelts STEEL 1/32 (Eduard sold out February 2023)
Aircraft detailing sets (etched)
Limited Availability
£38.30
-
In Stock
3

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

No Image
1:32
Gloster Sea Gladiator Mk.II 2 (designed to be used with ICM kits) This BiG-Ed set includes all these Eduard sets..... ED32969 Sea Gladiator 1/32 ED33257 Sea Gladiator seatbelts STEEL 1/32 EDJX255 Sea Gladiator 1/32 (Eduard sold out February 2023)
Aircraft detailing sets (etched)
Limited Availability
£26.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

1:32
Focke-Wulf Fw-190F-8 PART II (designed to be used with Revell kits) This BiG-Ed set includes all these Eduard sets.... ED32373 Fw-190F-8 wheel bay ED32374 Fw-190F-8 armament ED32375 Fw-190F-8 engine (Eduard sold out February 2023)
Aircraft detailing sets (etched)
Limited Availability
£30.60
-
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

Hawker Tempest Mk.V (designed to be used with Revell and Special Hobby kits) This Big-Ed set includes these Eduard sets.... EDJX193 Tempest Mk.V ED32392 Tempest Mk.V landing flaps ED32880 Tempest Mk.V ED32881 Tempest Mk. V seatbelts STEEL (Eduard sold out February 2023)
Aircraft detailing sets (etched)
Limited Availability
£36.70
-
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

Lockheed-Martin F-35A Lightning II. (designed to be used with Italeri kits) This BiG-Ed set includes all these Eduard sets.... EDJX201 F-35A ED32404 F-35A exterior ED32405 F-35A wheel bays & bomb bays ED32910 F-35A interior ED33169 F-35A seatbelts STEEL (Eduard sold out February 2023)
Aircraft detailing sets (etched)
Limited Availability
£42.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

1:32
Polikarpov I-16 type 24 WWII Soviet Fighter (designed to be used with Hasegawa, ICM and Revell kits) This BiG-Ed set includes all these Eduard sets.... EDJX209 I-16 Type 24 ED32919 I-16 Type 24 ED33185 I-16 Type 24 seatbets STEEL (Eduard sold out February 2023)
Aircraft detailing sets (etched)
Limited Availability
£22.60
-
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

1:32
North-American P-51D Mustang (designed to be with Revell kits) This BiG-Ed set includes all these Eduard sets.... EDJX210 P-51D ED32419 P-51D-5 exterior ED32420 P-51D undercarriage ED32920 P-51D-5 interior ED33187 P-51D seatbelts STEEL (Eduard sold out February 2023)
Aircraft detailing sets (etched)
Limited Availability
£52.40
-
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
Panavia Tornado GR.4 exterior (designed to be used with Italeri kits)(Eduard sold out February 2023)
Aircraft detailing sets (etched)
Limited Availability
£23.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

1:32
Luftwaffe instruments (Eduard sold out February 2023)
Aircraft detailing sets (etched)
Limited Availability
£11.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

Messerschmitt Bf-109G-6 instrument panel PRE-PAINTED IN COLOUR! (designed to be used with Hasegawa kits)(Eduard sold out February 2023)
Aircraft detailing sets (etched)
Limited Availability
£5.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

Northrop F-5E Tiger (designed to be used with Kitty Hawk Model kits)(Eduard sold out February 2023)
Aircraft detailing sets (etched)
Limited Availability
£14.40
-
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

Curtiss P-40F Warhawk canopy masks (designed to be used with Trumpeter kits) (Eduard sold out February 2023)
Aircraft paint masks (self adhesive)
Limited Availability
£7.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

AC/DC Tour Truck LIMITED EDITION
Truck and trailer kits (injection)
Limited Availability
£69.99
-
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
Bell AH-1G & TH-1G (for ICM) 1. Bell AH-1G, c/n 16440, US Army Artic Programme, Elmendorf AFB, Anchorage, 1975 2. Bell AH-1G, c/n 15046, 46H, US Marines training unit, 1969 3. Bell TH-1G, c/n 34270, 70A, US Army 4. Bell AH-1G, c/n 15259, Cobra New Equipment Transition Team (NETT), Vietnam 1967 5. Bell AH-1G, c/n 17054, C/2/20 Aerial Rocket Artillery (ARA), Vietnam 1971 6. Bell TH-1G, c/n 15115, US Army
Aircraft decals (military)
Limited Availability
£10.80
-
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

Curtiss Kittyhawk Mk.I/Mk.III landing flaps (designed to be used with Hasegawa kits)
Aircraft detailing sets (etched)
Limited Availability
£19.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

(Ltd) North-American P-51D Mustang Corrected Paper Drop tanks (designed to be used with Tamiya kits) Super-detailed, seamless nose and tailcones for Tamiya's 108 gallon drop tanks capture the rough, scalloped look of the paper mache. The paper drop tanks in the Tamiya Mustang kit are accurate in shape and size, but they do not capture the 'look' of the end caps on the real tanks. The real tanks are made of compressed, impregna...
Aircraft detailing sets (resin)
Limited Availability
£10.99
-
In Stock
6

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

(Ltd) American P-51D Mustang Oval Tread Pattern Tyres/Tires (designed to be used with Tamiya kits) This set contains new oval tread pattern tires/tyres that directly replace the tires/tyres in the Tamiya kit. The problem with the soft vinyl tires/tyres in the kit is that the seams are very difficult to remove, and they tend to attract dirt and dust. These seamless resin parts have superb tread detail, and are both sandable and...
Aircraft wheels (resin)
Limited Availability
£8.99
-
In Stock
10+

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

1:32
(Ltd) Republic P-47C/P-47D Thunderbolt Block Tread Mainwheels . This set contains a pair of detailed resin main wheels with crisply molded, seamless and accurate block tread pattern. You can choose between plain, covered or 6 slot hubs. The inner wheel hub detail is visible through the slots of the outer wheel hub, bringing a whole new level of detail. Makes a quick, easy and very visible upgrade (designed to be used with Hase...
Aircraft wheels (resin)
Limited Availability
£8.99
-
In Stock
7

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

(Ltd) Messerschmitt Me-262 Main, Plain Hub Nosewheels
Aircraft wheels (resin)
Limited Availability
£12.99
-
In Stock
8

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

(Ltd) Messerschmitt Bf-109G Wheels - Plain Hub, Ribbed Tire/tyre. This set consists of a pair of super detailed, accurate resin mainwheels as fitted to the Bf-109G-5 through G-14 series aircraft. These wheels represent the later fit of the ribbed tire/tyre fitted to the plain, ribless hub. Finely rendered raised tire/tyre data is featured. Will upgrade any 1/32nd Bf-109G kit, such as Hasegawa, Revell, and Trumpeter kits. (desi...
Aircraft wheels (resin)
Limited Availability
£9.99
-
In Stock
10+

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

(Ltd) Vought F4U Corsair, Grumman F6F Hellcat Wheels - Stamped Hub. Super detailed resin wheels with the late production stamped wheel hub and ribbed tires/tyres as fitted to late model F6F, F4U, Warbirds, and Air Racers. A simple upgrade for all Corsair and Hellcat kits (designed to be used with Trumpeter kits) [F6F-5N F6F-3N F6F-3 F6F-5 F4U-1D F4U-4]
Aircraft wheels (resin)
Limited Availability
£7.99
-
In Stock
10+

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

1:32
Curtiss P-40N Warhawk landing flaps (designed to be used with Trumpeter kits)
Aircraft detailing sets (etched)
Limited Availability
£22.20
-
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

Curtiss P-40F Warhawk (designed to be used with Trumpeter Kits) This Big-Ed sets contained all these Eduard sets! EDJX226 P-40F ED32430 P-40F landing flaps ED3243 1P-40F gun bays ED32940 P-40F ED33213 P-40F seatbelts STEEL ED32434 P-40F exterior
Aircraft detailing sets (etched)
Limited Availability
£67.20
-
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

Gloster Gladiator Mk.I (designed to be used with ICM kits) (Eduard sold out January 2023)
Aircraft detailing sets (etched)
Limited Availability
£22.20
-
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

Messerschmitt Bf-108 Taifun wheels with weighted tyre effect (designed to be used with Eduard kits)(Eduard sold out December 2022)
Aircraft wheels (resin)
Limited Availability
£8.70
-
In Stock
5+