WLE-CO participants 2014-2018 not active in 2019

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_2011_in_Colombia", 
   "Images_from_Wiki_Loves_Monuments_2012_in_Colombia",
   "Images_from_Wiki_Loves_Monuments_2013_in_Colombia",
   "Images_from_Wiki_Loves_Monuments_2014_in_Colombia",
   "Images_from_Wiki_Loves_Monuments_2015_in_Colombia",
   "Images_from_Wiki_Loves_Monuments_2016_in_Colombia",
   "Images_from_Wiki_Loves_Monuments_2017_in_Colombia",
   "Images_from_Wiki_Loves_Monuments_2018_in_Colombia",
   "Wikivacaciones 2015",
   "Wikivacaciones 2016",
   "Wikivacaciones 2017",
   "Wikivacaciones 2018"
) and not exists (SELECT 1
FROM commonswiki_p.revision
join commonswiki_p.categorylinks
on rev_page = cl_from                  
WHERE rev_parent_id = 0
                  AND  rev_user_text = r_prev.rev_user_text
and cl_to IN ("Images_from_Wiki_Loves_Earth_2019_in_Colombia")  
)  
 GROUP BY rev_user_text
SQL

Checking query status...
