Daiwa Tatula 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,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 = 'TALT1000D-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 Tatula LT lineup reflects the sophisticated engineering and design that has vaulted spinning reels on to the center stage of the bass fishing world. The Zaion Body is composed of a “high density” carbon strain material that is lighter and stronger than conventional construct material. The Tatula LT reel is one of the lightest spinning reels on the market. The state of the art Air Rotor design is 15% lighter yet stronger by dispersing the pressure evenly over the part. The digitally Machined Aluminum Alloy Digigear is smooth and flawless, delivering the power of the handle directly to the rotor with zero play. The 7 ball bearing system allows the parts to move effortlessly. The Daiwa Tatula LT series of spinning reels utilizes state of the art materials and technology to create a versatile tool designed with the more sophisticated bass fisherman in mind.
Now with a smaller and more compact frame, the LT family of reels utilize a small, lightweight frame with a larger DigiGear for the perfect combination of Light and Tough
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$349.97 to $419.99
$399.99 to $449.99
$209.99 to $249.99
$144.97 to $219.99
$79.99 to $89.99
$104.99 to $109.99