Daiwa Kage 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 = 'kglt1000d-xh' 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 KAGE LT reel is exclusive to independent Daiwa dealers which embraces the LT Concept or Light /Tough Concept. The KAGE LT is lighter by weight yet strong and rigid. The body is constructed from Zaion, a “high density” carbon strain material that is 20 percent stronger and 50 percent lighter than traditional nylon and aluminum. The true carbon body is reduced in size and weight, yet provides a rigid framework for the powerful gearing. The design incorporates the Air Bail and Air Rotor systems that reduce the weight by 15 percent yet provide strength and rigidity. The Aluminum Digigears are precision cut for a smooth, powerful performance with less weight. A unique Premium Cork Handle Knob looks smart yet provides a solid grip. A smooth and powerful ATD Drag System will stop the largest gamefish. Available in sizes from 1000 to 2500, the advanced spinning reel can be utilized for a variety of fresh water and light salt water applications.
Machined Aluminum Alloy DIGIGEAR
LT Concept Light / Tough
10 Bearing System (1 CRBB+8BB+1RB)
Gear Ratio - 6.2:1
Premium Cork Handle Knob
Sized from 1000 series to 2500 series
Independent Dealer Driven Series
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$249.99 to $299.99
$559.99 to $579.99