WLE DE Participants 2014-2022

SQL

USE commonswiki_p;
SELECT 
 DISTINCT CONCAT("# {{#target:User_talk:", img_user_text, "}}") AS user
FROM page
JOIN categorylinks
 ON cl_from = page_id
LEFT JOIN image_compat
 ON page_title = img_name
WHERE (
        cl_to = 'Images_from_Wiki_Loves_Earth_2022_in_Germany'
        OR cl_to = 'Images_from_Wiki_Loves_Earth_2021_in_Germany'
        OR cl_to = 'Images_from_Wiki_Loves_Earth_2020_in_Germany'
  		OR cl_to = 'Images_from_Wiki_Loves_Earth_2019_in_Germany'
  		OR cl_to = 'Images_from_Wiki_Loves_Earth_2018_in_Germany'
  		OR cl_to = 'Images_from_Wiki_Loves_Earth_2017_in_Germany'
  		OR cl_to = 'Images_from_Wiki_Loves_Earth_2016_in_Germany'
  		OR cl_to = 'Images_from_Wiki_Loves_Earth_2015_in_Germany'
  		OR cl_to = 'Images_from_Wiki_Loves_Earth_2014_in_Germany'
      )
GROUP BY img_user_text
;
SQL

Checking query status...
