USE wikidatawiki_p;

​

SELECT

    CONCAT('[[Wikidata:', p1.page_title, ']]') AS covi_report,

    CONCAT('[[', pl_title, ']]') AS linked_deleted_item

FROM

    pagelinks JOIN page p1 ON pl_from=p1.page_id LEFT JOIN page p2 ON pl_title=p2.page_title AND pl_namespace=p2.page_namespace

WHERE

    p1.page_title LIKE 'Database_reports/Constraint_violations/P%'

    AND pl_namespace=0

    AND p2.page_id IS NULL

    AND pl_title NOT IN (

        SELECT

            log_title

        FROM

            logging

        WHERE

            log_type='delete'

            AND log_action='delete'

            AND log_timestamp>=20190715000000

            AND log_namespace=0

    )

    AND pl_title LIKE 'Q%';