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 os.`us-usd-online` IN ('N','E','F') GROUP BY o.`option` ORDER BY `rank` DESC, `stock` DESC, pt.`from` DESC
Clothing for tall women, including long tops, suiting for tall, long dresses, tall pants and jeans, tall leisure and activewear and women's shoes in larger sizes
Based on 3527 customer reviews our current collection are rated 4.1 out of 5.
Discover 663 current collection with prices ranging from US $12.00 to US $285.00