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=8093 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 77 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
Linden Hill LHB-01
Book 'Airlift to the Top of the World' (book to accompany Shorts Sunderland decals) https://www.lindenhillimports.com/lhi-blog#/ "By 1950 it had been almost forty years since a publicly funded British polar expedition had been attempted. In contrast to the days of Scott and Shackleton, it was now possible to support such a venture with both motor and air transport. The British North Greenland Expedition (BNGE), a combined scie...
Aircraft books
Catalogue
£26.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
Linden Hill LHD72039
'Arctic Sunderlands' (Shorts Sunderland GR 5 collection from British North Greenland Expedition 1951-54 for Special Hobby kits) PDF instructions (15 MB) can be dowloaded here: https://www.dropbox.com/s/tayp9nsafohfkmi/LHD72039%20edit.pdf?dl=0
Aircraft decals (military)
Catalogue
£12.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

Linden Hill LHD48019
Re-printed! Iraqi Fighters (28) Includes de Havilland Vampire FB.52; Hawker Hunter F.6; Hawker Hunter F59A; Mikoyan MiG-17F; Mikoyan MiG-21MF; Mikoyan MiG-21bis; Mikoyan MiG-23 (6); Mikoyan MiG-25R; Dassault-Mirage F.1 (2); Sukhoi Su-7BMK; Sukhoi Su-22M3; Sukhoi Su-22M4; Sukhoi Su-25K; Mikoyan MiG-25PDS; Mikoyan MiG-29; Dassault Super Etendard; [Hawker Hunter F.6/FGA.9]
Aircraft decals (military)
Catalogue
£15.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

Linden Hill LHD48033
Re-printed! Mikoyan MiG-29 9-13 (Azerbaijan, Belarus, Moldova, Russia, Turkmenistan, Ukraine, USSR, Uzbekistan). Specifically sized for the new (designed to be used with Great Wall Hobby kits) kit
Aircraft decals (military)
Catalogue
£22.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

Linden Hill LHD72030
1:72
Re-printed! VVS 100 Years - The Bombers (2 x Tupolev Tu-22m3, 3 x Tupolev Tu-95MS, 3 x Tupolev Tu-160, 3 x Sukhoi Su-34 in new Soviet markings, which flew in the 2012 birthday flypast)
Aircraft decals (military)
Catalogue
£20.99
£18.89
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

Linden Hill LHD35017
Soviet Air Forces: Armenia. Mil Mi-8MT, Mil Mi-24V or Mil Mi-24RKhR) [Mil Mi-8MT/Mi-17 Hip-H Helicopter Mi-24V/VP Mi-24V/Mi-35VP]
Aircraft decals (military)
Catalogue
£8.80
-
Out of Stock
0

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

Linden Hill LHD48018
1:48
Post-Soviet Air Forces: Georgia. Sukhoi Su-25 2007 markings, Sukhoi Su-25UB 2007 markings, Aero L-29, Aero L-39,Mil Mi-24V, Mil Mi-24P, Mikoyan MiG-21UM, Bell UH-1H Huey x2 .
Aircraft decals (military)
Catalogue
£12.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

Linden Hill LHD72035
Russian MiGs over Armenia - 2016 VVS of Russia Mikoyan MiG-29s 5x Mikoyan MiG-29 9-13, 1x Mikoyan MiG-29UB
Aircraft decals (military)
Catalogue
£16.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

Linden Hill LHD48039
1:48
Russian MiGs over Armenia - 2016 VVS of Russia Mikoyan MiG-29s 5x Mikoyan MiG-29 9-13, 1x Mikoyan MiG-29UB
Aircraft decals (military)
Catalogue
£19.40
-
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

Linden Hill LHD48011M
1:48
Sukhoi Su-27 Flanker B airframe stencils update (Recommended for using with LHD48040. Resized for Hobby Boss Su-27 kits)
Aircraft decals (military)
Catalogue
£12.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

Linden Hill LHD48040
1:48
Sukhoi Su-27 'Guardians of the North' Update (13x Arctic Su-27P, 3x Arctic Su-27UB + bonus Su-27P 'Belbek Scheme'. All decal elements, including special nose art sized for Hobby Boss Su-27 kits.14-page instruction booklet)
Aircraft decals (military)
Catalogue
£21.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

