Tipton Compact Range Vise
|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(?,?,?) ) 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 = ? AND (upper(f.web_text) = ? or upper(f.orig_text) = ? or upper(a.brand) = ?) 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 Tipton® Compact Range Vise offers a completely new level of performance, securely holding he widest array of guns possible while collapsing to fit in a range bag. The compact design is a convenient solution to gun cleaning at the range. The Compact Range Vise collapses to 11-1/4” and fully expands to 17-3/4”, making it easily carried but full functioning when completely expanded. Six rubber feet provide the vise a very rigid, non-slip base. Two non-marring forks protect your guns’ finish while holding them securely in place for cleaning, light maintenance or as an extra set of hands. The Compact Range Vise is extremely durable and is made from highquality, solvent-resistant nylon that will deliver years of lasting performance. Serious shooters
know keeping their guns clean is essential to performance, making the Compact Range Vise the perfect range accessory.
- Solvent-resistant nylon delivers lasting performance
- Adapts to securely hold all types of firearms
- Expands from 11-1/4” to 17-3/4”
- Non-marring contact surfaces
*Firearm NOT Included*
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review