SEEKING BALANCE CANDLE

ai root candle

No 9941

Be the first to review!

$17.99

Choose Color

query

RESULTSET

query
	ATTR1	ATTR1_ENTRY_ID	FAM	HEX	MAXQC	MAXQOH	MINQC	MINQOH	ORIGATTR1	QOH	SELL_WEB	SKUOF16	SKU_ID	SORT_ORDER	STYLE_ID
1	AWAKEN	88331	[empty string]	[empty string]	0	6	0	0	AWAKEN	35	Y	[empty string]	561457	1	116713
2	ENERGIZE	88333	[empty string]	[empty string]	0	6	0	0	ENERGIZE	33	Y	[empty string]	561455	3	116713
3	ENLIGHTEN	88334	[empty string]	[empty string]	0	4	0	0	ENLIGHTEN	30	Y	[empty string]	723844	4	116713
4	ILLUMINATE	88335	[empty string]	[empty string]	0	6	0	0	ILLUMINATE	43	Y	[empty string]	561456	5	116713
5	RELAX	88336	[empty string]	[empty string]	0	8	0	0	RELAX	32	Y	[empty string]	561454	6	116713
6	RELIEVE	88337	[empty string]	[empty string]	0	5	0	0	RELIEVE	35	Y	[empty string]	606645	7	116713

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,max(a.sell_web) as sell_web 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 (11,8,6,5,9,14,15,7,2,1,3,97) group by sku_id having sum(qoh+qc) >= 4 ) 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 in ('Y','YES') ) and a.style_id=? AND e.store_id in(11,8,6,5,9,14,15,7,2,1,3,97) GROUP BY b.attr1 HAVING sum(e.qoh+e.qc) >= 4 ORDER BY max(b.attr1_order), max(b.attr1_entry_id)

SQLPARAMETERS

array
1	116713

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

query

RESULTSET

query
	ATTR1	ATTR1_ENTRY_ID	FAM	HEX	MAXQC	MAXQOH	MINQC	MINQOH	ORIGATTR1	QOH	SELL_WEB	SKUOF16	SKU_ID	SORT_ORDER	STYLE_ID
1	AWAKEN	88331	[empty string]	[empty string]	0	6	0	0	AWAKEN	35	Y	[empty string]	561457	1	116713
2	ENERGIZE	88333	[empty string]	[empty string]	0	6	0	0	ENERGIZE	33	Y	[empty string]	561455	3	116713
3	ENLIGHTEN	88334	[empty string]	[empty string]	0	4	0	0	ENLIGHTEN	30	Y	[empty string]	723844	4	116713
4	ILLUMINATE	88335	[empty string]	[empty string]	0	6	0	0	ILLUMINATE	43	Y	[empty string]	561456	5	116713
5	RELAX	88336	[empty string]	[empty string]	0	8	0	0	RELAX	32	Y	[empty string]	561454	6	116713
6	RELIEVE	88337	[empty string]	[empty string]	0	5	0	0	RELIEVE	35	Y	[empty string]	606645	7	116713

array
1	116713

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

query

RESULTSET

query
	ATTR1	ATTR1_ENTRY_ID	FAM	HEX	MAXQC	MAXQOH	MINQC	MINQOH	ORIGATTR1	QOH	SELL_WEB	SKUOF16	SKU_ID	SORT_ORDER	STYLE_ID
1	AWAKEN	88331	[empty string]	[empty string]	0	6	0	0	AWAKEN	35	Y	[empty string]	561457	1	116713
2	ENERGIZE	88333	[empty string]	[empty string]	0	6	0	0	ENERGIZE	33	Y	[empty string]	561455	3	116713
3	ENLIGHTEN	88334	[empty string]	[empty string]	0	4	0	0	ENLIGHTEN	30	Y	[empty string]	723844	4	116713
4	ILLUMINATE	88335	[empty string]	[empty string]	0	6	0	0	ILLUMINATE	43	Y	[empty string]	561456	5	116713
5	RELAX	88336	[empty string]	[empty string]	0	8	0	0	RELAX	32	Y	[empty string]	561454	6	116713
6	RELIEVE	88337	[empty string]	[empty string]	0	5	0	0	RELIEVE	35	Y	[empty string]	606645	7	116713

array
1	116713

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

