Offer applies automatically at checkout. Valid online (store.metmuseum.org) only for standard shipping to addresses within the contiguous 48 states, on merchandise orders of $100 or more, excluding tax and gift wrap. Offer ends 12/31/24 at 11:59 PM ET and does not apply to prior purchases, membership purchases, or select items with surcharges. Offer not available in our retail stores or Met Custom Prints (customprints.metmuseum.org) and subject to change or cancellation without notice. Void where prohibited.
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`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`stock_status` AS `is_salable` 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 = '1'
LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product'))
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 WHERE ((e.entity_id IN (34482, 8299, 10435, 9946, 18964, 18967))) AND (e.created_in '1714535940') ORDER BY FIELD(e.entity_id,34482,8299,10435,9946,18964,18967)
Discover The Met Store's full selection of unique, carefully chosen gifts for under $50. From scarves, earrings, and bracelets to puzzles, watches, posters, and more, The Met Store has made it easy to find gifts in any price range, all inspired by works from The Metropolitan Museum of Art.
Clearance
