Shimano Spheros SW A
$149.99 to $179.99
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) ) 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 = 'SPSW6000HGA' 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 jack of all trades in the saltwater realm, Shimano redesigned the Spheros SW series of saltwater spinning reels to conquer both offshore and inshore waters. Now featuring Shimano's flagship Infinity Drive technology to improve pinion gear support and enhance the overall drive gear design, Spheros SW provides anglers with increased winding power under load when cranking against hard-fighting game fish. Wielding both X-Protect and X-Shield for improved water resistance for increased durability in the harsh saltwater environment, Spheros SW fortifies an IPX8 water-resistant-rated body. From jigging for groupers or amberjacks, to tossing lures at cobia and football-size bluefin tuna, or free-lining live bait to snook or striped bass, the Spheros SW series will provide dependable performance for anglers targeting prized game fish.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$29.99 to $32.99
$269.99 to $359.99
$679.99 to $699.99
$139.99 to $159.99