WLM-UA Photo Competition participants 2012-2018

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

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

SQL

SELECT CONCAT("# {{#target:User_talk:", rev_user_text, "|commons.wikimedia.org}}") as line
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_2012_in_Ukraine",
  "Images_from_Wiki_Loves_Monuments_2013_in_Ukraine",
  "Images_from_Wiki_Loves_Monuments_2014_in_Ukraine",
  "Images_from_Wiki_Loves_Monuments_2015_in_Ukraine",
  "Images_from_Wiki_Loves_Monuments_2016_in_Ukraine",
  "Images_from_Wiki_Loves_Monuments_2017_in_Ukraine",
  "Images_from_Wiki_Loves_Monuments_2018_in_Ukraine"  
)  
 GROUP BY rev_user_text

SQL

Checking query status...