SELECT @rank := @rank + 1 AS rank, rev_user_text

FROM (

  SELECT rev_user_text

  FROM (

    SELECT cl_from

    FROM commonswiki_p.categorylinks

    WHERE cl_to IN (

    "Images_from_Science_Photo_Competition_2016_in_Ukraine"

    )

  ) images

--  JOIN commonswiki_p.page ON

--  cl_from = page_id AND

--  page_namespace = 6

  JOIN commonswiki_p.revision_userindex ON

  rev_page = cl_from AND

  rev_parent_id = 0 AND

  (

    SELECT log_user

    FROM commonswiki_p.logging_userindex

    WHERE rev_user = log_user

    AND log_type = 'newusers'

    AND log_action = 'create'

    AND log_timestamp BETWEEN 20160930210000 AND 20161028205959

  ) IS NOT NULL

  GROUP BY rev_user_text

  ORDER BY rev_user_text

) resultset

​

​