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.price_set = 1 
		 AND P.product_category_id = 102 
		AND pc.show_in_search = 1

	 AND (P.product_category_id = 103 OR P.price_set) GROUP BY P.id ORDER BY DATE(P.arrival_date) desc, P.code
Catalogue | Hannants
Hannants News Feed Subscribe To This Search | Create Search Alert Create Search Notification

Catalogue



Found 6,933 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

Quickboost (by Aires) QB32192
1:32
Supermarine Spitfire Mk.IXC exhaust -fishtail (designed to be used with Revell kits)
Aircraft exhausts (resin)
Catalogue
£6.60
-
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

Quickboost (by Aires) QB32193
1:32
Supermarine Spitfire Mk.IXC exhaust -oval type exhaust (designed to be used with Revell kits)
Aircraft exhausts (resin)
Catalogue
£6.60
-
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

Berna Decals BER32049
1:32
Cessna L-19E in French service : 24-589 code AQI - AĮ'"n-Sefra Algeria 1958, 24-572 code AME - Biskra Algeria 1962, 23-311 code AQJ - Toussus-le-Noble 1973, 24-526 code BPN - Pau 1967, 24-566 code KBP - Djibouti 1981, 24-567 code CMN - Montpellier 1981, 24-572 code BVW - Berlin 1993, 24-578 code BCM - Dax 1978. [Cessna L-19/O-1 Bird Dog]
Aircraft decals (military)
Catalogue
£15.40
-
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

CMK/Czech Master Kits CMQ32283
1:32
IAR IAR-80A/IAR-81 Mid Production Mainwheels This set offers anti-slipping tread pattern mainwheels with nicely detailed hubs Created using 3D. (designed to be used with Frrom and Special Hobby kits)
Aircraft wheels (resin)
Catalogue
£4.70
-
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

HPH Models HPH32045R
Grumman F7F-3P Tigercat primary parts and details made from resin assembly instructions printed clear resin canopies and transparencies metal reinforcements in highly-stressed resin parts photo-etched parts decals Wet Transfer HGW, masks laser-cut textile safety belts HGW
Aircraft kits (resin)
Catalogue
£314.99
-
In Stock
1

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

Master MR32-070
1:32
Mikoyan MiG-17PF (Fresco D) - 23mm gun barrels set & Pitot Tubes (designed to be used with Trumpeter kits)
Aircraft detailing sets (brass)
Catalogue
£8.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

Eduard ED33180
1:32
Vought F4U-1D Corsair seatbelts STEEL (designed to be used with Tamiya kits)
Aircraft detailing sets (etched)
Catalogue
£5.30
-
In Stock
5

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

Eduard EDJX206
Focke-Wulf Fw-190A-8 canopy frame paint mask (designed to be used with Revell kits)
Aircraft paint masks (self adhesive)
Catalogue
£7.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

Eduard EDJX207
1:32
Vought F4U-1D Corsair canopy frame paint mask (designed to be used with Tamiya kits)
Aircraft paint masks (self adhesive)
Catalogue
£7.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

AOA Decals AOA32023
1:32
VA-65 TIGERS (1) USN Grumman A-6A/A-6E Intruders in the Vietnam War & the Cold War This sheet and 32-024 span 25 years of the A-6 Intruder in service with one Navy squadron - VA-65 Tigers - from Vietnam to Desert Storm, including the ill-fated 1967 Forrestal flight deck explosion and fire distast and their more well known markings from the 1970s. This part 1 sheet covers the earlier high visibility period of the A-6A in the m...
Aircraft decals (military)
Catalogue
£24.50
-
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

AOA Decals AOA32024
1:32
VA-65 TIGERS (2) USN Grumman A-6E TRAM Intruders in the Cold War & Desert Storm This sheet and 32-023 span 25 years of the A-6 Intruder in service with one Navy squadron - VA-65 Tigers - from Vietnam to Desert Storm, including the ill-fated 1967 Forrestal flight deck explosion and fire distast and their more well known markings from the 1970s. This part 2 sheet covers the later low visibility period of the A-6E TRAM in the ea...
Aircraft decals (military)
Catalogue
£19.50
-
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

Kits-World KW132120
1:32
North-American P-51D Mustang 44-15611 PZ-H 'Diablo' , Pilot: Lt Glenn W Wensch, 486th FS, 352nd FG. Bodney, Norfolk 1943. Also 363rd FG 9th AF. P-51D-25-NA Mustang 44-72671 'The Enchantress', Pilot: Lt. William Saks, 457th FS, 506th FG North Field, Iwo Jima June 1945.
Aircraft decals (military)
Catalogue
£10.20
-
In Stock
4

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

