A Database Error Occurred

Error Number: 1052

Column 'brand_id' in where clause is ambiguous

SELECT `n`.*, `title`, `friendly_url`, `nb`.`picture` `brand_p` FROM `product` `n`, `product_desc` `nd`, `product_brand` `nb` WHERE `n`.`product_id` = `nd`.`product_id` AND `n`.`brand_id` = `nb`.`brand_id` AND `n`.`display` = 1 AND `lang` = 'vi' AND FIND_IN_SET('298', cat_list) <>0 AND `brand_id` = 80 AND `price` < 50000000 ORDER BY `menu_order` DESC, `n`.`date_post` DESC LIMIT 20

Filename: modules/product/models/Product_model.php

Line Number: 106