SELECT rc_cur_id AS page_id,

                   rc_title AS title,

                   COUNT(*) AS edits,

                   COUNT(DISTINCT rc_user) AS users,

                   rc_timestamp

            FROM recentchanges

            WHERE rc_namespace = 0

            AND rc_type = 0

            AND rc_timestamp BETWEEN CURDATE() - INTERVAL 1 DAY AND CURDATE()

            GROUP BY page_id

            ORDER BY edits

            DESC

            LIMIT 1000