مستخدمين أداة المُستَعيد

SQL

SELECT revision_userindex.rev_id,
comment_text,
actor.actor_name,
COUNT(*) AS num_operations
FROM revision_userindex
inner join page ON page.page_id = revision_userindex.rev_page
inner join comment on revision_userindex.rev_comment_id = comment.comment_id
inner join actor ON actor.actor_id = revision_userindex.rev_actor
WHERE page.page_namespace = 0
and page.page_is_redirect = 0
and revision_userindex.rev_timestamp between 20230701000000 and 20230716000000
and comment_text  like "%[[وب:م و ص|مشروع ويكي الصيانة]]%"
GROUP BY actor.actor_name;

SQL

Checking query status...