Daiwa Fuego LT
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) ) 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 = 'fglt1000d' 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|
The new Fuego LT series of spinning reels, state of the art fishing tools that define Daiwa’s commitment to the LT Concept of lighter, tougher material. With conventional, heavier spinning reels, long hours of casting and retrieving can fatigue the arms and hands.The Fuego LT housing is light but sturdy constructed from a Carbon based material. The innovative Magsealed main shaft delivers butter smooth performance while preventing water or dirt intrusion. The technology uses a Mag Oil that can be magnetically solidified similar to a packing on a boat’s propeller shaft. Oil smooth operation as well as a water and impurities barrier makes the design and function unparalleled. The Machined Aluminum handle is ergonomically correct and screws easily into the body. Six ball bearings and one roller bearing combine to create the ultimate in silky smooth operation. If you are looking for an amazing reel packed with high-end design and technology features then the Daiwa’s Fuego LT may be the reel for you.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$209.99 to $432.99
$449.99 to $499.99
$119.99 to $129.99
$189.99 to $199.99
$19.99 to $24.99