Recent additions of labels by certain users in Malayalam

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 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 ('Adithyak1997','Gnoeee')
AND rc_timestamp >= 20200801183000
  AND rc_namespace = 0) as derivedtable
GROUP BY rc_actor ORDER BY Number_of_labels_added desc;
#group by rc_user_text
#order by added;

SQL

Checking query status...