User Edits to Files in Commons under Specific Categories

SQL

SELECT r1.rev_timestamp, actor_name, page_title, comment_text, I.img_name, I.img_timestamp, U.user_name
      
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
AND FROM commonswiki_p.image I
  LEFT JOIN commonswiki_p.page P ON I.img_name=P.page_title
  LEFT JOIN commonswiki_p.categorylinks CL ON P.page_id=CL.cl_from
  LEFT JOIN commonswiki_p.actor A ON I.img_actor=A.actor_id
  LEFT JOIN commonswiki_p.user U ON A.actor_user=U.user_id
         AND P.page_namespace = 6
  AND CL.cl_to LIKE "Images from Wiki Loves Folklore 2020 in India"
GROUP BY page_id
ORDER BY r1.rev_timestamp desc;
SQL

Checking query status...
