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 ') and visible = 'Yes' and price <> 0' at line 1
| select * from goods where category in () and visible = 'Yes' and price <> 0 |