A Database Error Occurred

Error Number: 1052

Column 'brandId' in where clause is ambiguous

SELECT *, `ns_goods`.`name` as `name`, `ns_brands`.`name` as `brandName`, `ns_goods`.`url` as `url`, `ns_brands`.`url` as `brandUrl`, `ns_brands`.`visible` as `brandVisible` FROM `ns_goods` LEFT JOIN `ns_brands` ON `ns_goods`.`brandId` = `ns_brands`.`brandId` WHERE `brandId` = '7' AND `ns_goods`.`visible` = 1

Filename: models/Mdl_item.php

Line Number: 1478