All edits made by participants Wikidata Eleventh Birthday - India Datathon

SQL

SELECT revision.rev_id, revision.rev_timestamp, actor.actor_name, page.page_title, comment.comment_text
FROM revision
LEFT JOIN comment ON comment.comment_id = revision.rev_comment_id
LEFT JOIN actor ON actor.actor_id = revision.rev_actor
LEFT JOIN page ON page.page_id = revision.rev_page
WHERE actor_name IN ('J ansari', 'Kasyap', 'BHARATHESHA ALASANDEMAJALU', 'Ranjithsiji', 'Aliva Sahoo', 'KartikMistry', 'R Ashwani Banjan Murmu', 'Mujeebcpy', 'Ambadyanands', 'Meenakshi nandhini', 'Arkarjun1', 'Athulvis', 'Kavitha G. Kana', 'MT731', 'Tulspal', 'Kuldeepburjbhalaike', 'Sriveenkat', 'CptViraj', 'Vip3927', 'Asdofindia', 'Jothishbabu', 'AravindIM', 'Subins2000', 'Aajeditingwiki', 'ᱤᱧ ᱢᱟᱛᱟᱞ', 'ᱥᱟᱹᱜᱩᱱ ᱗')
AND rev_timestamp >= 20231025233000
AND rev_timestamp < 20231105182900
ORDER BY revision.rev_id DESC;

SQL

Checking query status...