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='1' 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('223460', '223461', '223462', '223463')) ORDER BY FIELD(e.entity_id, ) LIMIT 5 Green Camo Pant - Pants - Streetwear - Men - Catalog

Green Camo Pant

CHF 69.00 statt CHF 139.00
SKU
DSSS22-GCP
Auf Lager
Verfügbar in diesen Stores:
(Bitte Farbe und/oder Grösse wählen)
SALE
Die Jogger Green Camo Technical Pants von Drink Sexy aus der Yung Doli Wear Kollektion sind stylische Hosen mit elastischem Bund inklusive Kordel und Allover Print.
Details

Artikelnummer

DSSS22-GCP

Kategorie

Jogger, Training

Eigenschaften

Loose Fit