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,4) ) 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 ' 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|
Developed to protect firearms for up to five years in storage, Collector® exceeds stringent military specifications. Recommended for the occasional hunter or sports shooter, as well as knife and sword collectors. It’s ideal for seasonal sports equipment before placing in storage. In one test, Collector protected steel panels from rust and corrosion for over 1200 hours in 100% humidity. It does not degrade to waxy residue under heat or pressure and resists damage from fingerprint residue and minimizes the need for frequent wipe down.
Protects firearms and other weapons for up to five years in storage
Exceeds stringent military specifications
Does not degrade to waxy residue under heat or pressure
Resists damage from fingerprint residue and minimizes the need for frequent wipe downs
Perfect for gun collectors, armories and museums
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review