wikidata: deleted items that are still linked

SQL

USE wikidatawiki_p;

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_page NOT IN (SELECT page_id 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...
