WLM-UA Photo Competition 2018 filtered users

Fork of WLE-UA Photo Competition participants 2013-2017 not active in 2018 by Ilya

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

WLE-UA Photo Competition participants  2013-2017 not active in 2018

SQL

SELECT rev_page
FROM commonswiki_p.revision r_prev
join commonswiki_p.categorylinks 
on rev_page = cl_from
WHERE rev_parent_id = 0
and cl_to IN ("Images_from_Wiki_Loves_Monuments_2018_in_Ukraine") 
and rev_user_text in ("Nataliya Shestakova",
"Yara shark",
"Кальницкий Михаил",
"Mykyta Peregrym",
"Mykola Swarnyk",
"Іван Биков",
"Aniskov",
"Eusebius Talpa")

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.

SQL

Checking query status...