Untitled query #27068

SQL

USE commonswiki_p;
SELECT user_id, user_name, user_editcount, user_registration, COUNT(log_id) AS uploads, SUM(EXISTS(
  SELECT *
  FROM categorylinks
  WHERE cl_from = f.page_id AND cl_to = "Uploaded_with_Mobile/Android"
)) AS mobile_app_uploads
FROM logging
JOIN user ON user_id = log_user
JOIN change_tag ON ct_log_id = log_id
JOIN page AS f ON log_page = f.page_id
WHERE log_type = "upload" AND (log_action = "upload" OR log_action = "overwrite")
AND log_timestamp > "20180400" AND log_timestamp < "20180901"
GROUP BY user_id;
SQL

Checking query status...
