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

Men Dresses -> Jeans

Jeans

Stone Washed Skinny Fit Jeans

₹0₹ 2399

Jeans

Slim Fit Whiskered Jeans

₹0₹ 1570