Black Rifle Coffee Company Beyond Black Roast
|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,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 = '30-150-12G' AND (upper(f.web_text) = 'BLACK RIFLE COFFEE' or upper(f.orig_text) = 'BLACK RIFLE COFFEE' or upper(a.brand) = 'BLACK RIFLE COFFEE') 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 color black brings to mind thoughts of power, elegance, formality, death, evil, and mystery. As a color, it is both frightening yet undeniably compelling. Our core roast, Beyond Black, has long explored our innate curiosity for all things unknown, and our new design brings that sentiment to the forefront.
Enjoy this new look for a timeless BRCC classic –– and revel in its powerful spicy aromas, notes of dark chocolate, and sublime smoky finish.
Robust flavors feature a spicy aroma with dark chocolate tasting notes and a satisfying smoky finish.
- 12 oz
- Dark Roast
Cancer and Reproductive Harm
No reviews have been written for this product.
Be the first one! – Write a Review
$249.99 to $250.00