Skip to

  1. navigation
  2. content
(SELECT opt.`option` AS ID, sum(`stock`) AS stock, pdt.`name`, `seourl`, `wasusd` AS wasPrice, `nowusd` AS nowPrice, min(img.`filename`) AS image FROM `merch`, `sku-us-usd` AS sku, `base-size-map` AS bsm, `option-us` AS opt JOIN `product-us` AS pdt ON opt.product = pdt.product JOIN `option-image` AS img ON img.`option` = opt.`option` WHERE opt.`option` = `merch`.`related` AND sku.option = merch.related AND sku.stock + sku.`backorderable` >= '1' AND sku.`base-size` = bsm.`base-size` AND `merch`.`option` IN (?) AND img.`order`=1 GROUP BY `related` limit 4) UNION DISTINCT (SELECT opt.`option` AS ID, sum(`stock`) AS stock, pdt.`name`, `seourl`, `wasusd` AS wasPrice, `nowusd` AS nowPrice, min(img.`filename`) AS image FROM `sku-us-usd` AS sku, `base-size-map` AS bsm, `option-status`, `option-us` AS opt JOIN `product-us` AS pdt ON opt.product = pdt.product LEFT JOIN `option-department` ON `option-department`.`option` = opt.`option` JOIN `option-image` as img ON img.`option` = opt.`option` WHERE sku.`option` = opt.`option` AND img.`order`=1 AND `option-status`.`option` = opt.`option` AND `option-department`.`departmentID` = (SELECT `departmentID` FROM `option-department` WHERE `option` IN (?) LIMIT 1) AND `option-status`.`us-usd-online` = (SELECT `us-usd-online` FROM `option-status` WHERE `option` IN (?) LIMIT 1) AND opt.`option` NOT IN (?) AND sku.stock >= '1' AND sku.`base-size` = bsm.`base-size` GROUP BY opt.`option` limit 6) UNION DISTINCT (SELECT opt.`option` AS ID, sum(`stock`) AS stock, pdt.`name`, `seourl`, `wasusd` AS wasPrice, `nowusd` AS nowPrice, min(img.`filename`) AS image FROM `sku-us-usd` AS sku, `base-size-map` AS bsm, `option-status`, `option-us` AS opt JOIN `product-us` AS pdt ON opt.product = pdt.product LEFT JOIN `option-department` ON `option-department`.`option` = opt.`option` JOIN `option-image` as img ON img.`option` = opt.`option` WHERE sku.`option` = opt.`option` AND img.`order`=1 AND `option-status`.`option` = opt.`option` AND `option-department`.`departmentID` = (SELECT `departmentID` FROM `option-department` WHERE `option` IN (?) LIMIT 1) AND opt.`option` NOT IN (?) AND sku.stock >= '1' AND sku.`base-size` = bsm.`base-size` GROUP BY opt.`option` limit 6) LIMIT 6

Alisa Jeans

Extra 25% off shown in basket. Offer ends Sunday 8th March. Not to be used in conjunction with any other offer.

Product code: 14X21 / 14X22
Sorry, this product is sold out and is no longer available.

Description

 Stretch denim bootleg jeans  5 pocket western styling  Embossed leather patch at back waistband and crease wash detailing. Style note: Bootcut tall jeans are a seasonless staple. Partner them with a relaxed-fit tee and a slouchy bag for laidback cool.

Video

Loading delivery information...

Share

Reviews (1)

Overall Rating: { 1 Review | write a review }

      not sized properly

        waist is large and length is short. I ordered a size 6 and 34 inch length and it fits like an 8 with a 33 inch leg. Nice color and material, but stretches when you wear it and does not shrink back up.