Sandbox - Quarry

SQL

SELECT page_title, pt_create_perm, page_restrictions.pr_level FROM page draft
WHERE page_namespace = 118
AND (
  EXISTS (
    SELECT 1 
    FROM protected_titles title 
    WHERE pt_namespace = 0 
    AND pt_create_perm = 'sysop'
    AND pt_title = draft.page_title
  ) OR 
  EXISTS (
    SELECT 1
    FROM page main
    INNER JOIN page_restrictions ON (main.page_id = page_restrictions.pr_page)
    WHERE main.page_title = draft.page_title
    AND main.page_namespace = 0
    AND main.page_is_redirect = 1
    AND page_restrictions.pr_level = 'sysop' 
  ) 
)
SQL

Checking query status...
