Untitled query #25022

SQL

use plwikisource_p;

SELECT
	rev_user_text as user_name,
    count(rev_id) as edits
FROM
	revision, page
WHERE
    rev_timestamp > '20180101000000' and
    page_namespace = 100 and
    page_id = rev_page
GROUP BY
	rev_user_text
ORDER BY edits DESC

LIMIT 10;
use itwikisource_p;

SELECT
	rev_user_text as user_name,
    count(rev_id) as edits
FROM
	revision, page
WHERE
    rev_timestamp > '20180101000000' and
    page_namespace = 108 and
    page_id = rev_page
GROUP BY
	rev_user_text
ORDER BY edits DESC

LIMIT 10;

use enwikisource_p;

SELECT
	rev_user_text as user_name,
    count(rev_id) as edits
FROM
	revision, page
WHERE
    rev_timestamp > '20180101000000' and
    page_namespace = 104 and
    page_id = rev_page
GROUP BY
	rev_user_text
ORDER BY edits DESC

LIMIT 10;
SQL

Checking query status...
