Graftech Jigstick Cork Tape
$169.99 to $179.99
|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 = 'GJS80H' AND (upper(f.web_text) = 'GRAFTECH' or upper(f.orig_text) = 'GRAFTECH' or upper(a.brand) = 'GRAFTECH') 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|
Graftech Rods, designed by one of California’s most esteemed anglers Rick Ozaki, were built with the Southern California Angler in mind. The unique tapers and designs of each model are ready to tackle the toughest inshore and offshore species. These graphite rods are not only lightweight , but have a tremendous amount of power behind them. Graftech rods have 4 models, Wallbanger, Jigstick, Inshore and Offshore ready to tackle everything from bull Calico Bass to bruiser Bluefin.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$99.99 to $109.99
$169.99 to $189.99
$134.99 $119.99 to $129.99
$79.99 to $89.99