For some reason, I seem to have products still showing up on my site that I thought I deleted. They are showing up as upcoming products, I even had someone bought a product from my site that I actually deleted.

I used this bit of code to look for the products in question:

SELECT * FROM zen_categories AS c LEFT JOIN zen_categories AS cc ON c.parent_id = cc.categories_id LEFT JOIN zen_categories_description AS cd on c.categories_id = cd.categories_id WHERE cc.categories_id IS NULL AND c.parent_id != 0
but I didn't find any phantom products in the database, although they are still showing up somehow. How can I fix this?