Browse summer and winter thobes for teen boys, starting with the season you are shopping for. Review collar shapes, fastenings and cut details, then compare thobe and sleeve lengths with the product's sizing information. Consider whether the garment is for family visits or special occasions when choosing a design. To care for its appearance, follow the washing and ironing instructions on the garment label.
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 (7475, 7474, 7473, 7472, 7443, 7442, 7441, 7440, 13053, 12939, 12780, 12515, 12321, 11623, 11595, 11567, 11539, 10863)) ORDER BY FIELD(e.entity_id,7475,7474,7473,7472,7443,7442,7441,7440,13053,12939,12780,12515,12321,11623,11595,11567,11539,10863)
winter formal thob curved collar youth light grayAs low as 80.01SAR
