Gerber Machete Jr. with Air Ranger Knife
|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 = '31-002368N' AND (upper(f.web_text) = 'GERBER' or upper(f.orig_text) = 'GERBER' or upper(a.brand) = 'GERBER') 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|
Built Gerber tough, the Gator Jr. is a packable walker annihilation weapon. The two-sided blade has both a fine edge for hacking through the oncoming hordes and a serrated edge for rough-cutting through the brittle bones of the undead. For covert, low-profile travel through hostile territory, the Gator Jr. is the perfect machete for lightweight travel.
There's something about the way the Air Ranger feels in your hand that just makes you feel like you're ready for anything. And it has mostly to do with the checkering on the machined aluminum grip; precision texturing that can only be accomplished on sophisticated CNC machining equipment.
The tactile sensation is very high when gripped, which translates into an unusual degree of dexterity, which translates into confidence.
William Harsey, Jr. is the heralded knifemaker who conceived this popular clip folder. To his credit, he found the pivotal balance between a knife that's smooth to deploy and use, and a knife that's as tough as they come. The hearty thumbstud facilitates easy one-handed opening. The stainless steel pocket clip is strong and reliable.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review