Shimano Curado 300 K
|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 = 'CU300K' 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|
Tournament-tough quality and superb dependability, Shimano built the Curado 300 for anglers who aren't just chasing fish but those targeting quality over quantity. Incorporating a deep 300-size spool intended for heavy-pound line and the needed capacity for extra-long casts, the Curado 300 features a long handle with wide-grip knobs to provide anglers with the extra power that's necessary when pulling on big fish. At the backbone of the Curado 300 lies its rigid HAGANE Body that prevents flex when that giant finally decides to commit. Available in two gear-ratio options (a standard 4.7:1 and an HG 6.6:1) the Curado 300 allows anglers to find the right reel to match their fishing style and needs. Engineered with power in mind, the standard 4.7:1 model pulls double-duty for anglers fishing slower, methodical presentations, or when fishing with Alabama rigs or magnum crankbaits. The HG's 6.6:1 gear ratio provides a slightly faster retrieve and is ideal for anglers aggressively working baits or for quickly picking up topwater slack. Built to fish big baits for big fish, Shimano created the Curado 300 to perform and never back down.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$239.99 to $259.99
$239.99 to $249.99
$104.99 to $114.99
$289.97 to $489.99
$449.99 to $519.99
$679.99 to $699.99