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_title = SUBSTRING_INDEX(doc.page_title, "/", 1);
/*
JOIN page ON page_id = pp_page
JOIN templatelinks ON tl_title = page_title AND tl_namespace = page_namespace
JOIN revision ON rev_page = tl_from
JOIN change_tag ON ct_rev_id = rev_id

AND pp_propname = "templatedata" AND ct_tag = "visualeditor" AND rev2.rev_timestamp > 20160301000000
LIMIT 10;*/

SQL

Checking query status...