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

Women Dresses -> Nightwear

Nightwear

Masha (Maroon)

₹0₹ 799

Nightwear

Red Babydolls Nightwear

₹0₹ 1299

Nightwear

White Babydolls Nightwear

₹0₹ 1299

Nightwear

Fashigo (Purple)

₹0₹ 580

Nightwear

Being Fab Pink Solid Nightwear

₹0₹ 450