Untitled query #31066

SQL

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 AND rc_timestamp <= 20190819182959
#adjust this list of items as appropriate

AND rc_comment REGEXP
   'wbset(alias|description|label)-(add|set)...(anp|as|awa|bcc|bgn|bho|bn|bpy|brh|dty|dv|dz|gom|gu|hi|khw|kn|ks|lus|mai|ml|mr|ne|new|or|pa|pi|pnb|ps|rwr|sa|sat|sd|si|skr|ta|tcy|te|ur) '
ORDER BY rc_this_oldid desc;
SQL

Checking query status...
