USE wikidatawiki_p;

SELECT rc_id, rc_timestamp, rc_user_text, rc_title, comment_text

FROM recentchanges

LEFT JOIN comment ON comment.comment_id = recentchanges.rc_comment_id

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)...(bn)'

OR comment_text REGEXP 'wbsetsitelink-(add|set|remove)...(bn)'

OR comment_text REGEXP 'clientsitelink-(update|remove)..(bn)'

OR comment_text REGEXP 'wbsetlabeldescriptionaliases...(bn)'

)

ORDER BY rc_id desc LIMIT 500;