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

Women Dresses -> Jeans

Jeans

LEVIS Super Skinny Fit Jeans

₹0₹ 2394

Jeans

LEVIS Skinny Fit Jeans

₹0₹ 1999