This query is marked as a draft This query has been published by Certes.

SQL

AخA
 
SELECT log_timestamp,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 ON comment_id=log_comment_id
WHERE log_id>=80000000 AND log_id<80100000 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")
LIMIT 10;
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.

Checking query status...