SQL
AخA
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...bn'
AND rc_user_text IN ('Mahir256', 'Titodutta', 'Bodhisattwa', 'Pinakpani', 'খাঁ শুভেন্দু', 'Tanay barisha', 'ZI Jony', 'Tarunsamanta', 'Marajozkee')
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;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.