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

Cookie name	Description
existing_user	Stores the email address used to previously log into the site, used to prefill forms like on the reset password screen
authchallenge	Authentication security checks
hcart	Stores the anonymous customer\'s cart token. If items are added to the card while not logged in, if you log in the items will be added to the customer\'s existing cart
hannants	Stores the session information while you remain on the site
pricer	Stores if the export or eu prices is selected on the catalogue page
hidefilter	Stores if the search filter panel is hidden or shown
AWSELB	Stores which server you\'re connected to so to access the same server while you navigate around the site
__utma __utmb __utmc __utmz	Google analytics related cookies

Catalogue

Found 8 results 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

Scale

Product Type

Ship detailing sets (metal and resin)

Manufacturer

Added Within

Scale

Description

Type

Department

Price

Watch

Stock

Buy

Mk.1 Design MS-20019

DKM SCHARNHORST German Gneisenau Battleship (designed to be used with Trumpeter kits) DKM SCHARNHORST Armament Parts Composition : 2 X High Quality Brass Photo Etched Parts 51 X Brass Metal Parts 1.0mm Brass Rod 115 X 3D-Printed High Quality Resin Parts

Ship detailing sets (metal and resin)

Catalogue

£94.99

Master SM350-107

1:350

Schleswig-Holstein (1935) armament - 280mm (4pcs), 150mm (10pcs), 88mm (4pcs) barrels with resin mounts (designed to be used with Trumpeter kits)

Ship detailing sets (metal and resin)

Catalogue

£15.50

Master SM350-108

1:350

H.M.S. Exeter (1939) armament - 8in (6pcs), 4in (4pcs), Vickers 0.5 in (8pcs) barrels (designed to be used with Trumpeter kits)

Ship detailing sets (metal and resin)

Catalogue

£11.25

Master SM350-105

1:350

H.M.S. Lord Nelson armament - 12in (4pcs), 9.2in (10pcs), 12pdr (34pcs) barrels with resin mounts (designed to be used with Hobby Boss kits)

Ship detailing sets (metal and resin)

Catalogue

£22.60

Master SM350-106

1:350

SMS Seydlitz armament - 280mm (10pcs), 150mm (12pcs), 88mm (8pcs) barrels with resin mounts (designed to be used with Hobby Boss kits)

Ship detailing sets (metal and resin)

Catalogue

£18.60

Master SM350-102

1:350

French training gun 90mm Model 1935 - used on Richelieu 1943 and Dunkerque French Navy Battleship class - (resin, PE and turned parts) - (4pcs) (designed to be used with Hobby Boss and Trumpeter kits)

Ship detailing sets (metal and resin)

Catalogue

£8.99

Master SM350-103

1:350

French Twin Mount 37mm/50 (1.46in) Model 1933 - (resin, PE and turned parts) - (4pcs) (designed to be used with Hobby Boss kits)

Ship detailing sets (metal and resin)

Catalogue

£11.25

Master SM350-104

1:350

French Quad Mount Hotchkiss 13,2mm/76 (0.52in) Model 1929 - (resin, PE and turned parts) - (4pcs) (designed to be used with Hobby Boss kits)

Ship detailing sets (metal and resin)

Catalogue

£11.25

Search Area	Manufacturer		Item Type

Part Number	Scale	Keywords	Results per Page	Only discounted retail price
		Exact Match
Only Show Items In Stock	Only Show Items With Pictures	Sort by: Sort Direction:

Added Within	last week		last 2 weeks		last month		last 6 months		last year

We accept Visa, Mastercard & Paypal

Cookies

Catalogue