UserID
At & below OMR 99.9
Bundle Offers
Unilever
Deals
Mobile Phones & Tablets
Cameras & Photography
Electronics
Computers & Softwares
Watches
Perfumes
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='mobile-phones' Or Replace(LTrim(RTrim(Subcategory1_Name)), '& ', '')='mobile phones'

Mobile Phones, Mobile Phones & Tablets

Mobile Phones, Mobile Phones & Tablets

187.000 OMR
170.170 OMR
98.000 OMR
94.080 OMR
184.000 OMR
176.640 OMR
Top