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 = '57'
 INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = 57
 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` = 101)
 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:22:05') AND (sales_order_item.created_at <= '2021-12-01 23:22:05') 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. STRETCH HEAVY COTTON LEGGINGS
    As low as SEK91.92
  2. JURASSIC WORLD FLEECE PAJAMAS
    As low as SEK203.98
  3. JACKET WITH ZIPPER POCKET
    As low as SEK664.07
  4. MINIONS FLEECE PAJAMAS
    As low as SEK203.98
  5. LONG COAT WITH HOOD
    As low as SEK612.95
  6. MIXED YARN PULLOVER
    As low as SEK357.34
  7. COTTON SWEATPANTS
    As low as SEK102.14
  8. MIXED YARN PULLOVER
    As low as SEK357.34
Query + Rendering tempo totale: "1.903 secs."
 

LEFT INSPIRE BY OUR Looks