- 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)) 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 a.actor_name#, p.page_title
order by byte_count desc 
limit 20;
SQL

Checking query status...
