Daiwa Eliminator Spinning Reel
$109.99 to $129.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,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 = 'ELIMINATOR4000' 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|
These reels are Well Suited For Braided Line Applications. The reel body is constructed utilizing the Hardbodyz Concept. The Aluminum Frame and Sideplate combine to form a strong rigid housing for the state of the art Digigears cut to smooth, precise standards. The attractive yet durable Anodized Finish is scratch and corrosion resistant.
The Air Rotor design is 15-percent lighter yet more precisely balanced than competing reels. The stout Aluminum Spool can carry the increased pressures of braided line and houses buttery smooth, long lasting Felt Drags. Slide-in handle for easy left or right hand crank conversion. Suitable for fresh and saltwater applications. If you are looking for a high quality line of workhorse-like reels at a smart price, then you owe yourself a look at the ELIMINATOR SERIES SPINNING REELS.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$209.99 to $219.99
$99.99 to $109.99
$89.99 to $99.99
$279.99 to $299.99
$84.97 to $129.99
$99.99 to $109.99