Ardent Reel Guard 16oz Pump Spray Bottle
|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 = '4140' AND (upper(f.web_text) = 'ARDENT' or upper(f.orig_text) = 'ARDENT' or upper(a.brand) = 'ARDENT') 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|
Now available in a large, 16 oz pump spray bottle, Ardent Reel Guard® Corrosion Inhibitor is a breakthrough in chemical engineering that inhibits corrosion on saltwater equipment. Reel Guard® also delivers unmatched protection in freshwater for reels left out in the rain, soaked while wade fishing, or stored in high moisture areas like rod lockers. By dissolving sodium, potassium, and other hard water minerals, it significantly reduces the onset of galvanic corrosion in saltwater environments. Spray Reel Guard® on reels and equipment after a day on the water, and let dry. No scrubbing, no rinsing - let Reel Guard® Corrosion Inhibitor work for you.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$6.99 to $10.99
$349.99 $299.97 to $299.99
$5.99 to $7.99
$6.99 to $8.99