Urdu-Ukrainian-week-new

SQL

USE ukwiki_p;

SELECT  @rownum := @rownum + 1 AS rank,
  user_name,
  created  
FROM
  (
    SELECT
      CONCAT('[[Користувач:', rev_user_text, '|]]') as user_name,
      COUNT(1) AS created,
      rev_timestamp
    FROM page article
      JOIN revision
        ON rev_page = article.page_id AND
           rev_parent_id = 0    AND
        	YEAR(rev_timestamp) = 2016 AND MONTH(rev_timestamp) = 10 
      JOIN page talk
        ON talk.page_title = article.page_title AND
           talk.page_namespace = 1
      JOIN templatelinks ON
                           tl_from = talk.page_id AND
                           tl_title = 'Urdu-Ukrainian-week-new' AND
                           tl_namespace = 10
    WHERE
      article.page_namespace = 0 AND
      article.page_is_redirect = 0
    GROUP BY rev_user_text
    ORDER BY created  DESC) t,
  (SELECT @rownum := 0) r
ORDER BY created DESC
SQL

Checking query status...
