ZMan TT Lures NedlockZ EWG - Green Pumpkin
|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 = 'TTNL-3610' AND (upper(f.web_text) = 'ZMAN' or upper(f.orig_text) = 'ZMAN' or upper(a.brand) = 'ZMAN') 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|
Combining a traditional mushroom-shaped head with a weedless EWG hook, the NedlockZ EWG Jighead allows for easy weedless rigging and effortless hooksets with Ned Rig style softbaits. The jig’s custom, heavy duty #1 VMC® extra wide gap hook is sized to optimize the action of small softbaits without overpowering them. A molded keeper pins baits in place and prevents them from slipping, even on hard casts and after missed strikes. An ultra-premium Ned Rig jighead, the NedlockZ EWG features the same weights and colors (green pumpkin, black, chartreuse) as the original NedlockZ Jighead.
- Traditional mushroom-shaped head preferred by finesse fishing enthusiasts
- Allows for easy weedless rigging and easy hooksets for fishing with Ned Rig style softbaits
- Built on custom, heavy duty size 1 VMC® extra wide gap hook that is sized perfectly to maximize action of small softbaits
- Molded keeper holds baits in place and prevents slipping on hard casts and missed strikes
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$1.59 to $1.99
$3.97 to $7.99
$7.49 to $8.49
$5.97 to $9.99