Number of files uploaded with UploadWizard before it provided a log comment, by month

SQL

SELECT LEFT(r_first.rev_timestamp, 6) AS creation_month, COUNT(DISTINCT p.page_id) AS unique_page_count
FROM page p
JOIN revision r_first ON r_first.rev_page = p.page_id
WHERE r_first.rev_parent_id = 0
  AND r_first.rev_timestamp >= '20101130000000'
  AND r_first.rev_timestamp < '20120823203303'
  AND EXISTS (
    SELECT 1
    FROM revision r_later
    WHERE r_later.rev_page = p.page_id
      AND r_later.rev_comment_id = 33984
  )
GROUP BY creation_month
ORDER BY creation_month;

AخA
 
SELECT LEFT(r_first.rev_timestamp, 6) AS creation_month, COUNT(DISTINCT p.page_id) AS unique_page_countFROM page pJOIN revision r_first ON r_first.rev_page = p.page_idWHERE r_first.rev_parent_id = 0  AND r_first.rev_timestamp >= '20101130000000'  AND r_first.rev_timestamp < '20120823203303'  AND EXISTS (    SELECT 1    FROM revision r_later    WHERE r_later.rev_page = p.page_id      AND r_later.rev_comment_id = 33984  )GROUP BY creation_monthORDER BY creation_month;

SQL

Checking query status...