TRIVET - FIESTA

fiesta

No FIESTA_TRIVETS

1 Review(s)

$12.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	COOL_CALYPSO	121456	[empty string]	[empty string]	0	2	0	0	COOL_CALYPSO	5	Y	[empty string]	582984	2	120351
2	KITCHEN_FLOWER	121457	[empty string]	[empty string]	0	2	0	0	KITCHEN_FLOWER	4	Y	[empty string]	600914	3	120351
3	WARM_CALYPSO	121458	[empty string]	[empty string]	0	4	0	0	WARM_CALYPSO	10	Y	[empty string]	582985	4	120351

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) > 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 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) >= 0 ORDER BY max(b.attr1_order), max(b.attr1_entry_id)

SQLPARAMETERS

array
1	120351

struct
INTERNALLISTPRICE	12.99
INTERNALMARKDOWN	false
INTERNALPRICE	12.99
REG	12.99
SALE	12.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	COOL_CALYPSO	121456	[empty string]	[empty string]	0	2	0	0	COOL_CALYPSO	5	Y	[empty string]	582984	2	120351
2	KITCHEN_FLOWER	121457	[empty string]	[empty string]	0	2	0	0	KITCHEN_FLOWER	4	Y	[empty string]	600914	3	120351
3	WARM_CALYPSO	121458	[empty string]	[empty string]	0	4	0	0	WARM_CALYPSO	10	Y	[empty string]	582985	4	120351

array
1	120351

struct
INTERNALLISTPRICE	12.99
INTERNALMARKDOWN	false
INTERNALPRICE	12.99
REG	12.99
SALE	12.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	COOL_CALYPSO	121456	[empty string]	[empty string]	0	2	0	0	COOL_CALYPSO	5	Y	[empty string]	582984	2	120351
2	KITCHEN_FLOWER	121457	[empty string]	[empty string]	0	2	0	0	KITCHEN_FLOWER	4	Y	[empty string]	600914	3	120351
3	WARM_CALYPSO	121458	[empty string]	[empty string]	0	4	0	0	WARM_CALYPSO	10	Y	[empty string]	582985	4	120351

array
1	120351

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

color explosion

Add vibrant color to your table with the Fiesta Trivet in Assorted Styles! This eye-catching trivet is made of absorbent gypsum with a non-slip cork backing that protects your tabletop from heat, watermarks and scratches. It comes in bold designs and brilliant hues that will keep you entertaining in style.

Made of absorbent sandstone
Non-slip cork bottom
7 -7/8 x 7- 7/8 inches
Hand wash and towel dry
Do not place n dishwasher or microwave
Imported

Average 5 out of 5

1 reviews
May 24, 2015

Very attractive and functional!

I ordered one of each color as Christmas gifts for a couple who have both warm and cool Fiesta place settings. Ordered a bit early for the holiday (!) because I wanted to be sure and have them. The trivets are very colorful and well made. They arrived in perfect condition and were nicely packed. I was very happy with this purchase.

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

Add vibrant color to your table with the Fiesta Trivet in Assorted Styles! This eye-catching trivet is made of absorbent gypsum with a non-slip cork backing that protects your tabletop from heat, watermarks and scratches. It comes in bold designs and brilliant hues that will keep you entertaining in style.
Specs
- Made of absorbent sandstone
- Non-slip cork bottom
- 7 -7/8 x 7- 7/8 inches
- Hand wash and towel dry
- Do not place n dishwasher or microwave
- Imported
Reviews
- Average 5 out of 5
  
  1 reviews
- User
  
  May 24, 2015
  
  Very attractive and functional!
  
  I ordered one of each color as Christmas gifts for a couple who have both warm and cool Fiesta place settings. Ordered a bit early for the holiday (!) because I wanted to be sure and have them. The trivets are very colorful and well made. They arrived in perfect condition and were nicely packed. I was very happy with this purchase.
Live Chat