Break Free CLP Aerosol 12 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 = 'clp-12-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|
When the United States Military issued PD-48, a purchase description of properties for a single, multi-purpose product to maintain their weaponry, it became known as the "impossible specification" because of its severe requirements. The first product to meet the challenge - Break-Free CLP.
Break-Free's flagship product, CLP is a unique formulation of synthetic oils and individual proprietary ingredients which synergize in combination to do three important tasks simultaneously: Effectively Clean, Lubricate and Protect metal. Break-Free CLP is now recognized around the world as the standard by which maximum metal performance and protection is ensured.
Penetrates and spreads along metal surfaces into every pit and crevice to undercut contamination and lift residue away where it can be removed.
Long-lasting lubricating film dramatically reduces adhesion of sand, grit or other abrasives which cause wear and failure.
Corrosion inhibitors prevent the formation of rust while Break-Free's unique boundary film protects metal surfaces from moisture and other contaminants.
Specially formulated synthetic oils won't lose viscosity, dry out or stiffen up in extreme environments - such as cold, heat, dust, dirt, humidity and even salt air - keeping equipment in ready condition for months at a time.
Average of 5 customer reviews:
Write a Review
Rancho Cucamonga, CA
How Long Have You Been Using This Product: More than 2 years