I need to build a report of posts made by a specific group of people so I pull a list of those from posts table, joined by users and topics. This gives me a nice view of the content for each post, its author, which topic it belongs to and which category it’s in. I’d like to also include a link to that specific post, but I can’t find which table are the URLs stored at. Tried searching the forum and didn’t find either.
Appreciate the help,