Water Gremlin Rubbercor
|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 = 'PRC0' AND (upper(f.web_text) = 'WATER GREMLIN' or upper(f.orig_text) = 'WATER GREMLIN' or upper(a.brand) = 'WATER GREMLIN') 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|
Water Gremlin developed the Rubbercor® Sinker in 1949… the first truly original idea in sinkers since the rock. Rubbercor® slips easily on and off your line. Just give the rubber ears a half twist in opposite directions and Rubbercor® is ready to take your bait down to where the fish are biting.
Your line is protected by the rubber core inside the lead sleeve. To remove, simply twist the ears back to their original positions. There’s no tying, no pinching, no fuss, no mess. Rubbercor® is safe to use, even on the lightest monofilament line.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$10.99 to $38.99
$3.97 to $7.99
$5.97 to $8.99
$6.39 to $6.99
$4.59 to $5.29
$6.99 to $7.49
$599.99 to $879.99