Explore men's red and white shemaghs to find a design that complements your thobe and preferred way of wearing it. Compare patterns, border details and the sizes listed for each style, considering how far you want the ends to fall. Browse by colour to narrow your selection. Before washing or ironing a shemagh, check its care instructions, as the appropriate method depends on the individual fabric.
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 (8073, 5973, 5965, 5993, 5981, 5989, 7825, 5961, 5985, 7789, 7864, 7788, 8128, 7820, 7759, 7747, 7755, 7767, 8150, 8146, 8154, 8124, 7790, 6048, 7835, 7791, 8120, 12542, 12634, 12642, 12630, 12626, 12638, 12522, 12534, 12526, 12530, 8506, 12618, 12646, 12622, 12650, 8532, 12518, 8522, 8514, 8502, 12872, 8510, 8596, 13298, 13306, 8592, 13302, 12550, 12546, 12658, 12662, 12614)) ORDER BY FIELD(e.entity_id,8073,5973,5965,5993,5981,5989,7825,5961,5985,7789,7864,7788,8128,7820,7759,7747,7755,7767,8150,8146,8154,8124,7790,6048,7835,7791,8120,12542,12634,12642,12630,12626,12638,12522,12534,12526,12530,8506,12618,12646,12622,12650,8532,12518,8522,8514,8502,12872,8510,8596,13298,13306,8592,13302,12550,12546,12658,12662,12614)
AlAjlan Men's Dark red shemagh 4 black stamp (Gold)As low as 48.88SAR
AlAjlan Men's Dark red shemagh black stamp (Gold)As low as 48.88SAR
