WLM-UA 2019 participants not active in previous WLM

SQL

use commonswiki_p;

SELECT actor_name, COUNT(1) as files
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_Ukraine"
) and not exists (SELECT 1
FROM revision
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  actor_id = r_prev.rev_actor
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 actor_name
 ORDER BY files DESC
SQL

Checking query status...
