Outdoor Edge Razor-Pro, Orange
|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) ) 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 = 'RO-20C' AND (upper(f.web_text) = 'OUTDOOR EDGE' or upper(f.orig_text) = 'OUTDOOR EDGE' or upper(a.brand) = 'OUTDOOR EDGE') 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|
The ultimate double-blade knife for big game with our patented replacement razor-blade knife on one side, plus gutting blade on the other to open game like a zipper. This is the sharpest, strongest, replacement razor-knife available with blades that change safely and easily at the push of a button. The black-oxide coated blade holder supports the razor-blade for the strength of a standard knife and sharpness of a surgeon’s scalpel. Our signature gutting blade cuts underneath the skin without cutting hair, or piercing internal organs that can spoil fresh game meat. Both blades open and close independently with one hand and lock securely. The Razor-Pro comes complete with six 3.5” Japanese 420J2 stainless replacement blades and a nylon sheath with pockets to hold both the knife and spare blades. Replacement packs of 6 blades are sold separately. Rubberized TPR handles are available in black with a black nylon sheath and blaze-orange with Mossy Oak® camo sheath. The blaze-orange handle is easy to spot on the ground, saving valuable time in the field while preventing loss.
Knife Blade: 3.5 in / 8.9 cm
Gut Blade: 3.1 in / 7.9 cm
Overall: 8.0 in / 20.3 cm
Razor-Blade Steel: Japanese 420J2 Stainless
Razor-Blade Thickness: 0.6mm
Gut Blade Steel: 7Cr17 Stainless
Blade Holder: 420J2 with black-oxide coating
Handle: Rubberized TPR with 420J2 stainless steel liners
Weight: 8.3 oz / 235 g
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review