Arabians most edited articles

SQL

SELECT
    rc_title AS article,
    COUNT(*) AS edit_count
FROM recentchanges
WHERE
    rc_timestamp >= DATE_FORMAT(STR_TO_DATE('20240215121212', '%Y%m%d%H%i%S'), '%Y%m%d%H%i%S') -- Start of the month
    AND rc_timestamp < DATE_FORMAT(STR_TO_DATE('20241206121212', '%Y%m%d%H%i%S'), '%Y%m%d%H%i%S') -- Start of the next month
    AND rc_namespace = 0  -- Main article namespace
    AND rc_type IN (0, 1)  -- Only content edits (0: edit, 1: new)
GROUP BY
    rc_title
ORDER BY
    edit_count DESC
LIMIT 100; -- Top 100 most edited articles
SQL

Checking query status...