query

RESULTSET

query
	ATTR1	ATTR1_ENTRY_ID	FAM	HEX	MAXQC	MAXQOH	MINQC	MINQOH	ORIGATTR1	QOH	SELL_WEB	SKUOF16	SKU_ID	SORT_ORDER	STYLE_ID
1	AWAKEN	88331	[empty string]	[empty string]	0	6	0	0	AWAKEN	35	Y	[empty string]	561457	1	116713
2	ENERGIZE	88333	[empty string]	[empty string]	0	6	0	0	ENERGIZE	33	Y	[empty string]	561455	3	116713
3	ENLIGHTEN	88334	[empty string]	[empty string]	0	4	0	0	ENLIGHTEN	30	Y	[empty string]	723844	4	116713
4	ILLUMINATE	88335	[empty string]	[empty string]	0	6	0	0	ILLUMINATE	43	Y	[empty string]	561456	5	116713
5	RELAX	88336	[empty string]	[empty string]	0	8	0	0	RELAX	32	Y	[empty string]	561454	6	116713
6	RELIEVE	88337	[empty string]	[empty string]	0	5	0	0	RELIEVE	35	Y	[empty string]	606645	7	116713

array
1	116713

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

query

RESULTSET

query
	ATTR1	ATTR1_ENTRY_ID	FAM	HEX	MAXQC	MAXQOH	MINQC	MINQOH	ORIGATTR1	QOH	SELL_WEB	SKUOF16	SKU_ID	SORT_ORDER	STYLE_ID
1	AWAKEN	88331	[empty string]	[empty string]	0	6	0	0	AWAKEN	35	Y	[empty string]	561457	1	116713
2	ENERGIZE	88333	[empty string]	[empty string]	0	6	0	0	ENERGIZE	33	Y	[empty string]	561455	3	116713
3	ENLIGHTEN	88334	[empty string]	[empty string]	0	4	0	0	ENLIGHTEN	30	Y	[empty string]	723844	4	116713
4	ILLUMINATE	88335	[empty string]	[empty string]	0	6	0	0	ILLUMINATE	43	Y	[empty string]	561456	5	116713
5	RELAX	88336	[empty string]	[empty string]	0	8	0	0	RELAX	32	Y	[empty string]	561454	6	116713
6	RELIEVE	88337	[empty string]	[empty string]	0	5	0	0	RELIEVE	35	Y	[empty string]	606645	7	116713

array
1	116713

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

query

RESULTSET

query
	ATTR1	ATTR1_ENTRY_ID	FAM	HEX	MAXQC	MAXQOH	MINQC	MINQOH	ORIGATTR1	QOH	SELL_WEB	SKUOF16	SKU_ID	SORT_ORDER	STYLE_ID
1	AWAKEN	88331	[empty string]	[empty string]	0	6	0	0	AWAKEN	35	Y	[empty string]	561457	1	116713
2	ENERGIZE	88333	[empty string]	[empty string]	0	6	0	0	ENERGIZE	33	Y	[empty string]	561455	3	116713
3	ENLIGHTEN	88334	[empty string]	[empty string]	0	4	0	0	ENLIGHTEN	30	Y	[empty string]	723844	4	116713
4	ILLUMINATE	88335	[empty string]	[empty string]	0	6	0	0	ILLUMINATE	43	Y	[empty string]	561456	5	116713
5	RELAX	88336	[empty string]	[empty string]	0	8	0	0	RELAX	32	Y	[empty string]	561454	6	116713
6	RELIEVE	88337	[empty string]	[empty string]	0	5	0	0	RELIEVE	35	Y	[empty string]	606645	7	116713

array
1	116713

struct
INTERNALLISTPRICE	17.99
INTERNALMARKDOWN	false
INTERNALPRICE	17.99
REG	17.99
SALE	17.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

Melt away your stress

Work is over, the bills are paid and the kids are asleep, it's time to sit back and enjoy peace with the relaxing scent of your favorite Seeking Balance Candle. These A.I. Root Candles offer soothing scents from all-natural sources and essential oils for a long-lasting, aromatic bouquet that is true to nature. A beautiful and comforting blend of color and aromatherapy in a holistic soy candle with a crackling wooden wick makes this candle like no other. Perfect for unwinding and appreciating the calming moments after a long day.

