Daiwa Saltiga Lever Drag
$499.99 to $699.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 = 'SAGLD15-2SPD' AND (upper(f.web_text) = 'DAIWA' or upper(f.orig_text) = 'DAIWA' or upper(a.brand) = 'DAIWA') 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|
All Saltiga LD reels feature a one-piece machined aluminum frame and side plate to assure precise alignment of bearings and gears for amazingly smooth performance, less flex, more power and reduced binding even during the fiercest battles. Oversized, super-hard, polished and meshed stainless steel main and pinion gears fit together perfectly to drive the kicking gear with extra strength and nearly silent precision while large spool bearings reduce side load so anglers can concentrate on fighting fish rather than the reel.
Daiwa's acclaimed Advanced Tournament Drag System (ATD) keeps each Saltiga LD cool during the heat of battle while providing consistent maximum pressure through the end game. A machined aluminum spool won't bend under high drag pressure or outwardly expand as you tightly wind on line. A machined aluminum rod clamp always keeps your reel tightly secured.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$109.99 to $129.99
$359.99 to $489.99
$349.97 to $419.99
$419.99 to $579.99
$259.99 to $319.99
$639.99 to $659.99
$432.99 to $442.99