Find most recent changes on Wikidata to stuff in Bengali

Fork of Find most recent changes on Wikidata to stuff in Bengali by Mahir256

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

SQL

USE wikidatawiki_p;
SELECT rc_id, rc_timestamp, actor_name, rc_title, comment_text
FROM recentchanges
LEFT JOIN comment ON comment.comment_id = recentchanges.rc_comment_id
LEFT JOIN actor on actor.actor_id = recentchanges.rc_actor
WHERE (
   comment_text REGEXP 'wbsetdescription-(add|set|remove)...(bn)'
OR comment_text REGEXP 'wbsetlabel-(add|set|remove)...(bn)'
OR comment_text REGEXP 'wbsetaliases-(add|set|remove|add-remove|update)...(bn)'
OR comment_text REGEXP 'wbsetsitelink-(add|set|remove|add-both|set-badges|set-both)...(bn)'
OR comment_text REGEXP 'clientsitelink-(update|remove)...(bn)'
OR comment_text REGEXP 'wbsetlabeldescriptionaliases...(bn)'
)
ORDER BY rc_id desc LIMIT 500;

SQL

Checking query status...