California's #1 Hunting, Shooting & Fishing Headquarters Since 1971 0 View Cart CART My Account

 Nra Membership Hover to Zoom

national rifle association

NRA Membership

 Item# 1 YEAR

rating 1.0rating 2.0rating  3.0rating 4.0rating 5.0 0 Reviews

$15.00 to $500.00

query
RESULTSET
query
  ATTR1ID ATTR2ID CAPACITY NON_INVT OF8 OVERALLQOH PICTURE_ID REALNAME SCALEID SKU_ID SKU_OF7 STYLE STYLE_ID USEPACKAGE WEBSTYLE WEBSTYLE_SORT
1 [empty string] [empty string] 1 Year Membership Y STK -2 8909 NRA Membership [empty string] 7151 [empty string] 1 YEAR 7151 [empty string] 1 YEAR 1
2 [empty string] [empty string] 3 Year Membership Y STK -2 8989 NRA Membership [empty string] 7153 [empty string] 3 YEAR 7153 [empty string] 1 YEAR 2
CACHED false
EXECUTIONTIME 32
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 = '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
SQLPARAMETERS
array
1 OBS
2 RS
3 SM
4 DNR
5 DNRFD
6 CSN
7 SPDNR
2

 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)
 Warning - Cancer and reproductive harm WARNING 
Cancer and Reproductive Harm

 www.P65Warnings.ca.gov

No reviews have been written for this product.
Be the first one!  – Write a Review


2 Styles Available

NRA Membership 1 Year Membership 1 Year Membership $40.00 $35.00
NRA Membership 3 Year Membership 3 Year Membership $100.00 $85.00

arrow to add to cart button
Add to Wish List

We Also Recommend Next Prev

x

We use cookies to improve your browsing experience. By continuing to browse our website you agree to our use of cookies. To learn more about how we use cookies, please review our privacy policy  click here.