Linden Hill LHD48041
Red Stars for Russian/Soviet Sukhoi Su-27s & Mikoyan MiG-29s, 1980s to 2017 (enables modeler to use extra decal options from LHD's 1/48 Su-27 and MiG-29 sets)
Aircraft decals (military)
Catalogue
£6.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

Linden Hill LHD32018
1:32
Mikoyan MiG-23ML/MiG-23MLD stencil data
Aircraft decals (military)
Catalogue
£21.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

Linden Hill LHD48022
1:48
Post-Soviet Air Forces Turkmenistan. Mikoyan MiG-25, Mikoyan MiG-29A , Sukhoi Su-25, Mil Mi-8, Mil Mi-24
Aircraft decals (military)
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

Linden Hill LHD48029
1:48
Mikoyan MiG-23 Family full stencil data. The research for and creation of this sheet originated in Minsk and was then developed and executed in Moscow, using first-hand source materials and actual MiG-23 'Lightweight' airframes. Enough stencil data is provided to decorate the modeler's choice of one MiG-23ML, ML Export, MLA, P, MLD or MLDE variant. It is designed to complement Linden Hill Decals' various MiG-23 ML and MLD deca...
Aircraft decals (military)
Catalogue
£20.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

Linden Hill LHD72036
Mikoyan MiG-29 9-12 (12 Mikoyan MiG-29 9-12s from Eritrea, Kazakhstan, Russia/USSR and Ukraine for the new Trumpeter Mikoyan MiG-29 9-12 kits)
Aircraft decals (military)
Catalogue
£18.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

Linden Hill LHD72037
'Mikoyan MiG-29 9-13' (18 Mikoyan MiG-29 9-13s from Azerbaijan, Belarus, Moldova, Russia, Turkmenistan, Ukraine, USSR and Uzbekistan for the new Zvezda and Trumpeter Mikoyan MiG-29 9-13 kits)
Aircraft decals (military)
Catalogue
£19.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

Linden Hill LHP4801
1:48
Soviet Mikoyan MiG-29 tail fin stiffener plate modification (photo-etch to accompany LH48039)
Aircraft detailing sets (etched)
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

Linden Hill LHP7201
1:72
Soviet Mikoyan MiG-29 tail fin stiffener plate modification (photo-etch to accompany LH72035) (designed to be used with Aeroteam, Airfix, Bilek, Eastern Express, Eagle Kits, Esci, Fujimi, Hasegawa, Hobbycraft, Heller, ICM, Italeri, Kangnam Models, Kopro (ex KP), Mastercraft, Nakotna, Matchbox, Revell, Tamiya, Trumpeter and Zvezda kits)[MiG-29UB]
Aircraft detailing sets (etched)
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

Linden Hill LHD48038
1:48
Pavlov's MiGs - 2015 VVS of Russia MiG-29s http://www.lindenhillimports.com/lhd48038.htm
Aircraft decals (military)
Catalogue
£20.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

Linden Hill LHD72034
1:72
Pavlov's MiGs - 2015 VVS of Russia MiG-29s The sets feature five decal options for the MiG-29 9-13 variant and one for the MiG-29 UB. The set contains enough decal elements to use on a choice of three aircraft.
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

Linden Hill LHD32017
1:32
'Non-Aligned Mikoyan MiG-23ML/MiG-23MLDE Floggers part 2 Algeria, Angloa, Ethiopia, Free Libya and Syria.
Aircraft decals (military)
Catalogue
£21.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

Linden Hill LHD32014
1:32
International Sukhoi Su-25K The Rook Part 3 (9) Red 18 Armenia 2007; Blue 23 Azerbaijani 2009; Red 59 Gambia 2004; Black 25616 Iraq 201; White FG-501 Congo 2007; Red 02 Ivory Coast Big Shark Mouth 2004; Red 32 Russia small Shark Mouth 2004; Blue 81 Gambia; Yellow 04 Kzakha Air Force 2011; Black 203 Sudan 2009. includes two large decal sheets,
Aircraft decals (military)
Catalogue
£23.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

Linden Hill LHD48028
1:48
Brothers in Arms 1: Warsaw Pact Mikoyan MiG-23Ms and MFs 1976 - 1990 (nine marking options for Bulgaria, Hungary, Poland, Romania and the USSR)
Aircraft decals (military)
Catalogue
£20.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

Linden Hill LHD48036
1:48
Brothers in Arms 2: Mikoyan MiG-23ML/MLA/MLD/P variants in Warsaw Pact service and beyond
Aircraft decals (military)
Catalogue
£20.99
-
In Stock
4

   1   |   2   |   3   |   4      »      [4]

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