Whole Earth Provision Co. | Olukai OluKai Women's Pehua Shoes

Olukai

OluKai Women's Pehua Shoes

$80.00

Item # 20271-4040

query

RESULTSET

query
	ORIGSIZ	QOH	SCALE_ENTRY_ID	SIZ	SIZE_ORDER	SKU_ID	STYLE_ID
1	6	4	7773	6	[empty string]	381653	99168
2	6.5	2	7774	6.5	[empty string]	381654	99168
3	7	10	7775	7	[empty string]	381655	99168
4	7.5	7	7776	7.5	[empty string]	381656	99168
5	8	10	7777	8	[empty string]	381657	99168
6	8.5	8	7778	8.5	[empty string]	381658	99168
7	9	4	7779	9	[empty string]	381659	99168
8	9.5	5	7780	9.5	[empty string]	381660	99168
9	10	6	7781	10	88	381661	99168
10	11	4	7783	11	117	381662	99168

CACHED

false

EXECUTIONTIME

618

SQL

SELECT distinct (b.siz) as origSiz, max(CASE WHEN b.siz_alias IS NULL OR RTRIM(LTRIM(b.siz_alias)) = '' THEN b.siz ELSE b.siz_alias END) as siz, max(b.size_order) as size_order, max(a.sku_id) as sku_id, max(a.scale_entry_id) as scale_entry_id, sum(e.qoh) as qoh, max(a.style_id) as style_id FROM tb_skus a WITH (NOLOCK) LEFT JOIN tb_size_entries b WITH (NOLOCK) on (b.scale_entry_id = a.scale_entry_id) INNER JOIN ( SELECT DISTINCT sku_id , sum(qoh+qc) as qoh FROM dbo.tb_sku_buckets WITH (NOLOCK) WHERE store_id in(98,8,9,2,5,7,6,3) GROUP BY sku_id ) e on (a.sku_id = e.sku_id) LEFT JOIN tb_attr1_entries d WITH (NOLOCK) on (d.attr1_entry_id = a.attr1_entry_id) LEFT JOIN ( SELECT style_id FROM tb_styles WITH (NOLOCK) WHERE web_style = ? and web_style is not null ) sq ON(a.style_id = sq.style_id) WHERE (sq.style_id is not null OR a.style_id = ?) AND (b.siz_alias is null OR b.siz_alias NOT IN ('NO SHOW','NOSHOW') ) AND isNull(a.sell_web,'Y') = 'Y' AND e.qoh > 1 GROUP BY b.siz ORDER BY max(b.size_order), max(a.scale_entry_id)

SQLPARAMETERS

array
1	20271-4040
2	99168

query

RESULTSET

query
	ATTR1	ATTR1_ALIAS	ATTR1_ENTRY_ID	FAM	HEX	ORIGATTR1	QOH	SIZE	SKU_ID	SORT_ORDER	STYLE_ID
1	BLACK	[empty string]	79734	[empty string]	[empty string]	BLACK	60	7783	381662	[empty string]	99168

CACHED

false

EXECUTIONTIME

SQL

SELECT distinct (b.attr1) as origAttr1, max(b.attr1_alias) as attr1_alias, 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) as qoh, max(b.attr1_order) as sort_order, max(c.attr1_hex) as hex,max(d.attr1_fam) as fam, max(a.style_id) as style_id, max(a.SCALE_ENTRY_ID) as size FROM tb_skus a LEFT JOIN tb_attr1_entries b WITH (NOLOCK) ON (b.attr1_entry_id = a.attr1_entry_id) INNER JOIN ( SELECT DISTINCT sku_id , sum(qoh+qc) as qoh FROM dbo.tb_sku_buckets WITH (NOLOCK) WHERE store_id in(98,8,9,2,5,7,6,3) GROUP BY sku_id ) e on (a.sku_id = e.sku_id) LEFT JOIN tb_attr1_hexes c WITH (NOLOCK) ON (b.attr1=c.attr1) LEFT JOIN tb_size_entries k WITH (NOLOCK) on (k.scale_entry_id = a.scale_entry_id) LEFT JOIN tb_attr1_families d WITH (NOLOCK) ON (c.attr1_fam_id = d.attr1_fam_id) WHERE a.style_id =? AND (b.attr1_alias is null OR b.attr1_alias NOT IN ('NO SHOW','NOSHOW') ) AND e.qoh > 1 AND isNull(a.sell_web,'Y') = 'Y' GROUP BY b.attr1 ORDER BY sum(e.qoh) DESC --max(b.attr1_order), max(b.attr1_entry_id)

