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=352984 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 38 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
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
Flightpath UK FHP32201
Panavia Tornado Ladder with Top Platform This kit builds the 'RAF Germany' fighter style access ladder which appeared later than the 'boarding style' steps we also produce. The top platform featuresraised surrounds to all the detailing, together with the structure on the under-side of the top platform.
Diorama accessories (etched)
Catalogue
£11.99
-
In Stock
14

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
Flightpath UK FHP32202
RoyalNavy/Fleet Air Arm Wheel Chocks This set provides four of these characteristic chocks - they are a straightforward fold up etched unit with wire, chain & pull-rope included. These are ideal for all your FAA displays for a long period and can be seen with aircraft from the 1950s to the 1990s, including helicopters, such as the Wessex.
Diorama accessories (etched)
Catalogue
£5.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

No Image
Flightpath UK FHGS3251
US Navy Missile Trolleys - set of THREE - missiles not included. This boxed set provides three super-detailed trolleys with a range of missile cradles. They are intended for use with the various missiles in either the Gunsmoke Range from Flightpath or other weapons from your own kits etc. There are options to make up to two trolleys configured to carry AIM-7 [Sparrow] or AIM-120 [AMRAAM] missiles, and one of the trolleys confi...
Diorama accessories (etched and metal)
Catalogue
£34.40
-
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

Flightpath UK FHGS3235
AN/ALQ ECM Pod (Deep Config) (Fairchild A-10/McDonnell F-4G Phantom /Lockheed-Martin F-16)
Aircraft detailing sets (resin)
Catalogue
£8.50
-
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

Flightpath UK FHGS3202
Grumman F-14 Tomcat Chin Pod Set. Two super-detailed resin units - one for the AN/AXX-1 TCS unit fitted to earlier F-14 marks PLUS the twin unit fitted to F-14Ds. Please Note - we cannot split this set (designed to be used with Revell, Tamiya and Trumpeter kits)
Aircraft detailing sets (resin)
Catalogue
£8.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

Flightpath UK FHGS001D
1:32
McDonnell F-4G Wild Weasel chin pod (designed to be used with Revell F-4E/F-4F kits)
Aircraft detailing sets (resin)
Catalogue
£4.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

Flightpath UK FHGS3250
U.S. Navy Carrier Deck Section (For use with the Flightpath/Gunsmoke U.S. Navy Carrier deck Diorama set) This pack contains approx 430 x 280mm of deck section with fold down side walls making a neat display base. All the correctly spaced location holes are included for 20 aircraft tie down points and are matched to the cast tie-down points provided in our USN Deck Set (above), which will fit out one of these deck section units...
Diorama accessories (etched)
Catalogue
£36.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

Flightpath UK FHP32010C
1:32
RAF Maintenance Set - Contains three superbly-detailed Aircraft Jacks in cast metal and etched brass [great for use with the Revell BAe Hawk T.1 kits], together with an RAF General Step Ladder, and an Airfield Storage Bin (designed to be used with Revell kits)
Diorama accessories (resin)
Catalogue
£17.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

Flightpath UK FHP32010J
1:32
PSP Airfield Planking - Contains 28 clip-together etched sections - enough to display a WWII fighter aircraft - but is also ideal for use in a early-period BAe Harrier field-deployment setting
Diorama accessories (etched)
Catalogue
£15.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

Flightpath UK FHP32007F
1:32
Sky Shadow ECM Pod. As carrier on the port outer wing pylon of RAF Tornadoes. Super Detailed unit in injection resin. The kit/s that are currently available do not include this item, thus creating a difficulty for modellers of RAF machines.
Aircraft detailing sets (resin)
Catalogue
£11.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

