USE wikidatawiki_p;

SELECT *

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 'wbsetalias-(add|set|remove)...(bn)'

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

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

)

ORDER BY rc_id desc LIMIT 500;