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=355162 AND ps.id = 956 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 43 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
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
Starfighter Decals SFDR7212
Grumman F7F-3 Tigercat Wheel Wells. Designed for the Monogram F7F-3 Tigercat kit. The Monogram (also released by Revell of Germany) is a very nice kit, but missing it's "guts". This set addresses the lack of wheel wells, sorely needed for this kit Set includes both the Nose and Main gear bays. Modifications to kit parts required for installation. Instructions and painting guide included. NOTE! Part 2 listed is not missin...
Aircraft detailing sets (resin)
Catalogue
£14.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
Starfighter Decals SFDR7213
Douglas SBD-1 Dauntless Conversion. Plug and play replacement part to convert the 1/72 Hasegawa A-24 kit to the SBD-1. Instructions to convert the SBD-3 to the SBD-1 included. Decals sold separately SFD72138 Contains 1 part (but it's a big one!)
Aircraft conversions (resin)
Catalogue
£5.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
Starfighter Decals SFD72167
Early Wildcats Set provides markings for 3 Pre War including 2 Yellow Wings and 5 War time F4F-3s. Markings include the "Bomber a Minute" O'Hare aircraft with the correct markings (not the press photo widely circulated after the mission) , First USN Wildcat Kill; 2 aircraft from the Battle of Coral Sea; and an aircraft flown by Jimmy Thatch.
Aircraft decals (military)
Catalogue
£11.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

No Image
Starfighter Decals SFD72168
USN SBD Dauntless Pt.1 Sheet has markings for 17 different SBD-2/3 in service in the Pacific from the early days of the Pacific campaign. Planes from Coral sea, Midway, Hit & Run raids and the Guadalcanal campaign included. Bonus Pre-war markings for Air Group 5 and Air Group 6 (not Yellow Wings- sorry). Set has 2 sheets as an errata sheet had to be printed. Sadly , only side placement guide included. Placement guides ha...
Aircraft decals (military)
Catalogue
£14.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

No Image
Starfighter Decals SFD72169
USAAC B-10 & B-12 (designed to be used with Special Hobby kits)
Aircraft decals (military)
Catalogue
£17.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

Starfighter Decals SFDR7200
Boeing F4B-4 cockpit detail set (designed to be used with Accurate Miniatures and Monogram kits)
Aircraft detailing sets (resin)
Catalogue
£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
Starfighter Decals SFDR7216
R-1535-B Series Twin Wasp 14 cy. Radial Engine 7216 1 piece resin part. Suggested use for the following aircraft: SB2U series, both USN and export versions SBC-3 Helldiver A-17 Series (A-17, A-17A) BT-1 Bristol Bollingbrook (2x) Boeing Model 247 (2x) F2F-1 F3F-1
Aircraft engines and propellers (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

No Image
Starfighter Decals SFDR7223
R-1820G Engine Resin cast replacement or upgrade engine for your scratch builds or replace the basic kit part from 60-90's era model kits. Recommended uses: SBD-5/6 B-17F/G and variants General-Motors FM-2 Martlet 1 & IV Late DC-3 DC-5 Curtiss SC-1 Seahawk Ryan FR-1 Fireball This is just a few better known WWII era aircraft that used this engine. Note: Back of the cylinder heard are pre-drilled for the exhaust.
Aircraft engines and propellers (resin)
Catalogue
£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

Starfighter Decals SFDPE01
Boeing F4B-4 EZ Rigging (designed to be used with Monogram kits)
Aircraft detailing sets (etched)
Catalogue
£7.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

Starfighter Decals SFDPE03
Curtiss P-6E 'Hawk' EZ Rigging (designed to be used with Monogram kits)
Aircraft detailing sets (etched)
Catalogue
£7.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

No Image
Starfighter Decals SFD72164
Martin B-10B's in USAAC service Designed for either the Williams B-10 or the FROMM (made by Special Hobby) B-10B kits. Markings for 2 complete aircraft included. 12 different sets of markings for US Army Air Corps B-10s in service both stateside and in overseas territories. Units include the 5th BS, 7th OS, 25th BS, 1st BS, 11BS, 31st BS, 96th BS, 94th PS, 27th PS, 28th BS, and HQ 7th BG. Olive 22/Yellow 4 schemes, Blue 23/Y...
Aircraft decals (military)
Catalogue
£14.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

No Image
Starfighter Decals SFD72165
Curtiss P-40B/C/G in USAAF service For the Airfix Curtiss Hawk 81-A-2/P-40B kit. Markings for 9 different P-40B/C/G aircraft, including the 2 Pearl harbor Defenders. Also included in the mix are markings for a Philippine Defender, a P-40C in an ASW paint scheme, and 3 in colorful pre-war markings from the 20th Pursuit Group. Markings for 3 complete aircraft included. Placement guide is in full color as well with builders ...
Aircraft decals (military)
Catalogue
£11.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

No Image
Starfighter Decals SFD72166
Grumman TBF-1 Avengers Markings for 7 different TBF/TBM-1 Avengers from both the Atlantic and Pacific including the aircraft from Midway, Operation Torch, Guadalcanal campaigns, a Training unit, and even a "Movie Star"
Aircraft decals (military)
Catalogue
£11.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

Starfighter Decals SFDR7202
1:72
Re-released! Curtiss SBC-4 Helldiver upgrade cockpit detail set (designed to be used with Heller kits)
Aircraft detailing sets (resin)
Catalogue
£12.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

Starfighter Decals SFD72161
1:72
Fortress of the Sky Part 2 Boeing B-17B/C Flying Fortress (designed be used with the Academy kits) Sheet two in the the part series of Early B-17s. This covers B-17C and D models. Markings for 6 different aircraft. 2 Natural Metal birds, 3 OD over Neutral Gray birds, and a Hawaiian Depot scheme. Marking for 2-3 aircraft depending on schemes chosen. Planes from Hawaii, Philippines, CONUS, and one of the B-17s from Pearl Harbor ...
Aircraft decals (military)
Catalogue
£14.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

Starfighter Decals SFD72153
1:72
Operation Torch 1942. Markings for Grumman F4F-4 Wildcats, TBF-1 Avengers, Douglas SBD-3 Dauntless, Curtiss SOC Seagull, and a Piper L-4A Cub
Aircraft decals (military)
Catalogue
£11.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

Starfighter Decals SFD72154
Operation Leader Oct 1943. Set of three markings for the Aircraft from the USS Ranger that participated in Operation Leader, an Allied operation against German shipping in Norway above the Arctic Circle. It was USS Ranger's last War Time cruise. Decals are provided for 3 different F4F-4 Wildcats in what was a rare combination of USN 3 (Actually 4) Tone camouflage scheme and red outlined National Insignia, an SBD-5 Dauntles...
Aircraft decals (military)
Catalogue
£5.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

Starfighter Decals SFD72159
1:72
Grumman Wildcats at Midway. For Airfix and Hasegawa kits. Markings for 5 USN F4F-4 Wildcats and 2 USMC F4F-3 Wildcats. Markings for Thatch, Brassfield and McCluskey from VF-3, Byers from VF-6, Groves from VF-8, and Carl and Corry from MAG-22
Aircraft decals (military)
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

Starfighter Decals SFD72157
1:72
Forgotten Fords Douglas F4D-1 Skyrays Sheet covers 4 F4D-1s: VF-23; VF-141; VMF(AW)-314; and VFM(AW)-542 Designed for the Tamiya kit. May work on the ancient Hawk/Testors and MPC/Airfix kits
Aircraft decals (military)
Catalogue
£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

Starfighter Decals SFD72158
1:72
Boeing PT-13/N2S-3 Stearman PT-17/N2S-5 Kaydet. For the Revell 1/72 kit that is in and out of production for the last 50 years, last issued as kit # RV4676. Generic markings to build a variety of PT-13/17/27 and N2S-3/5 Primary Trainers. Many examples are provided in the instructions.
Aircraft decals (military)
Catalogue
£11.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

Starfighter Decals SFDR7222
1:72
Boeing PT-13/Stearman PT-17/N2S-3/N2S-5 Stearman Cockpit set (designed to be used with the Revell Stearman kits) Can be used for either the PT-13, Stearman PT-17, PT-27, N2S-3, and N2S-5 versions of this aircraft. Set comes with 10 resin parts. Ssuggest the YuHu Cockpit Instrument panels
Aircraft detailing sets (resin)
Catalogue
£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

Starfighter Decals SFD72156
1:72
NOTS Douglas Skyray F4D-1. Markings for one aircraft. This was one of the prototype F4D-1 updated to operational status. "747" was used with the NOTSNIK program as the launch platform.
Aircraft decals (military)
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

Starfighter Decals SFDR7217
R-1340-17/27 Engine. Contains 1 engine. Resin casting. The US R-1340-17/27 was widely ... USAAC P-26, P-12C/D/E, O-52. USN F3Bs, F4Bs, F7Cs, O2U and O3U Corsairs.
Aircraft engines and propellers (resin)
Catalogue
£5.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

Starfighter Decals SFDR7220
1:72
R-1830 Twin Wasp Radial Engine. 2 part replacement engine that can be used for many different aircraft: P-36s; F4F Wildcats; PBY; PB4Y; B-24; C-47A; P-43; PB2Y; Short Sunderland; Vickers Wellington, and so many more
Aircraft engines and propellers (resin)
Catalogue
£7.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

Starfighter Decals SFDR7221
1:72
NOTSNIK Launch Vehicle. 16 part Grey resin kit. Color assembly and painting guide included. The USN air launched orbital platform that was later developed into an ASAT Platform. Called Project Pilot at it's beginning, later it earned the nickname NOTSNIK, like sputnik. This is a multi-part resin kit with the launch Pylon that was used on F4D-1 Skyrays, the airborne launch vehicle. Program was cancelled due to pressure from ...
Aircraft conversions (resin)
Catalogue
£17.50
-
In Stock
5

   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