select distinct (bname),brimg,bid from brands,catedetail where catedetail.ecate=brands.ecate and brimg<>'-' and catedid=65 order by rand() limit 10
Watches
Titan Octane NE9308BM01J
₹0₹ 6950
Watches
Fastrack Aviator Sunglasses
₹0₹ 2095
Watches
Titan Purple
NE9743SM01
₹0₹ 6500
Watches
Fossil Chronograph Rose Gold D
₹0₹ 9495