Flightpath UK FHP32007J
1:32
AIM-9 Acquisition Rounds. This set contains two super detailed units in resin with cast metal launch rails & safety caps and details in etched nickel silver. These are ideal for your Hawks and also Harriers and other types The release of these is tied in with that of our Hawk AIM-9 Acquisition Round Trolley kit [converted ex-Hunter Gun Pack Trolley]. This set is supplied with rail/pylon units and safety caps. (designed to be u...
Aircraft detailing sets (resin)
Catalogue
£15.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

Flightpath UK FHGS3207
1:32
Boeing/Hughes AH-64A Apache Detail Set A photo-etched/resin/cast metal set to detail and update the Revell kit, including cockpit update parts, seat straps, rotor, undercarriage and airframe detailing - incl. cable cutters, 'Disco' light, aerial updates and chaff/flare dispenser. New wheels are included, together with rocket pod details. No less than eight super-detailed Hellfire missiles are supplied in injection-resin, toge...
Aircraft detailing sets (etched and resin)
Catalogue
£31.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
Flightpath UK FHP32003C
1:32
RAF BAC/EE Lightning Display Set - (designed to be used for Trumpeter kits) This set is specifically for use with either of the Trumpeter kits. In etched nickel silver and cast metal, It provides an accurate Access Ladder, detailed FOD Guard with full rivet detail and attachment parts, TWO Missile Handling Trolleys and beautifully detailed Running-up Screen for missile alignment testing.... [BAC/EE Lightning F.1A/F.3 BAC/EE L...
Aircraft detailing sets (metal)
Catalogue
£27.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

Flightpath UK FHP32005C
1:32
RAF/Royal Navy Hawk T1/T.1a Access Ladder/Work Platform & FOD Guard Set. This is a beautifully detailed kit in etched nickel silver and cast metal to make the very distinctive ladder/platform with the integrated wire storage bin included. The set also includes a full set of intake and tail pipe FOD guards (designed to be used with Revell kits) [BAe Hawk T.1]
Diorama accessories (metal)
Catalogue
£16.50
-
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

Flightpath UK FHP32051
Panavia Tornado /Eurofighter 48kVA Ground Power unit (etched and metal parts) (designed to be used with Revell and Trumpeter kits)
Diorama accessories (metal)
Catalogue
£23.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

Flightpath UK FHGS3221A
AIM-7F/AIM-7M/AIM-7P Post-Vietnam Sparrow III Missiles- two super-detailed units in resin and photo-etched brass - used with McDonnell F-4 Phantom, F-14 Tomcat, McDonnell F-15C Eagle, McDonnell F-15E Strike Eagle, Lockheed-Martin Lockheed-Martin F-16 Fighting Falcon, McDonnell-Douglas F/A-18 Hornet [FP-GS-015c]
Aircraft detailing sets (resin)
Catalogue
£10.80
-
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

Flightpath UK FHP32007B
1:32
RAF 1,000lb/CPU-123b Laser-Guided Bombs - two super-detailed units, with correct inner fin, and fuse vane detail, together with hollow cast seeker head units, used on Panavia Tornado, Eurofighter and Harrier
Aircraft detailing sets (resin)
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

Flightpath UK FHP32010A
1:32
RAF Diorama Set - for displaying your modern RAF aircraft in an operational setting - this set contains two fire extinguishers, two tow-bars, 6 earlier pattern sprung wheel chocks, 6 current style rubber wheel chocks, a wire storage bin, a maintenance ladder, 'Aircraft Armed' signs and 12 'Remove Before Flight' tags in two different sizes
Diorama accessories (resin)
Catalogue
£30.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

Flightpath UK FHP32010B
1:32
RAF Oxygen/Nitrogen Trolley - a super-detailed unit in cast metal and etched brass with alternative parts for both versions. This is an essential item for all your Hawker Hunter, Lightning, Phantom, BAe Hawk T.1 and Panavia Tornado displays
Diorama accessories (metal)
Catalogue
£23.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

Flightpath UK FHP32010E
1:32
RAF 25kVA Ground Power Unit - this is the unit alongside virtually every Lightning McDonnell Phantom and Harrier. This is a super-detailed kit in etched brass and cast metal with a pre-formed body and fittings to our usual standard,
Diorama accessories (metal)
Catalogue
£23.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

Flightpath UK FHP32006
1:32
Panavia Tornado or Eurofighter EF-2000 Typhoon Boarding Ladder (designed to be used with Revell kits)
Aircraft detailing sets (etched and metal)
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

Flightpath UK FHP32006B
1:32
Panavia Tornado Flaps, Slats and Spoilers Set (designed to be used with Revell kits)
Aircraft detailing sets (mixed-media)
Catalogue
£40.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

Flightpath UK FHP32001
RAF Bloodhound Mk.2 SAM Missile and Launcher
Military vehicle kits (resin)
Catalogue
£134.30
-
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

Flightpath UK FHP32103
1:32
Panavia Tornado 2250 Litre 'Hindenburger' Fuel Tanks [Pair] Vacform with etched finsc.
Aircraft detailing sets (resin)
Catalogue
£20.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

Flightpath UK FHP32003
1:32
RAF Hawker Hunter FGA.9/F.58 detail set. Large etched set for the Revell kit, as supplied - features cockpit details, instrument dial films, Mk.2 ejector seat parts, new wheel bay, undercarriage, air brake & wing flap detailing [including fuel tank cut-out versions], plus many other items, including some cast fittings. Includes our new colour-coded instructions (designed to be used with Revell kits)
Aircraft detailing sets (resin)
Catalogue
£33.70
-
In Stock
4

   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