SPC in UA MMXVI participants stats - Quarry

This query is marked as a draft This query has been published by Base.

SQL

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
GROUP BY rev_user_text

​x
 
SELECT rev_user_textFROM (  SELECT cl_from  FROM commonswiki_p.categorylinks  WHERE cl_to IN (  "Images_from_Science_Photo_Competition_2016_in_Ukraine"  )) imagesJOIN commonswiki_p.page ONcl_from = page_id ANDpage_namespace = 6JOIN commonswiki_p.revision_userindex ONrev_page = page_id ANDrev_parent_id = 0GROUP BY rev_user_text​

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

Checking query status...