Duplicate post
 

How can i delete the duplicate post ?

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
Showing rows 0 - 29 (291,867 total, Query took 282.2048 sec)


Attachment 43258


When i delete ....

Code:
Error




Attachment 43259


http://www.vbulletin.com/forum/showthread.php?343419