Aşağıdaki SQL kodunu çalıştırmanız yeterli

DELETE bad_rows . * FROM ktz3_posts AS bad_rows INNER JOIN ( SELECT post_title, MIN( id ) AS min_id FROM ktz3_posts GROUP BY post_title HAVING COUNT( * ) >1 ) AS good_rows ON good_rows.post_title = bad_rows.post_titleAND good_rows.min_id <> bad_rows.id