Aardaman Animations is the world famous, British animation studio renowned for their stop-motion films and series including Wallace & Gromit, Shaun the Sheep, Chicken Run and Morphe. Our collection of plush toys, homeware and gifts showcases the enchanting world of Aardman Animations and brings these animated classics to life in delightful, must-have treasures for fans of all ages!
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`, `stock_status_index`.`stock_status` AS `is_salable`, `at_bestsellers`.`qty_ordered` AS `bestsellers`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents` 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 = '5'
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 `amasty_sorting_bestsellers` AS `at_bestsellers` ON (at_bestsellers.`product_id`=e.entity_id) AND (at_bestsellers.store_id = '5')
LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id` WHERE (e.entity_id IN (76831, 74354, 79335, 79336, 82160, 74350, 74352, 74353, 74355, 74356, 82149, 76822, 76823, 76824, 76825, 76826, 76827, 76828, 76829, 76830, 79332, 79333, 79334, 79338, 79340, 79341, 79342, 79343, 79344, 79345, 79346, 79347)) ORDER BY FIELD(e.entity_id,76831,74354,79335,79336,82160,74350,74352,74353,74355,74356,82149,76822,76823,76824,76825,76826,76827,76828,76829,76830,79332,79333,79334,79338,79340,79341,79342,79343,79344,79345,79346,79347)
