AFW Mighty Mini Snap Swivel
$3.49 to $4.49
|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 = 'ftss070b-a' AND (upper(f.web_text) = 'AFW' or upper(f.orig_text) = 'AFW' or upper(a.brand) = 'AFW') 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|
Mighty-Mini Swivels and Snap Swivels are 100% stainless steel and are 3 times stronger than conventional brass swivels of the same size. Smart anglers know that terminal tackle can spook wary game fish. This line of compact, 100% stainless steel crane swivels was engineered to be smaller and stronger than the leading brands of swivels on the market. Now you can use swivels for your rigs, and snap swivels for attaching lures, that are less visible and significantly more powerful. Mighty-Mini Swivels also have less drag and provide enhanced rotation for more strikes. For decades, crane swivels were manufactured from brass because it is a relatively corrosion resistant material and easy to manufacture. Still today, the leading brand of mini swivels continues to use brass bodies with stainless steel rings that cannot match the strength of Mighty Mini Swivels. Recent advances in manufacturing enable us to bring you these revolutionary, smaller and stronger components. Mighty Mini Swivels are available in gunmetal black finish with and without stainless steel tournament-grade snaps for the ultimate in connection protection.
|Size Number||Test Lbs||Number per Pack||Part Number|
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$2.97 to $4.99
$6.79 to $6.89
$599.99 to $879.99
$10.99 to $38.99
$4.69 to $6.89