Finding pages with phantom parent; pages not listed in space

[Wojciech]

What I have:

I have pages A,B,C... (and more) that are children of page X.
Page X was deleted with children, whole-space-purge failed, page X was restored, deleted.
Pages exist and are visible to all users, despite having previously view restrictions from parent.
They can be found with search, but are not listed in the left panel. When opened, "sidebar pages" are selected.

Children link to parent X. When using link i see that X is outdated. When clicking "show current version", information "This page is deleted" is shown.

When X is restored, children link to outdated X with id 739. When clicking show current version, restored page X with id 738 is shown.

Page information of X shown no children. Adding new child to X shows list of all children which sums to 1 child.

Confluence version: 6.13.8

What I need to do:

I need to delete all children of X.

Related:

• "Purge all" fails - https://jira.atlassian.com/browse/CONFSERVER-57823
  
  • Purge X fails with
    • org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not execute statement; sql=n/a; SQL []; ORA-02292: integrity constraint (CONFDBM.FKSQB1AF9H7FVQTGY73O8JDCUUE) violated - child record found
• https://community.atlassian.com/t5/Confluence-questions/page-not-showing-in-page-list-but-can-find-via-search/qaq-p/611819
  • Reorder pages doesn't show A,B,C...
  • Manual page-by-page move is out of question, as I don't know which pages I'm supposed to process.

[Wojciech · Accepted solution]

After seeing this suggestion I was able to prepare proper search query.
I had to add filter with any page as an ancestor, search and then change pageId inside url to id of page X.

Now I can identify all the children