Pro-Shot 1 Step BIO Mil-Spec CLP 2 oz
Item# 1 STEP BIO MIL-SPEC-2
|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 = '1 STEP BIO MIL-SPEC-2' AND (upper(f.web_text) = 'PRO SHOT' or upper(f.orig_text) = 'PRO SHOT' or upper(a.brand) = 'PRO SHOT') 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|
1 Step BIO Mil-Spec CLP is a BIO formula highly penetrating fluid specifically designed to clean, lubricate and protect your firearms and weapon systems. Based on the highest quality synthetic oil and containing anti-corrosion and anti-wear additives, it has been formulated to keep small and large caliber weapons combat-ready in the harshest of environments (desert, snow, tropical, saline, etc.) 1 Step BIO Mil-Spec CLP performs in temperatures ranging from -51°C to +71°C (According to the US Mil Specification) and withstands temperatures from -54°C up to +150°C.
1 Step Bio Mil-Spec CLP is intended for field application to satisfy the complete need for cleaning, lubricating and short-term preservation of both small and large caliber weapons. As such, it replaces the 3 different products still commonly used for lubricating the mobile parts of weapons during shooting, cleaning the firing residues after shooting and preserving the weapon against corrosion during storage.
1 Step Bio Mil-Spec CLP is virtually odorless and is preferred by users as it is more pleasant to use than other CLP products. It facilitates the effective removal of firing residues, gums and other contaminants from weapon components and is compatible with all metals and alloys used in weapons.
3 FUNCTIONS IN 1:
- Cleans all metal parts and removes the propellant powder residues
- Lubricates, thus reducing friction and wear
- Protects, against corrosion in all climatic conditions and during storage, thanks to its active water repellent film.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review