SPC in UA MMXVI participants stats

SQL

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 noob, rev_user_text
) resultset
SQL

Checking query status...
