Flambeau Econo Single 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 = '6470SE' 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|
6470SE Safe Shot Single 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-5/8 L x 12-1/8 W x 3-3/4 " H. Largest economy single available. Four locking points and piano style hinge keeps childern out when properly locked. Durable egg-shell foam.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$7.99 to $29.99