Skip to

  1. navigation
  2. content

 
SELECT o.product, o.option, p.name, p.seourl as seoUrl, o.colour, os.`us-usd-online` as status, c.name AS colourName, o.wasusd AS wasPrice, o.nowusd 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-us-usd` AS sku LEFT JOIN `base-size` ON sku.`base-size` = `base-size`.`base-size` AND `base-size`.`currency` = 'usd' LEFT JOIN `option-us` o ON o.`option` = sku.option LEFT JOIN `product-us` 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.`us-usd-online` != 'O' -- Exclude obsolete status options GROUP BY sku.sku ORDER BY o.colour ASC, sku.`base-size` ASC

Heffalump Mingle Loop Back Hoodie

US $0.00

Product code: 07C101
  • M
  • L
  • XL
Size guide Out of stock
Please choose a size first

Description

Ladies tall popover fleece with drawstring crossover neck.Style note: You'll be comfy, yet cool in this laidback sweatshirt made for taller girls.

Fit & Care

Length:


Washing Instruction:
Machine washable

Loading delivery information...

Share

Reviews (2)

Overall Rating: { 2 Reviews | write a review }

      Sleeves are way too short

        I agree with the comment above!! This sweatshirt is more than long enough in the torso but the sleeves are about 2 too short for me! And I am only 6 0 tall. The sleeves of the pink Bench sweatshirt that I bought are long enough, so what happened with this sweatshirt?!?! I kept it cuz it is still a great sweatshirt...but very disappointed with the length of the sleeves.

        Comfy, but sleeves too short

          This is a really comfortable, nice feeling hoodie that is more than long enough in the torso. The sleeves, however, are another matter. They aren t long enough at all. Another inch of length, preferably two, would have made this hoodie perfect. I don t have that problem with the other Bench hoodies I have, so it must be a problem with this particular style.

        You may also like...