Моята количка
Моят потребителски профил

Намаления

Активни филтри
  1. Размер 35.5 Премахнете този елемент
string(1250) "SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `stock_status_index`.`stock_status` AS `is_salable`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id='32' INNER 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 INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN `search_tmp_5c1104328c7584_91894002` AS `search_result` ON e.entity_id = search_result.entity_id WHERE (stock_status_index.stock_status = 1) ORDER BY `cat_index`.`position` asc, `e`.`entity_id` DESC, `cat_index`.`position` asc LIMIT 20"

4 Артикули

на страница
Настрой низходяща посока
  1. Converse
    Детски маратонки CONVERSE C Chuck Taylor All Star Asphalt FOOTWEAR
    Специална цена 95,40 лв. Редовна цена 159,00 лв.
  2. Converse
    Детски кецове CONVERSE C Chuck Taylor All Star Asphalt FOOTWEAR
    Специална цена 95,40 лв. Редовна цена 159,00 лв.
  3. Nike
    Дамски маратонки NIKE WMNS AIR PRESTO ULTRA BR
    Специална цена 161,40 лв. Редовна цена 269,00 лв.
  4. Nike
    Детски маратонки NIKE AIR MAX 90 LTR (GS)
    Специална цена 125,40 лв. Редовна цена 209,00 лв.

4 Артикули

на страница
Настрой низходяща посока