Fork of
Number of WLM all years uploaders
by Ilya
This query is marked as a draft
This query has been published
by Ilya.
SQL
x
USE commonswiki_p;
SELECT count(distinct rev_user_text)
FROM commonswiki_p.revision r
join commonswiki_p.categorylinks c
on r.rev_page = c.cl_from
WHERE rev_parent_id = 0
and c.cl_to in (
'Images_from_Wiki_Loves_Monuments_2016_in_Ukraine',
'Images_from_Wiki_Loves_Monuments_2015_in_Ukraine',
'Images_from_Wiki_Loves_Monuments_2014_in_Ukraine',
'Images_from_Wiki_Loves_Monuments_2013_in_Ukraine',
'Images_from_Wiki_Loves_Monuments_2012_in_Ukraine')
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.