Untitled query #70544

SQL

SELECT u.user_name, user_registration, COUNT(*)
FROM user u
join actor a on a.actor_user=u.user_id
join revision_userindex r on a.actor_id=r.rev_actor and r.rev_timestamp between 20210101000000 and 20220101000000
#join page p on p.page_id=r.rev_page
where user_registration>20210101000000# and p.page_namespace=0
GROUP BY u.user_name
having COUNT(*)>50
ORDER BY 1 asc;

#visi ar labojumiem rakstu vārdtelpā
SELECT a.actor_name, COUNT(*)
FROM revision_userindex r
join actor a on a.actor_id=r.rev_actor
join page p on p.page_id=r.rev_page
WHERE p.page_namespace=0 and r.rev_timestamp between 20220101000000 and 20230101000000
GROUP BY r.rev_actor
having COUNT(*)>200
ORDER BY 1 asc;

#visi ar labojumiem visās vārdtelpās
SELECT a.actor_name, COUNT(*)
FROM revision_userindex r
join actor a on a.actor_id=r.rev_actor
#join page p on p.page_id=r.rev_page
WHERE r.rev_timestamp between 20220101000000 and 20230101000000
GROUP BY r.rev_actor
having COUNT(*)>200
ORDER BY 1 asc;
SQL

Checking query status...
