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

Home Appliances -> Mobile

Mobile

Panasonic TH-22C400DX 22 in

₹14500₹ 13500

Mobile

SONY BRAVIA 40

₹ 26428

Mobile

Samsung 40J5000 40 inches Full

₹47800₹ 25990

Mobile

Micromax 81 cm 32T7260HD HD Re

₹0₹ 13450