Dead Down Wind Laundry Bomb 28 Count
|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,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 = '118218' AND (upper(f.web_text) = 'DEAD DOWN WIND' or upper(f.orig_text) = 'DEAD DOWN WIND' or upper(a.brand) = 'DEAD DOWN WIND') 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|
Drop a Bomb on Odors. Laundry Bombs are new easy-to-use, water soluble multi-chamber packs that consist of Dead Down Wind's proven enzyme-based detergent, now with 50% more enzymes. Place a Dead Down Wind Laundry Bomb into the washing machine drum before adding hunting garments to remove stains, odors and even increase the longevity of your gear. Laundry Bombs are effective on natural, technical, synthetic or carbon garments to remain undetected when you step foot into the woods this season.
- DROP A BOMB ON ODORS: The Dead Down Wind Laundry Bombs eliminate odors with a broad-spectrum odor elimination formula that removes all traces of human scent on hunting gear, hunting accessories.
- FOR MOST MATERIALS: Recommended for all hunting garments including carbon, technical, natural and synthetic materials. The new water soluble multi-chamber packs are now made with 50% more enzymes.
- HOW TO USE: Place a Dead Down Wind Laundry Bomb into the washing machine drum before adding hunting garments to remove stains, odors and even increase the longevity of your gear.
- SAFE FOR SENSITIVE SKIN: Enzyme formulations keep clothes clean with ingredients that are safe for sensitive skin. Effective on natural, technical, synthetic, or carbon garments to remain undetected when you step foot into the woods.
- SCENT ELIMINATOR FOR HUNTING: Our Laundry Detergent contains no biocides and is gentle on humans and the environment.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$20.00 to $30.00