Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Ilya
.
Toggle Highlighting
SQL
use commonswiki_p; select distinct page_id from page p join categorylinks on cl_from = page_id join revision r on rev_page = page_id where rev_user_text in ('Brizhnichenko', 'Rbrechko', 'Klymenkoy', 'Q-lieb-in', 'Nina Shenturk', 'Michielverbeek', 'Ermell', 'ArildV', 'Code', 'C messier', 'Sulyma Oksana', 'George Chernilevsky', 'Ilya', 'Oleg Kushch', 'antanana', 'Sergento', 'Ата', 'Anntinomy', 'Оля Нестеренко', 'Aeou', 'Ahonc', 'NickK', 'Kharkivian', 'Taras r' ) and rev_parent_id = 0 and cl_to = 'Images_from_Wiki_Loves_Monuments_2017_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
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...