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 od.`departmentID` IN (4) AND os.`us-usd-online` IN ('M','S','U','C') GROUP BY o.`option` ORDER BY `rank` DESC, `stock` DESC, pt.`from` DESC
Based on 216 customer reviews our sale skirts are rated 3.9 out of 5.
Discover 32 sale skirts with prices ranging from US $19.00 to US $89.00