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

SQL

SELECT COUNT(DISTINCT p.page_id) -- Count unique page IDs
FROM page p
JOIN revision r ON p.page_id = r.rev_page
WHERE r.rev_comment_id = 33984 -- Find pages with the desired revision comment
  AND NOT EXISTS ( -- Ensure no disqualifying log entry exists for this page
      SELECT 1 -- Select a constant; we only care if a row exists or not
      FROM logging l
      WHERE l.log_page = p.page_id -- Link log entry to the current page being checked
        AND l.log_comment_id = 44 -- Check for the specific log comment ID to exclude
  );

AخA
 
SELECT COUNT(DISTINCT p.page_id) -- Count unique page IDsFROM page pJOIN revision r ON p.page_id = r.rev_pageWHERE r.rev_comment_id = 33984 -- Find pages with the desired revision comment  AND NOT EXISTS ( -- Ensure no disqualifying log entry exists for this page      SELECT 1 -- Select a constant; we only care if a row exists or not      FROM logging l      WHERE l.log_page = p.page_id -- Link log entry to the current page being checked        AND l.log_comment_id = 44 -- Check for the specific log comment ID to exclude  );

SQL

Checking query status...