Duplicate Topic Title search in phpBB3
發表於 : 2026-04-01, 06:41
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