Skip to content

Instantly share code, notes, and snippets.

@olsgreen

olsgreen/query.sql

Created October 15, 2021 07:08
Show Gist options
  • Save olsgreen/873304ce44f1d9c9633f61d666ae0f82 to your computer and use it in GitHub Desktop.
Save olsgreen/873304ce44f1d9c9633f61d666ae0f82 to your computer and use it in GitHub Desktop.
Download ZIP
Orphan Page Query
Raw
query.sql
SELECT Orphans.cID FROM Pages AS Orphans LEFT JOIN Pages AS Parents ON Orphans.cParentID = Parents.cID WHERE Parents.cID IS NULL AND Orphans.cID <> 1 AND Orphans.cIsSystemPage = 0 AND Orphans.cParentID <> 0;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment