A Database Error Occurred

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')) as tp WHERE p.id = tp.id order by p.ppcode' at line 2

SELECT p.* FROM products AS p,(select id from products where id in()) as tp WHERE p.id = tp.id order by p.ppcode