select distinct b.id,b.brandName from products p LEFT JOIN brand b on p.brandId=b.id where naviId in()
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 2