Primos Trigger Stick Gen3 Tall Tripod
|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 = '65815' 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 Locking Leg Angles give you more stability at more angles in the field. 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 Leg Angle Lock
- New Contoured Grip with No-Slip Backbone
- Strengthened Rotating Joint for Smooth Panning
- New Heavy Duty look with Dark Earth Accents
- Adjust from 24″ to 62″
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$349.99 to $399.99