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

1:72
Potez 25 A2/B2 Lorraine. Widely used and exported. Decals for four planes: RF-22 in Aĩronautique Militaire (French Navy), Rochefort, France, 1938 - White 6, Polish Air Force, Poznan, Poland, 1932 - Nr 211, Rumanian Air Force, 1934 - Aircraft in French Indochina captured by the Japanese in March 1945, sent to Thailand when the Japanese forces surrendered, Don Muang (Thailand), Autumn 1945.
Aircraft kits (injection)
Catalogue
£34.99
£31.49
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

Rogozarski IK-3 'Belgrade Defence' History: In 1941, the IK-3 is the most advanced locally built Yugoslav fighter. Designed by engineers Ilic and Sivcev, the IK-3 prototype make her maiden flight on April 14th, 1938. An initial order of 12 planes follows the very satisfying trials. First batch of 6 IK-3 is delivered during March 1939 (Nr 2 to 7, big wheel doors), second batch in July 1940 (clipped wheel doors). All are used ...
Aircraft kits (injection)
Catalogue
£15.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

Rogozarski IK-3 'Fighting Prototypes In 1941, the IK-3 is the most advanced locally built Yugoslav fighter. Designed by engineers Ilic and Sivcev, the IK-3 prototype make her maiden flight on April 14th, 1938. After the crash of the prototype on 19th january, 1939, the nƒšé°2 is used as prototype. The planes are delivered in March 1939 (nƒšé°2 to nƒšé°7) and Juiy 1940 (nƒšé°8 to 13), all being used by Grupa 51 in Zemun airfiel...
Aircraft kits (injection)
Catalogue
£15.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

Stampe & Vertongen S.V.4 Aerobatics Decals for four planes: F-BDGI single-seat, Marcel Charollais ' S.V.4a (yellow and red) Same plane without letters F-BDGI, with red arrows on top of upper wing (please see box art) F-BDNM, a S.V.4a at St-Yan (black 9), nƒ¯é¿é½668 D-EEFB, S.V.4c in Germany (white and red) History: The Stampe et Vertongen S.V.4 is probably one of the Belgian aeronautical industry's most outstanding...
Aircraft kits (injection)
Catalogue
£16.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

Breguet 1050 Alize 1G India Nr 78, IN206, INAS 310 "White Cobras", INS Vikrant carrier, beginning of 70. Nr 67, IN204, INAS 310 "White Cobras", INS Vikrant carrier, 1985. The 24 stars on fuselage are for the years in service. IN203, INAS 310 "White Cobras", December 1971, 10 (Gujrat). With an extra sprue for weapons (2 AS.12 wire-guided missiles, 6 HVAR, 2 Matra F2 missiles) History : The Breguet 1050 Alizĩ carrier-bas...
Aircraft kits (injection)
Catalogue
£34.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

Potez 25 A2/B2 Hispano. Decals for four planes: Sigma 3, Greek Air Force, Athenes-TatoƒÆ'é¯ airfield, end of April or May 1941 - White 20, Rumanian Air Force, Little Entente and Poland competition, Prague, August 1928 - White 12, in monoplane configuration, first Hispano aircraft delivered to Rumania, Prague, August 1928 - Nr 36, White 1, Yugoslav Army, Prague, August 1928.
Aircraft kits (injection)
Catalogue
£34.99
-
In Stock
10+

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

1:72
Limited re-release! Stampe & Vertongen S.V.4b United Kingdom Decals for three planes: In RAF camouflage, aircraft borrowed by Donnet and Divoy to escape to England, fitted with the modified exhaust (box art) Same aircraft shortly after arrival in England, still partly registered OO-ATD, with RAF roundels G-ATKC, used by Tiger Club History: The Stampe et Vertongen S.V.4 is probably one of the Belgian aeronautical in...
Aircraft kits (injection)
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
1:72
Stampe & Vertongen S.V.4b Belgium 1940
Aircraft decals (military)
Catalogue
£5.99
£5.39
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
1:72
Potez 25 Suisse 855
Aircraft decals (military)
Catalogue
£5.99
£5.39
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
Nieuport 29 Belgium (Comet and Cocottes)
Aircraft decals (military)
Catalogue
£5.99
£5.39
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
CASA C-212 KASET (Thailand)
Aircraft decals (military)
Catalogue
£9.99
£8.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
1:72
Stampe & Vertongen S.V.4 Etampes
Aircraft decals (military)
Catalogue
£5.99
£5.39
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
1:72
Fairey Battle Belgium
Aircraft decals (military)
Catalogue
£5.99
£5.39
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

Re-released! Vickers Vincent - K4712, HV-L, 8 Sqn RAF, Aden 1940 - K6363, H, 244 Sqn RAF, Sarjah, Persian Gulf, 1942 - NZ344, PA-H, 30 Sqn RZNAF, Gisborne (NZ), 1943 - NZ322, 2 SFTS, RNZAF, Woodbourne, NZ, 1941 History: The Vickers Vincent replaced the Westland Wapitis and Fairey IIIF in the General Purpose (GP) role; a role that was very involved with policing the British Empire. Vickers developed the Vincent from t...
Aircraft kits (injection)
Catalogue
£31.40
-
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

