All edits made by participants Wikidata 12th 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 ('ᱤᱧ ᱢᱟᱛᱟᱞ', '~aanzx', 'Akbarali', 'Akshaya108', 'Aliva Sahoo', 'Ashay vb', 'ASWINI SCHOOL', 'Athulvis', 'Bharathesha Alasandemajalu', 'C46DEADEYE', 'Charan Gill', 'Chinmayee Mishra', 'Delshasunny', 'Ewvarghese', 'GaganKaire95', 'Gill jassu', 'Gnoeee', 'Goodkid maad cty', 'Gurnoor ghuman', 'Jameela P.', 'Jcksn4099', 'JISNA CHACKO', 'Jithin Narayanan', 'JIYAJOJU', 'Joy sagar Murmu', 'KEERTHIKA SCHOOL', 'Kishore Kumar Rai', 'KOWSHIKA SCHOOL', 'Kuldeepburjbhalaike', 'Litzmary26', 'Manojk', 'Nivin Louis', 'Obaid Raza', 'Pavanaja', 'Pomnomnom', 'Prayagv', 'Rajdeep ghuman', 'Rajeev27nr', 'Ranjithsiji', 'RITHIKA SCHOOL', 'Sadiya Aboobacker', 'Santhosh Notagar99', 'Satdeep Gill', 'Satpal Dandiwal', 'SijiR', 'Sinansulaiman33', 'Sneha Forestry', 'Snehrashmi', 'Sridhar G', 'Ssgapu22', 'SUBHI SCHOOL', 'Tamanpreet Kaur', 'Taranpreet Goswami', 'Tonynirappathu', 'Tulspal', 'UNNIMAYA KURIYAKKOT', 'Yakshitha')
AND rev_timestamp >= 20241012183000
AND rev_timestamp < 20241116183000
ORDER BY revision.rev_id DESC;
SQL

Checking query status...
