Wikidata items to be possibly deleted

SQL

USE cswiki_p;
SELECT *
FROM (SELECT rev_page AS id FROM revision WHERE rev_user_text = "DvorapaBot" AND rev_timestamp BETWEEN 20160620140000 AND 20160620160000) AS rev1
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
#WHERE ct_tag = "visualeditor" AND rev_timestamp > 20160301000000
LIMIT 10;

SQL

Checking query status...