Break Free Collector 4 oz
|SQL||SELECT DISTINCT a.style_id, max(CASE WHEN m.description IS NULL OR RTRIM(LTRIM(m.description)) = '' THEN a.web_desc ELSE m.description END) as realname, sum(c.qoh+c.qc) as overallqoh, max(a.picture_id) as picture_id, max(a.of8) as of8, max(b.sku_id) as sku_id, max(b.sku_of7) as sku_of7, max(b.scale_entry_id) as scaleid, max(b.attr2_entry_id) as attr2id, max(b.attr1_entry_id) as attr1id, max(a.style) as style, max(r.package_id) as usepackage, max(a.web_style) as webStyle, max(m.capacity) as capacity, max(m.webstyle_sort) as webstyle_sort, max(a.NON_INVT) as NON_INVT FROM tb_styles a LEFT JOIN tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id) LEFT JOIN tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id AND NOT (c.qoh < 1 AND a.of8 in (?,?,?,?,?,?,?,?)) AND NOT (c.qoh < 1 AND a.of8='INACTIVE') AND c.store_id in(49,90) ) LEFT JOIN web_product_information m WITH (NOLOCK) ON (a.style_id = m.style_id) LEFT JOIN dbo.tb_inet_names f WITH (NOLOCK) on (f.orig_text = a.brand and f.field_name='BRAND') LEFT JOIN tb_package r WITH (NOLOCK) on (r.sku_id=b.sku_id) INNER JOIN web_all_products wb WITH (NOLOCK) ON (wb.style_id = a.style_id) WHERE a.web_style = 'co-4-1-breakfree' AND (upper(f.web_text) = 'BREAKFREE' or upper(f.orig_text) = 'BREAKFREE' or upper(a.brand) = 'BREAKFREE') GROUP BY a.style_id,a.of8 HAVING (sum(c.qoh+c.qc) > 0 OR a.of8='STK') ORDER BY max(m.webstyle_sort), a.style_id|
Collector Liquid provides a protective coating against rust and corrosion on metal to metal finishes; no need to remove before use.
Developed for military use to protect weapons for up to 5 years in storage.
Exceeds military requirements for rust and corrosion protection.
Unique 100% synthetic oil formulation with multiple high performance anti-rust and corrosion inhibitors.
Will not break down to form waxy residues under heat or with age. Contains no wax or mineral oil.
Protects up to five years. Lab test results show over 1,200 hours of rust and corrosion protection on mild steel panels when exposed to 100% humidity at 93 degrees with out developing even one micro of rust.
Does not have to be removed before firing; always "grab and go" combat ready condition.
Safe for use on all metals and finishes.
Ideal to protect gun collections, knives, swords, and sports equipment. Perfect for museums and police armories.
4oz. Liquid Bottle
No reviews have been written for this product.
Be the first one! – Write a Review