Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
Fork of
User Edits to Files in Commons under Specific Categories
by
Kasyap
This query is marked as a draft
This query has been published
by
Schlurcher
.
Edits made by users participating in Women's Month Datathon on Commons under Specific Categories with the Comments
Toggle Highlighting
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;
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...