Articles' edits, users, page length and talk page length

SQL

USE simplewiki_p;
SELECT page_id, article_title, num_editors_U, revisions_E, page_len AS page_length_L, talkpage_len_T, page_namespace FROM
	(SELECT page_title AS article_title, page_len AS talkpage_len_T,
     COUNT(DISTINCT rev_user) AS num_editors_U,
     COUNT(rev_id) AS revisions_E
     FROM revision
     JOIN page ON rev_page = page_id
     WHERE LOWER(rev_user) NOT LIKE LOWER("%bot%") AND page_is_redirect = "0" AND page_namespace = "1"
     GROUP BY page_id
     ORDER BY RAND()
     LIMIT 1000)
     AS subq
     JOIN page
     WHERE page_title = article_title
     AND (page_namespace = "0");

SQL

Checking query status...