Here’s what I came up with:
SELECT
'[' || t.title || '](https://notes.maiki.interi.org/t/' || t.id || ')' AS topic_link,
t.updated_at
FROM
topics t
JOIN
categories c ON t.category_id = c.id
WHERE
t.visible = TRUE
AND t.archetype != 'private_message'
AND t.deleted_at IS NULL
AND c.read_restricted = FALSE
ORDER BY
t.updated_at ASC
LIMIT 10
That grabs the oldest topics that public visitors may see, which is important since it is posted publicly.
Using the script for “Schedule a post with Data Explorer results” I’m able to publish the links I query for:
And this topic is currently at Notes review.
It will auto-delete responses there after a week, and it occurs to me that I can publish a lot of different messages there, which may be helpful. 