Orphan talk pages

SQL

select distinct replace(page_title,"_"," ") from revision_userindex join actor_revision on rev_actor=actor_id join page on page_id=rev_page
where page_namespace=14 and actor_name="Buaidh" and rev_parent_id=0
and exists (select 1 from archive where ar_namespace=14 and ar_title=page_title)
and exists (select 1 from logging_logindex join comment_logging on log_comment_id=comment_id
            where log_type="delete" and log_action="delete" and log_namespace=14 and log_title=page_title
            and comment_text like "%discussion%")
SQL

Checking query status...
