Untitled query #32477

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 20190101000000 and 20200101000000
join page p on p.page_id=r.rev_page
where user_registration>20190101000000 and p.page_namespace=0
GROUP BY u.user_name
having COUNT(*)>200
ORDER BY 1 asc;

use lvwiki_p;
SELECT concat('* [[Dalībnieks:',u.user_name,']]'), user_registration, r.rev_id
FROM user u
join revision r on u.user_name=r.rev_user and r.rev_timestamp between 20190101000000 and 20200101000000
join page p on p.page_id=r.rev_page
where user_registration>20190101000000 and p.page_namespace=0
limit 50

SQL

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

SQL

Checking query status...