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
