Strike King Tour Grade Tungsten Bullet Weight 3/8 oz
Out Of Stock
|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,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 = 'TGTW38-18' 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|
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!
- Insert free
- Incredibly durable paint coating
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$1.49 to $1.79
$4.99 to $8.49
$5.99 to $6.39
$4.69 to $6.89
$1.49 to $1.79
$5.49 to $5.99