Orphans with incoming links

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

Orphans with incoming links

SQL

SELECT p.page_title AS page, COUNT(link.pl_from) AS count
        FROM page p
        INNER JOIN ${database}.categorylinks c ON p.page_id = c.cl_from
          AND c.cl_to = 'All_orphaned_articles'
        INNER JOIN pagelinks link ON p.page_title = link.pl_title
          AND p.page_namespace = link.pl_namespace
        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

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...