We use cookies to provide and improve our service and your shopping experience. If you continue browsing, we’ll assume that you consent to receiving all cookies. Learn more.
Barn of Monkeys is a childrenswear brand for ages 2 to 16, focused on solid social and cultural values and with a strong concern for durability and eco-responsibility. Each piece is designed to hold a special meaning, resulting in exclusive prints that encourage interesting conversations with the little ones. In this season, there is fun sweatshirts and pleated skirts in dusty rose and eggshell.
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` FROM `tb_catalog_product_entity` AS `e`
INNER JOIN `tb_catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0
LEFT JOIN `tb_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 WHERE (e.entity_id IN (73954, 73945, 73935, 73925, 73898, 73896, 73878, 73868, 73858, 73848, 73838, 73828, 73817, 73808, 73798, 73788, 73774, 73768, 73767, 73756, 73746, 73739, 73731, 73725))
