WLM Puglia - past participants 2016-2023

SQL

SELECT CONCAT("# {{target| user = ", actor_name, "|site = 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_2022_in_Italy_-_Apulia",
   "Images_from_Wiki_Loves_Monuments_2021_in_Italy_-_Apulia",
   "Images_from_Wiki_Loves_Monuments_2020_in_Italy_-_Apulia",
   "Images_from_Wiki_Loves_Monuments_2019_in_Italy_-_Apulia",
   "Images_from_Wiki_Loves_Monuments_2018_in_Italy_-_Apulia",
   "Images_from_Wiki_Loves_Monuments_2017_in_Italy_-_Apulia",
   "Images_from_Wiki_Loves_Monuments_2016_in_Italy_-_Apulia"
) 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_2022_in_Italy_-_Apulia")  
)  
 GROUP BY actor_name
SQL

Checking query status...
