NAUGHTY PETS SINGLE TILE COASTER
- Description
- Specs
- Reviews
- Live Chat
Enjoy a little pet humor with your morning cup of coffee with this Naughty Pets Single Tile Coaster from CounterArt. Featuring a colorful graphic and funny quote, this single drink coaster provides a place for your mug and a good laugh. The absorbent stoneware on top prevents cold drinks from sweating off onto your counter and tabletops, while the cork backing keeps it from slipping and sliding around or leaving scratches behind.
- Absorbent stoneware
- Cork backing
- Dimensions: 4 x 4 x 0.30 inches
- Imported
No Reviews Yet!
-
Description
Enjoy a little pet humor with your morning cup of coffee with this Naughty Pets Single Tile Coaster from CounterArt. Featuring a colorful graphic and funny quote, this single drink coaster provides a place for your mug and a good laugh. The absorbent stoneware on top prevents cold drinks from sweating off onto your counter and tabletops, while the cork backing keeps it from slipping and sliding around or leaving scratches behind.
-
Specs
- Absorbent stoneware
- Cork backing
- Dimensions: 4 x 4 x 0.30 inches
- Imported
-
Reviews
No Reviews Yet!
- Live Chat
$3.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 BLAME_DOGGIES 110754 [empty string] [empty string] 0 25 0 0 BLAME_DOGGIES 137 Y [empty string] 926774 [empty string] 197414 2 LICKED_IT 110755 [empty string] [empty string] 0 35 0 0 LICKED_IT 220 Y [empty string] 926775 [empty string] 197414 3 NAUGHTY_CAT 110756 [empty string] [empty string] 0 18 0 0 NAUGHTY_CAT 113 Y [empty string] 926776 [empty string] 197414 4 NAUGHTY_DOG 110757 [empty string] [empty string] 0 29 0 0 NAUGHTY_DOG 169 Y [empty string] 926777 [empty string] 197414 5 FIX_LIGHTS 110758 [empty string] [empty string] 0 19 0 0 FIX_LIGHTS 131 Y [empty string] 926778 [empty string] 197414 6 JUST_A_LITTLE 110759 [empty string] [empty string] 0 25 0 0 JUST_A_LITTLE 150 Y [empty string] 926779 [empty string] 197414 7 NO_PEEKING 110760 [empty string] [empty string] 0 19 0 0 NO_PEEKING 98 Y [empty string] 926780 [empty string] 197414 8 SANTA_ATE_IT 110761 [empty string] [empty string] 0 28 0 0 SANTA_ATE_IT 130 Y [empty string] 926781 [empty string] 197414 9 I_CAN_EXPLAIN 110762 [empty string] [empty string] 0 39 0 0 I_CAN_EXPLAIN 144 Y [empty string] 926782 [empty string] 197414 10 SO_LITTLE_TIME 110763 [empty string] [empty string] 0 24 0 0 SO_LITTLE_TIME 138 Y [empty string] 926783 [empty string] 197414 11 WHAT_COOKIES 110764 [empty string] [empty string] 0 34 0 0 WHAT_COOKIES 191 Y [empty string] 926784 [empty string] 197414 12 WHATEVER 110765 [empty string] [empty string] 0 21 0 0 WHATEVER 137 Y [empty string] 926785 [empty string] 197414 CACHED false EXECUTIONTIME 16 SQL 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 (3,8,1,2,5,7,15,6,9,14,11,97) group by sku_id having sum(qoh+qc) >= 2 ) 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(3,8,1,2,5,7,15,6,9,14,11,97) GROUP BY b.attr1 HAVING sum(e.qoh+e.qc) >= 2 ORDER BY max(b.attr1_order), max(b.attr1_entry_id) SQLPARAMETERS array 1 197414 struct INTERNALLISTPRICE 3.99 INTERNALMARKDOWN false INTERNALPRICE 3.99 REG 3.99 SALE 3.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 BLAME_DOGGIES 110754 [empty string] [empty string] 0 25 0 0 BLAME_DOGGIES 137 Y [empty string] 926774 [empty string] 197414 2 LICKED_IT 110755 [empty string] [empty string] 0 35 0 0 LICKED_IT 220 Y [empty string] 926775 [empty string] 197414 3 NAUGHTY_CAT 110756 [empty string] [empty string] 0 18 0 0 NAUGHTY_CAT 113 Y [empty string] 926776 [empty string] 197414 4 NAUGHTY_DOG 110757 [empty string] [empty string] 0 29 0 0 NAUGHTY_DOG 169 Y [empty string] 926777 [empty string] 197414 5 FIX_LIGHTS 110758 [empty string] [empty string] 0 19 0 0 FIX_LIGHTS 131 Y [empty string] 926778 [empty string] 197414 6 JUST_A_LITTLE 110759 [empty string] [empty string] 0 25 0 0 JUST_A_LITTLE 150 Y [empty string] 926779 [empty string] 197414 7 NO_PEEKING 110760 [empty string] [empty string] 0 19 0 0 NO_PEEKING 98 Y [empty string] 926780 [empty string] 197414 8 SANTA_ATE_IT 110761 [empty string] [empty string] 0 28 0 0 SANTA_ATE_IT 130 Y [empty string] 926781 [empty string] 197414 9 I_CAN_EXPLAIN 110762 [empty string] [empty string] 0 39 0 0 I_CAN_EXPLAIN 144 Y [empty string] 926782 [empty string] 197414 10 SO_LITTLE_TIME 110763 [empty string] [empty string] 0 24 0 0 SO_LITTLE_TIME 138 Y [empty string] 926783 [empty string] 197414 11 WHAT_COOKIES 110764 [empty string] [empty string] 0 34 0 0 WHAT_COOKIES 191 Y [empty string] 926784 [empty string] 197414 12 WHATEVER 110765 [empty string] [empty string] 0 21 0 0 WHATEVER 137 Y [empty string] 926785 [empty string] 197414 CACHED false EXECUTIONTIME 16 SQL 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 (3,8,1,2,5,7,15,6,9,14,11,97) group by sku_id having sum(qoh+qc) >= 2 ) 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(3,8,1,2,5,7,15,6,9,14,11,97) GROUP BY b.attr1 HAVING sum(e.qoh+e.qc) >= 2 ORDER BY max(b.attr1_order), max(b.attr1_entry_id) SQLPARAMETERS array 1 197414 struct INTERNALLISTPRICE 3.99 INTERNALMARKDOWN false INTERNALPRICE 3.99 REG 3.99 SALE 3.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 BLAME_DOGGIES 110754 [empty string] [empty string] 0 25 0 0 BLAME_DOGGIES 137 Y [empty string] 926774 [empty string] 197414 2 LICKED_IT 110755 [empty string] [empty string] 0 35 0 0 LICKED_IT 220 Y [empty string] 926775 [empty string] 197414 3 NAUGHTY_CAT 110756 [empty string] [empty string] 0 18 0 0 NAUGHTY_CAT 113 Y [empty string] 926776 [empty string] 197414 4 NAUGHTY_DOG 110757 [empty string] [empty string] 0 29 0 0 NAUGHTY_DOG 169 Y [empty string] 926777 [empty string] 197414 5 FIX_LIGHTS 110758 [empty string] [empty string] 0 19 0 0 FIX_LIGHTS 131 Y [empty string] 926778 [empty string] 197414 6 JUST_A_LITTLE 110759 [empty string] [empty string] 0 25 0 0 JUST_A_LITTLE 150 Y [empty string] 926779 [empty string] 197414 7 NO_PEEKING 110760 [empty string] [empty string] 0 19 0 0 NO_PEEKING 98 Y [empty string] 926780 [empty string] 197414 8 SANTA_ATE_IT 110761 [empty string] [empty string] 0 28 0 0 SANTA_ATE_IT 130 Y [empty string] 926781 [empty string] 197414 9 I_CAN_EXPLAIN 110762 [empty string] [empty string] 0 39 0 0 I_CAN_EXPLAIN 144 Y [empty string] 926782 [empty string] 197414 10 SO_LITTLE_TIME 110763 [empty string] [empty string] 0 24 0 0 SO_LITTLE_TIME 138 Y [empty string] 926783 [empty string] 197414 11 WHAT_COOKIES 110764 [empty string] [empty string] 0 34 0 0 WHAT_COOKIES 191 Y [empty string] 926784 [empty string] 197414 12 WHATEVER 110765 [empty string] [empty string] 0 21 0 0 WHATEVER 137 Y [empty string] 926785 [empty string] 197414 CACHED false EXECUTIONTIME 16 SQL 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 (3,8,1,2,5,7,15,6,9,14,11,97) group by sku_id having sum(qoh+qc) >= 2 ) 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(3,8,1,2,5,7,15,6,9,14,11,97) GROUP BY b.attr1 HAVING sum(e.qoh+e.qc) >= 2 ORDER BY max(b.attr1_order), max(b.attr1_entry_id) SQLPARAMETERS array 1 197414 struct INTERNALLISTPRICE 3.99 INTERNALMARKDOWN false INTERNALPRICE 3.99 REG 3.99 SALE 3.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 BLAME_DOGGIES 110754 [empty string] [empty string] 0 25 0 0 BLAME_DOGGIES 137 Y [empty string] 926774 [empty string] 197414 2 LICKED_IT 110755 [empty string] [empty string] 0 35 0 0 LICKED_IT 220 Y [empty string] 926775 [empty string] 197414 3 NAUGHTY_CAT 110756 [empty string] [empty string] 0 18 0 0 NAUGHTY_CAT 113 Y [empty string] 926776 [empty string] 197414 4 NAUGHTY_DOG 110757 [empty string] [empty string] 0 29 0 0 NAUGHTY_DOG 169 Y [empty string] 926777 [empty string] 197414 5 FIX_LIGHTS 110758 [empty string] [empty string] 0 19 0 0 FIX_LIGHTS 131 Y [empty string] 926778 [empty string] 197414 6 JUST_A_LITTLE 110759 [empty string] [empty string] 0 25 0 0 JUST_A_LITTLE 150 Y [empty string] 926779 [empty string] 197414 7 NO_PEEKING 110760 [empty string] [empty string] 0 19 0 0 NO_PEEKING 98 Y [empty string] 926780 [empty string] 197414 8 SANTA_ATE_IT 110761 [empty string] [empty string] 0 28 0 0 SANTA_ATE_IT 130 Y [empty string] 926781 [empty string] 197414 9 I_CAN_EXPLAIN 110762 [empty string] [empty string] 0 39 0 0 I_CAN_EXPLAIN 144 Y [empty string] 926782 [empty string] 197414 10 SO_LITTLE_TIME 110763 [empty string] [empty string] 0 24 0 0 SO_LITTLE_TIME 138 Y [empty string] 926783 [empty string] 197414 11 WHAT_COOKIES 110764 [empty string] [empty string] 0 34 0 0 WHAT_COOKIES 191 Y [empty string] 926784 [empty string] 197414 12 WHATEVER 110765 [empty string] [empty string] 0 21 0 0 WHATEVER 137 Y [empty string] 926785 [empty string] 197414 CACHED false EXECUTIONTIME 16 SQL 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 (3,8,1,2,5,7,15,6,9,14,11,97) group by sku_id having sum(qoh+qc) >= 2 ) 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(3,8,1,2,5,7,15,6,9,14,11,97) GROUP BY b.attr1 HAVING sum(e.qoh+e.qc) >= 2 ORDER BY max(b.attr1_order), max(b.attr1_entry_id) SQLPARAMETERS array 1 197414 struct INTERNALLISTPRICE 3.99 INTERNALMARKDOWN false INTERNALPRICE 3.99 REG 3.99 SALE 3.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 BLAME_DOGGIES 110754 [empty string] [empty string] 0 25 0 0 BLAME_DOGGIES 137 Y [empty string] 926774 [empty string] 197414 2 LICKED_IT 110755 [empty string] [empty string] 0 35 0 0 LICKED_IT 220 Y [empty string] 926775 [empty string] 197414 3 NAUGHTY_CAT 110756 [empty string] [empty string] 0 18 0 0 NAUGHTY_CAT 113 Y [empty string] 926776 [empty string] 197414 4 NAUGHTY_DOG 110757 [empty string] [empty string] 0 29 0 0 NAUGHTY_DOG 169 Y [empty string] 926777 [empty string] 197414 5 FIX_LIGHTS 110758 [empty string] [empty string] 0 19 0 0 FIX_LIGHTS 131 Y [empty string] 926778 [empty string] 197414 6 JUST_A_LITTLE 110759 [empty string] [empty string] 0 25 0 0 JUST_A_LITTLE 150 Y [empty string] 926779 [empty string] 197414 7 NO_PEEKING 110760 [empty string] [empty string] 0 19 0 0 NO_PEEKING 98 Y [empty string] 926780 [empty string] 197414 8 SANTA_ATE_IT 110761 [empty string] [empty string] 0 28 0 0 SANTA_ATE_IT 130 Y [empty string] 926781 [empty string] 197414 9 I_CAN_EXPLAIN 110762 [empty string] [empty string] 0 39 0 0 I_CAN_EXPLAIN 144 Y [empty string] 926782 [empty string] 197414 10 SO_LITTLE_TIME 110763 [empty string] [empty string] 0 24 0 0 SO_LITTLE_TIME 138 Y [empty string] 926783 [empty string] 197414 11 WHAT_COOKIES 110764 [empty string] [empty string] 0 34 0 0 WHAT_COOKIES 191 Y [empty string] 926784 [empty string] 197414 12 WHATEVER 110765 [empty string] [empty string] 0 21 0 0 WHATEVER 137 Y [empty string] 926785 [empty string] 197414 CACHED false EXECUTIONTIME 16 SQL 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 (3,8,1,2,5,7,15,6,9,14,11,97) group by sku_id having sum(qoh+qc) >= 2 ) 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(3,8,1,2,5,7,15,6,9,14,11,97) GROUP BY b.attr1 HAVING sum(e.qoh+e.qc) >= 2 ORDER BY max(b.attr1_order), max(b.attr1_entry_id) SQLPARAMETERS array 1 197414 struct INTERNALLISTPRICE 3.99 INTERNALMARKDOWN false INTERNALPRICE 3.99 REG 3.99 SALE 3.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 BLAME_DOGGIES 110754 [empty string] [empty string] 0 25 0 0 BLAME_DOGGIES 137 Y [empty string] 926774 [empty string] 197414 2 LICKED_IT 110755 [empty string] [empty string] 0 35 0 0 LICKED_IT 220 Y [empty string] 926775 [empty string] 197414 3 NAUGHTY_CAT 110756 [empty string] [empty string] 0 18 0 0 NAUGHTY_CAT 113 Y [empty string] 926776 [empty string] 197414 4 NAUGHTY_DOG 110757 [empty string] [empty string] 0 29 0 0 NAUGHTY_DOG 169 Y [empty string] 926777 [empty string] 197414 5 FIX_LIGHTS 110758 [empty string] [empty string] 0 19 0 0 FIX_LIGHTS 131 Y [empty string] 926778 [empty string] 197414 6 JUST_A_LITTLE 110759 [empty string] [empty string] 0 25 0 0 JUST_A_LITTLE 150 Y [empty string] 926779 [empty string] 197414 7 NO_PEEKING 110760 [empty string] [empty string] 0 19 0 0 NO_PEEKING 98 Y [empty string] 926780 [empty string] 197414 8 SANTA_ATE_IT 110761 [empty string] [empty string] 0 28 0 0 SANTA_ATE_IT 130 Y [empty string] 926781 [empty string] 197414 9 I_CAN_EXPLAIN 110762 [empty string] [empty string] 0 39 0 0 I_CAN_EXPLAIN 144 Y [empty string] 926782 [empty string] 197414 10 SO_LITTLE_TIME 110763 [empty string] [empty string] 0 24 0 0 SO_LITTLE_TIME 138 Y [empty string] 926783 [empty string] 197414 11 WHAT_COOKIES 110764 [empty string] [empty string] 0 34 0 0 WHAT_COOKIES 191 Y [empty string] 926784 [empty string] 197414 12 WHATEVER 110765 [empty string] [empty string] 0 21 0 0 WHATEVER 137 Y [empty string] 926785 [empty string] 197414 CACHED false EXECUTIONTIME 16 SQL 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 (3,8,1,2,5,7,15,6,9,14,11,97) group by sku_id having sum(qoh+qc) >= 2 ) 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(3,8,1,2,5,7,15,6,9,14,11,97) GROUP BY b.attr1 HAVING sum(e.qoh+e.qc) >= 2 ORDER BY max(b.attr1_order), max(b.attr1_entry_id) SQLPARAMETERS array 1 197414 struct INTERNALLISTPRICE 3.99 INTERNALMARKDOWN false INTERNALPRICE 3.99 REG 3.99 SALE 3.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 BLAME_DOGGIES 110754 [empty string] [empty string] 0 25 0 0 BLAME_DOGGIES 137 Y [empty string] 926774 [empty string] 197414 2 LICKED_IT 110755 [empty string] [empty string] 0 35 0 0 LICKED_IT 220 Y [empty string] 926775 [empty string] 197414 3 NAUGHTY_CAT 110756 [empty string] [empty string] 0 18 0 0 NAUGHTY_CAT 113 Y [empty string] 926776 [empty string] 197414 4 NAUGHTY_DOG 110757 [empty string] [empty string] 0 29 0 0 NAUGHTY_DOG 169 Y [empty string] 926777 [empty string] 197414 5 FIX_LIGHTS 110758 [empty string] [empty string] 0 19 0 0 FIX_LIGHTS 131 Y [empty string] 926778 [empty string] 197414 6 JUST_A_LITTLE 110759 [empty string] [empty string] 0 25 0 0 JUST_A_LITTLE 150 Y [empty string] 926779 [empty string] 197414 7 NO_PEEKING 110760 [empty string] [empty string] 0 19 0 0 NO_PEEKING 98 Y [empty string] 926780 [empty string] 197414 8 SANTA_ATE_IT 110761 [empty string] [empty string] 0 28 0 0 SANTA_ATE_IT 130 Y [empty string] 926781 [empty string] 197414 9 I_CAN_EXPLAIN 110762 [empty string] [empty string] 0 39 0 0 I_CAN_EXPLAIN 144 Y [empty string] 926782 [empty string] 197414 10 SO_LITTLE_TIME 110763 [empty string] [empty string] 0 24 0 0 SO_LITTLE_TIME 138 Y [empty string] 926783 [empty string] 197414 11 WHAT_COOKIES 110764 [empty string] [empty string] 0 34 0 0 WHAT_COOKIES 191 Y [empty string] 926784 [empty string] 197414 12 WHATEVER 110765 [empty string] [empty string] 0 21 0 0 WHATEVER 137 Y [empty string] 926785 [empty string] 197414 CACHED false EXECUTIONTIME 16 SQL 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 (3,8,1,2,5,7,15,6,9,14,11,97) group by sku_id having sum(qoh+qc) >= 2 ) 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(3,8,1,2,5,7,15,6,9,14,11,97) GROUP BY b.attr1 HAVING sum(e.qoh+e.qc) >= 2 ORDER BY max(b.attr1_order), max(b.attr1_entry_id) SQLPARAMETERS array 1 197414 struct INTERNALLISTPRICE 3.99 INTERNALMARKDOWN false INTERNALPRICE 3.99 REG 3.99 SALE 3.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 BLAME_DOGGIES 110754 [empty string] [empty string] 0 25 0 0 BLAME_DOGGIES 137 Y [empty string] 926774 [empty string] 197414 2 LICKED_IT 110755 [empty string] [empty string] 0 35 0 0 LICKED_IT 220 Y [empty string] 926775 [empty string] 197414 3 NAUGHTY_CAT 110756 [empty string] [empty string] 0 18 0 0 NAUGHTY_CAT 113 Y [empty string] 926776 [empty string] 197414 4 NAUGHTY_DOG 110757 [empty string] [empty string] 0 29 0 0 NAUGHTY_DOG 169 Y [empty string] 926777 [empty string] 197414 5 FIX_LIGHTS 110758 [empty string] [empty string] 0 19 0 0 FIX_LIGHTS 131 Y [empty string] 926778 [empty string] 197414 6 JUST_A_LITTLE 110759 [empty string] [empty string] 0 25 0 0 JUST_A_LITTLE 150 Y [empty string] 926779 [empty string] 197414 7 NO_PEEKING 110760 [empty string] [empty string] 0 19 0 0 NO_PEEKING 98 Y [empty string] 926780 [empty string] 197414 8 SANTA_ATE_IT 110761 [empty string] [empty string] 0 28 0 0 SANTA_ATE_IT 130 Y [empty string] 926781 [empty string] 197414 9 I_CAN_EXPLAIN 110762 [empty string] [empty string] 0 39 0 0 I_CAN_EXPLAIN 144 Y [empty string] 926782 [empty string] 197414 10 SO_LITTLE_TIME 110763 [empty string] [empty string] 0 24 0 0 SO_LITTLE_TIME 138 Y [empty string] 926783 [empty string] 197414 11 WHAT_COOKIES 110764 [empty string] [empty string] 0 34 0 0 WHAT_COOKIES 191 Y [empty string] 926784 [empty string] 197414 12 WHATEVER 110765 [empty string] [empty string] 0 21 0 0 WHATEVER 137 Y [empty string] 926785 [empty string] 197414 CACHED false EXECUTIONTIME 16 SQL 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 (3,8,1,2,5,7,15,6,9,14,11,97) group by sku_id having sum(qoh+qc) >= 2 ) 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(3,8,1,2,5,7,15,6,9,14,11,97) GROUP BY b.attr1 HAVING sum(e.qoh+e.qc) >= 2 ORDER BY max(b.attr1_order), max(b.attr1_entry_id) SQLPARAMETERS array 1 197414 struct INTERNALLISTPRICE 3.99 INTERNALMARKDOWN false INTERNALPRICE 3.99 REG 3.99 SALE 3.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 BLAME_DOGGIES 110754 [empty string] [empty string] 0 25 0 0 BLAME_DOGGIES 137 Y [empty string] 926774 [empty string] 197414 2 LICKED_IT 110755 [empty string] [empty string] 0 35 0 0 LICKED_IT 220 Y [empty string] 926775 [empty string] 197414 3 NAUGHTY_CAT 110756 [empty string] [empty string] 0 18 0 0 NAUGHTY_CAT 113 Y [empty string] 926776 [empty string] 197414 4 NAUGHTY_DOG 110757 [empty string] [empty string] 0 29 0 0 NAUGHTY_DOG 169 Y [empty string] 926777 [empty string] 197414 5 FIX_LIGHTS 110758 [empty string] [empty string] 0 19 0 0 FIX_LIGHTS 131 Y [empty string] 926778 [empty string] 197414 6 JUST_A_LITTLE 110759 [empty string] [empty string] 0 25 0 0 JUST_A_LITTLE 150 Y [empty string] 926779 [empty string] 197414 7 NO_PEEKING 110760 [empty string] [empty string] 0 19 0 0 NO_PEEKING 98 Y [empty string] 926780 [empty string] 197414 8 SANTA_ATE_IT 110761 [empty string] [empty string] 0 28 0 0 SANTA_ATE_IT 130 Y [empty string] 926781 [empty string] 197414 9 I_CAN_EXPLAIN 110762 [empty string] [empty string] 0 39 0 0 I_CAN_EXPLAIN 144 Y [empty string] 926782 [empty string] 197414 10 SO_LITTLE_TIME 110763 [empty string] [empty string] 0 24 0 0 SO_LITTLE_TIME 138 Y [empty string] 926783 [empty string] 197414 11 WHAT_COOKIES 110764 [empty string] [empty string] 0 34 0 0 WHAT_COOKIES 191 Y [empty string] 926784 [empty string] 197414 12 WHATEVER 110765 [empty string] [empty string] 0 21 0 0 WHATEVER 137 Y [empty string] 926785 [empty string] 197414 CACHED false EXECUTIONTIME 16 SQL 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 (3,8,1,2,5,7,15,6,9,14,11,97) group by sku_id having sum(qoh+qc) >= 2 ) 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(3,8,1,2,5,7,15,6,9,14,11,97) GROUP BY b.attr1 HAVING sum(e.qoh+e.qc) >= 2 ORDER BY max(b.attr1_order), max(b.attr1_entry_id) SQLPARAMETERS array 1 197414 struct INTERNALLISTPRICE 3.99 INTERNALMARKDOWN false INTERNALPRICE 3.99 REG 3.99 SALE 3.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 BLAME_DOGGIES 110754 [empty string] [empty string] 0 25 0 0 BLAME_DOGGIES 137 Y [empty string] 926774 [empty string] 197414 2 LICKED_IT 110755 [empty string] [empty string] 0 35 0 0 LICKED_IT 220 Y [empty string] 926775 [empty string] 197414 3 NAUGHTY_CAT 110756 [empty string] [empty string] 0 18 0 0 NAUGHTY_CAT 113 Y [empty string] 926776 [empty string] 197414 4 NAUGHTY_DOG 110757 [empty string] [empty string] 0 29 0 0 NAUGHTY_DOG 169 Y [empty string] 926777 [empty string] 197414 5 FIX_LIGHTS 110758 [empty string] [empty string] 0 19 0 0 FIX_LIGHTS 131 Y [empty string] 926778 [empty string] 197414 6 JUST_A_LITTLE 110759 [empty string] [empty string] 0 25 0 0 JUST_A_LITTLE 150 Y [empty string] 926779 [empty string] 197414 7 NO_PEEKING 110760 [empty string] [empty string] 0 19 0 0 NO_PEEKING 98 Y [empty string] 926780 [empty string] 197414 8 SANTA_ATE_IT 110761 [empty string] [empty string] 0 28 0 0 SANTA_ATE_IT 130 Y [empty string] 926781 [empty string] 197414 9 I_CAN_EXPLAIN 110762 [empty string] [empty string] 0 39 0 0 I_CAN_EXPLAIN 144 Y [empty string] 926782 [empty string] 197414 10 SO_LITTLE_TIME 110763 [empty string] [empty string] 0 24 0 0 SO_LITTLE_TIME 138 Y [empty string] 926783 [empty string] 197414 11 WHAT_COOKIES 110764 [empty string] [empty string] 0 34 0 0 WHAT_COOKIES 191 Y [empty string] 926784 [empty string] 197414 12 WHATEVER 110765 [empty string] [empty string] 0 21 0 0 WHATEVER 137 Y [empty string] 926785 [empty string] 197414 CACHED false EXECUTIONTIME 16 SQL 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 (3,8,1,2,5,7,15,6,9,14,11,97) group by sku_id having sum(qoh+qc) >= 2 ) 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(3,8,1,2,5,7,15,6,9,14,11,97) GROUP BY b.attr1 HAVING sum(e.qoh+e.qc) >= 2 ORDER BY max(b.attr1_order), max(b.attr1_entry_id) SQLPARAMETERS array 1 197414 struct INTERNALLISTPRICE 3.99 INTERNALMARKDOWN false INTERNALPRICE 3.99 REG 3.99 SALE 3.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 BLAME_DOGGIES 110754 [empty string] [empty string] 0 25 0 0 BLAME_DOGGIES 137 Y [empty string] 926774 [empty string] 197414 2 LICKED_IT 110755 [empty string] [empty string] 0 35 0 0 LICKED_IT 220 Y [empty string] 926775 [empty string] 197414 3 NAUGHTY_CAT 110756 [empty string] [empty string] 0 18 0 0 NAUGHTY_CAT 113 Y [empty string] 926776 [empty string] 197414 4 NAUGHTY_DOG 110757 [empty string] [empty string] 0 29 0 0 NAUGHTY_DOG 169 Y [empty string] 926777 [empty string] 197414 5 FIX_LIGHTS 110758 [empty string] [empty string] 0 19 0 0 FIX_LIGHTS 131 Y [empty string] 926778 [empty string] 197414 6 JUST_A_LITTLE 110759 [empty string] [empty string] 0 25 0 0 JUST_A_LITTLE 150 Y [empty string] 926779 [empty string] 197414 7 NO_PEEKING 110760 [empty string] [empty string] 0 19 0 0 NO_PEEKING 98 Y [empty string] 926780 [empty string] 197414 8 SANTA_ATE_IT 110761 [empty string] [empty string] 0 28 0 0 SANTA_ATE_IT 130 Y [empty string] 926781 [empty string] 197414 9 I_CAN_EXPLAIN 110762 [empty string] [empty string] 0 39 0 0 I_CAN_EXPLAIN 144 Y [empty string] 926782 [empty string] 197414 10 SO_LITTLE_TIME 110763 [empty string] [empty string] 0 24 0 0 SO_LITTLE_TIME 138 Y [empty string] 926783 [empty string] 197414 11 WHAT_COOKIES 110764 [empty string] [empty string] 0 34 0 0 WHAT_COOKIES 191 Y [empty string] 926784 [empty string] 197414 12 WHATEVER 110765 [empty string] [empty string] 0 21 0 0 WHATEVER 137 Y [empty string] 926785 [empty string] 197414 CACHED false EXECUTIONTIME 16 SQL 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 (3,8,1,2,5,7,15,6,9,14,11,97) group by sku_id having sum(qoh+qc) >= 2 ) 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(3,8,1,2,5,7,15,6,9,14,11,97) GROUP BY b.attr1 HAVING sum(e.qoh+e.qc) >= 2 ORDER BY max(b.attr1_order), max(b.attr1_entry_id) SQLPARAMETERS array 1 197414 struct INTERNALLISTPRICE 3.99 INTERNALMARKDOWN false INTERNALPRICE 3.99 REG 3.99 SALE 3.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 BLAME_DOGGIES 110754 [empty string] [empty string] 0 25 0 0 BLAME_DOGGIES 137 Y [empty string] 926774 [empty string] 197414 2 LICKED_IT 110755 [empty string] [empty string] 0 35 0 0 LICKED_IT 220 Y [empty string] 926775 [empty string] 197414 3 NAUGHTY_CAT 110756 [empty string] [empty string] 0 18 0 0 NAUGHTY_CAT 113 Y [empty string] 926776 [empty string] 197414 4 NAUGHTY_DOG 110757 [empty string] [empty string] 0 29 0 0 NAUGHTY_DOG 169 Y [empty string] 926777 [empty string] 197414 5 FIX_LIGHTS 110758 [empty string] [empty string] 0 19 0 0 FIX_LIGHTS 131 Y [empty string] 926778 [empty string] 197414 6 JUST_A_LITTLE 110759 [empty string] [empty string] 0 25 0 0 JUST_A_LITTLE 150 Y [empty string] 926779 [empty string] 197414 7 NO_PEEKING 110760 [empty string] [empty string] 0 19 0 0 NO_PEEKING 98 Y [empty string] 926780 [empty string] 197414 8 SANTA_ATE_IT 110761 [empty string] [empty string] 0 28 0 0 SANTA_ATE_IT 130 Y [empty string] 926781 [empty string] 197414 9 I_CAN_EXPLAIN 110762 [empty string] [empty string] 0 39 0 0 I_CAN_EXPLAIN 144 Y [empty string] 926782 [empty string] 197414 10 SO_LITTLE_TIME 110763 [empty string] [empty string] 0 24 0 0 SO_LITTLE_TIME 138 Y [empty string] 926783 [empty string] 197414 11 WHAT_COOKIES 110764 [empty string] [empty string] 0 34 0 0 WHAT_COOKIES 191 Y [empty string] 926784 [empty string] 197414 12 WHATEVER 110765 [empty string] [empty string] 0 21 0 0 WHATEVER 137 Y [empty string] 926785 [empty string] 197414 CACHED false EXECUTIONTIME 16 SQL 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 (3,8,1,2,5,7,15,6,9,14,11,97) group by sku_id having sum(qoh+qc) >= 2 ) 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(3,8,1,2,5,7,15,6,9,14,11,97) GROUP BY b.attr1 HAVING sum(e.qoh+e.qc) >= 2 ORDER BY max(b.attr1_order), max(b.attr1_entry_id) SQLPARAMETERS array 1 197414 struct INTERNALLISTPRICE 3.99 INTERNALMARKDOWN false INTERNALPRICE 3.99 REG 3.99 SALE 3.99 TERMSALE false TERMSALELISTPRICE 0 TERMSALEPRICE 0