Deleting Duplicate Posts
 

Hi,

I would like to delete duplicate posts in a specific forum on my site.

I found this thread in a search.

http://www.vbulletin.com/forum/showt...uplicate+posts

The code in there said to do this.

Code:
SELECT bad_rows. * FROM post AS bad_rows
INNER JOIN (
SELECT threadid, dateline, username, userid, MIN( postid ) AS min_postid FROM post
GROUP BY threadid, dateline, userid
HAVING count( * ) >1
) AS good_rows ON good_rows.threadid = bad_rows.threadid
AND good_rows.dateline = bad_rows.dateline
AND good_rows.userid = bad_rows.userid
AND good_rows.min_postid bad_rows.postid
Assuming I have backed the database up and switched off the forums, how would I direct this at say forumid 16 rather than the entire forum.

Many thanks.