pages created - Quarry

SQL

WITH deleted AS (
  	WITH totalcount AS (
    SELECT MAX(ar_rev_id) AS REVUNIQ, DATE_FORMAT(ar_timestamp, '%Y-%m') AS MONTH
    FROM archive
    GROUP BY ar_title
  )
  SELECT COUNT(REVUNIQ) AS Del, MONTH
  FROM totalcount
  GROUP BY MONTH
  ORDER BY MONTH DESC)
  
  ,created AS (
  SELECT COUNT(page_title) AS cre, DATE_FORMAT(page_touched,'%Y-%m') AS creMONTH
  FROM page
  WHERE page.page_is_new=1
  GROUP BY DATE_FORMAT(page_touched,'%Y-%m') DESC)
  
SELECT (100.0*(deleted.Del/created.cre)), Del, cre, MONTH
FROM deleted
JOIN created ON deleted.MONTH=created.creMONTH
GROUP BY MONTH
ORDER BY MONTH DESC
SQL

Checking query status...
