Flambeau Econo Double Scoped Rifle Case
|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 = '6499NZ' AND (upper(f.web_text) = 'FLAMBEAU' or upper(f.orig_text) = 'FLAMBEAU' or upper(a.brand) = 'FLAMBEAU') 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|
6499NZ Safe Shot Double Rifle Case
Series of cases live up to their name in several of ways. These cases protect your guns from bumps and bruises while preventing unwanted trespassers into the case. The guns are blanketed with egg-shell foam padding, four locking points and piano style hinge to prevent opening during transport. Safe Shot Cases... Protect your investments. Made in the U.S.A.
53-3/8" L x 16-1/2" W x 4-1/2" H. Four locking points for extra security. Combination of piano style hinge and brass hinge provide durability, safety and protection. Oversized double will accomodate two scoped rifles. Durable egg-shell foam.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review