what table maps pageids with space in confluence?

[chintu Parameshwar]

hi,

I want to query pageids of all the pages in a space. Could you please let me know which table stores this info?

Thanks in advance!

Chintu

[Betsy Walker {Appfire} · Accepted solution]

You would need to join the content table on the spaces table, based on the spaceid in both columns, something like this:

SELECT title, contentid 
FROM content 
WHERE spaceid = 
    (SELECT spaceid FROM spaces WHERE spacekey = 'yourspacename') 
ORDER BY 1;

or

SELECT C.title, C.contentid
FROM content C
INNER JOIN spaces S ON C.spaceid = S.spaceid
ORDER BY title;