/delete - Quarry

Fork of WLM MMXII-MMXV, WLE MMXIII-MMXVI in Ukraine participants by Base

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

SQL

-- it is supposed to be counter of all participants from WLM MMXII - MMXV in Ukraine.
-- Number should count unique users and not just sum up the nums for all 4 cats

SELECT CONCAT("# {{target | user= ", rev_user_text, "| site = commons.wikimedia.org}}") as line
FROM commonswiki_p.revision 
WHERE rev_parent_id = 0
AND rev_page IN(
  SELECT cl_from
  FROM commonswiki_p.categorylinks
  WHERE cl_to IN (
  "Category:Images from European Science Photo Competition 2015 in Ukraine"
  )
)
GROUP BY rev_user_text
ORDER BY line ASC

SQL

Checking query status...