Duplicate Topic Title search in phpBB3

[Brave Ye]

phpmyadmin select database phpBB3 query paste the following then exec

Code: Select all

SELECT  topic_title, topic_time, forum_id, topic_first_post_id, topic_first_poster_name, topic_id, topic_poster, COUNT( * ) TotalCount
FROM phpbb_topics
GROUP BY  topic_title
HAVING COUNT( * ) >1