Which table holds the post URL?

[rmoff]

Thanks, that’s great.

FWIW with the hyphen it didn’t work, so instead of this:

'/t-/' || topics.id || '/' || posts.post_number

I used

'/t/' || topics.id || '/' || posts.post_number

All sorted