bnwiki orphaned non-archive usertalk subpages

Fork of enwiki orphaned non-archive usertalk subpages by Xaosflux
This query is marked as a draft This query has been published by MdaNoman.
SQL

SELECT
                                                page_namespace,
                                                page_id,
                                                page_title,
                                                page_is_redirect,
                                                page_len
                                FROM
                                                page talkpage
                                WHERE
                                				(
                                                  (talkpage.page_title NOT LIKE '%Archive%')
                                				  AND
                                                  (talkpage.page_title NOT LIKE '%archive%')
                                                  AND
                                                  (talkpage.page_title LIKE '%/%')
                                                )
                                AND
                                                talkpage.page_namespace IN (3)
                                AND
                                                NOT EXISTS (
                                                                SELECT
                                                                                1
                                                                FROM
                                                                                page mainpage
                                                                WHERE
                                                                                mainpage.page_namespace=talkpage.page_namespace-1
                                                                AND
                                                                                mainpage.page_title=talkpage.page_title
                                                                )
                                AND
                                                NOT EXISTS (
                                                                SELECT
                                                                                1
                                                                FROM
                                                                                templatelinks
                                                                WHERE
                                                                                talkpage.page_id=tl_from
                                                                AND
                                                                                tl_title='G8-exempt'
                                                                )
                                LIMIT 200
SQL

Checking query status...
