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

 Dead Down Wind Laundry Bomb 28 Count Hover to Zoom

dead down wind

Dead Down Wind Laundry Bomb 28 Count

 Item# 118218

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

$14.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 32
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
SQLPARAMETERS
array
1 OBS
2 RS
3 SM
4 DNR
5 DNRFD
6 CSN
7 SPDNR
8 DOA
1


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.


Features:

 

  • 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.
 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.