Find changes on Wikidata for the label-a-thon (explicit lists)

(The outreach dashboard by itself does not allow one to limit the scope of items tracked in the 'Activity' tab. Plus the length of this label-a-thon is shorter than $wgRCMaxAge, so there's plenty of time to assess contributions.)

SQL

USE wikidatawiki_p;
SELECT rc_this_oldid, rc_title, rc_user_text, rc_comment 
FROM recentchanges
WHERE rc_user_text IN (
  'Jinoytommanjaly','KCVelaga','Sumanth699','SuswethaK','Obaid Raza',
  'Bodhisattwa','J ansari','Ranjithsiji','Atudu','MKar',
  'Pavan santhosh.s','Ananth subray','Sidheeq','Akasmita','Aliva Sahoo',
  'KartikMistry','Sumita Roy Dutta','Marajozkee','Kritzolina','Suyash.dwivedi',
  'Ajaybanbi','Ssgapu22','Raju Jangid','Goutam1962','Sumana roy',
  'Subas Chandra Rout','Sushma Sharma','Jithinrajtk','Satpal Dandiwal','Mujeebcpy'
)
# AND rc_timestamp >= 20180814183000
# adjust this list of items as appropriate
#AND rc_title IN (
#  'Q11738875'
#)
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_user_text asc;

SQL

Checking query status...