这是更新后的 Data Explorer 查询，它将返回一个更整洁的按类别排序的所有置顶帖子的列表，全局置顶主题将显示在顶部：
SELECT pinned_globally, TO_CHAR(pinned_until,'DD/MM/YYYY') as pinned_till, id as topic_id, user_id, category_id
FROM topics
WHERE deleted_at IS NULL
AND pinned_at IS NOT NULL
AND (pinned_until IS NULL OR pinned_until > CURRENT_TIMESTAMP)
ORDER BY pinned_globally desc, category_id