USE commonswiki_p;

​

SELECT x.log_user_text AS user_name, x.first as first_date, x.uploads, page_title AS first_file

FROM change_tag

JOIN (

  SELECT MIN(log_timestamp) AS first, COUNT(log_timestamp) AS uploads, log_user_text, log_page, log_id

  FROM logging JOIN user ON user_id = log_user

  WHERE (log_action = "upload" OR log_action = "overwrite") AND user_registration > "20160701000000" GROUP BY log_user

) x ON ct_log_id = x.log_id AND ct_tag = "mobile app edit"

JOIN page ON x.log_page = page_id;

​