أكثر المقالات إسترجاعاً للتعديلات

SQL

SELECT 
    page.page_title AS "عنوان الصفحة",
    COUNT(revision_userindex.rev_comment_id) AS "عدد الظهور"
FROM 
    revision_userindex
JOIN 
    page ON page.page_id = revision_userindex.rev_page
JOIN 
    comment ON revision_userindex.rev_comment_id = comment.comment_id
JOIN 
    actor ON actor.actor_id = revision_userindex.rev_actor
WHERE 
    (
        comment.comment_text LIKE "%المُستَعيد%"
        OR comment.comment_text LIKE "%رجوع%"
        OR comment.comment_text LIKE "%مُسترجَع%"
        OR comment.comment_text LIKE "%استرجاع يدوي%"
    )
    AND revision_userindex.rev_timestamp BETWEEN 20240225000000 AND 20240311595959
GROUP BY 
    page.page_title
ORDER BY 
    COUNT(revision_userindex.rev_comment_id) DESC;

SQL

Checking query status...