Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
Fork of
All edits made by participants International Mother Language Day 2023 Datathon
by
Gnoeee
This query is marked as a draft
This query has been published
by
Gnoeee
.
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 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 EXISTS ( SELECT * FROM categorylinks JOIN page ON page_id = cl_from JOIN image ON img_name = page_title WHERE cl_to = "Facades of Akbar's Tomb" ) 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...