Birkenstock Madrid Birko Flor

Price £40.00£30.00

Clearance

Be the first to write a review!

Product Code: 51Z02SNA

The world famous brand is now exclusively available at Long Tall Sally. Specially designed to cradle your feet in all the right places, each sandal features the original Birkenstock contoured footbed with one purpose in mind- walking in comfort. Best selling single strap style in a fashionable range of Birko Flor uppers. Featuring; adjustable strap, cork/latex footbed and shock absorbing EVA sole.

(SELECT `related`, sum(`stock`) as stock,sku.`size-hmc`, `name`, `wasgbp`, `nowgbp`, `url`, `img150x223` FROM `merch`, `sku-www-gbp` as sku, `option-www` as opt JOIN `product-www` as pdt ON opt.product = pdt.product WHERE opt.`option` = `merch`.`related` AND sku.option = merch.related AND sku.stock >= '1' AND `merch`.`option` = (SELECT `option` FROM `option-www` WHERE `url` = '/tall/birkenstock/birkenstock-madrid-birko-flor/snake' LIMIT 1) GROUP BY `related` limit 3) UNION DISTINCT (SELECT opt.`option`, sum(`stock`) as stock,sku.`size-hmc`, `name`, `wasgbp`, `nowgbp`, `url`, `img150x223` FROM `sku-www-gbp` as sku, `option-status`,`option-www` as opt JOIN `product-www` as pdt ON opt.product = pdt.product LEFT JOIN `option-department` on `option-department`.`option` = opt.`option` WHERE sku.`option` = opt.`option` AND `option-status`.`option` = opt.`option` AND `option-department`.`departmentID` = (SELECT `departmentID` FROM `option-department` WHERE `option` = (SELECT `option` FROM `option-www` WHERE `url` = '/tall/birkenstock/birkenstock-madrid-birko-flor/snake' LIMIT 1) LIMIT 1) AND `option-status`.`www-gbp-online` = (SELECT `www-gbp-online` FROM `option-status` WHERE `option` = (SELECT `option` FROM `option-www` WHERE `url` = '/tall/birkenstock/birkenstock-madrid-birko-flor/snake' LIMIT 1) LIMIT 1) AND opt.`option` != (SELECT `option` FROM `option-www` WHERE `url` = '/tall/birkenstock/birkenstock-madrid-birko-flor/snake' LIMIT 1) AND sku.stock >= '1' GROUP BY `option` limit 6) UNION DISTINCT (SELECT opt.`option`, sum(`stock`) as stock,sku.`size-hmc`, `name`, `wasgbp`, `nowgbp`, `url`, `img150x223` FROM `sku-www-gbp` as sku, `option-status`,`option-www` as opt JOIN `product-www` as pdt ON opt.product = pdt.product LEFT JOIN `option-department` on `option-department`.`option` = opt.`option` WHERE sku.`option` = opt.`option` AND `option-status`.`option` = opt.`option` AND `option-department`.`departmentID` = (SELECT `departmentID` FROM `option-department` WHERE `option` = (SELECT `option` FROM `option-www` WHERE `url` = '/tall/birkenstock/birkenstock-madrid-birko-flor/snake' LIMIT 1) LIMIT 1) AND opt.`option` != (SELECT `option` FROM `option-www` WHERE `url` = '/tall/birkenstock/birkenstock-madrid-birko-flor/snake' LIMIT 1) AND sku.stock >= '1' GROUP BY `option` limit 6) LIMIT 3 Array ( [scheme] => http [host] => www.longtallsally.com [path] => /tall/birkenstock/birkenstock-madrid-birko-flor/snake [query] => category=f-064_birkenstock )