The store will not work correctly when cookies are disabled.
We use cookies and personal data for two reasons - to deliver the best website experience and serve personalised ads. Click Accept to continue or find out more in our Cookie and Privacy Policy
Discover the vibrant world of Floh, the trend-led sister brand to Toasted Crumpet, blending bold colours, playful patterns and contemporary design across stylish gifts and home accessories. Proudly designed and lovingly made in the United Kingdom, Floh brings a fresh feel to modern gifting with a focus on quality, sustainability and modern living. Designed with creativity and feel-good style in mind, the Floh collection is perfect for adding personality and joyful colour to every occasion.
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 (95813, 95815, 95814, 95816, 95819, 95821, 95820, 95822, 95809, 95818, 95817, 95824, 95823, 95826, 95825, 95828, 95827)) ORDER BY FIELD(e.entity_id,95813,95815,95814,95816,95819,95821,95820,95822,95809,95818,95817,95824,95823,95826,95825,95828,95827)
