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

SQL

SELECT 
actor.actor_name as name,
COUNT(revision_userindex.rev_comment_id) as score
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 
 revision_userindex.rev_timestamp between 2022-07-19T15:07 and 2023-07-19T15:07
and comment_text  like "%انتبه! تمّ استبدال المحتوى بـقالب صمخ%"
GROUP BY actor.actor_name;

SQL

Checking query status...