SPC in UA MMXVI participants stats

SQL

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
  rev_user IN (
    SELECT log_user
    FROM commonswiki_p.logging
    WHERE log_type = 'newusers'
    AND log_action = 'create'
    AND log_timestamp BETWEEN 20160930210000 AND 20161028205959
  )
  GROUP BY rev_user_text
  ORDER BY rev_user_text
) resultset
SQL

Checking query status...
