Untitled query #10437

SQL

/*
USE wikidatawiki_p;
SELECT term_full_entity_id, term_text, LENGTH(term_text) AS length
FROM wb_terms
WHERE term_language = 'cs'
AND term_type = 'description'
AND LENGTH(term_text) < 15
ORDER BY LENGTH(term_text)
LIMIT 100;
*/
USE wikidatawiki_p;
SELECT
	pl_from,
    p1.page_title,
    rev_timestamp,
    pl_title,
    log_timestamp
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 AND log_type = 'delete' AND log_action = 'delete'
    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%';
SQL

Checking query status...
