Primos Trigger Stick Gen3 Short Bipod
|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 = '65811' AND (upper(f.web_text) = 'PRIMOS' or upper(f.orig_text) = 'PRIMOS' or upper(a.brand) = 'PRIMOS') 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|
Like every Trigger Stick, the new Primos Trigger Stick Gen 3 adjusts to your desired height with just one hand and the pull of a trigger. The new Quick Detach Yoke System with Integrated Lock makes it easier than ever to switch from gun to optics and back again. Smoother panning action helps you rotate, scan and find your perfect shot effortlessly. It’s the next level of Trigger Stick to give you the next level of confidence in every shot in all terrain – standing, sitting, or kneeling!
- New Quick Detach Yoke System with Integrated Lock. NOTE: Keep in locked position at all times to assure yoke or optics are secure.
- New Contoured Grip with No-Slip Backbone
- Strengthened Rotating Joint for Smooth Panning
- New Heavy Duty look with Dark Earth Accents
- Adjusts from 18″ to 38″
*** Does NOT include camera plate
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$26.97 to $40.99
$13.97 to $23.99