USE svwiki_p;

#SHOW TABLES;

#DESCRIBE revision;

​

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"

​