Paper Shed Designs is the heartfelt creation of a talented husband-and-wife duo Dan and Jo O'Brien, bringing a touch of rustic charm to everyday moments. Their designs are inspired by nature, animals, and the great outdoors, and are created in their studio at Hewins Wood Farm in West Berkshire.
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`, `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 `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id` WHERE (e.entity_id IN (85511, 85510, 85509, 85508, 85507, 85506, 85504, 85505, 85503, 85502, 85501, 85500, 85499, 85497, 85498, 85496, 85495, 85494, 82723, 82722, 82721, 86081, 84570, 84571, 84572, 84569, 79311, 79310, 77423, 77422, 77421, 77420)) ORDER BY FIELD(e.entity_id,85511,85510,85509,85508,85507,85506,85504,85505,85503,85502,85501,85500,85499,85497,85498,85496,85495,85494,82723,82722,82721,86081,84570,84571,84572,84569,79311,79310,77423,77422,77421,77420)
