تجر - Quarry

SQL

USE arwiki_p;

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

Checking query status...
