Catalogue

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

Scale

Description

Type

Department

Price

Watch

Stock

Buy

CMK/Czech Master Kits CMKH1021

Coarse brass chain with rounded links - suitable for 1/35 scale

Diorama accessories (brass)

Catalogue

£2.99

Add to watchlist

CMK/Czech Master Kits CMKH1022

1:35, 1:48

Medium brass chain with rounded links - suitable for 1/35 and 1/48 scale

Diorama accessories (brass)

Catalogue

£2.99

Add to watchlist

CMK/Czech Master Kits CMKH1023

1:48

Fine brass chain with rounded links - suitable for 1/48 and 1/72 scale

Diorama accessories (brass)

Catalogue

£2.99

Add to watchlist

CMK/Czech Master Kits CMKH1024

Fine brass chain with rounded links - suitable for 1/72 scale

Diorama accessories (brass)

Catalogue

£2.99

Add to watchlist

CMK/Czech Master Kits CMKH1017

1:48

Fine Brass Chain - suitable for 1/72 or 1/48 scale

Diorama accessories (brass)

Catalogue

£2.70

Aber ABR35P25

German Stielhamdgranate 24 (15 grenades)

Diorama accessories (brass)

Catalogue

£7.90

CMK/Czech Master Kits CMKH1016

1:35

Brass chain, links are 2 by 2,5 mm, can be used with 1/35 and 1/48 scale models.

Diorama accessories (brass)

Catalogue

£2.50

Master MRGM35-023

M1919 Browning .30 caliber (7.62mm) - cartridges (25pcs)

Diorama accessories (brass)

Catalogue

£7.99

Master MRGM35-024

1:35

MG 42 - German Machine Gun (7.92mm) - complete gun incl. brass, resin and PE parts (1pc)

Diorama accessories (brass)

Catalogue

£25.20

Master MRGM35-025

1:35

MG 34/MG 42 (7.92mm) - empty shells (25pcs)

Diorama accessories (brass)

Catalogue

£7.99

Master MRGM35-026

1:35

MG 34/MG 42 (7.92mm) - cartridges (25pcs)

Diorama accessories (brass)

Catalogue

£7.99

Master GM-16-001

1:16

Browning .50 caliber (12.7mm) - empty shells (25pcs)

Diorama accessories (brass)

Catalogue

£12.25

Master GM-16-002

1:16

Browning .50 caliber (12.7mm) - cartridges (25pcs)

Diorama accessories (brass)

Catalogue

£12.25

Master GM-16-003

1:16

M1919 Browning .30 caliber (7.62mm) - empty shells (25pcs)

Diorama accessories (brass)

Catalogue

£11.25

Master GM-16-004

1:16

M1919 Browning .30 caliber (7.62mm) - cartridges (25pcs)

Diorama accessories (brass)

Catalogue

£11.25

Master MRGM35-022

1:35

M1919 Browning .30 caliber (7.62mm) - empty shells (25pcs)

Diorama accessories (brass)

Catalogue

£7.99

Master MRGM35-020

Browning .50 caliber (12.7mm) - empty shells (25pcs)

Diorama accessories (brass)

Catalogue

£8.30

Master MRGM35-021

1:35

Browning .50 caliber (12.7mm) - cartridges (25pcs)

Diorama accessories (brass)

Catalogue

£8.30

AFV Club AFAG3585

1:35

Ru 85mm Gun Ammo Set (Brass shells) Soviet with decals

Diorama accessories (brass)

Catalogue

£11.99

Master MRGM35-018

1:35

German 2cm ammunition (cal. 20x138B) for Flak 30/38, KwK 30/38 - empty shells (25pcs)

Diorama accessories (brass)

Catalogue

£10.50

Master MRGM35-019

1:35

German 2cm ammunition (cal. 20x138B) for Flak 30/38, KwK 30/38 - shells (15pcs) and 3 types of projectiles (5pcs of each type)

Diorama accessories (brass)

Catalogue

£10.50

AFV Club AF35097

1:35

German 10.5cm shell cases x 20

Diorama accessories (brass)

Catalogue

£11.99

Tamiya TA35191

1:35

Sherman Brass projectiles

Diorama accessories (brass)

Catalogue

£9.99

AFV Club AF35017

1:35

155mm and 203mm Howitzer Round Stowage case's, shells, decal

Diorama accessories (brass)

Catalogue

£15.99

Add to watchlist

AFV Club AF35085

1:35

Pz.Kpfw.IV 7.5cm Kwk L/46 ammunition Set

Diorama accessories (brass)

Catalogue

£14.99

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:

Cookies