Anyone know of a SQL script I can use?

[SBoards]

Hi folks,

I am running vbulletin 4.0.3. A few months ago, my upgrade from 4.0.1 produced bad results. I then restored my database from backup, but my backup apparently wasn't complete. Unfortunately, I had no other good backups.

I was able to salvage my users, which was a relief. But, losing thousands of posts definitely caused me to learn my lesson.

Anyhoo... I now have a crapload of threads which think they have posts in them, but they don't. Does anyone know of a SQL script I can use to delete all the postless threads? I can't mass-prune threads with zero posts, because as I said... the threads still think they have posts in them.

Any help would be appreciated. Thanks!