ONAM Label-a-thon - 1st - 2nd September 2020

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 Adithyak1997.

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 REGEXP 'wbsetlabel-add:1...ml'
AND actor_name IN ('Gnoeee', 'Ranjithsiji', 'Adithyak1997', 'Akbarali','Irshadpp','Meenakshi nandhini','Kiran Gopi','Iamvivekkj','Vijayanrajapuram')
AND rc_timestamp >= 20200831183000
AND rc_timestamp < 20200902183000
  AND rc_namespace = 0) as derivedtable
GROUP BY actor_name ORDER BY Number_of_labels_added desc;

SQL

Checking query status...