SELECT 1 AS `status`, `e`.`entity_id`, `e`.`attribute_set_id`, `e`.`type_id`, `e`.`created_at`, `e`.`updated_at`, `e`.`sku`, `e`.`is_new`, `stock_status_index`.`stock_status` AS `is_salable`, `product_absolutes`.`absolute_price`, `product_absolutes`.`absolute_cost`, `product_absolutes`.`absolute_weight` FROM `catalog_product_flat_1` AS `e` 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 LEFT JOIN `mageworx_optionfeatures_product_attributes` AS `product_absolutes` ON `e`.`entity_id` = `product_absolutes`.`product_id` WHERE (e.is_new = 1) ORDER BY `cat_index_position` ASC, `e`.`entity_id` ASC LIMIT 10 New Products
We're sorry, an error has occurred while generating this content.
We use cookies to provide you with a better service. Carry on browsing if you're happy with this, or find out how to manage cookies notification-close