PZl P.24 Over Danube.History: The P.24 was an improvement of the well-known Polish PZL P.11 fighter. It was purchased by four nations in the quantities indicated: Romania (5 plus 25 licence-built), Greece (36) who would make the plane famous fighting the 1940 invasion by Italy, Bulgaria (12) and Turkey (40). Interestingly, the Polish Air Force did not order the P.24 despite its export success. The Romanians, who alread...
Aircraft kits (injection)
Catalogue
£16.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
Spad 510 7 eme Escadre The Spad 510 was the last biplane fighter in the Armĩe de l'Air. Decals for three aircraft Nr26, Red 1, 1 ĩre escadrille GC I/7 (Spa 15 Bayard's helmet), Lt Ozanne, esc leader, Dijon, June 1938. Nr14, White 5, 3 eme escadrille GC II/7 (Spa 73 Japanse Stork, Dijon, Spring 1939. Nr25, 4 ĩme escadrille GC II/7 (Spa 78 Black Panther), Dunkirk show, 1937.
Aircraft kits (injection)
Catalogue
£22.40
-
In Stock
10+

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
Spad 510 at war The Spad 510 was the last biplane fighter in the Armĩe de l'Air, still in service in WWII. Nr 9, White 8, DIAP (Dĩpot d'Instruction de l'Aviation Polonaise), Lyon-Corbas, May 1940. Nr44, White 14, 3 eme escadrille GARC II/561, Le Havre-Octeville, November 1939. Nr56,Red 6, CIC Montpellier (FighterTraining Center), June 1940.
Aircraft kits (injection)
Catalogue
£22.40
-
In Stock
10+

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
Potez 25 Africa & Asia. Decals in 72nd for kits FR0037, FR0038, SH72407 for French Africa, Ethiopia, French Indochina, Manchuria (alternately : Japan), French Mandate in Syria, Nationalist Spain. Roundels provided only when not in the box.
Aircraft decals (military)
Catalogue
£17.60
-
In Stock
10+

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
Potez 25 in Europe & America. Decals in 1/72 nd for kits FR0037, FR0038, SH72407 for Aĩropostale (French Postal company between France and South America, with Mermoz, Saint-Exupĩry, Guillaumet, Daurat), Air France, Uruguay, Paraguay, Greece, Poland, anchors for Aĩronavale, Croisiĩre Noire. Roundels provided only when not in the box.
Aircraft decals (military)
Catalogue
£17.60
-
In Stock
10+

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
Gloster Meteor T Mk.7 with decals for Israel, Black 15 with Suez Yellow and Black stripes, January 1957, France, F9 coded 30-MY, 2/30 "Camargue" in 1953, Tours, Belgium, ED042 in 1958, Coxyde Fighter School.
Aircraft kits (injection)
Catalogue
£20.80
-
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
Martin B-10 Export WH-2/WAA. History : Martin B-10 exported to Dutch East Indies and Argentina (for Army), engines two 840 hp Wright Cyclone R-1820-G3. Decals for 3 aircraft, Model 139 WH-2 (Dutch) coded M515, 2-Vl.G.III of ML-KNIL, Singapore, December 41, Model 139 WAA (Argentine Army) coded B-504, Model 139 WAA coded B-511 with modified canopy, 1946.
Aircraft kits (injection)
Catalogue
£34.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
1:72
Martin B-10 Export WC/WAN. History : Martin B-10 exported to China and Argentina (for Navy), engines two Wright Cyclone R-1820-G2 giving 850 hp at 2,100 rpm. Decals for 2 aircraft, Model 139 WC coded 1403, January to July 1938, Chinese AF, Model 139 WAN coded 3-B-2, Puerto Belgrano, Argentine Navy, from 1938 to 1946.
Aircraft kits (injection)
Catalogue
£34.99
-
In Stock
10+

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

Northrop Delta 1A/1B/1C Civilian Version "Swedish, TWA and Mexican Service" Decals for c/n 3, TWA, c/n 4 Aerovias Mexico and c/n 7 AB Aerotransport Sweden - first Deltas with sliding canopy, one pilot and bipale propeller
Aircraft kits (injection)
Catalogue
£27.20
-
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

1:48
French Roundels gives roundels for Armĩe de l'Air, without the outside yellow circle (proportions 1-2-3). Dimensions are given in the sheet for real aircraft, in cm (120, 100, 90, 80, 75), for the usual 1/72 nd scale. Naturally enough, you may use it in other scale by dividing the dimensions : at 1/48 th, you have to divide the dimensions by 1,5 (in other words the roundel indicated as 120 cm will make a handy 80 cm in 1/48 t...
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

1:72
SNCASE SE-535 Mistral (ex-Special Hobby) French modification of the Vampire, mainly done in fitting a Rolls-Royce Nene in place of the original Goblin, 257 units built by SNCASE between 1951 and 1953.
Aircraft kits (injection)
Catalogue
£22.40
-
In Stock
10+