Untitled query #16967

SQL

use simplewiki_p;

SELECT page_id, page_title, 
	page_len AS PageLen,
    page_namespace AS Page_namespace,
	EditorNum, EditsNum,
    TalkLen, Talk_namespace FROM
	
    (SELECT page_title AS talk_title, 
     page_len AS TalkLen,
     page_namespace as Talk_namespace,
     COUNT(DISTINCT rev_user) AS EditorNum,
     COUNT(rev_id) AS EditsNum
     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 talk_data
     
     LEFT JOIN page
     WHERE page_title = talk_title
     AND (page_namespace = "0"); #OR page_namespace = "1");
SQL

Checking query status...
