Untitled query #40879

SQL

use trwiki_p;
#jauniņie ar labojumiem visās vārdtelpās
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 20180101000000 and 20190101000000
#join page p on p.page_id=r.rev_page
where user_registration>20180101000000# and p.page_namespace=0
GROUP BY u.user_name
having COUNT(*)>100
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 20190101000000 and 20200101000000
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 20190101000000 and 20200101000000
GROUP BY r.rev_actor
having COUNT(*)>200
ORDER BY 1 asc;
SQL

Checking query status...
