Outdoor Connection Black Filled Bench Bags 2 Piece Set
|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 = 'BRB2F-28213' AND (upper(f.web_text) = 'OUTDOOR CONNECTION' or upper(f.orig_text) = 'OUTDOOR CONNECTION' or upper(a.brand) = 'OUTDOOR CONNECTION') 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 TOC BenchBags are made with made with premium quality materials and are GUARANTEED FOREVER. The design creates a steady platform and grips the rifle forend like a soft vice for stability. The bags are designed to be heavy enough for support of large caliber rifles, yet light enough for transport. Your expensive rifle is carefully held in place and no metal that could mar the finish comes in contact with the firearm. Use your BenchBags at the range, in the deer stand or on any surface to hold your gun steady.
Bench Bags, 2 piece-set, Fabric/Leather, Filled, Black
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$10.99 to $11.99
$29.99 to $30.99