BB CREAM

burt's bees

No BB_CREAMS

Be the first to review!

$14.99

Choose Color

query

RESULTSET

query
	ATTR1	ATTR1_ENTRY_ID	FAM	HEX	MAXQC	MAXQOH	MINQC	MINQOH	ORIGATTR1	QOH	SKUOF16	SKU_ID	SORT_ORDER	STYLE_ID
1	LIGHT/MEDIUM	104890	[empty string]	[empty string]	0	6	0	0	LIGHT/MEDIUM	45	[empty string]	640397	[empty string]	130941

SELECT distinct (b.attr1) as origAttr1, max(CASE WHEN b.attr1_alias IS NULL OR RTRIM(LTRIM(b.attr1_alias)) = '' THEN b.attr1 ELSE b.attr1_alias END) as attr1, max(a.sku_id) as sku_id, max(b.attr1_entry_id) as attr1_entry_id, sum(e.qoh+e.qc) as qoh , max(b.attr1_order) as sort_order, max(c.attr1_hex) as hex,max(d.attr1_fam) as fam,max(a.SKU_OF16) as skuOF16,max(e.qoh) as maxqoh,max(e.qc) as maxqc,min(e.qoh) as minqoh,min(e.qc) as minqc,max(a.style_id) as style_id FROM tb_skus a with (nolock) inner join (select distinct sku_id as sku_id from TB_SKU_BUCKETS with (nolock) where 1=1 and store_id in (3,8,9,1,2,6,11,5,7,14,15) group by sku_id having sum(qoh+qc) >0) skuqoh on (skuqoh.sku_id=a.sku_id) LEFT JOIN tb_attr1_entries b WITH (NOLOCK) ON (b.attr1_entry_id = a.attr1_entry_id) LEFT JOIN tb_sku_buckets e WITH (NOLOCK) ON (e.sku_id = a.sku_id) LEFT JOIN tb_attr1_hexes c WITH (NOLOCK) ON (b.attr1=c.attr1) LEFT JOIN tb_attr1_families d WITH (NOLOCK) ON (c.attr1_fam_id = d.attr1_fam_id) WHERE (a.sell_web not in ('N','NO') or (a.sell_web is null)) and a.style_id=? AND e.store_id in(3,8,9,1,2,6,11,5,7,14,15) GROUP BY b.attr1 HAVING sum(e.qoh+e.qc) >= 0 ORDER BY max(b.attr1_order), max(b.attr1_entry_id)

SQLPARAMETERS

array
1	130941

struct
INTERNALLISTPRICE	14.99
INTERNALMARKDOWN	false
INTERNALPRICE	14.99
REG	14.99
SALE	14.99
TERMSALE	false
TERMSALELISTPRICE	0
TERMSALEPRICE	0

Qty

Check Store Availability

Add to Basket

Please login or create an account to save this product to your wish list.

Description
Specs
Reviews
Live Chat

rich in benefits

Hydrating lotion meets lightweight foundation in this BB Cream by Burt's Bee. This 98.9% natural cream includes a SPF protection of 15, as well as aiding in concealing, smoothing, firming and perfecting skin. Available in 3 shades, you are sure to find a match.

Why we love it:

"Love it! Burt's Bees BB Cream is a great alternative to a heavy, pore-clogging foundation. This 99.9% natural tinted moisturizer provides a light and even coverage that lasts all day while also providing protection from the sun. I truly enjoy using this product."

— Connie, Mast General Store, Support Facility, Valle Crucis, NC

"Burt's Bees BB Cream provides good coverage and is gentle on my skin. It's easy to apply and remove at the end of the day. I recommend it to any busy person."

— Adrienne, Mast General Store - Hendersonville, NC

"I love this product because it's 98.9% natural. It blends nicely and doesn't leave my face feeling oily or dry. It also has an SPF 15 in it which makes it even better for the days of light sun exposure."

— Madigan, Mast General Store, Support Facility - Valle Crucis, NC

Made in USA
98.9% natural
SPF 15 protection
Firms, conceals, smooths, perfects, and illuminates skin
Evens skin tone and visibly reduces the appearance of fine lines and wrinkles
Net weight 1.7 ounces

No Reviews Yet!

Spill the Beans

Headline Name Email Overall Rating

Review

We want to make sure you know: All reviews become the property of Mast General Store. Your review requires staff approval before posting. See our Terms of Use for details.

Description

Hydrating lotion meets lightweight foundation in this BB Cream by Burt's Bee. This 98.9% natural cream includes a SPF protection of 15, as well as aiding in concealing, smoothing, firming and perfecting skin. Available in 3 shades, you are sure to find a match.

Why we love it:

"Love it! Burt's Bees BB Cream is a great alternative to a heavy, pore-clogging foundation. This 99.9% natural tinted moisturizer provides a light and even coverage that lasts all day while also providing protection from the sun. I truly enjoy using this product."

— Connie, Mast General Store, Support Facility, Valle Crucis, NC

"Burt's Bees BB Cream provides good coverage and is gentle on my skin. It's easy to apply and remove at the end of the day. I recommend it to any busy person."

— Adrienne, Mast General Store - Hendersonville, NC

"I love this product because it's 98.9% natural. It blends nicely and doesn't leave my face feeling oily or dry. It also has an SPF 15 in it which makes it even better for the days of light sun exposure."

— Madigan, Mast General Store, Support Facility - Valle Crucis, NC
Specs
- Made in USA
- 98.9% natural
- SPF 15 protection
- Firms, conceals, smooths, perfects, and illuminates skin
- Evens skin tone and visibly reduces the appearance of fine lines and wrinkles
- Net weight 1.7 ounces
Reviews

No Reviews Yet!
QA

Your Name Email Question
Live Chat

BB CREAM

$14.99

Choose Color

Qty

Description

Specs

Reviews

Live Chat

Spill the Beans

You may also like