SELECT DISTINCT `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`, `price_index`.`udmp_new_min_price`, `price_index`.`udmp_new_max_price`, `price_index`.`udmp_new_cnt`, `price_index`.`udmp_used_min_price`, `price_index`.`udmp_used_max_price`, `price_index`.`udmp_used_cnt`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`is_salable` FROM `catalog_product_entity` AS `e`
INNER JOIN `udropship_vendor_product_limit` AS `udsclimit` ON e.entity_id=udsclimit.product_id
INNER JOIN `catalog_product_index_price_ws2` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '2' AND price_index.customer_group_id = 0 and price_index.udropship_vendor=0
LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 2 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product'))
INNER JOIN `catalog_product_entity` AS `product` ON product.entity_id = e.entity_id AND (product.created_in <= '1648512180' AND product.updated_in > '1648512180')
INNER JOIN `inventory_stock_4` AS `stock_status_index` ON product.sku = stock_status_index.sku WHERE ((udsclimit.class_id in (-1, '*')) AND (stock_status_index.is_salable = 1) AND (e.entity_id IN (1351316, 1351322, 1351448, 1351454, 1351460, 1351216, 1351221, 1351227, 1351233, 1351247, 1351252, 1351257, 1351262, 1351304, 1351310, 1351401, 1351507, 1354360, 1354366, 1354378))) AND (e.created_in <= '1648512180') AND (e.updated_in > '1648512180') ORDER BY FIELD(e.entity_id,1351316,1351322,1351448,1351454,1351460,1351216,1351221,1351227,1351233,1351247,1351252,1351257,1351262,1351304,1351310,1351401,1351507,1354360,1354366,1354378)
