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

Home Appliances -> AC

AC

Lenovo Ideapad 15.6-inch Lapto

₹0₹ 24000