USE wikidatawiki_p;

​

SELECT

    pl_from,

    p1.page_title,

    pl_title,

    log_timestamp

FROM

    pagelinks JOIN page p1 ON pl_from=p1.page_id JOIN logging ON log_title=pl_title 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/%'

    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%';