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.
Harlem Candle Co.
Founded in 2014 by travel and lifestyle expert Teri Johnson, Harlem Candle Co. is a luxury home fragrance brand specializing in scented candles inspired by the richness of Harlem.
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 (183718, 163366, 164305, 183794, 183788))) AND (e.created_in '1714535940') ORDER BY FIELD(e.entity_id,183718,163366,164305,183794,183788)