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
    INNER JOIN categorylinks c ON p.page_id = c.cl_from AND c.cl_to = "مقالات_يتيمة"
)

SELECT p.page_title
FROM orphaned_articles p
JOIN linktarget lt ON p.page_title = lt.lt_title AND p.page_namespace = lt.lt_namespace
JOIN pagelinks pl ON lt.lt_id = pl.pl_target_id
JOIN revision r ON pl.pl_from = r.rev_page
WHERE r.rev_timestamp BETWEEN '20240713000000' AND '20240713235959'
AND pl.pl_from_namespace = 0
AND NOT EXISTS (
    SELECT 1 
    FROM pagelinks pl2
    JOIN revision r2 ON pl2.pl_from = r2.rev_page
    WHERE pl2.pl_to = p.page_title AND r2.rev_timestamp < '20240713000000'
)
GROUP BY p.page_title
HAVING COUNT(pl.pl_from) > 1
ORDER BY COUNT(pl.pl_from) DESC, p.page_title;
SQL

Checking query status...
