Buck Knives 110 Folding Hunter
|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 = '0110BRS/9210' AND (upper(f.web_text) = 'BUCK' or upper(f.orig_text) = 'BUCK' or upper(a.brand) = 'BUCK') 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 110 Folding Hunter® is a classic and traditional favorite! Buck's Folding Hunter was created in 1963 when Al Buck decided that a revolutionary locking blade knife was needed by outdoorsmen who wanted a sturdy knife but did not want to carry a long, fixed blade knife. He was right and the result proved to be the key to the company's future. The challenge was to combine the strengths of other folding knives with locking mechanisms into a good-looking, reliable product. It wasn't easy, but after a series of refinements, the Model 110 was unveiled. Within six months, this innovation was the hottest knife in the industry.
The Folding Hunter®, after over 50 years, is still one of America's best-selling knives.
Blade Shape: Clip
Blade Thickness: 0.120"
Blade Length: 3 3/4" (9.5 cm)
Weight: 7.2 oz (205 g)
Handle: Crelicam™ genuine ebony
Carry System: Sheath
Origin: Made in the USA
No reviews have been written for this product.
Be the first one! – Write a Review