Cart

Mini Cart

You have items in your cart
There are no items in the cart
Home Page

PROMO

Final query: items(8) SELECT `e`.*, `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`, IF(at_visibility.value_id > 0, at_visibility.value, at_visibility_default.value) AS `visibility`, SUM(sales_order_item.qty_ordered) AS `qty_ordered`, `sales_order_item`.`created_at` AS `order_date`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e`
 INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '58'
 INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = 58
 LEFT JOIN `catalog_product_entity_int` AS `at_visibility_default` ON (`at_visibility_default`.`entity_id` = `e`.`entity_id`) AND (`at_visibility_default`.`attribute_id` = '99') AND `at_visibility_default`.`store_id` = 0
 LEFT JOIN `catalog_product_entity_int` AS `at_visibility` ON (`at_visibility`.`entity_id` = `e`.`entity_id`) AND (`at_visibility`.`attribute_id` = '99') AND (`at_visibility`.`store_id` = 104)
 LEFT JOIN `sales_order_item` ON e.entity_id = sales_order_item.product_id
 INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id WHERE (IF(at_visibility.value_id > 0, at_visibility.value, at_visibility_default.value) = '4') AND (e.entity_id IN((SELECT `cat`.`product_id` FROM `catalog_category_product` AS `cat` WHERE (cat.category_id IN(401))))) AND (sales_order_item.created_at >= '2021-11-28 23:19:15') AND (sales_order_item.created_at <= '2021-12-01 23:19:15') AND (stock_status_index.stock_status = 1) GROUP BY `e`.`entity_id` ORDER BY `qty_ordered` DESC
 LIMIT 8

DISCOVER THE MOST SOLD ONLINE

  1. LEGGINGS COTONE PESANTE ELASTICIZZATO
    As low as CHF 9.71
  2. PIGIAMA IN PILE JURASSIC WORLD
    As low as CHF 21.54
  3. GIUBBINO CON TASCHINO A CERNIERA
    As low as CHF 70.13
  4. PIGIAMA IN PILE MINIONS
    As low as CHF 21.54
  5. CAPPOTTINO LUNGO CON CAPPUCCIO
    As low as CHF 64.73
  6. PULLOVER IN FILATO MISTO
    As low as CHF 37.74
  7. PANTALONE IN FELPA DI COTONE
    As low as CHF 10.79
  8. PIGIAMA IN PILE CON RICAMO DAVANTI
    As low as CHF 13.98
Query + Rendering tempo totale: "1.538 secs."
 

LEFT INSPIRE BY OUR Looks