Whole Earth Provision Co. | BIRKENSTOCK Birkenstock Women's Mayari Birkibuc Sandals

BIRKENSTOCK

Birkenstock Women's Mayari Birkibuc Sandals

$99.95

Item # 1009512

query

RESULTSET

query
	ORIGSIZ	QOH	SCALE_ENTRY_ID	SIZ	SIZE_ORDER	SKU_ID	STYLE_ID
1	36	2	9379	36	[empty string]	498178	133712
2	37	6	9380	37	[empty string]	498179	133712
3	38	10	9381	38	[empty string]	498180	133712
4	39	6	9382	39	[empty string]	498181	133712
5	40	5	9383	40	[empty string]	498182	133712
6	41	4	9384	41	[empty string]	498183	133712

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	1009512
2	133712

Select Size 36 37 38 39 40 41

Selected Color

Birkenstock Women's Mayari Birkibuc Sandals ANTHRACITE

product description The classic support and adjustability of the Birkenstock Women's Mayari Birkibuc Sandals deliver a look that can go from beach to brunch effortlessly. The buckled straps criss-cross to form a toe loop that offers customizable comfort and the nubuck leather finish can easily match with any outfit.

These sandals are made with Birko-Flor®, giving them a natural leather look. Birko-Flor is a durable synthetic material made of PVC and lined with super soft fleece. So these refined sandals are breathable, easy to wipe clean, and very soft on the skin.

product specs

Contoured cork-latex footbed
Upper: Birko-Flor® nubuck
Lining: suede
Lightweight EVA sole for cushioning and shock absorption
Individually adjustable straps
Narrow fit only
Made in Germany

TOMS Women's Black Denim Majorca Cutout Sandals Blackdenim

Toms Shoes TOMS Women's Black Denim Majorca Cutout Sandals $89.95

ECCO ECCO Women's Yucatan Sandals $135.00

Injinji Injinji Unisex Liner Crew Socks $10.00

Tula Unisex Fedora Hat Multi Band - Small Multi_band

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

DAKINE Dakine Women's Jackey Handbag $25.00

TULA HATS Tula Women's Elegant Ranch Hat $37.95

OOFOS Women's OOriginals Flip Sandals Black

OOFOS OOFOS Women's OOriginals Flip Sandals $49.95

Klogs Footwear Klogs Women's Springfield Shoes $59.95

Dakine Women's JoJo Elevated Handbag Elmwood

DAKINE Dakine Women's JoJo Elevated Handbag $30.00

Tula Women's Ranch Lattice Hat - S Straw

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

Tula Unisex Lifeguard Hat - L/XL Natural

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

ECCO ECCO Women's Yucatan Sandals $130.00

Tula Unisex Gardener Lattice Hat - XXL Straw

TULA HATS Tula Unisex Gardener Lattice Hat - XXL $37.95

Vionic Women's Tide II Toe Post Sandals Brnzmtl

*More Colors Available* VIONIC Vionic Women's Tide II Toe Post Sandals $64.95

*More Colors Available* VIONIC Vionic Women's Rest Kirra Sandals $99.95

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

Tula Women's Ranch Lattice Hat - L Straw

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

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

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

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

Tula Women's Carmel Hat Cranberry Band Cranberryband

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

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>Contoured cork-latex footbed</li> <li>Upper: Birko-Flor® nubuck</li> <li>Lining: suede</li> <li>Lightweight EVA sole for cushioning and shock absorption</li> <li>Individually adjustable straps</li> <li>Narrow fit only</li> <li>Made in Germany</li>	[empty string]	[empty string]	15710	ANTHRACITE,	70019	BIRKENSTOCK	BIRKENSTOCK	CLOTHING & FOOTWEAR	Clothing & Footwear &gt Women's &gt Footwear &gt Sandals &gt Casual Sandals	[empty string]	[empty string]	[empty string]	596	[empty string]	23829507	[empty string]	99.95	99	99.95	birk, birks, birkenstok, synthetic	32026-DEFAULT-l.jpg	99.95	[empty string]	32026-DEFAULT-m.jpg	Slip into the Birkenstock Women's Mayari Birkibuc Sandals for an effortless look that can transition from beach to brunch as easily as you plan fun days.	[empty string]	W/MAYARI VEGAN-R	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	BTSTFW	[empty string]	[empty string]	[empty string]	[empty string]	ACTIVE	A	50F	[empty string]	[empty string]	SPRING	[empty string]	[empty string]	[empty string]	N	BIRKENSTOCK	34	0	[empty string]	32026	32026	100-to-150	0.00	0	[empty string]	[empty string]	[empty string]	Birkenstock Women's Mayari Birkibuc Sandals	The classic support and adjustability of the Birkenstock Women's Mayari Birkibuc Sandals deliver a look that can go from beach to brunch effortlessly. The buckled straps criss-cross to form a toe loop that offers customizable comfort and the nubuck leather finish can easily match with any outfit. <br></br> These sandals are made with Birko-Flor®, giving them a natural leather look. Birko-Flor is a durable synthetic material made of PVC and lined with super soft fleece. So these refined sandals are breathable, easy to wipe clean, and very soft on the skin.	[empty string]	N	99.95	99.95	3128	0	36,37,38,39,40,41,	[empty string]	32026-DEFAULT-s.jpg	32	1009512	133712	FOOTWEAR	SANDALS	CASUAL SANDALS	0	2	[empty string]	32026-DEFAULT-xs.jpg	WOMENS	shop/birkenstock-womens-mayari-birk-133712	0	[empty string]	1009512	[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='133712' order by ID desc