Caldwell Matrix Rest
|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 = '101600' AND (upper(f.web_text) = 'CALDWELL' or upper(f.orig_text) = 'CALDWELL' or upper(a.brand) = 'CALDWELL') 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 one rest that does it all.
Ulta rigid 2-piece sliding frame adjusts to fit any gun
Innovative new spring loaded elevation system allows for fast one handed, no wobble adjustment
Open central channel accomodates detachable magazines and lever action guns
Convenient storage compartment lid doubles as a handgun base
The highly versatile Matrix combines great new features and rock solid stability in an affordable rest. Central tot eh design is the innovative, ultra rigid U-channel frame, quickly adjusting in length for the perfect fit with any gun while remaining perfectly stable. The two piece sliding frame incorporates an open central channel with plenty of clearance for hi-capacity detachable magazines (AR style guns) as well as lever action guns. A convenient storage area incorporated into the front of the base features a removable lid that adds additional clearance when detached but also doubles as a rubberized rear support surface for firing handguns when left in place.
Another key feature is the all new innovative front elevation system. A spring loaded tension mechanism and height adjustment knob allow for fast, one handed elevation adjustments, keeping the front cradle wobble free throughout the entire vertical range. Overmolded front and rear supports protect the guns finish but are firm enough to prevent any give or play.
Shooters will also enjoy the versatility of converting the Matrix into a compact front rest be removing the rear portion of the frame. Weather used a s a front rest or as a full length rest the Matrix provides stability that will deliver maximum accuracy potential.
No reviews have been written for this product.
Be the first one! – Write a Review