Sightmark Firefield 6.7" Carbine Quad Rail
|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 = 'FF34001' AND (upper(f.web_text) = 'SIGHTMARK' or upper(f.orig_text) = 'SIGHTMARK' or upper(a.brand) = 'SIGHTMARK') 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 Firefield Carbine 6.7 inch quad rail is built for maximum intensity and is sure to be a vital accessory for any shooter’s firearm. Constructed from hard, anodized aluminum, the Firefield Carbine 6.7 inch quad rail’s sleek; matte black finish blends with any tactical weapon for a seamless, streamlined look.
Featuring mil spec picatinny rails, the Firefield Carbine 6.7 inch quad rail is compatible with most picatinny mount accessories, and its 2-piece bolt on design prevents scratches and damage to weapons. The Firefield Carbine 6.7 inch quad rail also features numbered rail slots for precise optic and accessory placement.
Protected by the Firefield manufacturer’s warranty and the quality that comes with the Firefield name, the Firefield Carbine 6.7 inch quad rail is sure to please any Xtreme shooting sports player or tactical shooter. Firefield-Victory Justifies Everything!
• two-piece design
• hard anodized aluminum construction
• mil-spec picatinny rails
• numbered rail slots
• easy to install
Cancer and Reproductive Harm
Average of 5 customer reviews:
Write a Review
How Long Have You Been Using This Product: Less than 1 month
$13.97 to $23.99