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;