Okuma Cerros Bass Spinning Rod
|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 = 'CRS-S-701ML' AND (upper(f.web_text) = 'OKUMA' or upper(f.orig_text) = 'OKUMA' or upper(a.brand) = 'OKUMA') 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|
The new Cerros Bass rods were designed to be fished by every angler. Well built, attractive and competitive, these technique specific rods are built on a responsive and durable 24-ton carbon blank. These blanks also feature Okuma’s UFR-Ultimate Flex Reinforcement tip technology. This process blends unidirectional fiber over 24-ton carbon in the extended tip section of the rod to increase lifting strength and power by as much as 400%. This technology provides for the ultimate in strength without sacrificing sensitivity so that you can feel even the lightest of bites.
The component system on the Cerros bass rods feature Sea Guide XO 316-SS angles guide frames to reduce line twists. Each guide has zirconium line guide inserts for reduced line abrasion when using braided lines. The 3K woven carbon butt section improves hoop strength and is complemented by contoured EVA split rear grip handle design.
- Specially designed technique specific bass rod series
- Responsive and durable 24-ton carbon blank construction
- UFR: Ultimate Flex Reinforced rod tip technology
- Sea Guide XO 316-SS angled guide frames reduce line twists
- Zirconium line guide insert for reduced line abrasion
- 3K woven carbon butt section improves hoop strength
- Split rear grip handle design with contoured EVA
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$29.97 to $84.99
$159.99 to $179.99
$119.99 to $129.99
$169.99 to $179.99
$49.99 to $59.99
$274.99 to $374.99
$29.99 to $32.99