Portuguese Wikipedia article creations in the last year (March 2020)

SQL

USE ptwiki_p;
SELECT
  page_title,
  rev_id,
  rev_timestamp AS creation_timestamp,
  FALSE AS archived,
  "OK" AS draft_quality 
FROM revision 
INNER JOIN page ON
  rev_page = page_id WHERE
  rev_timestamp BETWEEN "20190320" AND "20200320" AND
  rev_parent_id = 0 AND
  page_namespace = 0 

UNION ALL 

SELECT
  ar_title AS page_title,
  ar_rev_id AS rev_id,
  ar_timestamp AS creation_timestamp,
  True AS archived,
  IF(comment_text REGEXP "Spam / propaganda", "spam"
 	IF(comment_text REGEXP "Ofensivo / baixo calão", "unsuitable",
      IF(comment_text REGEXP "WP:ER#ER20\\|", "unsuitable",
         IF(comment_text REGEXP "WP:ER#ER6\\|", "spam", "OK")))) AS draft_quality 
FROM archive 
LEFT JOIN logging speedy_delete ON
  log_namespace = ar_namespace AND
  log_title = ar_title AND
  log_type = "delete" AND
  log_action = "delete" AND
  log_timestamp > ar_timestamp 
LEFT JOIN comment ON
  log_comment_id = comment_id AND
  comment_text LIKE "[[WP:ER#%" AND
  comment_text REGEXP "WP:ER#(ER6|ER20)\\|"
WHERE
  ar_timestamp BETWEEN "20190320" AND "20200320" AND
  log_timestamp BETWEEN "20190320" AND "20200320" AND
  ar_parent_id = 0 AND
  ar_namespace = 0;
SQL

Checking query status...
