Shimano Salmon/Steelhead Spinning Rod
Out Of Stock
|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 = 'SMS86M2B' AND (upper(f.web_text) = 'SHIMANO' or upper(f.orig_text) = 'SHIMANO' or upper(a.brand) = 'SHIMANO') 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 salmon and steelhead specific Scimitar series by Shimano was designed with a high-end look and feel that also outclasses every rod in the competition. These lightweight and powerful graphite spinning and casting rods feature a longer rear and foregrip to balance the longer rod blanks that are necessary when fishing for salmon and steelhead whether you are casting spoons, blades or crankbaits. No matter the technique, the Scimitar series is offered in the ideal powers and actions to get the job done. The Scimitar series feature aluminum oxide guides for increased casting distance and durability, especially for those anglers fishing with PowerPro braided fishing lines. The graphite composite construction makes the rod extremely light, super durable, and most importantly increases the rod’s sensitivity. All of the rods within the Scimitar salmon and steelhead series are two pieces.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$199.99 to $219.99
$49.99 to $54.99
$69.99 to $79.99
$79.99 to $94.99
$109.99 to $119.99
$109.97 to $299.99