SQLPARAMETERS

array
1	99168

Selected Color

Select Size 6 6.5 7 7.5 8 8.5 9 9.5 10 11

query

RESULTSET

query
	ATTR1_ENTRY_ID	ATTR2_ENTRY_ID	DEPT	PURCHASE_AMOUNT	QOH	SCALE_ENTRY_ID	SKU_ID	STORE_ID	STYLE
1	79734	41268	50-WOMENS FOOTWEAR	[empty string]	4	7773	381653	98	20271-4040
2	79734	41268	50-WOMENS FOOTWEAR	[empty string]	2	7774	381654	98	20271-4040
3	79734	41268	50-WOMENS FOOTWEAR	[empty string]	10	7775	381655	98	20271-4040
4	79734	41268	50-WOMENS FOOTWEAR	[empty string]	7	7776	381656	98	20271-4040
5	79734	41268	50-WOMENS FOOTWEAR	[empty string]	10	7777	381657	98	20271-4040
6	79734	41268	50-WOMENS FOOTWEAR	[empty string]	8	7778	381658	98	20271-4040
7	79734	41268	50-WOMENS FOOTWEAR	[empty string]	4	7779	381659	98	20271-4040
8	79734	41268	50-WOMENS FOOTWEAR	[empty string]	5	7780	381660	98	20271-4040
9	79734	41268	50-WOMENS FOOTWEAR	[empty string]	6	7781	381661	98	20271-4040
10	79734	41268	50-WOMENS FOOTWEAR	[empty string]	4	7783	381662	98	20271-4040
11	79734	41268	50-WOMENS FOOTWEAR	[empty string]	0	7782	537310	98	20271-4040

CACHED

false

EXECUTIONTIME

SQL

SELECT sum(c.qoh+c.qc) as qoh ,max(b.sku_id) as sku_id , max(b.scale_entry_id) as scale_entry_id , max(b.attr2_entry_id) as attr2_entry_id , max(e.attr1_entry_id) as attr1_entry_id , max(g.dept) as dept , max(a.style) as style , max(c.store_id) as store_id , max(h.purchase_amount) as purchase_amount FROM tb_styles a LEFT JOIN tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id) LEFT JOIN tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id) LEFT JOIN tb_size_entries d WITH (NOLOCK) ON (d.scale_entry_id = b.scale_entry_id) LEFT JOIN tb_attr1_entries e WITH (NOLOCK) ON (e.attr1_entry_id = b.attr1_entry_id) LEFT JOIN tb_attr2_entries f WITH (NOLOCK) ON (f.attr2_entry_id = b.attr2_entry_id) LEFT JOIN tb_taxonomy g WITH (NOLOCK) ON (g.taxonomy_id = a.taxonomy_id) LEFT JOIN web_product_information h WITH (NOLOCK) ON (a.style_id = h.style_id) WHERE (b.style_id IN ( SELECT style_id FROM tb_styles WHERE web_style = '20271-4040' ) or b.style_id =?) and c.store_id in(98,8,9,2,5,7,6,3) --AND c.qoh > 1 and b.attr1_entry_id = 79734 and b.attr2_entry_id = 41268 AND isNull(b.sell_web,'Y') = 'Y' GROUP BY b.sku_id ORDER BY b.sku_id

SQLPARAMETERS

array
1	99168

product description Treat your feet to the look and feel of bliss with the casual, breathable, classic comfort of the OluKai Women's Pehua Shoes. Constructed with a mesh upper for breathability, these shoes feature OluKai's versatile Drop-In Heel® for shoe or slide functionality, and embossed logos for charming flair. The dual density anatomical footbed has a durable chassis that provides heel stability and arch support while the softer top deck offers extra cushioning for all-day comfort.

