select distinct (bname),brimg,bid from brands,catedetail where catedetail.ecate=brands.ecate and brimg<>'-' and catedid=62 order by rand() limit 10
Wallets
Reza Pellis Brown Casual Short
₹0₹ 850
Wallets
Reza Pellis Black Formal Short
₹0₹ 950
Wallets
Puma Blue Formal Wallet For Me
₹0₹ 748