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

Women Dresses -> Skirts

Skirts

The Fashion World Orange and D

₹0₹ 1340

Skirts

Faballey Black Flared Skirt

₹0₹ 1750

Skirts

Orange Flared Skirt

₹0₹ 1590

Skirts

Designer Digital Printed Multi

₹0₹ 1050

Skirts

Multicoloured Printed Flared S

₹1900₹ 1850