New articles and drafts

SQL

SET @start_time = '20220101';
SET @end_time = '20220931';

SELECT 
  page_id, 
  page_namespace, 
  rev_timestamp AS 'created_at', 
  log_timestamp AS 'moved_at',
  log_params,
  comment_text
FROM 
  revision
  LEFT JOIN page ON rev_page = page_id
  LEFT OUTER JOIN logging ON log_page = page_id
  LEFT OUTER JOIN comment ON comment_id = log_comment_id
WHERE 
  page_namespace IN (0, 118) AND
  rev_parent_id = 0 AND
  rev_timestamp BETWEEN @start_time AND @end_time AND
  log_type IN ('move', 'move_redir') AND
  log_timestamp > rev_timestamp -- filter out logs prior to history merges
SQL

Checking query status...
