Edit: Could a mod please fix my typo in the title?
I have just finished importing close to 4 million posts from IPS. It all went quite well except I have close to 5000 previously soft deleted spam threads are now visible.
As you can see in the screenshot below, they have all been given a recent timestamp even though some would be over 6 years old. They're also listed as being posted by Guest, the post content isn't visible to users, just the thread title.
Is there an easy way to nuke these based on them having a time stamp that's less than 10 hours old?