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

Checking query status...
