select distinct (bname),brimg,bid from brands,catedetail where catedetail.ecate=brands.ecate and brimg<>'-' and catedid=3 order by rand() limit 10

Home Appliances -> Fridge

Fridge

Asus ET2040IUK-BB058M AIO Des

₹0₹ 26500

Fridge

Lenovo C260 (57-325928) All in

₹0₹ 23500