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 pt.id=2724 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 8,789 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
No Image
New Ware NWAM0955
North-American/Rockwell OV-10D Bronco EXPERT kabuki masks all windows including inner side masks, other clear parts, wheels, yellow stripes on bombs (designed to be used with ICM kits)
Aircraft paint masks (self adhesive)
Catalogue
£9.30
-
In Stock
5+
Eduard EDJX197
RE-RELEASED! Boeing B-17E Flying Fortress (designed to be used with Hong Kong Models kits)
Aircraft paint masks (self adhesive)
Catalogue
£12.99
£11.69
Out of Stock
0
No Image
New Ware NWAM0797
Douglas A-26B Invader Pacific War Theater BASIC kabuki masks all windows, other clear parts, wheels (designed to be used with ICM kits)
Aircraft paint masks (self adhesive)
Catalogue
£6.99
-
In Stock
5+
No Image
HAD Models MASK32001
Sukhoi Su-27B Ukrainian Digital camouflage pattern paint mask (designed to be used with Trumpeter kits) he set including 5 sheets A-5 mask The product used for masking is made of self-adhesive (Tamiya) paper and contains pre-cut shapes for painting. With its use, we greatly facilitate painting that is often impossible or very difficult to do with freehand
Aircraft paint masks (self adhesive)
Catalogue
£47.99
£43.19
Out of Stock
0
No Image
HAD Models MASK32003
1:32
Sukhoi Su-25 Ukrainian Digital camouflage pattern paint mask (designed to be used with Trumpeter kits) he product used for masking is made of self-adhesive (Tamiya) paper and contains pre-cut shapes for painting. With its use, we greatly facilitate painting that is often impossible or very difficult to do with freehand. Scaled to (designed to be used with Trumpeter kits) kit the set including 3 sheets A-5 mask
Aircraft paint masks (self adhesive)
Catalogue
£33.99
£30.59
Out of Stock
0
No Image
Eduard EDCX658
Messerschmitt Me-410A-1/U-2 1/72 (designed to be used with Airfix kits)
Aircraft paint masks (self adhesive)
Catalogue
£6.99
£6.29
Out of Stock
0
No Image
Eduard EDEX1004
Mitsubishi Ki-21-I 1/48 canopy frame paint mask (designed to be used with ICM kits) [Ki-21-Ia Ki-21-Ib]
Aircraft paint masks (self adhesive)
Catalogue
£7.99
£7.19
Out of Stock
0
No Image
Eduard EDEX1005
1:48
Mitsubishi Ki-21-I TFace canopy frame paint mask (inside & outside) 1/48 (designed to be used with ICM kits)[Ki-21-Ia Ki-21-Ib]
Aircraft paint masks (self adhesive)
Catalogue
£10.30
£9.27
Out of Stock
0
No Image
Eduard EDEX1006
Gotha Go-244B 1/48 canopy frame paint mask (designed to be used with ICM kits)
Aircraft paint masks (self adhesive)
Catalogue
£7.99
£7.19
Out of Stock
0
No Image
Eduard EDEX1007
Gotha Go-244B TFace canopy frame paint mask (inside & outside) 1/48 (designed to be used with ICM kits)
Aircraft paint masks (self adhesive)
Catalogue
£11.99
£10.79
Out of Stock
0
No Image
Eduard EDEX1008
Fokker D.VIIF 1/48 canopy frame paint mask (designed to be used with Eduard kits)
Aircraft paint masks (self adhesive)
Catalogue
£3.99
£3.59
Out of Stock
0
No Image
Eduard EDEX1009
Supermarine Spitfire Mk.Vb early 1/48 canopy frame paint mask (designed to be used with Eduard kits)
Aircraft paint masks (self adhesive)
Catalogue
£6.99
£6.29
Out of Stock
0
No Image
Eduard EDEX1010
Messerschmitt Bf-109K-4 tulip pattern & national insignia
Aircraft paint masks (self adhesive)
Catalogue
£5.30
£4.77
Out of Stock
0
No Image
Art Scale 200-M72034
Grumman Wildcat wheels and canopy frame paint mask (inside and outside) painting mask (designed to be used with Arma Hobby kits)
Aircraft paint masks (self adhesive)
Catalogue
£5.99
-
In Stock
5+
No Image
Kits-World KWM720057
1:72
RAF 48 inch Type B Roundels 15 and 25 inch
Aircraft paint masks (self adhesive)
Catalogue
£2.99
Out of Stock
0
No Image
Kits-World KWM720058
RAF 48 inch Type B Roundels 30 and 32 inch
Aircraft paint masks (self adhesive)
Catalogue
£2.99
Out of Stock
0
No Image
Kits-World KWM720059
RAF 48 inch Type B Roundels 35 and 40 inch
Aircraft paint masks (self adhesive)
Catalogue
£2.99
Out of Stock
0
No Image
Kits-World KWM720060
RAF 48 inch Type B Roundels 44 and 48 inch
Aircraft paint masks (self adhesive)
Catalogue
£2.99
Out of Stock
0
No Image
Kits-World KWM720061
1:72
RAF 48 inch Type B Roundels 49 and 50 inch
Aircraft paint masks (self adhesive)
Catalogue
£2.99
Out of Stock
0
No Image
Kits-World KWM720064
1:72
RAF 48 inch Type B Roundels 66.5 inch
Aircraft paint masks (self adhesive)
Catalogue
£2.99
Out of Stock
0
No Image
Kits-World KWM720065
RAF 48 inch Type B Roundels 75 inch
Aircraft paint masks (self adhesive)
Catalogue
£2.99
Out of Stock
0
No Image
Kits-World KWM720066
RAF 48 inch Type B Roundels 100 inch
Aircraft paint masks (self adhesive)
Catalogue
£2.99
Out of Stock
0
No Image
HGW HGW648412
1:48
Hawker Sea Fury FB.II (designed to be used with Airfix kits)
Aircraft paint masks (self adhesive)
Catalogue
£6.40
Out of Stock
0
No Image
Peewit PEE144044
Agusta-Bell 47J Super Ranger. - 2 pieces canopy frame paint mask (designed to be used with LF models kits)
Aircraft paint masks (self adhesive)
Catalogue
£5.20
Out of Stock
0
No Image
Peewit PEE48029
Augusta-Bell AB 47J Super Ranger canopy frame paint mask (designed to be used with LF models kits)
Aircraft paint masks (self adhesive)
Catalogue
£6.30
Out of Stock
0

   1   |   2   |   3   |   4   |   5      »      [352]
| +10 +20 +50 +100

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