edit count idwikisource contest 2025

SQL

SELECT
  ROW_NUMBER() OVER (ORDER BY COUNT(actor_id) DESC) AS row_number,
  CONCAT("[[Special:Contributions/", actor_name, "]]") AS rev_user_text,
  COUNT(actor_id) AS total_user_editcount,
  SUM(CASE WHEN page_namespace = '0' THEN 1 ELSE 0 END) AS main_namespace_edits
/*user_editcount*/
FROM revision
JOIN actor ON rev_actor = actor_id
JOIN page ON rev_page = page_id
WHERE actor_user IS NOT NULL
  AND page_namespace IN ('0', '10', '102', '104', '106', '100', '2', '828', '14')
  AND NOT (actor_name LIKE '%AWB%' OR actor_name LIKE '%Bot%' OR actor_name LIKE '%bot%' OR actor_name = 'CommonsDelinker')
  AND actor_name IN (
      'Aeia aai', 'Agin Puspa', 'Ah.Masyhar', 'Aitu20', 'Alamthelibrarian',
      'Alfiyah Rizzy Afdiquni', 'Alicya-', 'Alyadulyaiman', 'Ana Brilyana', 
      'Anisah Muzammil', 'Annisa Tiara Ramadhani', 'Ariska Fisabilillah', 
      'Bknsenjaa', 'Candramawa99', 'Dessyil', 'Desy Cristalia', 'Devi 4340', 
      'Dirumi', 'Dvnfit', 'Elcamatcha', 'Esa Fadjri', 'Fiskal Purbawan', 
      'Hariadhi', 'Hzu Hzu', 'Ibrahim TSA', 'Ilham Mufti Laksono', 
      'Iripseudocorus', 'Jeromi Mikhael', 'Jifani Wahyu', 'Kriita', 
      'Lembayung Indah', 'Lim Natee', 'Losstreak', 'Maria tanjung', 
      'Masruroh Febriyanti', 'Mega Lase', 'Meilisade', 'Mia Sulisnawati', 
      'Mnam23', 'MondBriller', 'Mrifqis713', 'Muhamad Izzul Fiqih', 
      'Muhnurtaufiq', 'Muufii', 'Nafisathallah', 'Najla Khairani Siregar', 
      'Narariya', 'NikolasKHF', 'Ning Gusti', 'Orfetaum', 'Partofme00', 
      'Penikmat Senja', 'Radramboo', 'Rahmie Sabine', 'Ratri Ayumsari', 
      'Rina Purba', 'Rizki Hidayatulloh', 'Rubyracha', 'Rumirami', 
      'Salmaafifahafif', 'Salsa66syifa', 'Sathira15', 'Sekarchamdi', 
      'Setyadirja', 'Ships in the Starlight', 'Thersetya2021', 'Ulumarifah', 
      'VidiDhemas21', 'WiniSJ', 'Wllndri', 'Zhilal Darma', 'ZoelKFL'
  )
  AND rev_timestamp BETWEEN '20250104170000' AND CURRENT_TIMESTAMP
GROUP BY actor_id, actor_name
ORDER BY total_user_editcount DESC
LIMIT 100;
SQL

Checking query status...
