Active users of WikiProject-India

SQL

USE wikidatawiki_p;

SELECT actor_name, COUNT(*) AS edit_count
FROM recentchanges
LEFT JOIN actor ON actor.actor_id = recentchanges.rc_actor
WHERE actor_name IN ('2006nishan178713', 'Aliva Sahoo', 'Ananth subray', 'Aniket', 'AshokChakra', 'Nemaniarjun', 
                     'Atudu', 'BeLucky', 'Bodhisattwa', 'BukhariSaeed', 'C1K98V', 'CAPTAIN RAJU', 'Daniel Mietchen', 
                     'DaxServer', 'Gnoeee', 'Godric ki Kothri', 'Gopala Krishna A', 'Anupamdutta73', 'Gurbakhshish chand', 
                     'J ansari', 'Jnanaranjan sahu', 'Jura1', 'Kc895835', 'KartikMistry', 'KCVelaga', 
                     'Mahir256', 'Manojk', 'Marajozkee', 'Mdmahir', 'MKar', 'Mouryan', 'Naga sai sravanth', 
                     'Naveenpf', 'Netha Hussain', 'Pavan santhosh.s', 'Obaid Raza', 'Pinakpani', 'Planemad', 'Pranayraj1985', 
                     'Prtksxna', 'Ranjithsiji', 'Rocky 734', 'Rohini', 'Saisumanth Javvaji', 'Sangappadyamani', 'Sarangmk0', 
                     'Satdeep Gill', 'Satpal Dandiwal', 'Shrinivaskulkarni1388', 'Shypoetess', 'Stalinjeet Brar', 'Sushma_Sharma', 
                     'SuswethaK', 'Vis M', 'आर्या जोशी', 'सुशान्त देवळेकर', 'सुबोध कुलकर्णी', 'कल्याणी कोतकर', 
                     'हिंदुस्थान वासी', 'rahul895835', 'రవిచంద్ర', 'Khalid0077', 'Owenpatel', 'Harshrathod50', 'sajithbhadra', 
                     'R Ashwani Banjan Murmu', 'Ramjit Tudu', 'Lokesha kunchadka', 'Balajijagadesh', 'Mallikarjunasj', 'Info-farmer', 
                     'Ambadyanands', 'Sreenandhini', 'Ilaveyil riswan', 'Abijith k.a', 'Chaduvari', 'Suman.bahuguna', 
                     'Planemad', 'Raju Jangid', 'Nikhilsheth', 'MNavya', 'Sumitsurai', 'KannanVM', 'Sriram vishnudatta', 
                     'Meenakshi nandhini', 'Nivas10798', 'AryamanA', 'Aditya0299', 'CptViraj', 'Kaaro01', 'Eatcha', 'Sai K shanmugam', 
                     'Path slopu', 'Bhuvana Meenakshi', 'Sb8912', 'Suyash.dwivedi', 'Soorya Hebbar', 'Pavanaja', 'Kasyap', 
                     'Adithyak1997', 'Manojk', 'Kiran Gopi', 'Abhinavgarule', 'SHISHIR DUA', 'Tanay barisha', 
                     'Thejeshgn', 'कन्हाई प्रसाद चौरसिया', 'Neechalkaran', 'Ratekreel', 'Psmdlisku', 'ParasharSarthak', 'Snehrashmi', 
                     'Tulspal', 'Surojit mondal memes', 'Kuldeepburjbhalaike', 'Sriveenkat', 'Arkarjun1', 'Jameela P')
  AND rc_timestamp >= 20240823183100
  AND rc_timestamp < 20240323183100
  AND rc_type IN (0, 1)
GROUP BY actor_name
ORDER BY edit_count DESC;
SQL

Checking query status...
