- Quarry

SQL

SELECT DISTINCT a.actor_name,
                p.page_title,
                sum(
                  (r.rev_len - IFNULL(
                                         (SELECT DISTINCT parent.rev_len
                                          FROM revision parent
                                          WHERE r.rev_parent_id = parent.rev_id
                                            AND p.page_id = parent.rev_page), 0)
                  ) / 4000
                    ) 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
INNER JOIN COMMENT ON comment_id = r.rev_comment_id
WHERE p.page_namespace = 0
  AND r.rev_timestamp BETWEEN 20240515000000 AND 20240616000000 #AND r.rev_timestamp BETWEEN 20230501000000 AND 20230526000000
  AND comment_text not like _utf8"%رجوع%" COLLATE utf8_general_ci
  AND comment_text not like _utf8"%استرجاع%" COLLATE utf8_general_ci
  AND a.actor_name not like _utf8"%bot" COLLATE utf8_general_ci
  AND a.actor_name IN ('Mr. Ibrahem') #AND p.page_title IN ('انعدام_الجنسية_في_لبنان')
GROUP BY p.page_title
ORDER BY byte_count DESC #limit 20 ;
SQL

Checking query status...
