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 ps.id = 955 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 30 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

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

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 LHD48037
Afgantsi: Soviet VVS Mikoyan MiG-23MLDs in Afghanistan
Aircraft decals (military)
Catalogue
£20.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 LHD48024
1:48
Sukhoi Su-25K Frogfoot Foreign (10) Red B-605 Angola 1994; White 39 Belarus 2010; White 8074 Slovakia 1995; Blue 14 Turkmenistan 2011; Red 44 2008 or Red 05 2001 Russia; Red 17 1998 or Blue 16 2008 Georgia; White 195 1987 Star National Insignia or White 246 2010 Roundel Insignia both Bulgaria. All different camouflage schemes.
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 LHD48035
Mikoyan MiG-21PFM: Brothers in Arms 4 Russia, Afghanistan, Czechoslovakia, Bulgaria, East Germany GDR, Mongolia, Romania
Aircraft decals (military)
Catalogue
£20.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 LHD48034
1:48
Belarusian Flankers (Sukhoi Su-27s of the 61st Fighter Air Base, Baranovichi)
Aircraft decals (military)
Catalogue
£14.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 LHD48031
1:48
Mikoyan MiG-21SM combat veterans of Azerbaijan (limited edition of 100 sets)
Aircraft decals (military)
Catalogue
£7.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 LHD48032
1:48
Mikoyan MiG-29 9-12 (Eritrea, Kazakhstan, Russia, Ukraine, USSR) (designed to be used with Great Wall Hobby kits)
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 LHD48025
1:48
International Sukhoi Su-25K The Rook Part 2 (9) Black TT-9AO Chad 2010; White 029 Equatorial Guinea 2009; Red 59 Afghanistan 1986; Grey 122 Macedonia Air Force 2001; Blue 01 and Blue 10 Ukranian AF; White 35 Uzbekistan AF2009; Black 54 Iran 2008; Blue 22 Russia 2005.
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 LHD48026
1:48
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.
Aircraft decals (military)
Catalogue
£20.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 LHD48027
1:48
Mikoyan MiG-21R Fishbed in Warsaw Pact Service (12) Red 01 USSR 1968; Red 532 Germany GDR 1973; Red 709 Star National Insignia or Red 9612 Roundel 1995 both Romania; Red 9512 or Red 9309 Star National Insignia or Red 4405 Chevron Insignia all Hungary; Red 52 or Red 613 Star National Insignia or White 021, White 55 or White 177 Roundel Insignia all Bulgaria. Variety of camouflage schemes.
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 LHD48023
1:48
Sukhoi Su-27 Flankers and Mikoyan MiG-27D Floggers. Kazakhistan Snow Leopards of the Seven Rivers (12) Flanker B and C, Yellow 01, 02, 03, 04, 05, 10,51, 53; Flogger Yellow 64, 30, 36, 44. All numbers are yellow outlined red. Variety of camouflage schemes.
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 LHD48014
1:48
Lipetsk Top Guns - The Aircraft of the Soviet Air Force's elite 4. TsBP PLS (15) Sukhoi Su-27SM; Red 02; Sukhoi Su-25T; Red 85; Sukhoi Su-25; Red 73; Mikoyan MiG-29 9-13; Red 29; Mikoyan MiG-29 9-13; Red 32; Mikoyan MiG-29 9-`Sukhoi Su-27S; Red 08 `Lipetsk Shark'; Sukhoi Su-27S; Red 01. Bonus options for Mikoyan MiG-29; Mikoyan MiG-29UB [Su-25K]
Aircraft decals (military)
Catalogue
£24.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 LHD48021
1:48
Post-Soviet Air Force Azerbaijan AF. Mil Mi-8T Hip 4K-25-93; Mi-24G Super Hind No 302; Mi-24V and P Hind 102 and 172; MiG-25P, PDS, RU; Su-24MR 101 or 111; MiG-29 'Fulcrum' C 01MiG-29UB 'Fulcrum' B 20; Aero L-39 Albatross 25; Su17M3 Fitter 81; Sukhoi Su-25 and Su-25UB Frogfoot 28, 24, 39
Aircraft decals (military)
Catalogue
£18.99
-
In Stock
2

   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