根据另一个表的id，查询从过期的表中删除行。

I have a table that is getting bigger and bigger. It stores path of images of the products that are posted in my website, but when we delete the products, the system does not delete the images lines from the image table. So I built a list of IDs of products that are currently published in my site, and I would like to build a mysql query that deletes lines where there is no corresponding product published in my site any more, so I tried to use this, but this deletes every line of the table and not just the ones I need to delete, can somebody tell me what I am doing wrong?I have a table that is getting bigger and bigge