OPUMO is a contemporary lifestyle platform connecting artists, designers, influencers and customers in a personalised and content-rich environment. With new arrivals added daily and new brands joining every week, you can be sure that every handpicked product - from menswear to art and interiors - meets our strict criteria of quality materials, craftsmanship and originality.
We spoke about the importance of layering in the city, but when it comes to the countryside you have to think a little bit harder than just packing a few extra t-shirts. The key to packing for this kind of trip is thinking about layers that you can remove or pile on as the weather dictates; which is why you’ll need a few of our favourite shirts, jackets, jeans and boots from the edit below.
SELECT DISTINCT `e`.*, `cat_index`.`position` AS `cat_index_position`, `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` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=5 AND cat_index.visibility IN(2, 4) AND cat_index.category_id='94'
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '3' AND price_index.customer_group_id = 0
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 ORDER BY `position` ASC, `cat_index`.`position` ASC