Break Free Powder Blast 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 = 'gc16' 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|
Powder Blast is a powerful, high pressure solvent gun cleaner that blasts away powder residue, grease and oil build-up, leaving the firearm clean and ready for lubrication.
Powder Blast gun cleaner is applicable to all shooters, but especially heavy volume shooters such as law enforcement officers, handgun shooters and clay, trap and skeet shooters. Because Powder Blast is quick and convenient, cleaning is done more often and more effectively.
Contains citrus oil and high-pressure, fast acting environmentally safer gun cleaning solvents.
Citrus oil is an effective oil and grease cutter used in hand cleaners and detergents. Only Powder Blast Gun Cleaner employs this active ingredient to break the bond of old oil, grease and gunpowder residue.
Works immediately without disassembly and leaves gunmetal brilliantly clean and free of oil, grease, plastic streaking and gunpowder residues.
Works faster, better, safer; environmentally friendlier. Pleasant citrus odor.
IMPORTANT: This product is a powerful solvent. DO NOT APPLY TO RUBBER OR PLASTIC GRIPS OR PARTS. Remove promptly with a cloth to avoid possible plastic damage. Powder Blast may damage painted finishes, camouflage or wood finishes and most polymers. Use with caution.
12oz. Aerosol Can
No reviews have been written for this product.
Be the first one! – Write a Review
$2.49 to $2.89