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 (8) 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
Long Swimwear
From ultra-feminine to sporty chic, our stunning tall swimwear range is bound to cause a splash! Crafted with care, attention to quality and a super-flattering fit, our tall swimwear range features everything you need to cause ripples of admiration around the pool, including a variety of gorgeous swimsuits and two-piece bikinis. Channel Baywatch era glamour with our fab Ruched Keyhole Back Swimsuit in statement red, or for simple sporty style, our Endurance Racer Back Swimsuit makes a strong statement with its bold pink accents. With a variety of flattering details, including wrap-over styling and ruching, as well as on-trend prints and colours, look no further than our tall swimwear range for all your suitcase tall essentials.
Based on 76 customer reviews our swimwear are rated 3.5 out of 5.
Discover 13 swimwear with prices ranging from US $45.00 to US $85.00