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=7939 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 56 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
Begemot BT72066
Petlyakov Pe-2... with opportunity make 108 marking variations of Pe-2 family aircraft's all types, from next AF's: VVS RKKA, Finland, Poland, Yugoslavia, Czechoslovakia, Bulgaria and Hungary. Including two big size decals, one small size decal and 23-pages booklet A4-size instruction.
Aircraft decals (military)
Catalogue
£19.40
-
In Stock
15

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
Begemot BT72069
Kamov Ka-52 - with the opportunity make 54 marking variations of Ka-52 Alligator family helicopter all types, from next AF's: Russia and Egypt. Including one big size decal, one small size decal and 11-pages instruction A3-size instruction http://www.begemotdecals.ru/doc/72-069%20Ka-52%20ins1.pdf http://www.begemotdecals.ru/doc/72-069%20Ka-52%20ins2.pdf
Aircraft decals (military)
Catalogue
£16.99
-
In Stock
9

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
Begemot BT72074
Yakovlev Yak-9 with the opportunity make 67 marking variations of Yak-9 family aircraft's all types, from next AF's: USSR. Including one big size decal, one small size decal and 11-pages instruction A3-size instruction. http://www.begemotdecals.ru/doc/72-074%20Yak-9%20ins%201.pdf http://www.begemotdecals.ru/doc/72-074%20Yak-9%20ins%202.pdf
Military vehicle decals
Catalogue
£16.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

