SQL Query for Space page structure

[eric brown]

How do I query the confluence database to pull back all the pages for a particular space?

[FelipeA]

Hi Eric,

Just replace the <spacename> below with the name of the particular space you want:

SELECT contentid,title 
FROM content 
WHERE prevver IS NULL 
AND content_status='current' 
AND spaceid=(SELECT spaceid FROM spaces WHERE spacename='<spacename>');

Best regards,

Felipe Alencastro