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
    JOIN revision r ON pl.pl_from = r.rev_page
    WHERE r.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...
