WantedPages - Quarry

SQL

SELECT
    pl_from_namespace AS namespace,
    pl_target_id AS target_id,
    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_id IS NULL -- Target page does not exist
    AND pl_from_namespace NOT IN (2, 3) -- Exclude User and User Talk namespaces
    AND pg2.page_namespace != 8 -- Exclude MediaWiki namespace
-- GROUP BY
--     pl_from_namespace, pl_target_id
-- HAVING
--     COUNT(*) > 0 -- Replace with your threshold value
-- ORDER BY
--     value DESC
LIMIT 100;
SQL

Checking query status...
