Geissele Super 3 Gun (S3G) Trigger
|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) ) 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 = '05-152' AND (upper(f.web_text) = 'GEISSELE AUTOMATICS INC' or upper(f.orig_text) = 'GEISSELE AUTOMATICS INC' or upper(a.brand) = 'GEISSELE AUTOMATICS INC') 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 Geissele Super 3 Gun (S3G) trigger is a semi-automatic-only derivative of the two-stage Super Select-Fire (SSF) combat trigger that Geissele Automatics produces for customers in the U.S. Special Operations Community. The S3G was developed to combine the SSF combat trigger’s match-grade semi-automatic performance with its smooth single-stage full-automatic feel to make a fast, smooth, and robust trigger ideal for 3 Gun competition shooting.
Note: The S3G trigger has a very short, light pull and reset. Geissele does not recommend it for duty use, bench rest, accuracy work or shooting small groups. It is designed for close course competition use where rapid target engagement with quick follow up shots are required.
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$20.97 to $39.99
$19.99 to $21.99
$29.99 $14.97 to $19.97
$26.97 to $44.99
$29.99 to $37.99