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

SQL

USE wikidatawiki_p;

SELECT 
    rc.rev_id,
    rc.rc_timestamp,
    a.actor_name,
    rc.rc_title,
    c.comment_text
FROM recentchanges AS rc
LEFT JOIN comment AS c ON c.comment_id = rc.rc_comment_id
LEFT JOIN actor AS a ON a.actor_id = rc.rc_actor
LEFT JOIN pagelinks AS pl ON pl.pl_from = rc.rc_cur_id
WHERE a.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 rc.rc_timestamp >= 20241012183000
AND rc.rc_timestamp < 20241116183000
AND rc.rc_type IN (0, 1)
AND pl.pl_namespace = 0 -- Links to main namespace items
AND pl.pl_title IN ('Q16917') -- Check subclass relationships
ORDER BY rc.rc_id DESC;
SQL

Checking query status...
