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

Men Dresses -> Casual Shirts

Casual Shirts

Roadster Olive Green Washed Ca

₹0₹ 1250

Casual Shirts

Blue Shirts

₹0₹ 450

Casual Shirts

VSI Brands Black Slim Fit Shi

₹0₹ 599