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

WOMEN FASHION -> Foot Ware

Foot Ware

Hansx Beige Women Slippers

₹0₹ 515

Foot Ware

Bata Women Fashion Sandals

₹0₹ 499

Foot Ware

Bata Power Women s Sports Sho

₹0₹ 799

Foot Ware

Bata Women Fashion Sandals

₹0₹ 599