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;