SQL: collect data on talk pages associated with article pages DE

SQL

use dewiki_p;

SELECT Article_id, article_title, 
	page_len AS TalkLen,
    page_namespace AS Talk_namespace,
	
    EditorNum, EditsNum,
    PageLen, Article_namespace
    
    FROM
    
    (SELECT page_title AS article_title, 
     page_len AS PageLen,
     page_namespace AS Article_namespace,
     page_id AS Article_id,
     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 = "0"
     GROUP BY page_id
     ORDER BY RAND()
     LIMIT 1000)
     
     AS temp_table
     
     #JOIN page
     #WHERE page_title = article_title
     #AND page_namespace = "1"
     
     LEFT JOIN page
     ON page_title = article_title
     AND page_namespace = "1"
     
     #RIGHT JOIN page
     #ON page_title = article_title
   
     #AND page_namespace = "1"
SQL

Checking query status...
