Untitled query #37495

SQL

USE commonswiki_p;
# Get all users who uploaded files to WLM in 2016
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_Monuments_2016_in_Germany"
# Exclude users who uploaded stuff yet
#AND img_user_text NOT IN
#	(SELECT 
# DISTINCT img_user_text AS user2
#FROM page
#JOIN categorylinks
# ON cl_from = page_id
#INNER JOIN image
# ON page_title = img_name
#WHERE cl_to = "Images_from_Wiki_Loves_Monuments_2017_in_Germany"
#GROUP BY img_user_text
#    )
GROUP BY img_user_text
;
SQL

Checking query status...
