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₹ 425

Computer - Laptop

Inktree Creative Designer Lap

₹0₹ 399

Computer - Laptop

laptop skin cover matt brush

₹0₹ 625

Computer - Laptop

Bravado Bob Marley When Music

₹0₹ 380

Computer - Laptop

Seven Rays Vincent Van Goghs

₹0₹ 299

Computer - Laptop

LOISTER Game of Throne Winter

₹0₹ 195

PHP Warning: PHP Startup: Unable to load dynamic library 'C:\PHP5\ext\php_mssql.dll' - The specified module could not be found. in Unknown on line 0