WLE-UA Photo Competition participants 2013-2017 not active in 2018

SQL

SELECT CONCAT("# {{#target:User_talk:", rev_user_text, "|commons.wikimedia.org}}") as line
FROM commonswiki_p.revision r
join commonswiki_p.categorylinks c
on r.rev_page = c.cl_from
WHERE rev_parent_id = 0
and c.cl_to IN (
   "Images_from_Wiki_Loves_Earth_2013_in_Ukraine",
   "Images_from_Wiki_Loves_Earth_2014_in_Ukraine",
   "Images_from_Wiki_Loves_Earth_2015_in_Ukraine",
   "Images_from_Wiki_Loves_Earth_2016_in_Ukraine",
   "Images_from_Wiki_Loves_Earth_2017_in_Ukraine",
  )   
GROUP BY rev_user_text 
ORDER BY line ASC
MINUS
SELECT CONCAT("# {{#target:User_talk:", rev_user_text, "|commons.wikimedia.org}}") as line
FROM commonswiki_p.revision r
join commonswiki_p.categorylinks c
on r.rev_page = c.cl_from
WHERE rev_parent_id = 0
and c.cl_to IN (
   "Images_from_Wiki_Loves_Earth_2018in_Ukraine",
  )  
ORDER BY line ASC

SQL

Checking query status...