All edits made by participants in the 2020 Sum of all Indian Paintings datathon

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
# removed Atudu, Gnoeee as their edits outside the scope of the datathon may overwhelm the result
WHERE actor_name in ('Marajozkee', 'Satdeep Gill', 'Simranjeet Sidhu', 'Gill jassu',
                    'Mulkh Singh', 'WikiPanti', 'Jagseer S Sidhu', 'Outofindia', 'R Ashwani Banjan Murmu',
                    'Bijendra Hansda Purudhul', 'Ssgapu22', 'Fagu Baskey', 'Tarunsamanta', 'Komal Sambhudas',
                    'Abhinavgarule', 'Vijay Barot', 'Priyankasingha1811', 'Nrgullapalli', 'Bhuvana Meenakshi',
                    'सुबोध कुलकर्णी')
AND rc_timestamp >= 20201023183100
AND rc_timestamp < 20201025182959
AND rc_type in (0, 1)
ORDER BY rc_id desc;
SQL

Checking query status...
