Untitled query #38524

SQL

USE commonswiki_p;

set @m=10; #month, 1, ...., 11
set @y=2018; #year

-- SELECT MIN(log_timestamp) AS first_upload, COUNT(log_timestamp) AS uploads, log_user_text AS username, ct_tag = "mobile app edit" AS is_mobile
-- FROM logging
-- LEFT JOIN user ON user_id = log_user
-- JOIN change_tag ON ct_log_id = log_id
-- JOIN page ON log_page = page_id
-- WHERE log_type = "upload" AND (log_action = "upload" OR log_action = "overwrite") AND user_registration > "20180101000000" GROUP BY log_user;

SELECT * FROM logging WHERE log_type = "upload" AND log_actor IN (SELECT user_id
        FROM user
  WHERE user_registration BETWEEN (@y*10000+@m*100+1)*1000000 and (@y*10000+(@m+1)*100+1)*1000000
  AND user_editcount > 0) LIMIT 10;
SQL

Checking query status...
