Untitled query #81045

SQL

USE arwiki_p;

SELECT
    p.page_title AS "عنوان الصفحة",
    COUNT(r.rev_id) AS "عدد المساهمات",
    SUM(r.rev_len) AS "إجمالي حجم التعديل (بايت)",
    r.rev_len AS "حجم التعديل الحالي (بايت)",
    a.actor_name AS "البربوشي"
FROM
    revision r
INNER JOIN
    actor a ON r.rev_actor = a.actor_id
INNER JOIN
    page p ON r.rev_page = p.page_id
WHERE
    p.page_namespace = 0
GROUP BY
    p.page_title, r.rev_id
ORDER BY
    "إجمالي حجم التعديل (بايت)" DESC;
SQL

Checking query status...