Kits-World KW132121
North-American P-51D-10-NA Mustang 44-14361 WD-K 'Fiesty Sue', Pilot: Lt. Darwin L Berry. 335th FS 4th FG Debden, March 1945. P-51D Mustang 44-72346 QP-K 'Lil Aggie', Pilot: Lt. Michael J 'Mike' Kennedy, 334th FS, 4th FG, Debden, England.
Aircraft decals (military)
Catalogue
£10.20
-
In Stock
4

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

Kits-World KW132122
1:32
North-American P-51D Mustang 44-15052 PI-J 'Lullaby for a Dream' Pilot Lt. James A Hickey. 360th FS, 356th FG, Martlesham Heath, 1945. P-51D Mustang 44-63195 G4-K 'MARYMAE' , Pilot: Lt. Richard 'Rip' Potter, 362nd FS, 357th FG.
Aircraft decals (military)
Catalogue
£10.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

New Ware NWAM0290
1:32
Lockheed-Martin F-16C Fighting Falcon BASIC (designed to be used with Academy kits). kabuki masks aircraft canopy, all other clear parts, wheels
Aircraft paint masks (self adhesive)
Catalogue
£6.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

New Ware NWAM0291
1:32
Lockheed-Martin F-16C Fighting Falcon ADVANCED (designed to be used with Academy kits) kabuki masks aircraft canopy including frames, all other clear parts, wheels, weapons, camouflage
Aircraft paint masks (self adhesive)
Catalogue
£8.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

New Ware NWAM0292
1:32
Lockheed-Martin F-16C Fighting Falcon EXPERT (designed to be used with Academy kits) Kabuki masks aircraft canopy including frames and inner side masks, all other clear parts, wheels, weapons, camouflage
Aircraft paint masks (self adhesive)
Catalogue
£10.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

Xtradecal X32047
1:32
RAF Code Letters and Numbers 30' m/s/grey Double sheet
Aircraft decals (military)
Catalogue
£7.99
-
In Stock
50++

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

Eduard Brassin ED632090
1:32
de Havilland Mosquito FB Mk.VI engines (designed to be used with Tamiya kits) Brassin set of engines Mosquito FB Mk.VI in scale by Tamiya. Set includes left and right engine with cowling. Set contains: resin: cca 120 parts decals: no photo-etched details: yes painting mask: no
Aircraft engines and propellers (resin)
Catalogue
£54.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

Yahu Models YMA3224
1:32
Mitsubishi A6M2 Zero Mitsubishi Green (designed to be used with Tamiya kits)
Aircraft detailing sets (etched)
Catalogue
£8.30
-
In Stock
5+

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

Yahu Models YMA3225
1:32
Heinkel He-162A-2 'Salamander' (designed to be used with Best Model (MPM) and Revell kits)
Aircraft detailing sets (etched)
Catalogue
£6.10
-
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

Yahu Models YMA3226
1:32
Curtiss P-40N Warhawk early (N-1 to N-5) (designed to be used with Eduard kits and Hasegawa kits)
Aircraft detailing sets (etched)
Catalogue
£8.30
-
In Stock
5

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

Quickboost (by Aires) QB32045
1:32
Sukhoi Su-27 Flanker B pitot tube (designed to be used with Trumpeter kits)
Aircraft detailing sets (resin)
Catalogue
£4.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

Scale Aircraft Conversions SAC32117
1:32
Sopwith F.1/2F.1 Camel Landing Gear (designed to be used with Wingnut Wings kits)
Aircraft detailing sets (metal)
Catalogue
£17.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

Eagle Cal EAG32172
Messerschmitt Bf-109G-6 "Red (or Black) 7" 2./JG 302 Jƒ¯é¿é½terbog February 1944 Pilot: Xaver Neumeier W. nr. Unknown "Blue 17" 12./JG 2 Beaumont le Roger, France 1943 "White 3" 1./JG 300 Wildesau Spring 1944 "White 11" Bf-109 G-6/R6 7./JG 54 Spring 1944
Aircraft decals (military)
Catalogue
£24.50
-
In Stock
5+

[1]   «      169   |   170   |   171   |   172   |   173      »      [278]
-100 -50 -20 -10 | +10 +20 +50 +100

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