Untitled query #52222

SQL

USE wikidatawiki_p;

select now();

SELECT rev_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
LEFT JOIN revision on revision.rev_id = recentchanges.rc_this_oldid
WHERE rc_actor_name IN ( 'Marajozkee', 'Ssgapu22', 'Gaurav_Jhammat', 'Benipal_hardarshan',
                 'অজয়_দাস', 'Dugal_harpreet', 'Tanay_barisha', 'Meenakshi_nandhini', 'Yakshitha', 'कन्हाई प्रसाद चौरसिया', 'Titodutta'
                    )
  


AND rc_timestamp >= 20210205183000 
AND rc_timestamp <= 20210206183000


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_this_oldid desc;
SQL

Checking query status...
