SQL
x
USE wikidatawiki_p;
SELECT rc_timestamp, CONCAT("Special:Diff/",rc_this_oldid), rc_title, rc_user_text, rc_comment
FROM recentchanges
WHERE rc_user_text IN (
'Titodutta','Bodhisattwa','Pinakpani'
)
# THE FOLLOWING LINES WILL BE UNCOMMENTED AND ALTERED
# ONCE THE LABEL-A-THON STARTS
AND rc_timestamp >= 20181106000000
#adjust this list of items as appropriate
AND rc_comment REGEXP
'wbset(label)-(add|set)...(an|bn|ur) '
ORDER BY rc_this_oldid desc;
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.