Edits made by participants WD Birthday Data-thon in India 2024

SQL

USE wikidatawiki_p;
SELECT rev_id, rc_timestamp, actor_name, rc_title, comment_text
FROM revision
LEFT JOIN actor ON actor.actor_id = revision.rev_actor
LEFT JOIN page ON page.page_id = revision.rev_page
WHERE actor_name in ('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 rc_timestamp >= 20241012183000
AND rc_timestamp < 20241116183000
AND rc_type in (0, 1)
ORDER BY rc_id desc;
SQL

Checking query status...
