European Science Photo Competition participants 2015 and 2016 in Ukraine

SQL

-- it is supposed to be counter of all participants from WLM MMXII - MMXV in Ukraine.
-- Number should count unique users and not just sum up the nums for all 4 cats

SELECT CONCAT("# {{#target:User_talk:", rev_user_text, "}}") 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 (
   "Astronomy images from European Science Photo Competition 2016",
    "General category images from European Science Photo Competition 2016",
    "Images of people in science from European Science Photo Competition 2016",
    "Non-photographic media from European Science Photo Competition 2016",
    "Microscopy images from European Science Photo Competition 2016",
    "Living organisms images from European Science Photo Competition 2016",
    "European Science Photo Competition 2015 in Ukraine",
    "Images from European Science Photo Competition 2015 in Ukraine"
  )   
GROUP BY rev_user_text 
ORDER BY line ASC
SQL

Checking query status...
