UserID
Muscat Festival
Deals
Buy2 Get1
Apparels
Mobile Phones & Tablets
Perfumes
Watches
Cameras & Photography
Electronics
Computers & Softwares
Select *, (Select Main_Category_Name From Main_Category Where Main_Category.Main_Category_ID=Sub_Category1.Main_Category_ID) As Main_Category_Name, (Select Main_Category_NameAr From Main_Category Where Main_Category.Main_Category_ID=Sub_Category1.Main_Category_ID) As Main_Category_NameAr From Sub_Category1 Where Subcategory1_ID='indian-dresses' Or Replace(LTrim(RTrim(Subcategory1_Name)), '& ', '')='indian dresses'

Indian Dresses, Apparels

Brand

Indian Dresses, Apparels

17.000 OMR
11.900 OMR
21.000 OMR
14.700 OMR
27.000 OMR
18.900 OMR
27.000 OMR
18.900 OMR
27.000 OMR
18.900 OMR
29.000 OMR
20.300 OMR
30.000 OMR
21.000 OMR
31.000 OMR
21.700 OMR
31.000 OMR
21.700 OMR
35.000 OMR
24.500 OMR
36.000 OMR
25.200 OMR
39.000 OMR
27.300 OMR
Top