Untitled query #36975

SQL

USE wikidatawiki_p;
SELECT current_date;
SELECT rc_user_text as Username, COUNT(*) as Number_of_labels_added
FROM (
SELECT rc_user_text,
       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_user_text IN ('Ranjithsiji', 'Mujeebcpy', 'Ambadyanands', 'KannanVM', 'Akbarali')
AND rc_timestamp >= 20181105183000
  AND rc_namespace = 0) as derivedtable
GROUP BY rc_user_text ORDER BY Number_of_labels_added desc;
#group by rc_user_text
#order by added;
SQL

Checking query status...
