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

Furniture -> Wardrobes

Wardrobes

Eco 3 Door Wardrobe

₹24083₹ 13626

Wardrobes

Rick 3 Door Wardrobe Wenge

₹27480₹ 13990

Wardrobes

Spacewood Kosmo Optima 3 Door

₹21100₹ 12999

Wardrobes

Spacewood Optima 3 Door Wardr

₹20190₹ 9999