Untitled query #83909

SQL

USE arwiki_p;  

WITH low_edit_users AS (
    SELECT rev_actor
    FROM revision
    JOIN actor ON revision.rev_actor = actor.actor_id
    WHERE actor.actor_user IS NOT NULL 
    GROUP BY rev_actor
    HAVING COUNT(*) < 100
)


SELECT a.actor_name AS username, p.page_title AS article_title
FROM revision r
JOIN actor a ON r.rev_actor = a.actor_id
JOIN page p ON r.rev_page = p.page_id
WHERE r.rev_timestamp BETWEEN '20240125000000' AND '20240125235959'
AND r.rev_actor IN (SELECT rev_actor FROM low_edit_users)
ORDER BY username, article_title DESC
LIMIT 500;
SQL

Checking query status...
