WantedPages - Quarry

SQL

SELECT pl_from_namespace AS namespace, pg1.page_title AS title, COUNT(*) AS value
FROM pagelinks
LEFT JOIN page AS pg1 ON pg1.page_id = pl_target_id
LEFT JOIN page AS pg2 ON pg2.page_id = pl_from
WHERE pg1.page_namespace IS NOT NULL
AND pl_from_namespace != '2'  -- Exclude User and User Talk namespaces
AND pg2.page_namespace != '8'  -- Exclude MediaWiki namespace
GROUP BY pl_from_namespace, pg1.page_title
HAVING COUNT(*) > 10  -- Example threshold, could be configured
AND COUNT(*) > SUM(pg2.page_is_redirect)
SQL

Checking query status...
