Untitled query #77351

SQL

SET @start_date = '2023-01-01 00:00:00';
SET @end_date = '2023-10-10 00:00:00';

SELECT
    user.user_name AS creator,
    COUNT(*) AS redirect_count
FROM page
JOIN revision ON page.page_id = revision.rev_page
JOIN actor_revision ON revision.rev_actor = actor_revision.actor_id
JOIN user ON actor_revision.actor_user = user.user_id
WHERE page.page_namespace = 0
    AND page.page_is_redirect = 1
    AND revision.rev_timestamp >= @start_date
    AND revision.rev_timestamp < @end_date
GROUP BY creator
ORDER BY redirect_count DESC;
SQL

Checking query status...
