How do I find the Page name if I have the PageID in the database

Question

I am doing some SQL queries in the Confluence database.  I have the Pageid and my report wants to use the actual Page name.  What database table do I need to look at?

Greg Della-Croce · Accepted Answer

Thanks to Aron Gombas, Midori CEO, Who has some great plugins for Confluence.

He pointed me to the Content table, using Content.contentid  = PageID (and qualifying that with Content.contenttype = "Page" so I got the pages and not the attachments).  Now I have the page name as Content.Title.  And using Content.Spaceid = Spaces.Spaceid I get the space name Spaces.Spacename.

Again thanks Aron for the point in the right direction.