All edits made by participants in the Open Data Day 2020 edit-a-thon

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 actor_name in ('Adithyak1997', 'Gnoeee', 'Imvivekkj', 'Ranjithsiji')
AND rc_timestamp >= 20200306183000
AND rc_timestamp < 20200308183000
AND rc_type in (0, 1)
ORDER BY rc_id desc;

SQL

Checking query status...