Untitled query #36557

SQL

use plwikisource_p;
SELECT count(DISTINCT(page_id)) as num from page where page_namespace=100 and page_is_redirect=0;
SELECT page_id as num from page where page_namespace=100 and page_is_redirect=0 ORDER BY page_id DESC
LIMIT 2;
SELECT page_id as num from page where page_namespace=100 and page_is_redirect=0 ORDER BY page_id ASC
LIMIT 2;
SELECT rev_id, rev_page FROM revision WHERE rev_page IN (SELECT page_id as num from page where page_namespace=100 and page_is_redirect=0)
ORDER BY rev_id ASC  LIMIT 2;
SELECT
	rev_user_text as user_name,
    count(rev_id) as edits
FROM
	revision
WHERE
    rev_page IN (SELECT page_id as num from page where page_namespace=100 and page_is_redirect=0)
GROUP BY
	rev_user_text
ORDER BY edits DESC

LIMIT 10;
SQL

Checking query status...
