Explore women's and girls' pajamas alongside girls' underwear sets at Ajlan & Bros. Browse pajamas for sleepwear and time at home, or choose underwear sets when shopping for girls' everyday basics. Check the intended size category on each product, as women's, teen girls' and children's ranges use different sizing. Compare design details and size information, then follow the washing and ironing instructions provided with each garment.
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, 3186, 3155)) 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,3186,3155)
