User Edits to Files in Commons under Specific Categories

SQL

SELECT r1.rev_timestamp, actor_name, page_title, comment_text
      
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
WHERE actor_name IN ('Ayshamarjana','Anupamdutta73','Joy sagar Murmu','Sridhar G',
                     'Meenakshi nandhini','Rajasekhar1961','Sanu N','Mulkh Singh',
                     'कन्हाई प्रसाद चौरसिया','आर्या जोशी','Kavitha G. Kana','Bijendra Hansda Purudhu',
                     'J ansari','Kwameghana','Filipinayzd','Gnoeee','Aishik Rehman','Obaid Raza',
                     'பிரயாணி','कल्पनाशक्ती','Meghdhanu','Sukeerti.Bhopal', 'Salil Kumar Mukherjee',
                     '~aanzx', 'Ssgapu22', 'K.Venkataramana', 'Kuldeepburjbhalaike', 'Chinmayee_Mishra',
                     'Kasyap', 'Gabiruban', 'Official Brar harry', 'Simranjeet Sidhu', 'KINNERA ARAVIND')
AND r1.rev_timestamp > '20230320183100'
AND r1.rev_timestamp < '20230331183000'
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 '%wbsetclaim-update:2%' #Statements Updated
      OR comment_text LIKE 'added [[Category:%') #Added Category
WHERE file.page_namespace = 6      
AND EXISTS (
SELECT *
FROM categorylinks
JOIN page ON page_id = cl_from
JOIN image ON img_name = page_title
WHERE cl_to = "Facades of Akbar's Tomb"
)
ORDER BY r1.rev_timestamp desc;
SQL

Checking query status...
