WantedPages - Quarry

SQL

SELECT
    pagelinks.pl_namespace AS namespace,
    pagelinks.pl_title AS title,
    COUNT(*) AS value
FROM
    pagelinks
LEFT JOIN
    page AS pg1
ON
    pg1.page_namespace = pagelinks.pl_namespace
    AND pg1.page_title = pagelinks.pl_title
LEFT JOIN
    page AS pg2
ON
    pg2.page_id = pagelinks.pl_from
WHERE
    pg1.page_namespace IS NULL
    AND pagelinks.pl_namespace NOT IN (2, 3) -- Exclude User and User Talk namespaces
    AND pg2.page_namespace != 8 -- Exclude MediaWiki namespace
GROUP BY
    pagelinks.pl_namespace, pagelinks.pl_title
HAVING
    COUNT(*) > 0
    AND COUNT(*) > SUM(pg2.page_is_redirect)
ORDER BY
    value DESC;
SQL

Checking query status...