Begemot BT72027
1:72
Sukhoi Su-27 Flankers (20) Includes `Soviet Knights' five versions and various Squadrons, most in blue, blue grey camouflage schemes
Aircraft decals (military)
Catalogue
£10.70
-
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

No Image
Begemot BT72054
Grumman F9F Panther 12 marking variations of F9F Panther from US NAVY and MARINES aviation and Argentinian naval aviation. In decal consist full stencil set for one aircraft. Including one big size decals sheet and 4-pages big size instruction. [F9F-2 F9F-2B F9F-3 F9F-5 F9F-5KD]
Aircraft decals (military)
Catalogue
£16.99
-
In Stock
15

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
Begemot BT72086
1:72
St George ribbon on the Russian tanks. St. George ribbons on armored vehicles and vehicles of the Armed Forces of Russia, a set of two different widths of two shades and stars of various designs and sizes.Including one big size decal, one standard size decal sheet.
Military vehicle decals
Catalogue
£8.99
-
In Stock
7

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

Begemot BT72047
Re-printed! Yakovlev Yak-3 family. Decal set consist from 2 big decal sheets and 8 format A3 instruction pages. Fantastic choice from 68 versions this best Soviet WW II fighter. Stencils for 3 model kits.
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

No Image
Begemot BT72068
1:72
Mil Mi-24P Decal with opportunity make 51 marking variations Mi-24P helicopter. Full stencil data for one helicopter and variouse external armament. Including two big decal sheet, one small size decal sheet and four-pages A3 instruction.
Aircraft decals (military)
Catalogue
£14.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
Begemot BT72078
Curtiss P-40 Warhawk CCCP. Decal with opportunity make 41 marking variations of Curtiss é -40 aircraft of all modication from VVS RKKA. Including one big size decals and 9-pages big size instruction. http://www.begemotdecals.ru/doc/72-078%20P-40%20in%20USSR%20ins1.pdf http://www.begemotdecals.ru/doc/72-078%20P-40%20in%20USSR%20ins2.pdf [Tomahawk Mk.IIA Mk.IIB P-40C P-40E P-40K-1 P-40N]
Aircraft decals (military)
Catalogue
£16.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

Begemot BT72012
Re-printed! Mil Mi-8 Hip (13) Soviet (5) in Afghanistan, Germany; Pakistan Army; Kyrgyzstan 2001; Egypt 1970; Egypt captured by Israel; Polar Airlines Russia 2004; Indian Air Force (2); Aeroflot;
Aircraft decals (military)
Catalogue
£5.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

Begemot BT72014
Re-printed! Mil Mi-17 Hip (13) Soviet in Russia, Germany, , Afghanistan; Iraqi Air Force 2004; Turkish Gendarmerie 2002; Afghanistan Air Force 1988 and 2004; Cuban Air Force; Mexican Navy; Czech Air Force with large mouth 1992; Heli-Harvest Australia 1999 ER-MHZ; Army of Equador 1990s; Aeroflot Barcelona 1984
Aircraft decals (military)
Catalogue
£5.60
-
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

Begemot BT72021
Re-printed! Mikoyan MiG-21 Fishbed complete stencil data for one aircraft
Aircraft decals (military)
Catalogue
£7.30
-
In Stock
3

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

Begemot BT72023
Re-printed! Tupolev Tu-160 Blackjack. Complete stencil data for one aircraft
Aircraft decals (military)
Catalogue
£7.30
-
In Stock
5

nothing for manufacturer

nothing for product_id

nothing for has_image_200

nothing for has_image_400

nothing for product_category_id

nothing for product_division_id

nothing for scale

nothing for real_arrival_date

nothing for product_type

nothing for filename

nothing for stock_level

nothing for stock_committed

nothing for backorders

nothing for free_backorders

nothing for department_id

nothing for future

nothing for unixtime

Begemot BT72076
Re-printed! Sukhoi Su-33 in Syria. Su-33 from Soviet Naval Aviation in Syria. 10 markings scheme - any Su-33s aircraft, which took a part in Admiral Kuznetsov carrier mission in Syria. In decal include insignias, board numbers, badges and mission marks. Attention! In this decal set not include stencil for aircraft and external armament, please use our decal 72-030 "Su-27 family full stencil".
Aircraft decals (military)
Catalogue
£8.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
Begemot BT72080
Russian VKS board numbers and signs (type 2018)
Aircraft decals (military)
Catalogue
£16.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
Begemot BT72083
MiG pink sealant. mitation of pink supersonic selalnt, which use in Mikoyan MiG-25, Mikoyan MiG-31, sometimes in other types of aircraft. Three different thikness of lines, two shades of pink colours. Including one standard size decal sheet, there is no instruction.
Aircraft decals (military)
Catalogue
£5.60
-
In Stock
9

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

Begemot BT72063
1:72
New life of Foxhound - Mikoyan MiG-31BM + MiG-31K (Kinzhal) New life of Foxhound - MiG-31BM + K Decal with opportunity make 28 marking variations of MiG-31BM(BSM) and MiG-31K (Kinzhal) from Russian Air and Space Forces.In decal consist full stencil set for one aircraft and all possible external armament. Including two big size decals sheet and 6-pages big size instruction.
Aircraft decals (military)
Catalogue
£14.99
-
In Stock
9

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

Begemot BT72067
Sukhoi Su-34 Decal with opportunity make all known at now days Su-34s - prototypes and all Su-34s from the Russian Air Force, include aircraft from RuAF group in Syria with mission markings. Full stencil set for one aircraft and fill complect of external armament. Including two big size decals sheet, two small size decal sheet, 8-pages big size instruction and 1 pages small size instruction.
Aircraft decals (military)
Catalogue
£19.40
-
In Stock
7

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

Begemot BT72034
1:72
Mikoyan MiG-29SMT. You can choose any known aircraft from Algerian or Russian Air Force Also includes full stencil set for one aircraft and any external armament for MiG-29SMT.
Aircraft decals (military)
Catalogue
£8.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

Begemot BT72071
1:72
Yakovlev Yak-130 'Mitten' Decal for all known Yak-130s from Russian, Belarusian, Algerian, Myanmar and Bangladesh Air Force. Full stencil set for one aircraft (in any marking scheme), all possibile external armament, also included pyrotechnic cords for canopy of aircraft.
Aircraft decals (military)
Catalogue
£8.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

Begemot BT72075
USSR Air Force insignia, type 1955. Decal set with seven different sizes of USSR Air Force insignia (type 1955), for all main types of RuAF aircrafts and helicopters. Including two big size decals and 2-pages A3-size instruction.
Aircraft decals (military)
Catalogue
£10.70
-
In Stock
9

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

Begemot BT72064
1:72
Mil Mi-24V/Mi-24VP/Mi-24R and Mi-24K. Decal includes 36 marking scheme for helicopters from different countries, also include full stencil set for one helicopter and any types of external armament. Including one big decal sheet, one standard size decal sheet and four-pages A3 instruction.
Aircraft decals (military)
Catalogue
£8.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

Begemot BT72073
1:72
Tupolev SB-2 (Hight Speed Bomber). 40 marking schemes for different modifications of SBs from VVS RKKA, Republic of Spain and China Air Forces. Including one big decal sheet, one small size decal sheet and instruction.
Aircraft decals (military)
Catalogue
£8.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

Begemot BT72015
1:72
Mikoyan MiG-25P/MiG-25PD/MiG-25PDS/MiG-25PU/MiG-25RB/MiG-25RBF/MiG-25BM Foxbat (23) USSR, Algeria, Syria, Libya; Ukraine, Egypt, Bulgaria, Iraq, India; Natural Metal and Camouflage Schemes. Revised with 10 additional schemes
Aircraft decals (military)
Catalogue
£5.60
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

Begemot BT72061
Sukhoi Su-24M in Syria
Aircraft decals (military)
Catalogue
£8.99
-
In Stock
5

   1   |   2   |   3      »      [3]

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