Big Hammer Hammer Head Jig 3/16 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,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 = 'SE3610' AND (upper(f.web_text) = 'BIG HAMMER' or upper(f.orig_text) = 'BIG HAMMER' or upper(a.brand) = 'BIG HAMMER') 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|
These premium shad head swimbait heads from Big Hammer offer anglers the best there is for rigging your Big Hammer or other brand swimbait tails. Each colored head is powder coated for an extremely durable finish that will resist chips and scratches far longer than regular painted heads. Premium black nickel hooks and deep prismatic eyes round out the package for the best head on the market. Each weight Hammer Head comes with different choices of hook size to perfectly match the size of Big Hammer swimbait you want to put on. The two aggressive keepers on the top and bottom of the shaft will keep your plastic where you want it, cast after cast. These heads and the Big Hammer Tails work well for almost any fish anywhere, salt or fresh. Bass eat the Big Hammers when they are slowly cranked along the bottom or over deep ledges. Have fun with the Big Hammers, there are enough head/tail color combinations that you can come up with something never seen before.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$4.39 to $5.99
$5.49 to $7.49
$5.09 to $5.19
$89.99 to $99.99
$12.99 to $13.99
$249.95 to $289.95
$7.99 to $9.99
$1.49 to $1.79