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

MEN FASHION -> Belts

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