Owner Beast Hook With Twistlock
$8.09 to $10.99
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,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 = '5130-161' AND (upper(f.web_text) = 'OWNER' or upper(f.orig_text) = 'OWNER' or upper(a.brand) = 'OWNER') 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|
This unweighted version has all the features of the Weighted Beast less the weight. The unweighted version is ideal for lighter baits than do not need large amounts of weight to be swam. Due the XXX-strong wire and big gap angle there is a lot of steel in this hook which allows the hook alone to act as the weight on lighter baits.
Beast Hooks with TwistLOCK® Centering-Pin Spring (CPS) are designed for weedless-style rigging of larger plastics like big swimbaits, flukes, tubes and creature baits. With its TwistLOCK® Centering-Pin Spring (CPS - patent pending) attached to the hook eye, baits can be permanently secured by inserting the pin in the center of the nose of a soft plastic, which can then be screwed onto the TwistLOCK® coil spring to rig perfect everytime! Different Size springs are matched to hook size to maximize holding power. Quick-drop shank below eye allows for rigging fat-headed baits, and maximum gap allows for improved hook sets because of better bait clearance.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$1.99 to $2.99
$38.99 $11.49 to $33.99
$12.99 to $42.99
$31.99 to $39.99