Duplicate Topic Title search in phpBB3

[Brave Ye]

phpmyadmin select database phpBB3 query paste the following then exec

代碼: 選擇全部

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