California's #1 Hunting, Shooting & Fishing Headquarters Since 1971 0 View Cart CART My Account

 Lucas Oil Extreme Duty Clp 11oz Hover to Zoom

lucas oil

Lucas Oil Extreme Duty CLP 11oz

 Item# LCS10916

rating 1.0rating 2.0rating  3.0rating 4.0rating 5.0 0 Reviews

$10.99

query
RESULTSET
query
  ATTR1ID ATTR2ID CAPACITY NON_INVT OF8 OVERALLQOH PICTURE_ID REALNAME SCALEID SKU_ID SKU_OF7 STYLE STYLE_ID USEPACKAGE WEBSTYLE WEBSTYLE_SORT
CACHED false
EXECUTIONTIME 31
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
SQLPARAMETERS
array
1 OBS
2 RS
3 SM
4 DNR
5 DNRFD
6 CSN
7 SPDNR
1


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.
KEY BENEFITS:
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.

 Warning - Cancer and reproductive harm WARNING 
Cancer and Reproductive Harm

 www.P65Warnings.ca.gov

No reviews have been written for this product.
Be the first one!  – Write a Review


We Also Recommend Next Prev

x

We use cookies to improve your browsing experience. By continuing to browse our website you agree to our use of cookies. To learn more about how we use cookies, please review our privacy policy  click here.