Why we love it:

"I have this candle in the scent Awaken, and I am not hyperbolizing when I say it is the best candle I’ve ever burned. It smells so refreshing, and the fragrance fills the entire room—without being overpowering. I especially love the gentle crackling sound of the wood wick!"

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

"The Illuminate Fragrance is my favorite to enjoy after getting home from work and winding down. All of the fragrances are wonderful, but the Juniper Rosewood stands out to me. It has a sweet and earthy aroma that isn't overpowering but remains noticeable. I do like the fact that this is a soy based candle as well. That means it burns longer and doesn't release the toxins that a petroleum-based paraffin wax candle does. And I must say, the crackling wooden wick is just the icing on the cake! I highly recommend this brand to all you candle lovers seeking a treat for yourselves or a loved one."

— Erika, Mast General Store - Asheville, NC

Made in USA
Scented soy candle
6.5 ounces
Diameter: 3.5 inches
Height: 4 inches
Awaken: Sparkling zesty lime, orange and grapefruit with cool green basil, cilantro and thyme. Nature comes alive at the base with fresh tones of fir, musk and rosewood.
Energize: The bright orange color along with the energizing essential oils of rosemary and eucalyptus give an immediate lift, touch of rejuvenation, energy and invigoration.
Illuminate: Free your mind of clutter and confusion by mixing the simplicity of the color white with the clarifying power of juniper and rosewood essential oils for cleanliness and clarity.
Meditate: Citrus, myrrh and olibanum combine to create focus, relaxation and clarity essential for the journey of meditation.
Relax: Pure essential oils of lavender and the geranium bud combine with the tranquil color of lavender to provide an atmosphere of comfort, calm and relaxation.
Relieve: The scent of eucalyptus increases overall brain activity and relieves congestion. When mixed with subtle menthol, expect comfort from colds and headaches.

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

Work is over, the bills are paid and the kids are asleep, it's time to sit back and enjoy peace with the relaxing scent of your favorite Seeking Balance Candle. These A.I. Root Candles offer soothing scents from all-natural sources and essential oils for a long-lasting, aromatic bouquet that is true to nature. A beautiful and comforting blend of color and aromatherapy in a holistic soy candle with a crackling wooden wick makes this candle like no other. Perfect for unwinding and appreciating the calming moments after a long day.

Why we love it:

"I have this candle in the scent Awaken, and I am not hyperbolizing when I say it is the best candle I’ve ever burned. It smells so refreshing, and the fragrance fills the entire room—without being overpowering. I especially love the gentle crackling sound of the wood wick!"

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

"The Illuminate Fragrance is my favorite to enjoy after getting home from work and winding down. All of the fragrances are wonderful, but the Juniper Rosewood stands out to me. It has a sweet and earthy aroma that isn't overpowering but remains noticeable. I do like the fact that this is a soy based candle as well. That means it burns longer and doesn't release the toxins that a petroleum-based paraffin wax candle does. And I must say, the crackling wooden wick is just the icing on the cake! I highly recommend this brand to all you candle lovers seeking a treat for yourselves or a loved one."

— Erika, Mast General Store - Asheville, NC
Specs
- Made in USA
- Scented soy candle
- 6.5 ounces
- Diameter: 3.5 inches
- Height: 4 inches
- Awaken: Sparkling zesty lime, orange and grapefruit with cool green basil, cilantro and thyme. Nature comes alive at the base with fresh tones of fir, musk and rosewood.
- Energize: The bright orange color along with the energizing essential oils of rosemary and eucalyptus give an immediate lift, touch of rejuvenation, energy and invigoration.
- Illuminate: Free your mind of clutter and confusion by mixing the simplicity of the color white with the clarifying power of juniper and rosewood essential oils for cleanliness and clarity.
- Meditate: Citrus, myrrh and olibanum combine to create focus, relaxation and clarity essential for the journey of meditation.
- Relax: Pure essential oils of lavender and the geranium bud combine with the tranquil color of lavender to provide an atmosphere of comfort, calm and relaxation.
- Relieve: The scent of eucalyptus increases overall brain activity and relieves congestion. When mixed with subtle menthol, expect comfort from colds and headaches.
Reviews

No Reviews Yet!
Live Chat