Untitled query #15505

SQL

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

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

Checking query status...
