Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
Fork of
ONAM Label-a-thon - 1st - 2nd September 2020
by
Gnoeee
This query is marked as a draft
This query has been published
by
Gnoeee
.
One million Malayalam labels is a event organised by WikiProject Kerala to add and improve Malayalam labels in Wikidata.
Toggle Highlighting
SQL
USE wikidatawiki_p; SELECT current_date; SELECT actor_name as Username, COUNT(*) as Number_of_labels_added FROM ( SELECT actor_name, rc_title, comment_text FROM recentchanges LEFT JOIN comment ON comment.comment_id = recentchanges.rc_comment_id LEFT JOIN actor on actor.actor_id = recentchanges.rc_actor WHERE (comment_text LIKE '%wbsetlabel-add:1|ml%' OR comment_text LIKE '%wbsetlabel-set:1|ml%' OR comment_text LIKE '%wbeditentity-update-languages-short:0||ml%') AND actor_name IN ('Gnoeee', 'Ranjithsiji', 'Adithyak1997', 'Akbarali', 'Kiran Gopi', 'Iamvivekkj', 'ShajiA', 'Wunderjeenie', 'Mallikarjunasj', 'Ajeeshkumar4u', 'NASIF C M', 'Meenakshi nandhini', 'Sreenandhini', 'Ivishnuajith', 'JithinKochi') AND rc_timestamp >= 20210731183000 AND rc_timestamp < 20210831183000 AND rc_namespace = 0) as derivedtable GROUP BY actor_name ORDER BY Number_of_labels_added 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...