Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
Fork of
WMUA-UA Photo Competition participants 2012-2019 not active in WLM-UA 2019
by
MichaelMaggs
This query is marked as a draft
This query has been published
by
MichaelMaggs
.
WLM-UK competition participants 2013-14 & 2016-18, not active so far in 2019
Toggle Highlighting
SQL
use commonswiki_p; SELECT CONCAT("# {{#target:User_talk:", actor_name, "|commons.wikimedia.org}}") as line FROM revision r_prev join categorylinks on rev_page = cl_from join actor on rev_actor = actor_id and actor_user is not null WHERE rev_parent_id = 0 and cl_to IN ( "Images from Wiki Loves Monuments 2013 in the United Kingdom", "Images from Wiki Loves Monuments 2014 in the United Kingdom", "Images from Wiki Loves Monuments 2016 in the United Kingdom", "Images from Wiki Loves Monuments 2017 in the United Kingdom", "Images from Wiki Loves Monuments 2018 in the United Kingdom" ) and not exists ( SELECT 1 FROM revision join categorylinks on rev_page = cl_from WHERE rev_parent_id = 0 AND rev_actor = r_prev.rev_actor and cl_to IN ("Images from Wiki Loves Monuments 2019 in the United Kingdom") ) GROUP BY actor_name
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...