Whole Earth Provision Co. | BIRKENSTOCK Birkenstock Women's Florida Soft Footbed Birkibuc Sandals

BIRKENSTOCK

Birkenstock Women's Florida Soft Footbed Birkibuc Sandals

$110.00

Item # 53881

This item ships for FREE

query

RESULTSET

query
	ORIGSIZ	QOH	SCALE_ENTRY_ID	SIZ	SIZE_ORDER	SKU_ID	STYLE_ID
1	36	6	8039	36	278	376226	97220
2	37	8	8040	37	280	376227	97220
3	38	13	8041	38	285	376228	97220
4	39	10	8042	39	287	376229	97220
5	40	10	8043	40	308	376230	97220
6	41	4	8044	41	313	376231	97220

CACHED

false

EXECUTIONTIME

504

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	53881
2	97220

query

RESULTSET

query
	ATTR1	ATTR1_ALIAS	ATTR1_ENTRY_ID	FAM	HEX	ORIGATTR1	QOH	SIZE	SKU_ID	SORT_ORDER	STYLE_ID
1	Mocha	Mocha	367	[empty string]	[empty string]	MOCHA	51	8044	376231	[empty string]	97220

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	97220

Selected Color

Birkenstock Women's Florida Soft Footbed Birkibuc Sandals MOCHA

Select Size 36 37 38 39 40 41

query

RESULTSET

query
	ATTR1_ENTRY_ID	ATTR2_ENTRY_ID	DEPT	PURCHASE_AMOUNT	QOH	SCALE_ENTRY_ID	SKU_ID	STORE_ID	STYLE
1	367	39965	50-WOMENS FOOTWEAR	[empty string]	6	8039	376226	98	53881
2	367	39965	50-WOMENS FOOTWEAR	[empty string]	8	8040	376227	98	53881
3	367	39965	50-WOMENS FOOTWEAR	[empty string]	13	8041	376228	98	53881
4	367	39965	50-WOMENS FOOTWEAR	[empty string]	10	8042	376229	98	53881
5	367	39965	50-WOMENS FOOTWEAR	[empty string]	10	8043	376230	98	53881
6	367	39965	50-WOMENS FOOTWEAR	[empty string]	4	8044	376231	98	53881

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 = '53881' ) 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 = 367 and b.attr2_entry_id = 39965 AND isNull(b.sell_web,'Y') = 'Y' GROUP BY b.sku_id ORDER BY b.sku_id

SQLPARAMETERS

array
1	97220

product description

Enjoy not one, not two, but three straps to secure those tootsies into your new favorite pair of sandals. An extra foot bed layer of soft foam and super soft fleece-lined straps will define a new standard of comfort. The Birkenstock Women's Florida Soft Footbed Birkibuc Sandals are designed to mold to your feet and pamper with all that added cushioning.

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 great for sensitive skin.

product specs

Contoured cork footbed with integrated latex foam cushion
Upper: Birko-Flor® with nubuck leather finish
Upper lining: fleece
Footbed lining: suede
Lightweight EVA sole for cushioning and shock absorption
Individually adjustable straps
Regular fit
Made in Germany

TOMS Women's Seaglass Torn Denim Espadrilles Apargatas Denim

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

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 London Suede Shoes Taupesuede

BIRKENSTOCK Birkenstock Women's London Suede Shoes $170.00

VIONIC Vionic Women's Rest Kirra Sandals $99.95 $49.99
50% off

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

Klogs Footwear Klogs Women's Springfield Shoes $59.95

TOMS Women's Classic Canvas Shoes - Black Black

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

TOMS Women's Natural Oxford Monica Wedges Nathemp

Toms Shoes TOMS Women's Natural Oxford Monica Wedges $79.95

Tula Women's Ranch Lattice Hat - L Straw

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

Injinji Injinji Unisex Liner Crew Socks $10.00

TOMS Women's Classic Canvas Shoes - Red Red

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

KEEN KEEN Women's Whisper Sandals $90.00 $53.99
40% off

Birkenstock Women's Mayari Birkibuc Sandals Anthracite

BIRKENSTOCK Birkenstock Women's Mayari Birkibuc Sandals $99.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

TULA HATS Tula Unisex Pecos Hat - XXL $37.95

Tula Unisex Lifeguard Hat - L/XL Natural

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

TOMS Women's Black Denim Majorca Cutout Sandals Blackdenim

Toms Shoes TOMS Women's Black Denim Majorca Cutout Sandals $89.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

KEEN Women's Whisper Sandals Drkshd/Crmc

KEEN KEEN Women's Whisper Sandals $90.00

TULA HATS Tula Women's Elegant Ranch Hat $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	<ul> <li>Contoured cork footbed with integrated latex foam cushion</li> <li>Upper: Birko-Flor® with nubuck leather finish</li> <li>Upper lining: fleece</li> <li>Footbed lining: suede</li> <li>Lightweight EVA sole for cushioning and shock absorption</li> <li>Individually adjustable straps</li> <li>Regular fit</li> <li>Made in Germany</li> </ul>	[empty string]	[empty string]	323	MOCHA,	39952	BIRKENSTOCK	BIRKENSTOCK	CLOTHING & FOOTWEAR	Clothing & Footwear &gt Women's &gt Footwear &gt Sandals	[empty string]	[empty string]	[empty string]	596	[empty string]	27280546	[empty string]	110	110	110	[empty string]	11010-DEFAULT-l.jpg	110	[empty string]	11010-DEFAULT-m.jpg	Enjoy not one, not two, but three straps with the ultra cushy and soft Birkenstock Women's Florida Soft Footbed Birkibuc Sandals. These slide-ons are designed to tp conform to your feet!	[empty string]	W/Florida-SFT-R	N	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	BTSTFW	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	[empty string]	50F	[empty string]	[empty string]	FALL_3	[empty string]	[empty string]	[empty string]	N	BIRKENSTOCK	50	0	[empty string]	11010	11010	100-to-150	0.00	0	[empty string]	[empty string]	[empty string]	Birkenstock Women's Florida Soft Footbed Birkibuc Sandals	<p>Enjoy not one, not two, but three straps to secure those tootsies into your new favorite pair of sandals. An extra foot bed layer of soft foam and super soft fleece-lined straps will define a new standard of comfort. The Birkenstock Women's Florida Soft Footbed Birkibuc Sandals are designed to mold to your feet and pamper with all that added cushioning.<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 great for sensitive skin.</p>	[empty string]	N	110	110	2888	0	36,37,38,39,40,41,	[empty string]	11010-DEFAULT-s.jpg	1000	53881	97220	FOOTWEAR	SANDALS	EMPTY	0	[empty string]	[empty string]	11010-DEFAULT-xs.jpg	WOMENS	shop/birkenstock-womens-florida-sof-97220	0	[empty string]	53881	[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='97220' order by ID desc