Orphaned articles with more than two incoming links

Fork of Orphaned articles with more than two incoming links by GoingBatty

This query is marked as a draft This query has been published by DannyS712.

SQL

        SELECT p.page_title AS page, COUNT(link.pl_from) AS count
        FROM page p
        INNER JOIN categorylinks c ON p.page_id = c.cl_from
          AND c.cl_to = 'All_orphaned_articles'
        INNER JOIN linktarget lt ON p.page_title = lt.lt_title
          AND p.page_namespace = lt.lt_namespace
        INNER JOIN pagelinks link ON pl.pl_target_id = lt.lt_id
        INNER JOIN page p2 ON p2.page_id = link.pl_from
        WHERE
          link.pl_from_namespace = 0
          AND p2.page_is_redirect = 0
        GROUP BY
          p.page_title
        HAVING
          COUNT(link.pl_from) > 2
        ORDER BY
          COUNT(link.pl_from) DESC, p.page_title ASC

SQL

Checking query status...