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

 Strike King Tour Grade Tungsten Bullet Weight 1/8 Oz Hover to Zoom

strike king

Strike King Tour Grade Tungsten Bullet Weight 1/8 oz

 Item# TGTW18-46

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

$5.49

Out Of Stock

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] Black N STK 0 24635 Strike King Tour Grade Tungsten Bullet Weight 1/8 oz [empty string] 539091 [empty string] TGTW18-10 733430 [empty string] TGTW18-46 1
2 [empty string] [empty string] Green Pumpkin N STK 0 24636 Strike King Tour Grade Tungsten Bullet Weight 1/8 oz [empty string] 539090 [empty string] TGTW18-46 733429 [empty string] TGTW18-46 2
CACHED false
EXECUTIONTIME 31
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 = 'TGTW18-46' AND (upper(f.web_text) = 'STRIKE KING' or upper(f.orig_text) = 'STRIKE KING' or upper(a.brand) = 'STRIKE KING') 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
8 DOA
2

Some of the finest quality weights available, the Tour Grade Tungsten Weights by Strike King® are insert-free, designed to not fray your line, have an incredibly durable paint coating and will increase your catch-rate. The Tungsten Weights' boat-tail/weight forward shape allow the weights to easily penetrate and fall through cover which will lead to a higher catch-rate. Tungsten's high-density enables a smaller size than comparable lead weights, which makes them less obtrusive to your lure and will help your hook-up ratio. Plus, the Tungsten Weights' hardness gives you incredible feel of the bottom and strikes that can't be matched by lead. The Strike King Tour Grade Tungsten Weights will improve your fishing success so you will never want to use lead again!


Features:

 

  • Insert free
  • Incredibly durable paint coating
 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

Strike King Tour Grade Tungsten Bullet Weight 1/8 oz Black Black $5.49
Strike King Tour Grade Tungsten Bullet Weight 1/8 oz Green Pumpkin Green Pumpkin $5.49

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.