Untitled query #38074

SQL

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

Checking query status...
