Medium

Browse boys' winter thobes and compare designs for visits and occasions. Start by checking thobe and sleeve lengths, then consider the collar shape and fastening you prefer. Use body measurements and the product's size information when selecting a fit, allowing for the clothing that will be worn underneath. Follow the thobe's washing and ironing instructions to care for its details and appearance.

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 (11829, 11817, 11227, 11211, 11195, 11179, 10855, 10847, 10839, 10831, 7470, 7468, 7439, 7438, 7437, 7436)) ORDER BY FIELD(e.entity_id,11829,11817,11227,11211,11195,11179,10855,10847,10839,10831,7470,7468,7439,7438,7437,7436)