Skip to

  1. navigation
  2. content

 
SELECT o.product, o.option, p.name, p.seourl as seoUrl, o.colour, os.`www-gbp-online` as status, c.name AS colourName, o.wasgbp AS wasPrice, o.nowgbp AS nowPrice, `option-image`.`filename` AS image, IF(o.`swatch` IS NULL, c.`swatch`, o.`swatch`) as swatch, sku.sku, sku.stock, sku.backorderable, sku.`base-size`, `base-size`.`locale-size`, `base-size`.`locale-leg-size`, `base-size`.`order` AS `base-size-order`, sku.due, o.rating, CONCAT( CONCAT('d', GROUP_CONCAT(DISTINCT CAST(bsm.`dress-size` AS char) SEPARATOR ',d')), ',', CONCAT('t', GROUP_CONCAT(DISTINCT CAST(bsm.`trouser-size` AS char) SEPARATOR ',t')), ',', CONCAT('l', GROUP_CONCAT(DISTINCT CAST(bsm.`leg-length` AS char) SEPARATOR ',l')), ',', CONCAT('s', GROUP_CONCAT(DISTINCT CAST(bsm.`shoe-size` AS char) SEPARATOR ',s')) ) AS sizes, GROUP_CONCAT(DISTINCT om.`modifierID`) AS 'modifiers', GROUP_CONCAT(DISTINCT od.`departmentID`) AS 'departments', GROUP_CONCAT(DISTINCT ob.`brandID`) AS 'brands' FROM `sku-www-gbp` AS sku LEFT JOIN `base-size` ON sku.`base-size` = `base-size`.`base-size` AND `base-size`.`currency` = 'gbp' LEFT JOIN `option-www` o ON o.`option` = sku.option LEFT JOIN `product-www` p ON p.product = o.product LEFT JOIN colour c ON c.colour = o.colour LEFT JOIN `option-image` ON `option-image`.`option` = o.`option` LEFT JOIN `option-modifier` AS om ON (om.`option` = o.`option`) LEFT JOIN `option-status`as os ON o.`option` = os.`option` LEFT JOIN `option-brand`as ob ON o.`option` = ob.`option` LEFT JOIN `base-size-map` AS bsm ON sku.`base-size` = bsm.`base-size` LEFT JOIN `option-department` AS od ON sku.`option` = od.`option` WHERE sku.option IN (?,?,?,?,?,?) AND os.`www-gbp-online` != 'O' -- Exclude obsolete status options GROUP BY sku.sku ORDER BY o.colour ASC, sku.`base-size` ASC

Stretch Cotton Cami

£14.00

Product code: 07C06
  • XS
  • S
  • M
  • L
  • XL
Size guide LLow stock Out of stock
Please choose a size first

Description

Our best-selling soft jersey cami with adjustable-length straps. Please note: If you are between sizes, it may be worth purchasing the smaller size.

Fit & Care

Length:
68cm (27")
Sleeve:
Sleeveless
Body Fit:
Tight fit.
Fabric:
95% Cotton, 5% Elastane.

Washing Instruction:
Machine washable.

Loading delivery information...

Share

Reviews (1)

Overall Rating: { 1 Review | write a review }

  • Fit: true to size
  • Quality:
  • Value:

    • Fit: true to size
    • Quality:
    • Value:

    I bought five of these and wear one almost everyday. they are perfect for the first layer under any other shirt. they are long and comfortable.

    Katrina would recommend this product to a friend.