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

Olukai

OluKai Women's Pehuea Leather Shoes

$100.00

Item # 20329

This item ships for FREE

query

RESULTSET

query
	ORIGSIZ	QOH	SCALE_ENTRY_ID	SIZ	SIZE_ORDER	SKU_ID	STYLE_ID
1	6	6	145158	6	[empty string]	523162	128714
2	6.5	9	145159	6.5	[empty string]	523163	128714
3	7	6	145160	7	[empty string]	523164	128714
4	7.5	8	145161	7.5	[empty string]	523165	128714
5	8	13	145162	8	[empty string]	523166	128714
6	8.5	11	145163	8.5	[empty string]	523167	128714
7	9	8	145164	9	[empty string]	523168	128714
8	9.5	5	145165	9.5	[empty string]	523169	128714
9	10	7	145166	10	[empty string]	523170	128714

CACHED

false

EXECUTIONTIME

985

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+e.qc) 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) LEFT JOIN tb_sku_buckets e WITH (NOLOCK) on (e.sku_id = a.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.store_id in (98,8,9,2,5,7,6,3) GROUP BY b.siz HAVING sum(e.qoh+e.qc) > 0 ORDER BY max(b.size_order), max(a.scale_entry_id)

SQLPARAMETERS

array
1	20329
2	128714

Select Color

OluKai Women's Pehuea Leather Shoes CLAHON_LH10

OluKai Women's Pehuea Leather Shoes TRBLU_THDE

Select Size 6 6.5 7 7.5 8 8.5 9 9.5 10

product description Classy shoes within the casual-but-sophisticated Pehuea family, the OluKai Women's Pehuea Leather Shoes come in soft, unlined full-grain leather or embossed suede with a plush microfiber lining. With OluKai's versatile Drop-In Heel® for shoe or slide option, the Pehuea Leather is a dynamic shoe that can dress any outfit up or down. A durable chassis provides heel stability and arch support. The softer top deck offers extra cushioning for step-in comfort.

product specs

Patented Drop-In Heel design offers both a shoe and slide functionality
Embossed suede with microfiber lining and soft nylon binding
Dual-density anatomical PU footbed with lightweight, moisture-wicking microfiber lining
Footbeds are removable and washable
Embossed logo detail and decorative sidewall stitching

Tula Unisex Fedora Hat Multi Band - Small Multi_band

TULA HATS Tula Unisex Fedora Hat Multi Band - Small $35.95

*More Colors Available* DAKINE Dakine Women’s Lola Handbag $20.99 to $35.00

Tula Women's Ranch Lattice Hat - L Straw

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

Tula Women's Carmel Hat Cranberry Band Cranberryband

TULA HATS Tula Women's Carmel Hat Cranberry Band $37.95

Tula Unisex Lifeguard Hat - L/XL Natural

TULA HATS Tula Unisex Lifeguard Hat - L/XL $37.95

Dakine Women's JoJo Elevated Handbag Elmwood

DAKINE Dakine Women's JoJo Elevated Handbag $30.00

TULA HATS Tula Unisex Pecos Hat - L/XL $37.95

Tula Unisex Gardener Lattice Hat - S/M Straw

TULA HATS Tula Unisex Gardener Lattice Hat - S/M $37.95

ECCO ECCO Women's Yucatan Sandals $135.00

*More Colors Available* DAKINE Dakine Jo Jo Handbag $25.00

Injinji Injinji Unisex Liner Crew Socks $10.00

TULA HATS Tula Women's Elegant Ranch Hat $37.95

Klogs Footwear Women's Springfield Wide Non-Slip Shoes Black

Klogs Footwear Klogs Footwear Women's Springfield Wide Non-Slip Shoes $59.95

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

*More Colors Available* DAKINE Dakine Women's Tote Pack 18L $33.99 to $48.00

Tula Women's Ranch Lattice Hat - S Straw

TULA HATS Tula Women's Ranch Lattice Hat - S $35.95

Klogs Footwear Klogs Women's Springfield Shoes $59.95

TULA HATS Tula Unisex Pecos Hat - XXL $37.95

Tula Unisex Gardener Lattice Hat - XXL Straw

TULA HATS Tula Unisex Gardener Lattice Hat - XXL $37.95

ECCO ECCO Women's Yucatan Sandals $130.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	<li>Patented Drop-In Heel design offers both a shoe and slide functionality</li> <li>Embossed suede with microfiber lining and soft nylon binding</li> <li>Dual-density anatomical PU footbed with lightweight, moisture-wicking microfiber lining</li> <li>Footbeds are removable and washable</li> <li>Embossed logo detail and decorative sidewall stitching</li>	[empty string]	[empty string]	60395	CLAHON_LH10,TRBLU_THDE,	66579	OLUKAI	Olukai	CLOTHING & FOOTWEAR	Clothing & Footwear &gt Women's &gt Footwear &gt Casual Shoes	[empty string]	[empty string]	[empty string]	596	[empty string]	23648429	[empty string]	100	100	100	[empty string]	31142-DEFAULT-l.jpg	100	[empty string]	31142-DEFAULT-m.jpg	Dress any outfit up or down. Classy shoes within the casual-but-sophisticated Pehuea family, the OluKai Women's Pehuea Leather Shoes come in soft, unlined full-grain leather or embossed suede with a plush microfiber lining.	[empty string]	W/PEHUEA LEATHER	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	BTSTFW	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	50B	[empty string]	[empty string]	SPRING	[empty string]	[empty string]	[empty string]	[empty string]	OLUKAI PREMIUM FOOTW	73	0	[empty string]	31142	31142	100-to-150	0.00	0	[empty string]	[empty string]	[empty string]	OluKai Women's Pehuea Leather Shoes	Classy shoes within the casual-but-sophisticated Pehuea family, the OluKai Women's Pehuea Leather Shoes come in soft, unlined full-grain leather or embossed suede with a plush microfiber lining. With OluKai's versatile Drop-In Heel® for shoe or slide option, the Pehuea Leather is a dynamic shoe that can dress any outfit up or down. A durable chassis provides heel stability and arch support. The softer top deck offers extra cushioning for step-in comfort.	[empty string]	N	100	100	57674	0	10,6,6.5,7,7.5,8,8.5,9,9.5,	[empty string]	31142-DEFAULT-s.jpg	103	20329	128714	FOOTWEAR	CASUAL SHOES	EMPTY	0	2	[empty string]	31142-DEFAULT-xs.jpg	WOMENS	shop/olukai-womens-pehuea-leather-s-128714	0	[empty string]	20329	[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='128714' order by ID desc