Untitled query #72547

SQL

SELECT r1.rev_timestamp, actor_name, page_title, comment_text, 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
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','K.Venkataramana','Salil_Kumar_Mukherjee','~aanzx','Ssgapu22','Kuldeepburjbhalaike')
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
ORDER BY r1.rev_timestamp desc;
SQL

Checking query status...
