Daiwa Tatula SV TW103
|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 = 'TTUSV103HS' 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|
Just when you thought the Tatula SV reel could not get any better. Daiwa is excited to introduce the new smaller 100 size TATULA SV TW103. Their development team has redesigned this Tatula SV reel to be the smallest and lightest most stress free reel we have ever built. What really makes this reel special is the patented SV Spool and our Airbrake technology. These two features work together to minimize backlashes while allowing the reel to achieve extreme cast-ability with unmatched control by using both magnetic breaking and centrifugal breaking technology.
The Daiwa Zero Adjust spool provides settings to finely tune the spool tension and T-Wing System level wind opens up line feed, all working together to casts longer, more accurately and provide you the stress free control of not having to worry about backlashing when casting in the wind, skipping baits or casting light lures. Comfort is enhanced by a smaller low-profile design and Soft Touch handle knobs. The SV TWS103 reels is formed around a Aluminum Frame providing rigidity and a smooth performance.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$252.99 to $357.99
$249.99 to $319.95
$132.99 to $139.99
$399.99 to $449.99
$209.99 to $249.99