wikidata: deleted items that are still linked

SQL

SELECT DISTINCT
    logging.log_title,
    COUNT(pagelinks.pl_from) AS backlinks,
    actor_logging.actor_name,
    logging.log_timestamp
FROM
    logging JOIN pagelinks ON
        logging.log_title=pagelinks.pl_title
        AND logging.log_namespace=pagelinks.pl_namespace
    JOIN actor_logging ON
        logging.log_actor=actor_logging.actor_id
WHERE
    logging.log_namespace=0
    AND pagelinks.pl_from_namespace=0
    AND logging.log_type='delete'
    AND logging.log_action='delete'
    AND logging.log_title NOT IN (
        SELECT
            page_title
        FROM
            page
        WHERE
            page_namespace=0
    )
GROUP BY
    logging.log_title,
    actor_logging.actor_name,
    logging.log_timestamp
ORDER BY
    logging.log_timestamp ASC;
SQL

Checking query status...
