Daiwa Saltist MQ
$319.99 to $349.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(?,?,?) ) 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 = ? AND (upper(f.web_text) = ? or upper(f.orig_text) = ? or upper(a.brand) = ?) 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 Saltist you have come to know and love has been redesigned and upgraded. Still featuring a heavy duty aluminum frame for maximum durability, Daiwa has now added their Monocoque Body (MQ) for even more power and a more compact frame. An MQ frame design allows us to fit a larger gear inside of the reel, adding power and longevity to your gear set. A 360 degree screw-in sideplate removes to need for traditional sideplate screws, allowing for a more compact and more weather resistant housing.
Utilizing a Zaion AIR ROTOR, the rotation is effortless allowing you to cast and retrieve all day with ease.
Complete with a Magsealed main shaft to maximize protection from the elements, you will be ready to take on the even the toughest of battles. The Saltist MQ is truly a prime example of what a spinning reel should be capable of.
MQ Body takes reel design to the next level. The MQ system does not require a body cover, instead using an engine plate to screw directly to the body. Eliminating the need for screws to hold a body cover in place. MQ body improves the strength of the reel, it also improves the water-resistance of the body and allows a larger diameter drive gear to be installed.
Daiwa’s innovative bail design features a hollow tubular stainless steel bail that delivers maximum rigidity and strength with minimum weight. Featuring a smooth protrusion-free design and construction line easily slides unencumbered along the Air Bail towards the line roller for trouble free line control.
Lighter, stronger and more balanced than any rotor system that’s come before, ‘Air Rotor’ delivers a great leap forward in rotor design and function and delivers the ultimate reel sensitivity and rotational balance.
A further evolution of its predecessor Digigear, Tough Digigear is our brand new digitally designed, machine cut gearing system that ensures ultimate gear precision, rotational smoothness, and strength.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$74.99 to $114.99
$79.99 to $84.99
$239.99 to $259.99
$229.99 to $249.99
$139.99 to $159.99
$149.99 to $179.99
$279.99 to $299.99
$199.99 to $209.99
$14.97 to $24.99