Wiki Loves Africa Unique Participants 2014-2023

SQL

SELECT DISTINCT actor_name, rev_actor
FROM commonswiki_p.page p 
INNER JOIN commonswiki_p.categorylinks cl ON p.page_id = cl.cl_from 
INNER JOIN commonswiki_p.revision r ON p.page_id = r.rev_page
join actor on rev_actor = actor_id and actor_user is not null
WHERE cl.cl_to IN (
  "Images_from_Wiki_Loves_Africa_2014",
  "Images_from_Wiki_Loves_Africa_2015",
  "Images_from_Wiki_Loves_Africa_2016",
  "Images_from_Wiki_Loves_Africa_2017",
  "Images_from_Wiki_Loves_Africa_2019",
  "Images_from_Wiki_Loves_Africa_2020",
  "Images_from_Wiki_Loves_Africa_2021",
  "Images_from_Wiki_Loves_Africa_2022",
  "Images_from_Wiki_Loves_Africa_2023"
) 
-- WHERE cl.cl_to LIKE "Images\_from\_Wiki\_Loves\_Africa\_20__"
AND p.page_namespace = 6 
AND r.rev_parent_id = 0;
SQL

Checking query status...
