SQL
AخA
USE frwiki_p;
SELECT rev_user_text AS user, CONCAT(page_namespace, ':', page_title) as title, rev_comment as comment
FROM revision_userindex
JOIN page ON page_id = rev_page
WHERE rev_user_text LIKE '% (WMF)'
AND rev_timestamp > DATE_SUB(NOW(), INTERVAL 1 YEAR)
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.