Browse women's and girls' pajamas by the relevant category, including women's, teen girls' and children's ranges. Start with the size and intended use, then compare sleeve details, trouser designs and colours across the listed styles. Check the category and sizing information before ordering, as sizing varies between ranges. Choose a design for your sleep and home routine, and follow its washing and ironing instructions.
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'))
INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id WHERE (stock_status_index.stock_status = 1) AND (e.entity_id IN (5162, 5158, 5147, 5144, 5137, 5133, 12143, 12139, 12135, 12131, 12128, 12124, 12114, 12104, 10769, 10765, 10761, 10754, 10747, 10740, 5048, 5031, 5021)) ORDER BY FIELD(e.entity_id,5162,5158,5147,5144,5137,5133,12143,12139,12135,12131,12128,12124,12114,12104,10769,10765,10761,10754,10747,10740,5048,5031,5021)
