count WD edits by user

SQL

#use dewiki_p;
use wikidatawiki_p;

#describe wb_changes;
#describe comment;

#select comment_text from comment where comment_text like "%Bild, BW erfüllt%" 
#limit 20;
# change_revision_id  change_user_id 

#select * from comment
#where comment.comment_text like "/* wbcreateclaim-create:1| */ [[Property:P18]]:%"
#limit 100;

SELECT /* SLOW_OK */ DISTINCT actor_name AS user, COUNT(wb_changes.change_object_id) as obj_count 
    FROM actor, /*user_groups,*/ comment, wb_changes, revision
    WHERE actor.actor_id = wb_changes.change_user_id
        and wb_changes.change_revision_id = revision.rev_id
        and revision.rev_comment_id = comment.comment_id
        AND comment.comment_text like "/* wbcreateclaim-create:1| */ [[Property:P18]]:%"
    GROUP BY user 
    ORDER BY obj_count DESC limit 200;
    
SELECT /* SLOW_OK */ DISTINCT actor_name AS user, COUNT(page.page_id) as obj_count 
    FROM actor, /*user_groups,*/ comment, revision, page
    WHERE actor.actor_id = revision.rev_actor
        and revision.rev_page = page.page_id
        and revision.rev_comment_id = comment.comment_id
        AND comment.comment_text like "/* wbcreateclaim-create:1| */ [[Property:P18]]:%"
    GROUP BY user 
    ORDER BY obj_count DESC limit 200;
SQL

Checking query status...
