select distinct (bname),brimg,bid from brands,catedetail where catedetail.ecate=brands.ecate and brimg<>'-' and catedid=63 order by rand() limit 10
Belts
Park Avenue Brown/Black Leathe
₹0₹ 1580
Belts
Park Avenue Blue Leather Belt
₹0₹ 1699
Belts
Park Avenue Green/Brown Leathe
₹0₹ 1480
Belts
Park Avenue Black Men Belts
₹0₹ 1400
Belts
Louis Philippe Men Brown Genui
₹0₹ 1350
Belts
Hornbull Brown Casual Belt For
₹2899₹ 490