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

16.000 OMR
11.200 OMR
16.000 OMR
11.200 OMR
Top