SELECT upload_month, COUNT(*) AS upload_count

FROM (

  -- Early uploads (page creations later revised with rev_comment_id = 33984)

  SELECT LEFT(r_first.rev_timestamp, 6) AS upload_month

  FROM revision r_first

  WHERE r_first.rev_parent_id = 0

    AND EXISTS (

      SELECT 1

      FROM revision r_later

      WHERE r_later.rev_page = r_first.rev_page

        AND r_later.rev_comment_id = 33984

    )

    AND r_first.rev_timestamp < '20120823203303'

​

  UNION ALL

​

  -- Middle period uploads (log_comment_id = 44)

  SELECT LEFT(l.log_timestamp, 6) AS upload_month

  FROM logging l

  WHERE l.log_type = 'upload'

    AND l.log_comment_id = 44

    AND l.log_timestamp >= '20120823203303'

    AND l.log_timestamp < '20170510194757'

​

  UNION ALL

​

  -- Recent uploads (change tag = 'uploadwizard')

  SELECT LEFT(l.log_timestamp, 6) AS upload_month

  FROM logging l

  JOIN change_tag ct ON ct.ct_log_id = l.log_id

  JOIN change_tag_def ctd ON ct.ct_tag_id = ctd.ctd_id

  WHERE l.log_type = 'upload'

    AND ctd.ctd_name = 'uploadwizard'

    AND l.log_timestamp >= '20170510194757'

) AS all_uploads

GROUP BY upload_month

ORDER BY upload_month;