Go to crxde and select use the query tools to query like this, select SQL 2
SELECT * FROM [nt:base] AS s WHERE ISDESCENDANTNODE([/content/sites/<page name>]) and s.[fileReference] is not null
copy the list in notepad ++ and remove the /content... node path
not sure about the exact requirment. just a tweak