Okuma Cavalla 2-Speed Lever Drag
|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 = 'cav-5nii' 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 Cavalla 2-Speed Lever Drag reels are a compact bodied machine built to handle the toughest of conditions. This reel is built with 6061-T6 machined aluminum frame and side plates. The rigid 1 piece frame continues around to the non handle side plate. This rigid frame combined with a cold forged, type-II anodized machined aluminum spool give you a sleek and rugged weapon.
The Cavalla reels feature a battle proven carbonite drag system with Cal’s drag grease that puts out 24 to 34 pounds of drag at full. The 17.4 grade stainless steel main and pinion gear as well as the CRC: Corrosion Resistance Coating process make this reel virtually corrosion resistant. Add to that 4 corrosion resistant stainless steel bearings and a silent retrieve system for complete smooth operation.
Rigid 1-pcs frame and left sideplate construction
6061-T6 Machined aluminum frame and sideplates
17-4 grade stainless steel main and pinion gears
Carbonite drag system with Cal’s drag grease
Cold forged, Type-II anodized, machined aluminum spool
CRC: Corrosion Resistant Coating process
4 BB corrosion resistant stainless steel bearings
Ergo Grip handle knob with anodized aluminum handle arm
Silent retrieve system for cranking smoothness
On/Off bait clicker for all lever drag models
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$349.97 to $419.99
$49.99 to $59.99
$29.99 to $39.99