Marsupial Enclosed Binocular Pack - Small
|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 = 'EBINO-CB-S' AND (upper(f.web_text) = 'MARSUPIAL GEAR' or upper(f.orig_text) = 'MARSUPIAL GEAR' or upper(a.brand) = 'MARSUPIAL GEAR') 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|
Years of feedback and testing have led to the design and creation of the new Enclosed Binocular Pack. Utilizing state of the art fabrics and features, the Enclosed Binocular Pack offers the same one-handed operation that Marsupial Gear is known for. This new pack uses Marsupial's trademark front folding magnetic lid design, but adds another layer of protection. Taller sidewalls and overlapping wings, fully seal and protect your binoculars from the elements. MOLLE webbing has been added to the bottom of the pack for additional accessory attachment points. Durable stretch fabric allows you to carry more in the front and side pockets. The modular design allows you to customize your chest pack with interchangeable accessories on both sides of the pack. For those of you who like a more sealed system, this is the pack for you.
- Full containment design to protect from outside elements
- Secures open and closed with magnets on the bottom and top of pack
- Durable fleece liner for silent operation
- Stretch side pockets
- Rear Cell Phone Pocket
- Stretch front zippered pocket
- MOLLE attachment on bottom of pack
- Includes padded mesh harness with removable safety tethers
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$35.99 $16.97 to $27.99