# Is there any way to extract a URL to a post from Discourse backend DB?
**URL:** https://meta.discourse.org/t/is-there-any-way-to-extract-a-url-to-a-post-from-discourse-backend-db/129426
**Category:** Development
**Created:** [24 בספטמבר, 2019, 10:58pm UTC](https://meta.discourse.org/t/is-there-any-way-to-extract-a-url-to-a-post-from-discourse-backend-db/129426 "2019-09-24T22:58:33Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@olegbc1](https://meta.discourse.org/u/olegbc1)
#### Post date: [24 בספטמבר, 2019, 10:58pm UTC](https://meta.discourse.org/t/is-there-any-way-to-extract-a-url-to-a-post-from-discourse-backend-db/129426/1 "2019-09-24T22:58:34Z")
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,
Oleg.
---
### Author:  [@pfaffman](https://meta.discourse.org/u/pfaffman)
#### Post date: [25 בספטמבר, 2019, 1:31am UTC](https://meta.discourse.org/t/is-there-any-way-to-extract-a-url-to-a-post-from-discourse-backend-db/129426/2 "2019-09-25T01:31:46Z")
You might have a look at [(Superseded) What cool data explorer queries have you come up with?](https://meta.discourse.org/t/what-cool-data-explorer-queries-have-you-come-up-with/43516).
The url is /t/post.topic\_id/post.post\_number if I remember the field names exactly right.
---
### Author:  [@Falco](https://meta.discourse.org/u/Falco)
#### Post date: [25 בספטמבר, 2019, 3:35am UTC](https://meta.discourse.org/t/is-there-any-way-to-extract-a-url-to-a-post-from-discourse-backend-db/129426/3 "2019-09-25T03:35:13Z")
The slug is also stored in the topics table.