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

Home Appliances -> Music Player

Music Player

Semi Automatic

₹0₹ 8000

Music Player

Whirlpool 6.5 kg Fully Automat

₹0₹ 15990

Music Player

IFB 6.5 Kg Senorita Aqua SX Fu

₹0₹ 9500

Music Player

LG P7853R3SA Semi-automatic To

₹0₹ 11179

Music Player

Fully Automatic

₹0₹ 12000