product specs

Non-marking rubber outsole with Polynesian inspired artwork design
Dual density PU anatomical footbed
Removable and washable footbed lined with lightweight mesh
Drop-In Heel® offers shoe or slide functionality
Durable chassis for arch support and heel stability
Leather patch with embossed logo

TULA HATS Tula Unisex Pecos Hat - XXL $37.95

TOMS Women's Classic Canvas Shoes - Black on Black Black.Black

Toms Shoes TOMS Women's Classic Canvas Shoes - Black on Black $49.95

Birkenstock Women's Gizeh Essentials EVA Sandals Lavender

BIRKENSTOCK Birkenstock Women's Gizeh Essentials EVA Sandals $39.95

TULA HATS Tula Women's Elegant Ranch Hat $37.95

KEEN KEEN Women's Whisper Sandals $90.00 $39.99
56% off

TOMS Women's Seaglass Torn Denim Espadrilles Apargatas Denim

Toms Shoes TOMS Women's Seaglass Torn Denim Espadrilles Apargatas $59.00

Pistil Women's Suzette Wide Brim Fedora Naturl_nat

PISTIL Pistil Women's Suzette Wide Brim Fedora $42.00 $28.99
31% off

TOMS Women's Classic Canvas Shoes - Red Red

Toms Shoes TOMS Women's Classic Canvas Shoes - Red $49.95

TULA HATS Tula Unisex Pecos Hat - S/M $37.95

TOMS Women's Black Arrow Embroidered Mesh Classics Alpargatas Blk.Arw.Mesh

Toms Shoes TOMS Women's Black Arrow Embroidered Mesh Classics Alpargatas $59.95

TOMS Women's Classic Canvas Shoes - Black Black

Toms Shoes TOMS Women's Classic Canvas Shoes - Black $49.95

Birkenstock Women's Mayari Birkibuc Sandals Anthracite

BIRKENSTOCK Birkenstock Women's Mayari Birkibuc Sandals $99.95

Birkenstock Women's Mayari Oiled Leather Sandals Bluelth

BIRKENSTOCK Birkenstock Women's Mayari Oiled Leather Sandals $125.00

KEEN Women's Whisper Sandals Drkshd/Crmc

KEEN KEEN Women's Whisper Sandals $90.00 $71.99
20% off

Tula Women's Ranch Lattice Hat - L Straw

TULA HATS Tula Women's Ranch Lattice Hat - L $37.95

TOMS Women’s Birch Canvas TRVL LITE Slip-On Shoes Birchcanv

Toms Shoes TOMS Women’s Birch Canvas TRVL LITE Slip-On Shoes $69.95

Birkenstock Women's London Suede Shoes Taupesuede

BIRKENSTOCK Birkenstock Women's London Suede Shoes $170.00

Birkenstock Women’s Celina II Shoes Blacksd

BIRKENSTOCK Birkenstock Women’s Celina II Shoes $120.00

Birkenstock Women's Arizona Leather Sandals Wmtlstgold

BIRKENSTOCK Birkenstock Women's Arizona Leather Sandals $125.00

Darn Tough Women's Vertex No Show Tab Ultra Light Cushion Socks Lightblue

DARN TOUGH Darn Tough Women's Vertex No Show Tab Ultra Light Cushion Socks $16.00

Overall Rating

0.0/5.0

Review Stats 0 total reviews

5 0

4 0

3 0

2 0

1 0

Write a Review

1 - 0 of 0

No reviews have been written for this product.
Be the first one! –

query

RESULTSET

