Tacstar Side Saddle
Out Of Stock
|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 = '1081157' AND (upper(f.web_text) = 'TACSTAR' or upper(f.orig_text) = 'TACSTAR' or upper(a.brand) = 'TACSTAR') 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|
Places extra shells right where you need them for a fast reload.
The patented TacStar Sidesaddle mounts 6 extra rounds on your shotgun in a convenient and accessible location for fast reloading. The tough, weatherproof shell carrier is attached to an aluminum mounting plate that installs directly on the shotgun receiver. All mounting screws are included, no gunsmithing required. Installation is easy, and in most cases requires no alterations to the shotgun. Note: some field grade shotguns may require a modification to the shotgun's forend. Shotguns using the TacStar pistol grip forend do not require modification. The 4-round sidesaddle will also work smoothly with all models without modification. Works great as a separate Shotshell Storage Caddy for Duck Blind, Boat or Hunting Cabin! 12 Gauge Only.
Unbreakable, Corrosion Resistant Polymer Shellholder
Rugged, Aluminum Backing Plate
Easy Mounting, No Gunsmith Design
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$16.99 to $19.99
$16.99 to $19.99