Fishing Legend Chartreuse Hook Remover
|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 = 'HR7-CHAR' AND (upper(f.web_text) = 'FISHING LEGEND' or upper(f.orig_text) = 'FISHING LEGEND' or upper(a.brand) = 'FISHING LEGEND') 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|
OUT WITH THE OLD
The red hook remover
1) Made outside of the USA
2) A three piece unit (often coming apart and leaving the ball in the fish)
3) Have to push and pull & twist to try to get the hook out (always killing the fish and leaving the fish and you bloody!!!)
4) Kids have unpleasant first time memories of fishing (Don’t want to go fishing ever again!!!)
5) Most fisherman end up cutting their line leaving hook in the fish!
6) Most importantly they “JUST DON’T WORK”
IN WITH THE NEW
The One and Only Hook Remover
Strong selling points
1) Made in the USA
2) A two piece unit (made of the highest grade plastic to last a life time)
3) Multi function custom metal clip
a) Clip the One and Only Hook Remover to your pocket
b) Turn clip to secure the One and Only Hook Remover to your line while putting your fish on the stringer. (Great feature for boats and float tubes to keep from losing in the water!!!)
c) Remove clip and clean slot of the One and Only Hook Remover (Great feature when using dough baits!)
4) Simply insert tight line in the One and Only Hook Remover slide down to hook! (the hook is out!)
8) Designed for quick catch and release (Keeps fish alive!!!)
9) Catch more fish!
10) So simple even a kid can use them! (Great family memories!!!)
11) Use it on the shore, on your boat or your float tube.
12) The One and Only Hook Remover
“IT REALLY WORKS!”
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$35.99 to $46.99
$24.99 to $29.99
$19.99 to $25.99