query
	ADDITIONAL_DESCRIPTION	AGERANGE	ALTIMAGERECORDCOUNT	ATTR1ID	ATTR1LIST	ATTR2ID	BRAND	BRANDDISPLAY	DEPT	DEPTTREE	DESCRIPTION	FAMLIST	GENDER	GOOGLEPRODUCTTAXONOMY	HEXLIST	ID	INSTORE_ONLY	INTERNALLISTPRICE	INTERNALMARKDOWN	INTERNALPRICE	KEYWORDS	LARGEPICTURE	LISTPRICE	LOWESTPRICE	MEDIUMPICTURE	METADESC	METATAGS	NAME	NEW	OF1	OF10	OF11	OF12	OF13	OF14	OF15	OF16	OF17	OF18	OF19	OF2	OF20	OF3	OF4	OF5	OF6	OF7	OF8	OF9	ORIGBRAND	OVERALLQOH	OVERALL_RATING	PAGETITLE	PICTUREID	PICTURE_ID	PRICERANGE	PRODREVIEWSAVERAGE	PRODREVIEWSRECORDCOUNT	QUANTITYONHANDSUM	QUANTITYSOLDSUM	RANKING	REALNAME	ROMANTICCOPYLONG	ROMANTICCOPYSHORT	SALE	SALEPRICERANGEBOTTOM	SALEPRICERANGETOP	SCALEID	SHIP_SURCHARGE	SIZELIST	SIZING_IMAGE_FILE	SMALLPICTURE	SORTPOSITION	STYLE	STYLE_ID	SUBTYP1	SUBTYP2	SUBTYP3	TERMSALE	TERMSALELISTPRICE	TERMSALEPRICE	TINYPICTURE	TYP	URL	USEPACKAGE	VIDEO	WEBSTYLE	WEB_OF1	WEB_OF10	WEB_OF11	WEB_OF12	WEB_OF13	WEB_OF14	WEB_OF15	WEB_OF16	WEB_OF17	WEB_OF18	WEB_OF19	WEB_OF2	WEB_OF20	WEB_OF3	WEB_OF4	WEB_OF5	WEB_OF6	WEB_OF7	WEB_OF8	WEB_OF9
1	<ul> <li>Non-marking rubber outsole with Polynesian inspired artwork design</li> <li>Dual density PU anatomical footbed</li> <li>Removable and washable footbed lined with lightweight mesh</li> <li>Drop-In Heel® offers shoe or slide functionality</li> <li>Durable chassis for arch support and heel stability</li> <li>Leather patch with embossed logo</li> </ul>	[empty string]	[empty string]	34695	BLACK,	41246	OLUKAI	Olukai	CLOTHING & FOOTWEAR	Clothing & Footwear &gt Women's &gt Footwear &gt Casual Shoes	[empty string]	[empty string]	[empty string]	596	[empty string]	27375268	[empty string]	80	80	80	[empty string]	13788-DEFAULT-l.jpg	80	[empty string]	13788-DEFAULT-m.jpg	Treat your feet to the look and feel of bliss with the casual, breathable, classic comfort of the OluKai Women's Pehua Shoes.	[empty string]	W/Pehuea	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	BTSTFW	[empty string]	[empty string]	PIN	[empty string]	[empty string]	[empty string]	50B	[empty string]	[empty string]	FALL_3	[empty string]	[empty string]	[empty string]	[empty string]	OLUKAI PREMIUM FOOTW	59	0	[empty string]	13788	13788	50-to-100	0.00	0	[empty string]	[empty string]	[empty string]	OluKai Women's Pehua Shoes	Treat your feet to the look and feel of bliss with the casual, breathable, classic comfort of the OluKai Women's Pehua Shoes. Constructed with a mesh upper for breathability, these shoes feature OluKai's versatile Drop-In Heel® for shoe or slide functionality, and embossed logos for charming flair. The dual density anatomical footbed has a durable chassis that provides heel stability and arch support while the softer top deck offers extra cushioning for all-day comfort.	[empty string]	N	80	80	2839	0	10,11,6,6.5,7,7.5,8,8.5,9,9.5,	[empty string]	13788-DEFAULT-s.jpg	1000	20271-4040	99168	FOOTWEAR	CASUAL SHOES	EMPTY	0	[empty string]	[empty string]	13788-DEFAULT-xs.jpg	WOMENS	shop/olukai-womens-pehua-shoes-99168	0	[empty string]	20271-4040	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]

CACHED

false

EXECUTIONTIME

SQL

SELECT * from [dbo].[web_all_products] WHERE style_id='99168' order by ID desc