Untitled query #10437

SQL

USE wikidatawiki_p;
SELECT
	pl_from,
    p1.page_title,
    rev_timestamp,
    pl_title,
    log_timestamp,
    comment_text,
    rev_timestamp - log_timestamp AS diff
FROM
	pagelinks
    JOIN page AS p1 ON pl_from = p1.page_id
    JOIN revision ON rev_id = p1.page_latest
    JOIN logging ON log_title = pl_title AND log_namespace = pl_namespace
    LEFT JOIN comment_logging ON comment_id = log_comment_id
    LEFT JOIN page AS p2 ON pl_title = p2.page_title AND pl_namespace = p2.page_namespace
WHERE
	pl_from_namespace = 4
	AND p1.page_namespace = pl_from_namespace
	AND p1.page_title LIKE 'Database\_reports/Constraint\_violations/P%'
	AND pl_namespace = 0
	AND p2.page_id IS NULL
	AND pl_title LIKE 'Q%'
	AND log_type = 'delete'
	AND log_action = 'delete'
	AND log_timestamp < rev_timestamp;
SQL

Checking query status...
