SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='2' AND cat_index.visibility IN(3, 2, 4) AND cat_index.category_id='463' LEFT JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1 WHERE (`e`.`entity_id` IN('94784')) ORDER BY FIELD(e.entity_id, ) LIMIT 5 Treasure - Socks - Streetwear - Women - Catalog

Treasure

0,00 CHF
SKU
W1800TRE
Out of stock
Disponible dans les stores doodahs suivants:
(Choisis la couleur et/ou la taille stp)
Les Treasure Socks de Stance garantissent un confort incroyable. Un soutient élastique au niveau de la cheville et les orteils ainsi que les talons renforcés soutiennent tes pieds durant toute la journée.
Détails

Composition

55% coton, 27% nylon, 18% elasthane