WLE participants 2013-2017 and WLM participants 2012-2017 in Ukraine

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 (
   "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",
    "Images_from_European_Science_Photo_Competition_2015_in_Ukraine"
  )   
GROUP BY rev_user_text 
ORDER BY line ASC

SQL

Checking query status...