How to find a Wiki and all linked pages in the database

I was struggling to find back deleted / unlinked pages for a wiki for one of our users and wanted to visualise a wiki and all associated pages in the database. Thank you Julian Mosen for pointing me in the right direction on the database design. I used the following SQL Query to list the data I wanted

select *

from WIKIS.MEDIA left join WIKIS.LIBRARY

on WIKIS.MEDIA.LIBRARY_ID = WIKIS.LIBRARY.ID

WHERE WIKIS.LIBRARY.EXTERNAL_INSTANCE_ID = 'Wf8480c3f63f3_4cc0_806b_76256d97ebba'