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

MEN FASHION -> Neckties & Cravats