WLM in Sweden participants

Fork of WLE / WLM in Sweden participants by Alicia Fagerving (WMSE)

This query is marked as a draft This query has been published by Alicia Fagerving (WMSE).

People who have uploaded images during WLM in Sweden (2011–2019). List ready for mass messaging (https://commons.wikimedia.org/wiki/Commons:Wiki_Loves_Monuments_in_Sweden/Mass_message)

SQL

use commonswiki_p;

SELECT CONCAT("# {{#target:User_talk:", actor_name, "}}") 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_2019_in_Sweden",
  "Images_from_Wiki_Loves_Monuments_2018_in_Sweden",
  "Images_from_Wiki_Loves_Monuments_2017_in_Sweden",
  "Images_from_Wiki_Loves_Monuments_2016_in_Sweden",
  "Images_from_Wiki_Loves_Monuments_2015_in_Sweden",
  "Images_from_Wiki_Loves_Monuments_2014_in_Sweden",
  "Images_from_Wiki_Loves_Monuments_2013_in_Sweden",
  "Images_from_Wiki_Loves_Monuments_2012_in_Sweden",
  "Images_from_Wiki_Loves_Monuments_2011_in_Sweden"
)
GROUP BY actor_name
ORDER BY actor_name

SQL

Checking query status...