SQL
x
USE commonswiki_p;
SELECT REPLACE(page_title, '_', ' ') , rev_user_text, DATE_FORMAT(rev_timestamp, '%H:%i:%s %b %d %Y')
FROM page
JOIN categorylinks ON page_id=cl_from
JOIN revision ON page_latest = rev_id
WHERE page_is_redirect=0 AND cl_to='Media_requiring_renaming' and page_namespace = '6';
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.