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_title = pl.pl_title AND p.page_namespace = pl.pl_namespace
    WHERE pl.pl_from IS NULL 
    AND p.page_namespace = 0 
    AND p.page_is_redirect = 0
    AND p.page_id NOT IN (
        SELECT p2.page_id 
        FROM page p2
        JOIN pagelinks pl2 ON p2.page_title = pl2.pl_title AND p2.page_namespace = pl2.pl_namespace
        JOIN revision r ON pl2.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_title = pl.pl_title AND p.page_namespace = pl.pl_namespace
    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...
