SQL Query for Space page structure

eric brown_zyc9w5

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