Untitled query #81042

SQL

SELECT DISTINCT
    a.actor_name,
    p.page_title,
    sum(r.rev_len - IFNULL(parent.rev_len, 0)) AS byte_count
    
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
LEFT JOIN revision parent ON r.rev_parent_id = parent.rev_id AND p.page_id = parent.rev_page
WHERE p.page_namespace = 0
    AND r.rev_timestamp BETWEEN 20230901000000 AND 20231201000000
    AND a.actor_name IN ('Mr. Ibrahem')
    #AND p.page_title IN ('انعدام_الجنسية_في_لبنان')
GROUP BY a.actor_name, p.page_title
;
SQL

Checking query status...
