Untitled query #55128

SQL

SELECT orphan.page_title, orphan.page_id, cl.cl_from, pl.pl_from, pl.pl_target_id, lt.lt_id, lt.lt_namespace , lt.lt_title 
        FROM page orphan
        INNER JOIN categorylinks cl ON orphan.page_id = cl.cl_from
         	AND cl.cl_to = 'All_Orphaned_articles'
        INNER JOIN pagelinks pl ON orphan.page_id = pl.pl_from
        INNER JOIN linktarget lt ON pl.pl_target_id = lt.lt_id
        	AND orphan.page_namespace = lt.lt_namespace 
            AND p2.page_title = lt.lt_title 
        INNER JOIN page p2 ON p2.page_id = pl.pl_from
        WHERE
          pl.pl_from_namespace = 0
          AND p2.page_is_redirect = 0
SQL

Checking query status...
