Problem with soft delete query

[vbplusme]

Its a test "thread" ... I looked at this thing for hours thinking that it was a "post", oops! Just check the posts that I deleted with the query and they are indeed gone.

Edit: In case this is not clear, if you are trying to get rid of "soft deletes" via a CRON hack, you have to do two queries, one to get rid of the "posts" and another if you want to delete "threads". For example, a member creates a thread, adds a post then figures out its a mistake and deletes it. If you use the query above it only removes the "post". You have to run a second query to remove the soft delete on the thread:

DELETE FROM " . TABLE_PREFIX . "thread WHERE visible = '2'

HTH