J Brand Cigarette Jean

Price £160.00£110.00

Clearance

Be the first to write a review!

Product Code: 54Z12DVI

Launched in 2005, fashion forward J brand are popular for their stylishly understated designs. With style icons Anna Wintour and Kate Moss as fans, this fashion favourite is here to stay. Slim, straight leg jeans with five pocket styling and contrast stitching. Available online only.

This is a slim fit with little stretch, we recommend you go up a size.

(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` = '/converse/j-brand-cigarette-jean/d-vintage' 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` = '/converse/j-brand-cigarette-jean/d-vintage' 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` = '/converse/j-brand-cigarette-jean/d-vintage' LIMIT 1) LIMIT 1) AND opt.`option` != (SELECT `option` FROM `option-www` WHERE `url` = '/converse/j-brand-cigarette-jean/d-vintage' 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` = '/converse/j-brand-cigarette-jean/d-vintage' LIMIT 1) LIMIT 1) AND opt.`option` != (SELECT `option` FROM `option-www` WHERE `url` = '/converse/j-brand-cigarette-jean/d-vintage' LIMIT 1) AND sku.stock >= '1' GROUP BY `option` limit 6) LIMIT 3 Array ( [scheme] => http [host] => www.longtallsally.com [path] => /converse/j-brand-cigarette-jean/d-vintage [query] => category=SaleGBP101 )