Skip to

  1. navigation
  2. content
Free Shipping on orders with $30 of clothing
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 o.`option` IN (SELECT `option-modifier`.`option` FROM `option-modifier` WHERE `option-modifier`.`modifierID` IN (24) ) 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
Tall Knitwear For Tall Women
Fun, flattering and made using the softest yarns, our tall knitwear essentials are perfect for layering - or to be worn on their own! You'll find a great selection of different styles in our knitwear range, from basic crew-neck cardigans in bright shades to flattering wrap-over tops and chic jersey shrugs. Great for seeing you through those tricky transitional seasons, our staple knitwear pieces can be worn casually over t-shirts and jeans, or, in the case of this elegant Jersey Shrug, over an evening dress to keep shoulders warm, giving you plenty of stylish knit options for every occasion.
Based on 368 customer reviews our long knitwear are rated 4.1 out of 5.
Discover 50 long knitwear with prices ranging from US $25.00 to US $149.00