Skip to

  1. navigation
  2. content
SELECT o.`option`, `wasusd` AS wasPrice, `nowusd` AS nowPrice, p.`product`, p.`name`, p.`seourl`, sum(s.`stock`) as `stock`, sum(s.`sold`) as `sold`, 0 + IF((MAX(pt.`supertop`)>0),990000,0) + IF(os.`us-usd-online`='N' AND sum(s.`sold`) < 1, ROUND( 10000/(sum(s.`sold`)+1) ) ,sum(s.`sold`)) + IF(os.`us-usd-online`='N' AND sum(s.`sold`) > 1, ROUND( 1000+(sum(s.`sold`)+1) ) ,sum(s.`sold`)) + IF(os.`us-usd-online`='N' AND GROUP_CONCAT(DISTINCT om.`modifierID`) NOT LIKE('%95%'),910000,0) + IF(os.`us-usd-online` IN ('H','N','E','F','R','V') AND (GROUP_CONCAT(DISTINCT om.`modifierID`) NOT LIKE('%95%')),10000,0) + IF( GROUP_CONCAT(DISTINCT om.`modifierID`) NOT LIKE('%95%'),3500,0) AS `rank`, 0 + IF(os.`us-usd-online`='N' AND sum(s.`sold`) < 10, ROUND ( 910000/(sum(s.`sold`)+1) ) ,sum(s.`sold`)) + IF(os.`us-usd-online`='N' AND sum(s.`sold`) > 10, ROUND ( 91000+(sum(s.`sold`)+1) ) ,0) + IF(os.`us-usd-online`='E', 80000, 0) + IF(os.`us-usd-online`='F', 70000, 0) + IF(os.`us-usd-online`='R', 60000, 0) + IF(os.`us-usd-online`='U', 50000, 0) + IF(os.`us-usd-online`='S', 40000, 0) + IF(os.`us-usd-online`='C', 30000, 0) AS `newarrivalrank`, c.`basecolour`, c.`colour` AS colour, CONCAT( CONCAT('d', GROUP_CONCAT(DISTINCT CAST(bsm.`dress-size` AS UNSIGNED) SEPARATOR ',d')), ',', CONCAT('t', GROUP_CONCAT(DISTINCT CAST(bsm.`trouser-size` AS UNSIGNED) SEPARATOR ',t')), ',', CONCAT('l', GROUP_CONCAT(DISTINCT CAST(bsm.`leg-length` AS UNSIGNED) SEPARATOR ',l')), ',', CONCAT('s', GROUP_CONCAT(DISTINCT IF( ROUND(bsm.`shoe-size`) = bsm.`shoe-size`, CAST(bsm.`shoe-size` AS UNSIGNED), CAST(bsm.`shoe-size` AS char)) SEPARATOR ',s')) ) AS sizes, ob.`brandID`, os.`us-usd-online` AS status, GROUP_CONCAT(DISTINCT om.`modifierID`) AS modifiers, GROUP_CONCAT(DISTINCT od.`departmentID`) AS departments, MAX(pt.`promotext`) AS 'promoText', MAX(pt.`colourcode`) AS 'promoTextColour', MAX(pt.`badge`) AS 'badge', o.rating FROM `option-us` AS o JOIN `product-us` AS p ON (p.`product` = o.`product`) JOIN `colour` AS c ON (o.`colour` = c.`colour`) JOIN `sku-us-usd` AS s ON (o.`option` = s.`option`) LEFT JOIN `base-size-map` AS bsm ON s.`base-size` = bsm.`base-size` JOIN `option-brand` AS ob ON (ob.`option` = o.`option`) JOIN `option-department` AS od ON (o.`option` = od.`option`) JOIN `option-status` AS os ON (o.`option` = os.`option`) LEFT JOIN `option-modifier` AS om ON (om.`option` = o.`option` AND om.`modifierID` IN (SELECT `modifierID` FROM `modifier` WHERE `refinement` = 1) ) LEFT JOIN `promotext` AS pt ON (pt.`option` = o.`option` AND `site` = 'us' AND `currency` = 'usd' AND `from` < NOW() AND `to` > NOW() ) WHERE o.`option` = s.`option` AND s.`stock`+s.`backorderable`> 0 AND od.`departmentID` IN (3) AND os.`us-usd-online` IN ('N','E','F','R','M','S','U','C','V') GROUP BY o.`option` ORDER BY `rank` DESC, `stock` DESC, pt.`from` DESC
Women Tall Jeans

Jeans are a must-have staple in any wardrobe, which is why we've brought you a fantastic range of tall women's jeans, designed to fit and flatter your proportions. Available in 34", 36" and 38" leg lengths, our jeans come in a variety of cuts, whether you're looking for a basic bootcut, simple straight leg or slimline skinny fit. You'll also find a variety of denim colours and washes in the Long Tall Sally collection, giving your wardrobe maximum versatility. As well as the classic black, grey and dark denim options, you can also make a bold fashion statement with our Camden Tall Skinny Jeans, now available in on-trend acid wash and tie-dye print. Just team with one of our tall tunic topsfor an effortless weekend daytime look!

.
Based on 410 customer reviews our jeans are rated 3.9 out of 5.
Discover 154 jeans with prices ranging from US $25.00 to US $149.00