User Edits to Files in Commons under Specific Categories

SQL

SELECT r1.rev_timestamp, actor_name, page_title, comment_text, page_id, cl.cl_to
      
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 image img ON img.img_name = page.page_title
LEFT JOIN categorylinks cl ON cl.cl_from = page.page_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 > '20230320233000'
AND r1.rev_timestamp < '20230331233000'
AND (cl.cl_to LIKE 'Images_from_Wiki_Loves_Folklore_2020_in_India'
     OR cl.cl_to LIKE 'Images_from_Wiki_Loves_Folklore_2021_in_India'
     OR cl.cl_to LIKE 'Images_from_Wiki_Loves_Folklore_2022_in_India' ) # Filter by specific category
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
     ORDER BY r1.rev_timestamp desc;
SQL

Checking query status...
