User Edits to Files in Commons under Specific Categories

SQL

SELECT DISTINCT actor_name, actor_user, page_title, comment_text, r1.rev_timestamp, page_id
      
FROM revision_userindex r1
JOIN actor_revision ON actor_id = r1.rev_actor
LEFT JOIN page ON page_id = r1.rev_page
LEFT JOIN comment_revision ON comment_id = r1.rev_comment_id
LEFT JOIN revision r2 ON r1.rev_parent_id = r2.rev_id
 WHERE actor_name IN ('Gnoeee')
AND r1.rev_timestamp > '20221201113100'
AND r1.rev_timestamp < '20230301114100'
 AND (comment_text LIKE '%wbsetlabel-add:1%' #Captions Added
      OR comment_text LIKE '%wbsetlabel-set:1%' #Captions Changed
       OR comment_text LIKE '%wbeditentity-update:0%' #Statements updated
       OR comment_text LIKE '%wbcreateclaim-create:1%' #Statements created/updated
       OR comment_text LIKE '%wbsetclaim-create:2%' #Statements Created
       OR comment_text LIKE 'added [[Category:%') #Added Category
ORDER BY r1.rev_timestamp desc;
SQL

Checking query status...
