Yo-Zuri H.D. Carbon Leader Pink 30 yards
Item# HD 100LB DP
$10.99 to $80.99
|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 = 'HD 100LB DP' AND (upper(f.web_text) = 'YO-ZURI' or upper(f.orig_text) = 'YO-ZURI' or upper(a.brand) = 'YO-ZURI') 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|
Double Your Invisibility with Yo-Zuri H.D. Fluorocarbon Disappearing Pink. Yo-Zuri H.D. Carbon™ is a fluorocarbon leader that maximizes the advantages of fluorocarbon with a Disappearing Pink tint. Fluorocarbon is virtually invisible in the water and red is the first color to disappear in the water column. Pink is the lightest shade of red and as a result disappears the quickest. Fluorocarbon is also only invisible until it gets nicked or scraped. If this happens, that nicked section of the leader actually lights up from the sunlight becoming highly visible. The color pink added to the line helps greatly reduce this problem.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$8.99 to $15.99
$14.99 to $49.99
$7.99 to $8.79
$5.49 to $5.69
$10.49 to $11.79
$4.69 to $4.99