Lucas Oil Extreme Duty CLP 11oz
|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 = 'LCS10916' AND (upper(f.web_text) = 'LUCAS OIL' or upper(f.orig_text) = 'LUCAS OIL' or upper(a.brand) = 'LUCAS OIL') 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|
Used and recommended by major firearms manufacturers, Lucas Oil Extreme Duty CLP is designed to clean, lubricate and protect your firearms in one simple step.
It contains high grade additives that dissolve powder residue, old lubrication and other contaminates. It penetrates deep into rust to help clean neglected firearms and free rusted parts and actions. Extreme Duty CLP’s superior anti-wear additives reduce friction and wear while the unique waterproof, super slick film resists blow out and extends firearm life and runtime.
The special formulation leaves behind a microscopic layer of protection against rust and corrosion caused by handling, fingerprints, moisture and harsh environments, including salt water. Used by major firearms manufacturers to coat and protect firearms prior to shipping, the solvent based Extreme Duty CPL aerosol contains a unique drying agent that leaves your firearm clean and protected from rust and corrosion without any gummy residue.
Cleans and protects your firearms in one easy step.
Penetrates deep into rusted firearms, freeing stuck parts and aids in cleaning.
Provides long-lasting protection from rust.
Great for general shop and home use too.
Made in U.S.A.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$3.99 to $4.49