Untitled query #38621

SQL

use commonswiki_p;
SELECT
 user.user_name as uploader,
 image.img_timestamp,
 user_properties.up_property,
 user_properties.up_value,
 COUNT(img_name) as images
 FROM (SELECT
   cl_to,
   cl_from
   FROM categorylinks
   WHERE cl_to = "Images_from_Wiki_Loves_Monuments_2018" AND cl_type = 'file') cats
 INNER JOIN page ON cl_from = page_id
 INNER JOIN image ON page_title = img_name
 LEFT JOIN actor ON actor.actor_id = image.img_actor
 LEFT JOIN user ON user.user_id = actor.actor_user
 LEFT JOIN user_properties ON user_properties.up_user = user.user_id
 WHERE img_timestamp BETWEEN 20180901000000 AND 20180927000000
   AND user_properties.up_property = "disablemail" AND user_properties.up_value = 1
 GROUP BY uploader
SQL

Checking query status...
