Choose a men's thobe for the summer season and compare design details for everyday wear and occasions. Review collar shape, fastenings, thobe length and sleeves before selecting a size. Check the fabric description for each model to match your preferences rather than relying only on its seasonal category. Follow the individual washing and ironing instructions when caring for your chosen thobe.
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 (12517, 12516, 12320, 9610, 9577, 8988, 8986, 8983, 8982, 13281, 13264, 13247, 13230, 13213, 13196, 13173, 13161, 13149, 13095, 12973)) ORDER BY FIELD(e.entity_id,12517,12516,12320,9610,9577,8988,8986,8983,8982,13281,13264,13247,13230,13213,13196,13173,13161,13149,13095,12973)
ثوب رجالي اسبان اف كريمي سحاب مخفي قلاب جديد رجاليAs low as 71.25SAR
ثوب رجالي اسبان اف أبيض سحاب مخفي قلاب جديد رجاليAs low as 71.25SAR
