Commons users started as mobile app users (2)

SQL

USE commonswiki_p;

SELECT first_upload, uploads, username FROM
(
  SELECT MIN(log_timestamp) AS first_upload, MIN(log_id) AS first_upload_id, COUNT(log_timestamp) AS uploads, log_user_text AS username
  FROM logging_compat
  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 > "20190101000000" GROUP BY log_user
) AS tmp
LEFT JOIN change_tag ON first_upload_id=ct_log_id AND ct_tag_id=21;

SQL

Checking query status...