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

Fork of Find most recent additions of labels by certain users in Bengali by Mahir256

This query is marked as a draft This query has been published by Gnoeee.

SQL

USE wikidatawiki_p;
SELECT current_date;
SELECT rc_actor as Username, COUNT(*) as Number_of_labels_added
FROM (
SELECT rc_actor,
       rc_title, comment_text
#       count(comment_text) as added
FROM recentchanges
LEFT JOIN comment ON comment.comment_id = recentchanges.rc_comment_id
WHERE comment_text REGEXP 'wbsetlabel-add...ml'
AND rc_actor IN ('Gnoeee', 'Ranjithsiji', 'Adhitya1997', 'Akbarali')
AND rc_timestamp >= 20200801183000
AND rc_timestamp < 2020082983000
  AND rc_namespace = 0) as derivedtable
GROUP BY rc_actor ORDER BY Number_of_labels_added desc;
#group by rc_actor
#order by added;

SQL

Checking query status...