Rjwilmsi edits in the last month to structure {{cite journal}}

Fork of InternetArchiveBot edits in the last month to add links to archive.org books by Nemo bis

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

Query which tries to capture edit summaries like:
*"Journal cites:,"
*"templated 3 journal cites",
*"Added 14 dois to journal cites"
*"Journal cites:, templated 3 journal cites"

SQL

USE enwiki_p;
SELECT rev_id
FROM revision_compat
WHERE rev_actor = 4246
AND rev_id > 95000000
AND rev_timestamp > DATE(NOW() - INTERVAL 1 MONTH)
AND rev_comment LIKE "%ournal%";

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...