Daiwa Tatula SV 103HS
|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 = 'tasv103hs' 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|
TWS (LONG CAST WITH MINIMAL BACKLASH)
Ultimate Tournament Drag
Cut-Away 90mm Swept Handle
Custom Soft-Touch Handle Knob
H: Gold, HS: Red, XS: Purple
Daiwa's T-wing System solves an age old problem with baitcasting reel levelwind systems. The "T" aperture allows line to flow freely through the wide top section on outcast, reducing the normally sharp angles and friction that slow line flowing through a narrow aperture when exiting the reel. For retrieve, line drops into the narrow, lower channel of the T-wing for even distribution across the spool width.
Specially developed material is applied to the induct rotor, which is exposed out from the spool when rotating at high speed. As the spool slows, the induct rotor moves back towards the magnetic field which brakes the spool according to the weights of different types of lures.
TATULA SV TW's SV SPOOL is made of Super Duralumin which is lighter but has great strength. SV SPOOL with Air Brake System helps cast lightweight lures with ease to give you a longer cast with no back lash.
Daiwa's exclusive swept handle moves the paddles closer to the rod's centerline. The result is less wobble of the rod and reel in your hand as you crank. That means less wasted energy - a more powerful retrieve.
CUSTOM I-SHAPED HANDLE KNOBS
Featuring Daiwa's Soft Touch material.
Compact Body with bright glitter coating that is same as Daiwa's high end models.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$79.99 to $89.99
$319.99 to $349.99
$459.99 to $499.99
$229.99 to $249.99