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

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 = page_id AND

  rev_parent_id = 0

  JOIN (

    SELECT log_user, "+" as noobmark FROM commonswiki_p.logging

    WHERE log_user

    AND log_type = 'newusers'

    AND log_action = 'create'

    AND log_timestamp BETWEEN 20160930210000 AND 20161028205959

  ) as noobs ON log_user = rev_user

  GROUP BY rev_user_text

  ORDER BY noobmark, rev_user_text

) resultset

​

​