XenForo taslaktaki konu ve mesajları SQL ile silme

SELECT p.post_id, p.thread_id, p.message
FROM xf_post p
LEFT JOIN xf_thread t ON p.thread_id = t.thread_id
WHERE t.thread_id IS NULL;

DELETE p FROM xf_post p
LEFT JOIN xf_thread t ON p.thread_id = t.thread_id
WHERE t.thread_id IS NULL;

OPTIMIZE TABLE xf_thread, xf_post;  -- Disk alanını geri kazanmak için

OPTIMIZE TABLE
xf_admin_log,
xf_attachment,
xf_attachment_data,
xf_conversation_master,
xf_conversation_message,
xf_forum,
xf_node,
xf_permission_entry,
xf_post,
xf_thread,
xf_user,
xf_user_profile;

OPTIMIZE TABLE
xf_post,
xf_thread,
xf_thread_read,
xf_thread_user_post,
xf_conversation_message,
xf_session,
xf_search_index,
xf_admin_log,
xf_moderator_log;