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 LIKE '%wbsetlabel-add:1|te%'

       OR comment_text LIKE '%wbsetlabel-set:1|te%'

       OR comment_text LIKE '%wbeditentity-update-languages-short:0||te%')

AND actor_name IN ('Gnoeee', 'Kasyap', 'Adithyak1997', 'Akbarali', 'Kiran Gopi', 'Iamvivekkj', 'ShajiA', 'Wunderjeenie', 'Mallikarjunasj', 'Ajeeshkumar4u', 'NASIF C M', 'Meenakshi nandhini', 'Sreenandhini', 'Ivishnuajith' )

AND rc_timestamp >= 20210331183000

AND rc_timestamp < 20210430183000

  AND rc_namespace = 0) as derivedtable

GROUP BY actor_name ORDER BY Number_of_labels_added desc;