Discover Beau & Elliot, a boutique British lifestyle brand inspired by all things charmingly chic and beguilingly beautiful. Inspired by the character and charm of vintage British design, the collection brings together retro patterns, bold geometric shapes, vibrant colours and beautifully considered details with a fresh contemporary feel. Explore stylish kitchenware, picnicwares, stationery, travel essentials and more, each collection is designed to add personality and a splash of colour to everyday life. From cheerful prints to practical pieces made for modern living, Beau & Elliot captures a distinctly British sense of style while creating colourful, versatile products to enjoy every day.
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 (104477, 104478, 104479, 104480, 104481, 104482, 104483, 104484, 104485, 104486, 104487, 104488, 104489, 104490, 104491, 104492, 104493, 104494, 104495, 104496, 104497, 104498, 104499, 104500, 104501, 104502, 104503, 104504, 104505, 104506, 104507)) ORDER BY FIELD(e.entity_id,104477,104478,104479,104480,104481,104482,104483,104484,104485,104486,104487,104488,104489,104490,104491,104492,104493,104494,104495,104496,104497,104498,104499,104500,104501,104502,104503,104504,104505,104506,104507)
