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

Home Appliances -> Curved TV

Curved TV

LG LSA5PW3A L-Pearl Split AC 1

₹0₹ 28580

Curved TV

Windows AC 2 Tons

₹0₹ 30000

Curved TV

Split AC 1 Ton

₹0₹ 24000