Primos Short Bi-Pod Pole Cat
|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 = '65482' 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|
The best strength-to-weight ratio in the business makes this the most trusted monopod in the field. Seamless tempered-aluminum tubes with patented Posi-Lock™ adjustment are bench stable, lightweight, mobile, and silently adjust to terrain with a quick quarter-twist. The rugged nylon yoke is strong, lighter than steel and will never rust. The tactile rubber shooting V grips your stock for a steadier shot. It’s rock-solid support that is lightweight enough to take anywhere.
Three piece bi pod
Perfect for kneeling to sitting
Adjust from 16″ to 38″
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$299.99 to $300.00
$69.97 to $100.00
$29.97 to $38.00