Untitled query #23856

SQL

use lvwiki_p;
SELECT concat('* [[Dalībnieks:',u.user_name,']]'), user_registration, COUNT(*)
FROM user u
join revision r on u.user_name=r.rev_user and r.rev_timestamp between 20170101000000 and 20180101000000
join page p on p.page_id=r.rev_page
where user_registration>20160101000000 and p.page_namespace=0
GROUP BY u.user_name
having COUNT(*)>200
ORDER BY 1 asc;

SELECT concat('* [[Dalībnieks:',r.rev_user_text,']]'), COUNT(*)
FROM revision r
join page p on p.page_id=r.rev_page
WHERE p.page_namespace=0 and r.rev_timestamp between 20170101000000 and 20180101000000
GROUP BY r.rev_user_text
having COUNT(*)>200
ORDER BY 1 asc;

SELECT concat('* [[Dalībnieks:',r.rev_user_text,']]'), COUNT(*)
FROM revision r
join page p on p.page_id=r.rev_page
WHERE r.rev_timestamp between 20170101000000 and 20180101000000
GROUP BY r.rev_user_text
having COUNT(*)>200
ORDER BY 1 asc;
SQL

Checking query status...
