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('108526')) ORDER BY FIELD(e.entity_id, ) LIMIT 5 WM Janek II Denim Short - Shorts - Streetwear - Women - Catalog

WM Janek II Denim Short

0,00 CHF
SKU
VA31PTM6A
Out of stock
Disponible dans les stores doodahs suivants:
(Choisis la couleur et/ou la taille stp)
Le Janek II Denim Short de Vans est un short en jeans léger pour filles. Il possède un cordonnet pour que tu puisses ajuster la taille simplement.
Détails

Composition

100% coton

Catégorie

Casual