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

Home Appliances -> LED TV

LED TV

Single-door Refrigerator

₹0₹ 8158

LED TV

LG GL D201ASLN.ASLZEBN Direct

₹0₹ 16500