Wikidata items to be possibly deleted

SQL

USE cswiki_p;
SELECT pages.page_title, rev_id, rev_user_text, rev_timestamp
FROM (SELECT rev_page AS id FROM revision WHERE rev_user_text = "DvorapaBot" AND rev_timestamp BETWEEN 20160620145300 AND 20160620145700) AS edits
JOIN page AS doc ON doc.page_id = id
JOIN page AS temp ON temp.page_namespace = doc.page_namespace AND temp.page_title = SUBSTRING_INDEX(doc.page_title, "/", 1)
JOIN templatelinks ON tl_title = temp.page_title AND tl_namespace = temp.page_namespace
JOIN revision ON rev_page = tl_from
JOIN change_tag ON ct_rev_id = rev_id
JOIN page AS pages ON pages.page_id = tl_from
WHERE ct_tag = "visualeditor" AND rev_timestamp > 20160301000000
ORDER BY rev_timestamp DESC;
SQL

Checking query status...
