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

Accesseries -> Computer - Laptop

Computer - Laptop

LOISTER Game of Throne Winter

₹0₹ 195

Computer - Laptop

Bravado Bob Marley When Music

₹0₹ 380

Computer - Laptop

LOISTER Game of Throne Winter

₹0₹ 425

Computer - Laptop

Seven Rays Vincent Van Goghs

₹0₹ 299

Computer - Laptop

Inktree Creative Designer Lap

₹0₹ 399

Computer - Laptop

laptop skin cover matt brush

₹0₹ 625