Untitled query #21769

SQL

USE wikidatawiki_p;
/*
SELECT * FROM (SELECT * FROM pagelinks WHERE pl_title = 'Q3305213' AND pl_namespace = 0 AND pl_from_namespace = 0) AS pl
JOIN page AS paintings ON paintings.page_id = pl_from
JOIN redirect ON rd_title = paintings.page_title AND rd_namespace = paintings.page_namespace
JOIN page AS redirs ON redirs.page_id = rd_from
JOIN revision ON redirs.page_latest = rev_id
WHERE rev_user_text = 'MatSuBot'
LIMIT 1;
*/
SELECT * FROM (SELECT * FROM revision WHERE rev_user_text = 'MatSuBot' AND rev_timestamp > 20170000000000
               AND rev_timestamp < 20170400000000) AS revs
JOIN (SELECT * FROM page WHERE page_namespace = 0 AND page_is_redirect = 1) AS redirs ON redirs.page_latest = rev_id
JOIN redirect ON rd_from = redirs.page_id
JOIN page AS paintings ON paintings.page_title = rd_title AND paintings.page_namespace = rd_namespace
JOIN pagelinks ON pl_from = paintings.page_id
WHERE pl_title = 'Q3305213' AND pl_namespace = 0;
SQL

Checking query status...
