WOMEN'S TAYLIN

No 1706_100200

Be the first to review!

$140.00

Choose Color

query
	ATTR1	ATTR1_ENTRY_ID	FAM	HEX	MAXQC	MAXQOH	MINQC	MINQOH	ORIGATTR1	QOH	SELL_WEB	SKUOF16	SKU_ID	SORT_ORDER	STYLE_ID
1	BLACK_BURNISH_SUEDE	112079	[empty string]	[empty string]	0	2	0	0	BLACK_BURNISH_SUEDE	45	Y	[empty string]	938219	[empty string]	200174

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,5,8,6,9,14,15,7,2,1,3,97) group by sku_id having sum(qoh+qc) >=1) 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,5,8,6,9,14,15,7,2,1,3,97) GROUP BY b.attr1 HAVING sum(e.qoh+e.qc) >= 1 ORDER BY max(b.attr1_order), max(b.attr1_entry_id)

SQLPARAMETERS

array
1	200174

struct
INTERNALLISTPRICE	140
INTERNALMARKDOWN	false
INTERNALPRICE	140
REG	140
SALE	140
TERMSALE	false
TERMSALELISTPRICE	0
TERMSALEPRICE	0

CHOOSE Size

Size Chart

Size

One

Qty

Check Store Availability

Add to Basket

Please login or create an account to save this product to your wish list.

Description
Specs
Reviews
Live Chat

Tall, cute & oh so comfy

Taylin is an on trend open toe heeled sandal with hook and loop adjustability at the ankle strap, an open back, and clean metal hardware detail. Taylin features burnished suede uppers, leather linings for all day comfort, a contoured footbed with memory foam for all-day support, a lightweight, shock absorbing PU midsole, and a rubber outsole for long-lasting wear.

Leather linings for all day comfort
Burnished leather uppers
Stapled construction
Cushioned PUT footbed for all day support
Fully contoured, lightweight rigid PU midsole
Rubber outsole for long lasting wear
Care instructions: Use a damp soapy cloth or sponge to remove surface dirt. Do not saturate the leather. Ordinary scuff marks may be touched up with shoe polish. To maintain, buff lightly with the Dansko Anytime ShoeShine sponge.
Imported

No Reviews Yet!

Spill the Beans

Headline Name Email Overall Rating

Review

We want to make sure you know: All reviews become the property of Mast General Store. Your review requires staff approval before posting. See our Terms of Use for details.

Description

Taylin is an on trend open toe heeled sandal with hook and loop adjustability at the ankle strap, an open back, and clean metal hardware detail. Taylin features burnished suede uppers, leather linings for all day comfort, a contoured footbed with memory foam for all-day support, a lightweight, shock absorbing PU midsole, and a rubber outsole for long-lasting wear.
Specs
- Leather linings for all day comfort
- Burnished leather uppers
- Stapled construction
- Cushioned PUT footbed for all day support
- Fully contoured, lightweight rigid PU midsole
- Rubber outsole for long lasting wear
- Care instructions: Use a damp soapy cloth or sponge to remove surface dirt. Do not saturate the leather. Ordinary scuff marks may be touched up with shoe polish. To maintain, buff lightly with the Dansko Anytime ShoeShine sponge.
- Imported
Reviews

No Reviews Yet!
Live Chat

WOMEN'S TAYLIN

$140.00

Choose Color

CHOOSE Size

One

Qty

Spill the Beans

You may also like