FLOWER OF THE MONTH BRACELET
- Description
- Specs
- Reviews
- Live Chat
A special little something
Say it with flowers. A Flower of the Month Bracelet from Salisbury Silver and Pewter is a wonderful way to remember your loved one on any momentous occasion. These uniquely handcrafted 1-inch cuff bracelets are made of lead-free pewter and feature the blossom that corresponds to the recipient's birth month or that symbolizes your dear one's personality and spirit. They also make meaningful personal keepsakes to honor graduates, bridesmaids, and mothers on their special day and are certain to be treasured and worn with great affection.
Why we love it:
"These bracelets are my go-to gift... I like the idea of giving someone a bracelet that celebrates a special time of their life, whether it's a birthday or just an occasion that they would like to remember."
— Lisa, Mast General Store - Valle Crucis, NC
- Made in USA
- 1 inch cuff bracelet
- Lead-free pewter
Flowers of the Month:
- January - Carnation, a symbol of marriage
- February - Violet, a symbol of faithfulness
- March - Jonquil, a symbol of rebirth
- April - Daisy, a symbol of cheer and innocence
- May - Lily of the Valley, a symbol of purity of heart
- June - Rose, a symbol of love and passion
- July - Larkspur, associated with vivacity
- August - Poppy, associated with rest and oblivion
- September - Aster, associated with true love and fidelity
- October - Cosmos, signifies the heart of a girl
- November - Chrysanthemum, a symbol of cheerfulness and optimism
- December - Narcissus, a symbol of good fortune
No Reviews Yet!
-
Description
Say it with flowers. A Flower of the Month Bracelet from Salisbury Silver and Pewter is a wonderful way to remember your loved one on any momentous occasion. These uniquely handcrafted 1-inch cuff bracelets are made of lead-free pewter and feature the blossom that corresponds to the recipient's birth month or that symbolizes your dear one's personality and spirit. They also make meaningful personal keepsakes to honor graduates, bridesmaids, and mothers on their special day and are certain to be treasured and worn with great affection.
Why we love it:
"These bracelets are my go-to gift... I like the idea of giving someone a bracelet that celebrates a special time of their life, whether it's a birthday or just an occasion that they would like to remember."
— Lisa, Mast General Store - Valle Crucis, NC
-
Specs
- Made in USA
- 1 inch cuff bracelet
- Lead-free pewter
Flowers of the Month:
- January - Carnation, a symbol of marriage
- February - Violet, a symbol of faithfulness
- March - Jonquil, a symbol of rebirth
- April - Daisy, a symbol of cheer and innocence
- May - Lily of the Valley, a symbol of purity of heart
- June - Rose, a symbol of love and passion
- July - Larkspur, associated with vivacity
- August - Poppy, associated with rest and oblivion
- September - Aster, associated with true love and fidelity
- October - Cosmos, signifies the heart of a girl
- November - Chrysanthemum, a symbol of cheerfulness and optimism
- December - Narcissus, a symbol of good fortune
-
Reviews
No Reviews Yet!
-
Live Chat
$24.99
Choose Color
-
jan for $24.99
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 JAN 39440 [empty string] [empty string] 0 6 0 0 JAN 42 Y [empty string] 558940 [empty string] 116144 2 FEB 39441 [empty string] [empty string] 0 8 0 0 FEB 53 Y [empty string] 558941 [empty string] 116144 3 MAR 39442 [empty string] [empty string] 0 9 0 0 MAR 59 Y [empty string] 558942 [empty string] 116144 4 APR 39443 [empty string] [empty string] 0 9 0 0 APR 54 Y [empty string] 558943 [empty string] 116144 5 MAY 39444 [empty string] [empty string] 0 9 0 0 MAY 50 Y [empty string] 558944 [empty string] 116144 6 JUNE 39445 [empty string] [empty string] 0 10 0 0 JUNE 56 Y [empty string] 558945 [empty string] 116144 7 JULY 39446 [empty string] [empty string] 0 8 0 0 JULY 53 Y [empty string] 558946 [empty string] 116144 8 AUG 39447 [empty string] [empty string] 0 8 0 0 AUG 55 Y [empty string] 558947 [empty string] 116144 9 SEPT 39448 [empty string] [empty string] 0 8 0 0 SEPT 54 Y [empty string] 558948 [empty string] 116144 10 OCT 39449 [empty string] [empty string] 0 8 0 0 OCT 52 Y [empty string] 558949 [empty string] 116144 11 NOV 39450 [empty string] [empty string] 0 7 0 0 NOV 45 Y [empty string] 558950 [empty string] 116144 12 DEC 39451 [empty string] [empty string] 0 8 0 0 DEC 53 Y [empty string] 558951 [empty string] 116144 CACHED false EXECUTIONTIME 0 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 (11,14,6,5,9,8,15,7,2,1,3,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(11,14,6,5,9,8,15,7,2,1,3,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 116144 struct INTERNALLISTPRICE 24.99 INTERNALMARKDOWN false INTERNALPRICE 24.99 REG 24.99 SALE 24.99 TERMSALE false TERMSALELISTPRICE 0 TERMSALEPRICE 0 -
feb for $24.99
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 JAN 39440 [empty string] [empty string] 0 6 0 0 JAN 42 Y [empty string] 558940 [empty string] 116144 2 FEB 39441 [empty string] [empty string] 0 8 0 0 FEB 53 Y [empty string] 558941 [empty string] 116144 3 MAR 39442 [empty string] [empty string] 0 9 0 0 MAR 59 Y [empty string] 558942 [empty string] 116144 4 APR 39443 [empty string] [empty string] 0 9 0 0 APR 54 Y [empty string] 558943 [empty string] 116144 5 MAY 39444 [empty string] [empty string] 0 9 0 0 MAY 50 Y [empty string] 558944 [empty string] 116144 6 JUNE 39445 [empty string] [empty string] 0 10 0 0 JUNE 56 Y [empty string] 558945 [empty string] 116144 7 JULY 39446 [empty string] [empty string] 0 8 0 0 JULY 53 Y [empty string] 558946 [empty string] 116144 8 AUG 39447 [empty string] [empty string] 0 8 0 0 AUG 55 Y [empty string] 558947 [empty string] 116144 9 SEPT 39448 [empty string] [empty string] 0 8 0 0 SEPT 54 Y [empty string] 558948 [empty string] 116144 10 OCT 39449 [empty string] [empty string] 0 8 0 0 OCT 52 Y [empty string] 558949 [empty string] 116144 11 NOV 39450 [empty string] [empty string] 0 7 0 0 NOV 45 Y [empty string] 558950 [empty string] 116144 12 DEC 39451 [empty string] [empty string] 0 8 0 0 DEC 53 Y [empty string] 558951 [empty string] 116144 CACHED false EXECUTIONTIME 0 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 (11,14,6,5,9,8,15,7,2,1,3,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(11,14,6,5,9,8,15,7,2,1,3,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 116144 struct INTERNALLISTPRICE 24.99 INTERNALMARKDOWN false INTERNALPRICE 24.99 REG 24.99 SALE 24.99 TERMSALE false TERMSALELISTPRICE 0 TERMSALEPRICE 0 -
mar for $24.99
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 JAN 39440 [empty string] [empty string] 0 6 0 0 JAN 42 Y [empty string] 558940 [empty string] 116144 2 FEB 39441 [empty string] [empty string] 0 8 0 0 FEB 53 Y [empty string] 558941 [empty string] 116144 3 MAR 39442 [empty string] [empty string] 0 9 0 0 MAR 59 Y [empty string] 558942 [empty string] 116144 4 APR 39443 [empty string] [empty string] 0 9 0 0 APR 54 Y [empty string] 558943 [empty string] 116144 5 MAY 39444 [empty string] [empty string] 0 9 0 0 MAY 50 Y [empty string] 558944 [empty string] 116144 6 JUNE 39445 [empty string] [empty string] 0 10 0 0 JUNE 56 Y [empty string] 558945 [empty string] 116144 7 JULY 39446 [empty string] [empty string] 0 8 0 0 JULY 53 Y [empty string] 558946 [empty string] 116144 8 AUG 39447 [empty string] [empty string] 0 8 0 0 AUG 55 Y [empty string] 558947 [empty string] 116144 9 SEPT 39448 [empty string] [empty string] 0 8 0 0 SEPT 54 Y [empty string] 558948 [empty string] 116144 10 OCT 39449 [empty string] [empty string] 0 8 0 0 OCT 52 Y [empty string] 558949 [empty string] 116144 11 NOV 39450 [empty string] [empty string] 0 7 0 0 NOV 45 Y [empty string] 558950 [empty string] 116144 12 DEC 39451 [empty string] [empty string] 0 8 0 0 DEC 53 Y [empty string] 558951 [empty string] 116144 CACHED false EXECUTIONTIME 0 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 (11,14,6,5,9,8,15,7,2,1,3,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(11,14,6,5,9,8,15,7,2,1,3,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 116144 struct INTERNALLISTPRICE 24.99 INTERNALMARKDOWN false INTERNALPRICE 24.99 REG 24.99 SALE 24.99 TERMSALE false TERMSALELISTPRICE 0 TERMSALEPRICE 0 -
apr for $24.99
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 JAN 39440 [empty string] [empty string] 0 6 0 0 JAN 42 Y [empty string] 558940 [empty string] 116144 2 FEB 39441 [empty string] [empty string] 0 8 0 0 FEB 53 Y [empty string] 558941 [empty string] 116144 3 MAR 39442 [empty string] [empty string] 0 9 0 0 MAR 59 Y [empty string] 558942 [empty string] 116144 4 APR 39443 [empty string] [empty string] 0 9 0 0 APR 54 Y [empty string] 558943 [empty string] 116144 5 MAY 39444 [empty string] [empty string] 0 9 0 0 MAY 50 Y [empty string] 558944 [empty string] 116144 6 JUNE 39445 [empty string] [empty string] 0 10 0 0 JUNE 56 Y [empty string] 558945 [empty string] 116144 7 JULY 39446 [empty string] [empty string] 0 8 0 0 JULY 53 Y [empty string] 558946 [empty string] 116144 8 AUG 39447 [empty string] [empty string] 0 8 0 0 AUG 55 Y [empty string] 558947 [empty string] 116144 9 SEPT 39448 [empty string] [empty string] 0 8 0 0 SEPT 54 Y [empty string] 558948 [empty string] 116144 10 OCT 39449 [empty string] [empty string] 0 8 0 0 OCT 52 Y [empty string] 558949 [empty string] 116144 11 NOV 39450 [empty string] [empty string] 0 7 0 0 NOV 45 Y [empty string] 558950 [empty string] 116144 12 DEC 39451 [empty string] [empty string] 0 8 0 0 DEC 53 Y [empty string] 558951 [empty string] 116144 CACHED false EXECUTIONTIME 0 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 (11,14,6,5,9,8,15,7,2,1,3,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(11,14,6,5,9,8,15,7,2,1,3,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 116144 struct INTERNALLISTPRICE 24.99 INTERNALMARKDOWN false INTERNALPRICE 24.99 REG 24.99 SALE 24.99 TERMSALE false TERMSALELISTPRICE 0 TERMSALEPRICE 0 -
may for $24.99
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 JAN 39440 [empty string] [empty string] 0 6 0 0 JAN 42 Y [empty string] 558940 [empty string] 116144 2 FEB 39441 [empty string] [empty string] 0 8 0 0 FEB 53 Y [empty string] 558941 [empty string] 116144 3 MAR 39442 [empty string] [empty string] 0 9 0 0 MAR 59 Y [empty string] 558942 [empty string] 116144 4 APR 39443 [empty string] [empty string] 0 9 0 0 APR 54 Y [empty string] 558943 [empty string] 116144 5 MAY 39444 [empty string] [empty string] 0 9 0 0 MAY 50 Y [empty string] 558944 [empty string] 116144 6 JUNE 39445 [empty string] [empty string] 0 10 0 0 JUNE 56 Y [empty string] 558945 [empty string] 116144 7 JULY 39446 [empty string] [empty string] 0 8 0 0 JULY 53 Y [empty string] 558946 [empty string] 116144 8 AUG 39447 [empty string] [empty string] 0 8 0 0 AUG 55 Y [empty string] 558947 [empty string] 116144 9 SEPT 39448 [empty string] [empty string] 0 8 0 0 SEPT 54 Y [empty string] 558948 [empty string] 116144 10 OCT 39449 [empty string] [empty string] 0 8 0 0 OCT 52 Y [empty string] 558949 [empty string] 116144 11 NOV 39450 [empty string] [empty string] 0 7 0 0 NOV 45 Y [empty string] 558950 [empty string] 116144 12 DEC 39451 [empty string] [empty string] 0 8 0 0 DEC 53 Y [empty string] 558951 [empty string] 116144 CACHED false EXECUTIONTIME 0 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 (11,14,6,5,9,8,15,7,2,1,3,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(11,14,6,5,9,8,15,7,2,1,3,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 116144 struct INTERNALLISTPRICE 24.99 INTERNALMARKDOWN false INTERNALPRICE 24.99 REG 24.99 SALE 24.99 TERMSALE false TERMSALELISTPRICE 0 TERMSALEPRICE 0 -
june for $24.99
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 JAN 39440 [empty string] [empty string] 0 6 0 0 JAN 42 Y [empty string] 558940 [empty string] 116144 2 FEB 39441 [empty string] [empty string] 0 8 0 0 FEB 53 Y [empty string] 558941 [empty string] 116144 3 MAR 39442 [empty string] [empty string] 0 9 0 0 MAR 59 Y [empty string] 558942 [empty string] 116144 4 APR 39443 [empty string] [empty string] 0 9 0 0 APR 54 Y [empty string] 558943 [empty string] 116144 5 MAY 39444 [empty string] [empty string] 0 9 0 0 MAY 50 Y [empty string] 558944 [empty string] 116144 6 JUNE 39445 [empty string] [empty string] 0 10 0 0 JUNE 56 Y [empty string] 558945 [empty string] 116144 7 JULY 39446 [empty string] [empty string] 0 8 0 0 JULY 53 Y [empty string] 558946 [empty string] 116144 8 AUG 39447 [empty string] [empty string] 0 8 0 0 AUG 55 Y [empty string] 558947 [empty string] 116144 9 SEPT 39448 [empty string] [empty string] 0 8 0 0 SEPT 54 Y [empty string] 558948 [empty string] 116144 10 OCT 39449 [empty string] [empty string] 0 8 0 0 OCT 52 Y [empty string] 558949 [empty string] 116144 11 NOV 39450 [empty string] [empty string] 0 7 0 0 NOV 45 Y [empty string] 558950 [empty string] 116144 12 DEC 39451 [empty string] [empty string] 0 8 0 0 DEC 53 Y [empty string] 558951 [empty string] 116144 CACHED false EXECUTIONTIME 0 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 (11,14,6,5,9,8,15,7,2,1,3,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(11,14,6,5,9,8,15,7,2,1,3,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 116144 struct INTERNALLISTPRICE 24.99 INTERNALMARKDOWN false INTERNALPRICE 24.99 REG 24.99 SALE 24.99 TERMSALE false TERMSALELISTPRICE 0 TERMSALEPRICE 0 -
july for $24.99
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 JAN 39440 [empty string] [empty string] 0 6 0 0 JAN 42 Y [empty string] 558940 [empty string] 116144 2 FEB 39441 [empty string] [empty string] 0 8 0 0 FEB 53 Y [empty string] 558941 [empty string] 116144 3 MAR 39442 [empty string] [empty string] 0 9 0 0 MAR 59 Y [empty string] 558942 [empty string] 116144 4 APR 39443 [empty string] [empty string] 0 9 0 0 APR 54 Y [empty string] 558943 [empty string] 116144 5 MAY 39444 [empty string] [empty string] 0 9 0 0 MAY 50 Y [empty string] 558944 [empty string] 116144 6 JUNE 39445 [empty string] [empty string] 0 10 0 0 JUNE 56 Y [empty string] 558945 [empty string] 116144 7 JULY 39446 [empty string] [empty string] 0 8 0 0 JULY 53 Y [empty string] 558946 [empty string] 116144 8 AUG 39447 [empty string] [empty string] 0 8 0 0 AUG 55 Y [empty string] 558947 [empty string] 116144 9 SEPT 39448 [empty string] [empty string] 0 8 0 0 SEPT 54 Y [empty string] 558948 [empty string] 116144 10 OCT 39449 [empty string] [empty string] 0 8 0 0 OCT 52 Y [empty string] 558949 [empty string] 116144 11 NOV 39450 [empty string] [empty string] 0 7 0 0 NOV 45 Y [empty string] 558950 [empty string] 116144 12 DEC 39451 [empty string] [empty string] 0 8 0 0 DEC 53 Y [empty string] 558951 [empty string] 116144 CACHED false EXECUTIONTIME 0 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 (11,14,6,5,9,8,15,7,2,1,3,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(11,14,6,5,9,8,15,7,2,1,3,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 116144 struct INTERNALLISTPRICE 24.99 INTERNALMARKDOWN false INTERNALPRICE 24.99 REG 24.99 SALE 24.99 TERMSALE false TERMSALELISTPRICE 0 TERMSALEPRICE 0 -
aug for $24.99
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 JAN 39440 [empty string] [empty string] 0 6 0 0 JAN 42 Y [empty string] 558940 [empty string] 116144 2 FEB 39441 [empty string] [empty string] 0 8 0 0 FEB 53 Y [empty string] 558941 [empty string] 116144 3 MAR 39442 [empty string] [empty string] 0 9 0 0 MAR 59 Y [empty string] 558942 [empty string] 116144 4 APR 39443 [empty string] [empty string] 0 9 0 0 APR 54 Y [empty string] 558943 [empty string] 116144 5 MAY 39444 [empty string] [empty string] 0 9 0 0 MAY 50 Y [empty string] 558944 [empty string] 116144 6 JUNE 39445 [empty string] [empty string] 0 10 0 0 JUNE 56 Y [empty string] 558945 [empty string] 116144 7 JULY 39446 [empty string] [empty string] 0 8 0 0 JULY 53 Y [empty string] 558946 [empty string] 116144 8 AUG 39447 [empty string] [empty string] 0 8 0 0 AUG 55 Y [empty string] 558947 [empty string] 116144 9 SEPT 39448 [empty string] [empty string] 0 8 0 0 SEPT 54 Y [empty string] 558948 [empty string] 116144 10 OCT 39449 [empty string] [empty string] 0 8 0 0 OCT 52 Y [empty string] 558949 [empty string] 116144 11 NOV 39450 [empty string] [empty string] 0 7 0 0 NOV 45 Y [empty string] 558950 [empty string] 116144 12 DEC 39451 [empty string] [empty string] 0 8 0 0 DEC 53 Y [empty string] 558951 [empty string] 116144 CACHED false EXECUTIONTIME 0 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 (11,14,6,5,9,8,15,7,2,1,3,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(11,14,6,5,9,8,15,7,2,1,3,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 116144 struct INTERNALLISTPRICE 24.99 INTERNALMARKDOWN false INTERNALPRICE 24.99 REG 24.99 SALE 24.99 TERMSALE false TERMSALELISTPRICE 0 TERMSALEPRICE 0 -
sept for $24.99
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 JAN 39440 [empty string] [empty string] 0 6 0 0 JAN 42 Y [empty string] 558940 [empty string] 116144 2 FEB 39441 [empty string] [empty string] 0 8 0 0 FEB 53 Y [empty string] 558941 [empty string] 116144 3 MAR 39442 [empty string] [empty string] 0 9 0 0 MAR 59 Y [empty string] 558942 [empty string] 116144 4 APR 39443 [empty string] [empty string] 0 9 0 0 APR 54 Y [empty string] 558943 [empty string] 116144 5 MAY 39444 [empty string] [empty string] 0 9 0 0 MAY 50 Y [empty string] 558944 [empty string] 116144 6 JUNE 39445 [empty string] [empty string] 0 10 0 0 JUNE 56 Y [empty string] 558945 [empty string] 116144 7 JULY 39446 [empty string] [empty string] 0 8 0 0 JULY 53 Y [empty string] 558946 [empty string] 116144 8 AUG 39447 [empty string] [empty string] 0 8 0 0 AUG 55 Y [empty string] 558947 [empty string] 116144 9 SEPT 39448 [empty string] [empty string] 0 8 0 0 SEPT 54 Y [empty string] 558948 [empty string] 116144 10 OCT 39449 [empty string] [empty string] 0 8 0 0 OCT 52 Y [empty string] 558949 [empty string] 116144 11 NOV 39450 [empty string] [empty string] 0 7 0 0 NOV 45 Y [empty string] 558950 [empty string] 116144 12 DEC 39451 [empty string] [empty string] 0 8 0 0 DEC 53 Y [empty string] 558951 [empty string] 116144 CACHED false EXECUTIONTIME 0 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 (11,14,6,5,9,8,15,7,2,1,3,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(11,14,6,5,9,8,15,7,2,1,3,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 116144 struct INTERNALLISTPRICE 24.99 INTERNALMARKDOWN false INTERNALPRICE 24.99 REG 24.99 SALE 24.99 TERMSALE false TERMSALELISTPRICE 0 TERMSALEPRICE 0 -
oct for $24.99
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 JAN 39440 [empty string] [empty string] 0 6 0 0 JAN 42 Y [empty string] 558940 [empty string] 116144 2 FEB 39441 [empty string] [empty string] 0 8 0 0 FEB 53 Y [empty string] 558941 [empty string] 116144 3 MAR 39442 [empty string] [empty string] 0 9 0 0 MAR 59 Y [empty string] 558942 [empty string] 116144 4 APR 39443 [empty string] [empty string] 0 9 0 0 APR 54 Y [empty string] 558943 [empty string] 116144 5 MAY 39444 [empty string] [empty string] 0 9 0 0 MAY 50 Y [empty string] 558944 [empty string] 116144 6 JUNE 39445 [empty string] [empty string] 0 10 0 0 JUNE 56 Y [empty string] 558945 [empty string] 116144 7 JULY 39446 [empty string] [empty string] 0 8 0 0 JULY 53 Y [empty string] 558946 [empty string] 116144 8 AUG 39447 [empty string] [empty string] 0 8 0 0 AUG 55 Y [empty string] 558947 [empty string] 116144 9 SEPT 39448 [empty string] [empty string] 0 8 0 0 SEPT 54 Y [empty string] 558948 [empty string] 116144 10 OCT 39449 [empty string] [empty string] 0 8 0 0 OCT 52 Y [empty string] 558949 [empty string] 116144 11 NOV 39450 [empty string] [empty string] 0 7 0 0 NOV 45 Y [empty string] 558950 [empty string] 116144 12 DEC 39451 [empty string] [empty string] 0 8 0 0 DEC 53 Y [empty string] 558951 [empty string] 116144 CACHED false EXECUTIONTIME 0 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 (11,14,6,5,9,8,15,7,2,1,3,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(11,14,6,5,9,8,15,7,2,1,3,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 116144 struct INTERNALLISTPRICE 24.99 INTERNALMARKDOWN false INTERNALPRICE 24.99 REG 24.99 SALE 24.99 TERMSALE false TERMSALELISTPRICE 0 TERMSALEPRICE 0 -
nov for $24.99
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 JAN 39440 [empty string] [empty string] 0 6 0 0 JAN 42 Y [empty string] 558940 [empty string] 116144 2 FEB 39441 [empty string] [empty string] 0 8 0 0 FEB 53 Y [empty string] 558941 [empty string] 116144 3 MAR 39442 [empty string] [empty string] 0 9 0 0 MAR 59 Y [empty string] 558942 [empty string] 116144 4 APR 39443 [empty string] [empty string] 0 9 0 0 APR 54 Y [empty string] 558943 [empty string] 116144 5 MAY 39444 [empty string] [empty string] 0 9 0 0 MAY 50 Y [empty string] 558944 [empty string] 116144 6 JUNE 39445 [empty string] [empty string] 0 10 0 0 JUNE 56 Y [empty string] 558945 [empty string] 116144 7 JULY 39446 [empty string] [empty string] 0 8 0 0 JULY 53 Y [empty string] 558946 [empty string] 116144 8 AUG 39447 [empty string] [empty string] 0 8 0 0 AUG 55 Y [empty string] 558947 [empty string] 116144 9 SEPT 39448 [empty string] [empty string] 0 8 0 0 SEPT 54 Y [empty string] 558948 [empty string] 116144 10 OCT 39449 [empty string] [empty string] 0 8 0 0 OCT 52 Y [empty string] 558949 [empty string] 116144 11 NOV 39450 [empty string] [empty string] 0 7 0 0 NOV 45 Y [empty string] 558950 [empty string] 116144 12 DEC 39451 [empty string] [empty string] 0 8 0 0 DEC 53 Y [empty string] 558951 [empty string] 116144 CACHED false EXECUTIONTIME 0 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 (11,14,6,5,9,8,15,7,2,1,3,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(11,14,6,5,9,8,15,7,2,1,3,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 116144 struct INTERNALLISTPRICE 24.99 INTERNALMARKDOWN false INTERNALPRICE 24.99 REG 24.99 SALE 24.99 TERMSALE false TERMSALELISTPRICE 0 TERMSALEPRICE 0 -
dec for $24.99
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 JAN 39440 [empty string] [empty string] 0 6 0 0 JAN 42 Y [empty string] 558940 [empty string] 116144 2 FEB 39441 [empty string] [empty string] 0 8 0 0 FEB 53 Y [empty string] 558941 [empty string] 116144 3 MAR 39442 [empty string] [empty string] 0 9 0 0 MAR 59 Y [empty string] 558942 [empty string] 116144 4 APR 39443 [empty string] [empty string] 0 9 0 0 APR 54 Y [empty string] 558943 [empty string] 116144 5 MAY 39444 [empty string] [empty string] 0 9 0 0 MAY 50 Y [empty string] 558944 [empty string] 116144 6 JUNE 39445 [empty string] [empty string] 0 10 0 0 JUNE 56 Y [empty string] 558945 [empty string] 116144 7 JULY 39446 [empty string] [empty string] 0 8 0 0 JULY 53 Y [empty string] 558946 [empty string] 116144 8 AUG 39447 [empty string] [empty string] 0 8 0 0 AUG 55 Y [empty string] 558947 [empty string] 116144 9 SEPT 39448 [empty string] [empty string] 0 8 0 0 SEPT 54 Y [empty string] 558948 [empty string] 116144 10 OCT 39449 [empty string] [empty string] 0 8 0 0 OCT 52 Y [empty string] 558949 [empty string] 116144 11 NOV 39450 [empty string] [empty string] 0 7 0 0 NOV 45 Y [empty string] 558950 [empty string] 116144 12 DEC 39451 [empty string] [empty string] 0 8 0 0 DEC 53 Y [empty string] 558951 [empty string] 116144 CACHED false EXECUTIONTIME 0 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 (11,14,6,5,9,8,15,7,2,1,3,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(11,14,6,5,9,8,15,7,2,1,3,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 116144 struct INTERNALLISTPRICE 24.99 INTERNALMARKDOWN false INTERNALPRICE 24.99 REG 24.99 SALE 24.99 TERMSALE false TERMSALELISTPRICE 0 TERMSALEPRICE 0
866-367-6278
Sign In
