Item# 1 YEAR
$15.00 to $500.00
|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 = '1 YEAR' AND (upper(f.web_text) = 'NATIONAL RIFLE ASSOCIATION' or upper(f.orig_text) = 'NATIONAL RIFLE ASSOCIATION' or upper(a.brand) = 'NATIONAL RIFLE ASSOCIATION') 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 NRA is you -- its members ... millions of Americans representing a diverse contrast of age, sex, race and religion. You're patriots one and all. You believe in the Constitution, staunch in the defense of your rights, and you actively pursue some of this country's finest traditions - Hunting and Sports Shooting. Since its incorporation in 1871, the NRA has grown as a service organization involved in all aspects of the shooting sports and a proud defender of the Bill of Rights.
• Join the NRA at www.turners.com and save $10 to $250.
• Turner's Outdoorsman will donate $5 to the NRA for every membership purchased at www.turners.com
As a Member of the NRA, you will receive a subscription to one of the follow magazines (during the checkout process, write your one magazine choice in the order comments box):
American Rifleman (Print Edition)
American Rifleman (Digital Edition)
American Hunter (Print Edition)
American Hunter (Digital Edition)
American’s First Freedom (Print Edition)
American’s First Freedom (Digital Edition)
Insights [Juniors Only] (Digital Edition)
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review