Caldwell Lead Sled Plus
|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 = '820300' 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 Original Lead Sled revolutionized the shooting rest market by nearly eliminating felt recoil from even the heaviest magnum rifles. The Lead Sled Plus is the next-generation of Lead Sled. Like the Original, the Plus reduces recoil by up to 95% while securely holding your gun on target.
Key improvements include a newly-designed precision elevation shaft that eliminates wobble and play in front elevation keeping you perfectly on target and a new Universal Weight Tray. The unique new tray adjusts to accommodate a variety of weight types, including 25 pound bar bell weights, sand or lead shot bags.
These improvements along with all the other great features are sure to continue the legacy of The Lead Sled as the world's finest recoil reducing rest.
Carry your weight conveniently and easily with our available Weight Carrying Bags
Up to 95% recoil reduction
Ideal for magnum rifles & slug guns
New innovative, adjustable weight tray slides to accommodate bar bell weights as well as weight bags
Holds two 25 lb. bar bell weights
Holds up to 100lbs. of lead shot
New improved "no wobble" elevation ram
Fingertip elevation adjustment
Filled front bag included
Padded rear rest
Non-marring rubber feet
Adjustable height rear foot
Weight: Approx. 15 lbs
Weight Capacity: up to 100 lbs
Frame Material: Steel
Box Size: 25.8" wide x 11.3" high x 3.9" deep
No reviews have been written for this product.
Be the first one! – Write a Review
$26.97 to $39.99