Users performed the most reviews on July 13th

SQL

USE arwiki_p;

WITH orphaned_articles AS (
    SELECT p.page_id, p.page_title
    FROM page p
    LEFT JOIN pagelinks pl ON p.page_id = pl.pl_to
    WHERE pl.pl_from IS NULL AND p.page_namespace = 0 AND p.page_is_redirect = 0
    AND p.page_id NOT IN (SELECT pl.pl_to FROM pagelinks pl JOIN revision r ON pl.pl_from = r.rev_page WHERE r.rev_timestamp < '20240713000000')
    GROUP BY p.page_id
),

linked_articles AS (
    SELECT p.page_id, p.page_title
    FROM page p
    JOIN pagelinks pl ON p.page_id = pl.pl_to
    WHERE pl.pl_from IN (SELECT rev_page FROM revision WHERE rev_timestamp BETWEEN '20240713000000' AND '20240713235959')
    AND p.page_namespace = 0 AND p.page_is_redirect = 0
    GROUP BY p.page_id
)

SELECT la.page_title
FROM linked_articles la
JOIN orphaned_articles oa ON la.page_id = oa.page_id
ORDER BY la.page_title;
SQL

Checking query status...
