them week users

SQL

USE ukwiki_p;
SELECT
      CONCAT('[[Користувач:', rev_user_text, '|', ']]') as user_name
    FROM page article
      JOIN revision
        ON rev_page = article.page_id AND
           rev_parent_id = 0  --  AND
 --   		20161001 * 1000000 <= rev_timestamp  AND 
 --   		rev_timestamp < 20161101 * 1000000
      JOIN page talk
        ON talk.page_title = article.page_title AND
           talk.page_namespace IN (0, 1)
      JOIN templatelinks ON
                           tl_from = talk.page_id AND
                           tl_title IN (
                             'Top-1000-10000-week-new',
                             'Algeria-week-new',
                             'Olympic-2016-new',
                             'Місяць_фантастичних_творів',
                             'Cherkasy-week-new',
                             'Михайло_Грушевський-week-new',
                             'Urdu-Ukrainian-week-new',
                             'Угорська_революція_1956-week-new',
                             'Переяслав-Хмельницький-музей-week-new',
                             'Asian-month-2016-new'
                           ) AND
                           tl_namespace = 10
    WHERE
      article.page_namespace = 0 AND
      article.page_is_redirect = 0
    GROUP BY rev_user_text
SQL

Checking query status...
