SQL
AخA
SET STATEMENT max_statement_time = 60 FOR
SELECT log_timestamp,Po.page_title,log_title,comment_text FROM logging
JOIN page Po ON Po.page_id=log_page AND Po.page_namespace=0 AND Po.page_is_redirect=0
JOIN page Pn ON Pn.page_title=log_title AND Pn.page_namespace=0 AND Pn.page_is_redirect=0 AND Pn.page_id != log_page
JOIN comment_logging ON comment_id=log_comment_id
WHERE log_timestamp>="201701" AND log_timestamp<"201702" AND log_type='move' AND log_action='move' AND log_namespace=0
AND comment_text NOT REGEXP "[Dd]raft"
AND NOT EXISTS (SELECT 1 FROM categorylinks WHERE cl_from=log_page AND cl_to="All_disambiguation_pages")
AND NOT EXISTS (SELECT 1 FROM categorylinks WHERE cl_from=Pn.page_id AND cl_to="All_disambiguation_pages")
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.