Hoppe's Lead B Gone
|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 = 'LBG40' AND (upper(f.web_text) = 'HOPPES' or upper(f.orig_text) = 'HOPPES' or upper(a.brand) = 'HOPPES') 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|
Shooting at the gun range, reloading ammunition, or cleaning your gun can be a dirty process. Hoppe's understands and has you covered when it's time to clean up. Hoppes Lead-B-Gone Skin Cleaning Wipes lift and trap lead, nickel, cadmium, arsenic, silver, mercury, zinc, chromium, copper, antimony, and other metals without smearing. Why choose Lead-B-Gone Skin Cleansing Wipes instead of soap and water? Simple. They've been proven to remove 98.8 percent of contaminants on their own, and 99.9 percent with a water rinse. Soap and water only removes 72 percent of contaminants. Use them to wipe down your hands, arms, face, neck, and any working surfaces after cleaning your firearm or any other activity involving lead and other metal dust.
- Removes up to 99.9 percent of metal contaminants with water rinse (soap and water only remove 72 percent)
- Saturated with gentle pH cleaner
- Soft towels lift and trap lead and metal dust
- Contains aloe skin moisturizers
- Not for use on firearms
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$2.89 to $3.99