California's #1 Hunting, Shooting & Fishing Headquarters Since 1971 0 View Cart CART My Account

 Owner Mutu Circle Hook Hover to Zoom

owner

Owner Mutu Circle Hook

 Item# 5163111

rating 1.0rating 2.0rating  3.0rating 4.0rating 5.0 0 Reviews

$5.69 to $6.59

Out Of Stock

query
RESULTSET
query
  ATTR1ID ATTR2ID CAPACITY NON_INVT OF8 OVERALLQOH PICTURE_ID REALNAME SCALEID SKU_ID SKU_OF7 STYLE STYLE_ID USEPACKAGE WEBSTYLE WEBSTYLE_SORT
1 [empty string] [empty string] #4 8 Pack N STK 0 4041 Owner Mutu Circle Hook [empty string] 7606 [empty string] 5163071 7606 [empty string] 5163111 [empty string]
2 [empty string] [empty string] #2 8 Pack N STK 0 4042 Owner Mutu Circle Hook [empty string] 7607 [empty string] 5163091 7607 [empty string] 5163111 [empty string]
3 [empty string] [empty string] #1 7 Pack N STK 0 4043 Owner Mutu Circle Hook [empty string] 7608 [empty string] 5163101 7608 [empty string] 5163111 [empty string]
4 [empty string] [empty string] #2/0 6 Pack N STK 0 4045 Owner Mutu Circle Hook [empty string] 7610 [empty string] 5163121 7610 [empty string] 5163111 [empty string]
5 [empty string] [empty string] #3/0 5 Pack N STK 0 4046 Owner Mutu Circle Hook [empty string] 7611 [empty string] 5163131 7611 [empty string] 5163111 [empty string]
6 [empty string] [empty string] #4/0 4 Pack N STK 0 4047 Owner Mutu Circle Hook [empty string] 7612 [empty string] 5163141 7612 [empty string] 5163111 [empty string]
7 [empty string] [empty string] #1/0 6 Pack N STK 0 4044 Owner Mutu Circle Hook [empty string] 7609 [empty string] 5163111 7609 [empty string] 5163111 0
CACHED false
EXECUTIONTIME 62
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) ) 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 = '5163111' AND (upper(f.web_text) = 'OWNER' or upper(f.orig_text) = 'OWNER' or upper(a.brand) = 'OWNER') 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
SQLPARAMETERS
array
1 OBS
2 RS
3 SM
4 DNR
5 DNRFD
6 CSN
7 SPDNR
2

XX Strong. Saltwater use with up to 50 pound test line. Lighter hook encourages rigged live baits to swim more naturally. Strong enough to land 100# class fish.

 

 Warning - Cancer and reproductive harm WARNING 
Cancer and Reproductive Harm

 www.P65Warnings.ca.gov

No reviews have been written for this product.
Be the first one!  – Write a Review


7 Styles Available

Owner Mutu Circle Hook #4 8 Pack #4 8 Pack $5.69
Owner Mutu Circle Hook #2 8 Pack #2 8 Pack $6.59
Owner Mutu Circle Hook #1 7 Pack #1 7 Pack $6.59
Owner Mutu Circle Hook #2/0 6 Pack #2/0 6 Pack $6.59
Owner Mutu Circle Hook #3/0 5 Pack #3/0 5 Pack $6.59
Owner Mutu Circle Hook #4/0 4 Pack #4/0 4 Pack $6.59
Owner Mutu Circle Hook #1/0 6 Pack #1/0 6 Pack $6.59

arrow to add to cart button Add to Wish List

We Also Recommend Next Prev

x

We use cookies to improve your browsing experience. By continuing to browse our website you agree to our use of cookies. To learn more about how we use cookies, please review our privacy policy  click here.