Crosstac Tactical Rear Squeeze Bag, Multicam
|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 = '135620-MC' AND (upper(f.web_text) = 'CROSSTAC' or upper(f.orig_text) = 'CROSSTAC' or upper(a.brand) = 'CROSSTAC') 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|
The Crosstac Rear Squeeze Bag is the most rugged, most unique, tactical squeeze bag on the market. It's the industry's first ergonomically designed shooting bag (oval) that fits your hand.
Unique one-way stretch fabric and special fill allows for precise up and down adjustment, vastly superior to a sock.
- 6.0" long with a 4.0" x 2.5" oval shape.
- Wrist strap to wear on the off-hand.
- Pre-filled with inert solid poly beads for great feel.
- Zippered so you can adjust the fill if wanted.
- Oval ergonomic shape fits the hand for comfort.
- Weighs 0.85lb.
- 100% USA Made by the dedicated folks at Crosstac.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$13.97 to $23.99
$19.99 to $22.99
$16.99 to $19.99
$4.97 to $7.99