Edits made by participants of One million Malayalam labels

Fork of All edits made by participants ONAM Label-a-thon 2020 by Gnoeee

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

SQL

USE wikidatawiki_p;

select now();

SELECT rev_id, rc_timestamp, 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
LEFT JOIN revision on revision.rev_id = recentchanges.rc_this_oldid
WHERE (comment_text LIKE '%wbsetlabel-add:1\|ml%'
       OR comment_text LIKE '%wbeditentity-update-languages-short:0|ml%')
AND actor_name IN ('Gnoeee', 'Ranjithsiji', 'Adithyak1997', 'Akbarali', 'Kiran Gopi', 'Iamvivekkj', 'Kiran Gopi', 'ShajiA', 'Wunderjeenie')
AND rc_timestamp >= 20201029183000
AND rc_timestamp < 20201129183000
AND rc_type in (0, 1)
ORDER BY rc_id desc;

SQL

Checking query status...